公开(公告)号：US20180314750A1

公开(公告)日：2018-11-01

申请号：US16013725

申请日：2018-06-20

Applicant: Dwight Merriman ,  Eliot Horowitz ,  Cory P. Mintz ,  Cailin Anne Nelson ,  Akshay Kumar ,  David Lenox Storch ,  Charles William Swanson ,  Keith Bostic ,  Michael Cahill ,  Dan Pasette ,  Mathias Benjamin Stearn ,  Geert Bosch

Inventor： Dwight Merriman ,  Eliot Horowitz ,  Cory P. Mintz ,  Cailin Anne Nelson ,  Akshay Kumar ,  David Lenox Storch ,  Charles William Swanson ,  Keith Bostic ,  Michael Cahill ,  Dan Pasette ,  Mathias Benjamin Stearn ,  Geert Bosch

IPC: G06F17/30

Abstract: Systems and methods are provided to enable control and placement of data repositories. In some embodiments, the system segments data into zones. A website, for example, may need to segment data according to location. In this example, a zone may be created for North America and another zone may be created for Europe. Data related to operations executed in North America, for example, can be placed in the North America zone and data related to transactions in Europe can be placed in the Europe zone. According to some embodiments, the system may use zones to accommodate a range of deployment scenarios.

公开(公告)号：US20170262516A1

公开(公告)日：2017-09-14

申请号：US15604879

申请日：2017-05-25

Applicant: Eliot Horowitz ,  David Lenox Storch ,  Mathias Benjamin Stearn

Inventor： Eliot Horowitz ,  David Lenox Storch ,  Mathias Benjamin Stearn

IPC: G06F17/30

CPC classification number: G06F16/258 ,  G06F16/24556 ,  G06F16/2471 ,  G06F16/248 ,  G06F16/254 ,  G06F16/27 ,  G06F16/284 ,  G06F16/951 ,  G06F16/958

Abstract: A system and computer implemented method for execution of aggregation expressions on a distributed non-relational database system is provided. The method comprises the acts of determining, by a computer system, an optimization for execution of an aggregation operation, wherein the aggregation operation includes a plurality of data operations on a distributed non-relational database; modifying, by the computer system, the plurality of data operations to optimize execution; splitting the aggregation operation into a distributed aggregation operation and a merged aggregation operation; instructing each of a plurality of shard servers to perform the distributed aggregation operation; aggregating, at a merging shard server, the results of the distributed aggregation operation from each of the plurality of shard servers; and performing the merged aggregation operation on the aggregated results of the distributed aggregation operation from each of the plurality of shard servers.

公开(公告)号：US20170262517A1

公开(公告)日：2017-09-14

申请号：US15605143

申请日：2017-05-25

Applicant: Eliot Horowitz ,  David Lenox Storch ,  Charles William Swanson

Inventor： Eliot Horowitz ,  David Lenox Storch ,  Charles William Swanson

IPC: G06F17/30

CPC classification number: G06F16/258 ,  G06F16/24556 ,  G06F16/2471 ,  G06F16/248 ,  G06F16/254 ,  G06F16/27 ,  G06F16/284 ,  G06F16/951 ,  G06F16/958

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.

公开(公告)号：US20170262441A1

公开(公告)日：2017-09-14

申请号：US15605069

申请日：2017-05-25

Applicant: Eliot Horowitz ,  David Lenox Storch ,  Mathias Benjamin Stearn

Inventor： Eliot Horowitz ,  David Lenox Storch ,  Mathias Benjamin Stearn

IPC: G06F17/30 ,  G06F17/27

CPC classification number: G06F16/211 ,  G06F16/215 ,  G06F17/2725 ,  G06T11/206

Abstract: A system is provided that includes a document validation within a non-relational database system that is capable of reviewing documents according to one or more validation rules. The document validator may be incorporated within a non-relational database engine and may perform validation operations when one or more database functions are performed.

公开(公告)号：US20180300385A1

公开(公告)日：2018-10-18

申请号：US16013706

申请日：2018-06-20

