STREAMING MULTIDIMENSIONAL DATA BY BYPASSING MULTIDIMENSIONAL QUERY PROCESSOR
First Claim
1. A data warehouse comprising:
- a multidimensional data storage area to store multidimensional data;
a transactional data storage area to store underlying transactional data from which the multidimensional data is generated;
a multidimensional query processor to provide one or more interfaces to issue a first set of queries conforming to one or more multidimensional query languages to retrieve the multidimensional data from the multidimensional data storage area; and
a dynamic query engine to provide an additional interface to issue a second set of queries that bypass the interfaces provided by the multidimensional query processor to retrieve the transactional data from the transactional data storage area, wherein the second set of queries do not conform to any of the one or more multidimensional query languages.
5 Assignments
0 Petitions
Accused Products
Abstract
A data warehouse comprises a multidimensional data storage area to store multidimensional data and a transactional data storage area to store underlying transactional data from which the multidimensional data is generated. The data warehouse also comprises a multidimensional query processor to provide one or more interfaces to issue a first set of queries conforming to one or more multidimensional query languages to retrieve the multidimensional data from the multidimensional data storage area. Furthermore, the data warehouse comprises a dynamic query engine to provide an additional interface to issue a second set of queries that bypass the interfaces provided by the multidimensional query processor to retrieve the transactional data from the transactional data storage area, wherein the second set of queries do not conform to any of the one or more multidimensional query languages.
-
Citations
30 Claims
-
1. A data warehouse comprising:
-
a multidimensional data storage area to store multidimensional data; a transactional data storage area to store underlying transactional data from which the multidimensional data is generated; a multidimensional query processor to provide one or more interfaces to issue a first set of queries conforming to one or more multidimensional query languages to retrieve the multidimensional data from the multidimensional data storage area; and a dynamic query engine to provide an additional interface to issue a second set of queries that bypass the interfaces provided by the multidimensional query processor to retrieve the transactional data from the transactional data storage area, wherein the second set of queries do not conform to any of the one or more multidimensional query languages. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13)
-
-
14. A method comprising:
-
installing a dynamic query engine on a data warehouse, wherein the data warehouse includes transactional data in a transactional data storage area and multidimensional data generated from the transactional data in a multidimensional data storage area, and further wherein the data warehouse includes one or more interfaces for issuing a first set of queries conforming to the one or more multidimensional query languages to query the multidimensional data; providing, with the dynamic query engine, an additional interface that issues a second set of queries that bypass the interfaces provided by the multidimensional query processor, wherein the second set of queries do not conform to any of the one or more multidimensional query languages; retrieving, with the additional interface of the dynamic query engine, the transactional data from the transactional data storage area according to the second set of queries; and streaming the retrieved transactional data on a network - View Dependent Claims (15, 16, 17, 18, 19, 20, 21)
-
-
22. A system comprising:
-
a data warehouse comprising; a multidimensional data storage area to store multidimensional data, a transactional data storage area to store underlying transactional data from which the multidimensional data is generated, a multidimensional query processor to provide one or more interfaces to issue a first set of queries conforming to one or more multidimensional query languages to retrieve the multidimensional data from the multidimensional data storage area, and a dynamic query engine to provide an additional interface to issue a second set of queries that bypass the interfaces provided by the multidimensional query processor to retrieve the transactional data from the transactional data storage area and metadata from the transactional data storage area and metadata from the multidimensional data storage area, wherein the second set of queries do not conform to any of the one or more multidimensional query languages; and a network device comprising; a streaming database having a local multidimensional data storage area, a metadata driver to receive metadata from the dynamic query engine of the data warehouse, and a data driver to create a storage schema in the local multidimensional data storage area according to the metadata received from the dynamic query engine, to generate the second set of queries for the dynamic query engine, to receive transactional data from the dynamic query engine, and to store the received transactional data in the local multidimensional storage area according to the storage schema. - View Dependent Claims (23, 24, 25, 26, 27, 28, 29)
-
-
30. A computer-readable medium comprising instructions for causing a programmable processor to:
-
receive, from a dashboard device, a unique identifier and a set of queries, wherein the queries do not conform to a multidimensional data query language; store the unique identifier and the set of queries in a data table; retrieve metadata from a transactional data storage area of a data warehouse; retrieve metadata from a multidimensional data storage area of a data warehouse; transmit the metadata from the transactional data storage area and the metadata from the multidimensional data storage area to the dashboard device using a chunking protocol operating at an application layer (layer seven) of the Open Systems Interconnection (“
OSI”
) networking model;retrieve transactional data from the transactional data storage area of the data warehouse; and transmit the retrieved transactional data to the dashboard device using the chunking protocol.
-
Specification