Apparatus and method for query processing using analytical view partitions and database partitions
A system includes a distributed database with database partitions distributed across worker nodes connected by a network. An analytical view module defines an analytical view comprising dimensions and aggregates defined prior to receipt of a query and maintained as a data unit separate from the distributed database. The analytical view module includes instructions executed by a processor to form analytical view partitions. The query is evaluated to identify implicated fresh analytical view partitions and implicated stale analytical view partitions. The implicated fresh analytical view partitions are accessed to obtain analytical view results. Database results corresponding to the implicated stale analytical view partitions are obtained. A response to the query is supplied based upon the analytical view results and the database results.
1. A system, comprising;
a distributed database with a plurality of database partitions distributed across a corresponding plurality of worker nodes connected by a network; and
an analytical view module to define an analytical view comprising dimensions and aggregates defined prior to the receipt of a query and maintained as a data unit separate from the distributed database, wherein the analytical view module includes instructions executed by a processor to:
form analytical view partitions,
evaluate the query to identify implicated fresh analytical view partitions and implicated stale analytical view partitions,
access the implicated fresh analytical view partitions to obtain analytical view results,
obtain from database partitions database results corresponding to the implicated stale analytical view partitions, and
supply a response to the query using the analytical view results and the database results.
2. The system of claim 1 further comprising a client machine connected to the network to secure the response to the query.
3. The system of claim 1 wherein the analytical view module is executed by an analytical view machine connected to the network.
4. The system of claim 1 wherein the analytical view module is executed by a master machine connected to the network, wherein the master machine coordinates the operation of the plurality of worker nodes.