Applicant: Dwight Merriman ,  Eliot Horowitz ,  Cory P. Mintz ,  Cailin Anne Nelson ,  Akshay Kumar ,  David Lenox Storch ,  Charles William Swanson ,  Keith Bostic ,  Michael Cahill ,  Dan Pasette ,  Mathias Benjamin Stearn ,  Geert Bosch

Inventor： Dwight Merriman ,  Eliot Horowitz ,  Cory P. Mintz ,  Cailin Anne Nelson ,  Akshay Kumar ,  David Lenox Storch ,  Charles William Swanson ,  Keith Bostic ,  Michael Cahill ,  Dan Pasette ,  Mathias Benjamin Stearn ,  Geert Bosch

IPC: G06F17/30

Abstract: Systems and methods are provided to enable control and placement of data repositories. In some embodiments, the system segments data into zones. A website, for example, may need to segment data according to location. In this example, a zone may be created for North America and another zone may be created for Europe. Data related to operations executed in North America, for example, can be placed in the North America zone and data related to transactions in Europe can be placed in the Europe zone. According to some embodiments, the system may use zones to accommodate a range of deployment scenarios.

公开(公告)号：US20180300381A1

公开(公告)日：2018-10-18

申请号：US16013720

申请日：2018-06-20

Applicant: Eliot Horowitz ,  David Lenox Storch ,  Charles William Swanson

Inventor： Eliot Horowitz ,  David Lenox Storch ,  Charles William Swanson

IPC: G06F17/30

Abstract: A system and computer implemented method for execution of aggregation expressions on a distributed non-relational database system is provided. According to an aspect, an operation is provided to perform the aggregation operation. An indication of at least one foreign collection of documents is accepted. An indication of at least one variable for at least one local field of at least one local collection of documents is accepted. An indication of a pipeline for execution on the at least one local collection of documents and the at least one foreign collection of documents is accepted. An operation comparing the local field of the at least one local collection of documents and the foreign field of the at least one foreign collection of documents is performed. Responsive to the operation, data from the at least one local collection of documents and the at least one foreign collection of documents is aggregated.

公开(公告)号：US20170344588A1

公开(公告)日：2017-11-30

申请号：US15605196

申请日：2017-05-25

Applicant: Eliot Horowitz ,  David Lenox Storch

Inventor： Eliot Horowitz ,  David Lenox Storch

IPC: G06F17/30

CPC classification number: G06F16/2228

Abstract: According to one aspect, methods and systems are provided for creating partial indexes in a distributed database environment. The database includes an index engine configured to receive at least one index field, a criteria field, and a criteria condition, wherein the criteria field is not included in the at least one index field; and generate an index comprising the at least one index field from at least one record of the plurality of records and a pointer to the at least one record of the plurality of records, wherein the criteria field of the at least one record of the plurality of records satisfies the criteria condition. The database further includes a query engine configured to receive a search query containing the at least one index field; and search the index for the at least one index field.

公开(公告)号：US20170286510A1

公开(公告)日：2017-10-05

申请号：US15605391

申请日：2017-05-25

Applicant: Eliot Horowitz ,  David Lenox Storch ,  Charles William Swanson

Inventor： Eliot Horowitz ,  David Lenox Storch ,  Charles William Swanson

IPC: G06F17/30

CPC classification number: G06F16/258 ,  G06F16/23 ,  G06F16/24556 ,  G06F16/2471 ,  G06F16/248 ,  G06F16/254 ,  G06F16/27 ,  G06F16/284 ,  G06F16/951 ,  G06F16/958

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.

公开(公告)号：US20170262440A1

公开(公告)日：2017-09-14

申请号：US15605032

申请日：2017-05-25

Applicant: Eliot Horowitz ,  David Lenox Storch ,  Mathias Benjamin Stearn

Inventor： Eliot Horowitz ,  David Lenox Storch ,  Mathias Benjamin Stearn

IPC: G06F17/30 ,  G06F17/27

CPC classification number: G06F16/93 ,  G06F16/2423 ,  G06F17/2725

Abstract: A system is provided that includes a document validation within a non-relational database system that is capable of reviewing documents according to one or more validation rules. The document validator may be incorporated within a non-relational database engine and may perform validation operations when one or more database functions are performed.