Aggregate and transactional networked database query processing
AssigneeSnowflake Inc.
InventorsLeonidas Galanis, Alexander Miller, William Waddington, Khaled Yagoub
Life of this patent
Estimating the term…
Abstract
A hybrid network-based database system for handling OLTP and OLAP queries using decoupled compute and storage devices. A set of decoupled compute instances perform transactions on an OLTP database, and the data is replicated to an OLAP database, which is managed by another set of decoupled compute instances. Further, in response to queries, the database system can retrieve data from the OLTP and OLAP database for merging and processing according to the query.
Claims20
A method comprising:
- receiving, by a first set of decoupled compute instances of a distributed database, a plurality of transactional queries against a transactional processing database, each of the plurality of transactional queries comprising data manipulation language statements that change data in the transactional processing database;
- replicating, by one or more hardware processors, the changed data from the transactional processing database to an object store database of an aggregated analytical query database managed by a second set of decoupled compute instances of the distributed database;
- receiving one or more select queries against the aggregated analytical query database;
- and
- generating, by the second set of decoupled compute instances, an aggregated analytical query result dataset for the one or more select queries in response to the one or more select queries.
A system comprising:
- one or more hardware processors;
- and
- at least one memory storing instructions that, when executed by the one or more processors, cause the one or more hardware processors to perform operations comprising:
- receiving, by a first set of decoupled compute instances of a distributed database, a plurality of transactional queries against a transactional processing database, each of the plurality of transactional queries comprising data manipulation language statements that change data in the transactional processing database;
- replicating the changed data from the transactional processing database to an object store database of an aggregated analytical query database managed by a second set of decoupled compute instances of the distributed database;
- receiving one or more select queries against the aggregated analytical query database;
- and
- generating, by the second set of decoupled compute instances, aggregated analytical query result dataset for the one or more select queries in response to the one or more select queries.
A computer-storage medium embodying instructions that, when executed by a one or more hardware processors, cause the one or more hardware processors to perform operations comprising:
- receiving, by a first set of decoupled compute instances of a distributed database, a plurality of transactional queries against a transactional processing database, each of the plurality of transactional queries comprising data manipulation language statements that change data in the transactional processing database;
- replicating the changed data from the transactional processing database to an object store database of an aggregated analytical query database managed by a second set of decoupled compute instances of the distributed database;
- receiving one or more select queries against the aggregated analytical query database;
- and
- generating, by the second set of decoupled compute instances, aggregated analytical query result dataset for the one or more select queries in response to the one or more select queries.
Dependencies are inferred from the claim text.