公开(公告)号：US20230267130A1

公开(公告)日：2023-08-24

申请号：US18309056

申请日：2023-04-28

Applicant: Snowflake Inc.

Inventor： Leonidas Galanis ,  Alexander Miller ,  William Waddington ,  Khaled Yagoub

IPC: G06F16/25 ,  G06F16/2452 ,  G06F16/28 ,  G06F16/2455 ,  G06F16/27

CPC classification number: G06F16/258 ,  G06F16/256 ,  G06F16/24524 ,  G06F16/283 ,  G06F16/24564 ,  G06F16/27

Abstract: The subject technology receives, by a first set of decoupled compute instances of a distributed database, a plurality of transactional queries against a transactional processing database stored on a first set of decoupled storage instances, at least one of the first set of decoupled compute instances bypassing a compiler of the distributed database to process the plurality of transactional queries using locally cached data. The subject technology receives at least one select query for processing on an aggregated analytical query database of the distributed database. The subject technology generates, by the compiler of the distributed database, a query plan for execution of the at least one select query using a second set of decoupled compute instances. The subject technology generates, by the second set of decoupled compute instances, an aggregated analytical query result dataset for the at least one select query according to the query plan.

公开(公告)号：US20220188325A1

公开(公告)日：2022-06-16

申请号：US17249598

申请日：2021-03-05

Applicant: Snowflake Inc.

Inventor： Leonidas Galanis ,  Alexander Miller ,  William Waddington ,  Khaled Yagoub

IPC: G06F16/25 ,  G06F16/27 ,  G06F16/28 ,  G06F16/2455 ,  G06F16/2452

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.

公开(公告)号：US11675806B2

公开(公告)日：2023-06-13

申请号：US17249598

申请日：2021-03-05

Applicant: Snowflake Inc.

Inventor： Leonidas Galanis ,  Alexander Miller ,  William Waddington ,  Khaled Yagoub

IPC: G06F16/30 ,  G06F16/25 ,  G06F16/2452 ,  G06F16/28 ,  G06F16/2455 ,  G06F16/27

CPC classification number: G06F16/258 ,  G06F16/24524 ,  G06F16/24564 ,  G06F16/256 ,  G06F16/27 ,  G06F16/283

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.