Abstract: 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.

Abstract: A system has worker machines connected by a network. Each worker machine stores at least one partition of a distributed database and a partial function module to initialize a database dimension, increment an aggregate of the database dimension in response to a data change and to serialize a last aggregate of the database dimension in response to a refresh operation to form partial results of an analytical view. An analytical view machine connected to the network responds to a query without accessing a partition of the distributed database. The analytical view machine merges partial results from the worker machines to produce a final result to the query.