Apparatus and method for allowing complex aggregates in analytical views in a distributed database
US10120898B1 · kind B1 · utility
Assignee
Inventors
Key dates
| Filing date | Aug 5, 2016 |
| Grant date | Nov 6, 2018 |
| Priority date | — |
| Expiry date | May 11, 2037 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2455
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
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.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.