BUSINESS INFORMATION WAREHOUSE TOOLKIT AND LANGUAGE FOR WAREHOUSING SIMPLIFICATION AND AUTOMATION
First Claim
1. A method for information warehouse construction, comprising:
- providing a language specification for information warehouse construction, the language specification having information warehouse (IW) level commands and dimension level commands; and
constructing an information warehouse based on a script comprising at least one of the IW level commands and the dimension level commands according to the language specification for information warehouse construction.
0 Assignments
0 Petitions
Accused Products
Abstract
A method for use with an information (or data) warehouse comprises managing the information warehouse with instructions in a declarative language. The instructions specify information warehouse-level tasks to be done without specifying certain details of how the tasks are to be implemented, for example, using databases and text indexers. The details are hidden from the user and include, for example, in an information warehouse having a FACT table that joins two or more dimension tables, details of database level operations when structured data are being handled, including database command line utilities, database drivers, and structured query language (SQL) statements; and details of text-indexing engines when unstructured data are being handled. The information warehouse is managed in a dynamic way in which different tasks—such as data loading tasks and information warehouse construction tasks—may be interleaved (i.e., there is no particular order in which the different tasks must be completed).
35 Citations
35 Claims
-
1. A method for information warehouse construction, comprising:
-
providing a language specification for information warehouse construction, the language specification having information warehouse (IW) level commands and dimension level commands; and constructing an information warehouse based on a script comprising at least one of the IW level commands and the dimension level commands according to the language specification for information warehouse construction. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. A method for data loading in an information warehouse, comprising:
-
providing a language specification for data loading in an information warehouse, the language specification having source mapping commands and data loading commands; and loading data into an information warehouse based on a script comprising at least one of the source mapping commands and data loading commands according to the language specification for data loading. - View Dependent Claims (8, 9, 10, 11, 12)
-
-
13. A method for data maintenance of an information warehouse, comprising:
-
providing a language specification for information warehouse (IW) maintenance in an information warehouse, the language specification having failure recovery commands and error correction commands; and performing an IW maintenance operation on the information warehouse based on a script comprising at least one of the failure recovery commands and error correction commands according to the language specification for IW maintenance. - View Dependent Claims (14, 15, 16, 17, 18)
-
-
19. An information warehouse system comprising:
-
a front-end graphical user interface that accepts inputs from a user and generates commands in a declarative information warehouse language; an information warehouse language processor that receives the commands from the user interface and provides system level, database level, and indexing engine level commands for performing tasks specified by the commands from the interface; and a warehouse builder that receives the system level, database level, and indexing engine level commands from the information warehouse language processor and performs tasks specified by the system level, database level, and indexing engine level commands to build an information warehouse according to the commands from the user interface, the system level, database level, and indexing engine level commands being hidden from the user. - View Dependent Claims (20, 21, 22, 23, 24, 25)
-
-
26. A computer program product for use with an information warehouse, the computer program product comprising a computer useable medium including a computer readable program, wherein the computer readable program when executed on a computer causes the computer to:
-
accept commands of a declarative information warehouse language provided by a script; parse the commands from the script; generate data description language commands from the parsed commands; and execute the data description language commands to construct an information warehouse. - View Dependent Claims (27, 28, 29, 30, 32, 33, 34, 35)
-
-
31. A computer program product for use with an information warehouse, the computer program product comprising a computer useable medium including a computer readable program, wherein the computer readable program when executed on a computer causes the computer to:
-
accept commands of a declarative information warehouse language provided by a script; parse the commands from the script; extract desired data from a source file according to the parsed commands; transform the extracted data into a target format according to the parsed commands; and load the transformed data into information warehouse tables and file system locations according to the parsed commands.
-
Specification