December 30, 2008 at 11:46 PM
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.
A dynamic query engine operates within each data warehouse to provide a continual stream of enterprise events to the dashboard appliance. As described herein, the dynamic query engine provides an execution framework for execution of low-level queries that bypass any multidimensional interfaces provided by the data warehouse. The low-level queries may be queries which do not conform to any multidimensional querying language. In one embodiment, for example, the dynamic query engine allows devices, such as the dashboard device, to define SQL-based queries that are used to extract incremental differences made to the multidimensional data warehouse.