Method and system for designing, implementing and documenting OLAP
OwnerPeter Nadorinventor
Life of this patent
Estimating the term…
Abstract
A system for assisting in the design, implementation and documentation of an online analytical processing system provides a plurality of extractor programs for extracting data from the online analytical processing system, and transferring the data to at least one extracted data table. The extracted data table serves as an information source for a master information cube that stores data for permitting users to generate reports about the design, implementation and documentation of the online analytical processing system.
Claims20
A system for assisting in the design, implementation and documentation of a subject online analytical processing system, comprising:
- a plurality of extractor programs for respectively extracting data from one of:
- a table of the subject online analytical processing system, and a view of two or more of the tables;
- and
- an extracted data table for receiving data extracted by the plurality of extractor programs, the extracted data table serving as an information source for a master information cube of a host online analytical processing system that stores data for permitting users to generate reports about the online analytical processing system.
A method of assisting in the design, implementation and documentation of a subject online analytical processing system, comprising:
- providing a plurality of extractor programs for respectively extracting data from one of:
- a table of the online analytical processing system, and a view of two or more of the tables;
- providing at least one extracted data table for receiving data extracted by the plurality of extractor programs, each extracted data table serving as an information source for a master information cube of a host online analytical processing system that stores the data;
- and
- structuring data staging facilities of the host online analytical processing system to transfer the data from the extracted data table to the master information cube to permit users to generate reports about the online analytical processing system.
Dependencies are inferred from the claim text.