US 2017/0286510 A1 · AGGREGATION FRAMEWORK SYSTEM ARCHITECTURE AND METHOD

Abstract

A system and computer implemented method for execution of aggregation expressions on a distributed non-relational database system is provided. According to one aspect, an aggregation operation may be provided that permits more complex operations using separate collections. For instance, it may be desirable to create a report from one collection using information grouped according to information stored in another collection. Such a capability may be provided within other conventional database systems, however, in a non-relational database system such as NoSQL, the system is not capable of performing server-side joins, such a capability may not be performed without denormalizing the attributes into each object that references it, or by performing application-level joins which is not efficient and leads to unnecessarily complex code within the application that interfaces with the NoSQL database system.

Claims16

Dependent claims

A computer implemented method for execution of aggregation expressions on a distributed non-relational database system, the method comprising the acts of:

executing, by a computer system, an aggregation operation, wherein the aggregation operation includes a plurality of data operations on a distributed non-relational database having a plurality of collections of documents including at least one local collection of documents and at least one foreign collection of documents;
providing an operation using the at least one local collection of documents and the at least one foreign collection of documents, wherein the operation performs the aggregation operation comprises:
accepting an indication of at least one foreign collection of documents;
accepting an indication of a field of the at least one local collection of documents;
accepting an indication of a field of the at least one foreign collection of documents;
performing a match operation between the field of the at least one local collection of documents and the field of the at least one foreign collection of documents;
and
aggregating data from the at least one local collection of documents and the at least one foreign collection of documents responsive to the match operation.

5 more elements

Dependencies are inferred from the claim text.

Aggregation framework system architecture and method

Life of this patent

Aggregation framework system architecture and method

Life of this patent

Abstract

Claims16