Patent ID: 11860869
Assignee: AMAZON TECHNOLOGIES, INC.
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 0:
1. A system, comprising:
a first one or more processors and a first memory that implement a storage node that stores a common copy of data for a database in a common format;
a second one or more processors and a second memory that implement an Online Transaction Processing (OLTP) type of query engine for the common copy of the data of the database stored in the common format at the data node, wherein the OLTP type of query engine is communicatively coupled to the storage node via a first network connection;
a third one or more processors and a third memory that implement an Online Analytical Processing (OLAP) type of query engine for the common copy of the data of the database stored in the common format at the data node, wherein the OLAP type of query engine is communicatively coupled to the storage node over a second network connection different from the first network connection;
the OTLP type of query engine, configured to:
receive a query to the database;
identify at least a portion of the query to be performed at the OLAP type of query engine;
determine a consistent view of a data set of the database applicable to the query, the consistent view comprising one or more changes to the common copy of the data of the data set stored on the storage node;
send a request to the OLAP type of query engine to perform the portion of the query; and
provide the OLAP type of query engine with the consistent view of the data set applicable to the query;

the OLAP type of query engine, configured to:
obtain, responsive to receipt of the request to perform the portion of the query, the common copy of the data of the data set in the common format from the storage node via the second network connection,
the obtained data comprising a current value not within the consistent view of the data set;
apply the one or more changes of the consistent view of the data set provided by the OLTP query engine when evaluating the obtained data of the database as part of performing the portion of the query on the consistent view of the database; and
return a result of the portion of the query to the OLTP query engine; and

the OTLP type of query engine, further configured to:
return a final result of the query based, at least in part, on the result received from the OLAP type of query engine.