# US 10,120,898 B1 · Apparatus and method for allowing complex aggregates in analytical views in a distributed database

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 10,120,898 B1
- Document ID: US10120898B1
- Status: Granted
- Kind: B1
- Application number: 15/230,261
- Filed: 2016-08-05
- Granted: 2018-11-06
- Earliest claimed: 2016-08-05
- Assignees: Arcadia Data Inc.
- Applicants: Arcadia Data Inc.
- Inventors: Anjali Betawadkar-Norwood; Douglas J. Cameron; Rachit Agarwal; Shant Hovsepian
- Web page: https://patentgrep.com/patent/US10120898B1

## CPC

- G06F 16/24535: {of sub-queries or views}
- G06F 16/2455: Query execution
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## 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.

## Claims

### Claim 1

A system, comprising:
a plurality of worker machines connected by a network, each worker machine storing 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; and
an analytical view machine connected to the network to respond to a query without accessing a partition of the distributed database, the analytical view machine merging partial results from the plurality of worker machines to produce a final result to the query.

### Claim 2 (depends on 1)

The system of claim 1 wherein the aggregate of the database dimension is a decomposable measure.

### Claim 3 (depends on 1)

The system of claim 1 wherein the aggregate of the database dimension is not a decomposable measure.

### Claim 4 (depends on 3)

The system of claim 3 wherein the aggregate of the database dimension that is not a decomposable measure is an estimate supplied by a database management system associated with the distributed database.

### Claim 5 (depends on 1)

The system of claim 1 wherein the analytical view machine merges partial results from the plurality of worker machines to aggregate data along a hierarchical dimension and thereby define an analytical view that is maintained as a data unit separate from the distributed database prior to the receipt of a query applied to the analytical view.

### Claim 6 (depends on 1)

The system of claim 1 further comprising a client machine connected to the network to secure the final result from the analytical view machine.