公开(公告)号：US20230222121A1

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

申请号：US18175007

申请日：2023-02-27

Applicant: Snowflake Inc.

Inventor： Varun Ganesh ,  Saiyang Gou ,  Prasanna Rajaperumal ,  Wenhao Song ,  Libo Wang ,  Jiaqi Yan

IPC: G06F16/23 ,  G06F16/28 ,  G06F16/21

CPC classification number: G06F16/2393 ,  G06F16/285 ,  G06F16/21

Abstract: Methods, systems, and computer programs are presented for providing a cluster view method of a database to perform compaction and clustering of database objects, such as database materialized view. A cluster view system identifies a materialized view including data from one or more base tables, a portion of the data of the materialized view including stale data. The cluster view system performs an integrated task within a maintenance operation on a database, the integrated task including compacting the materialized view, the maintenance operation including clustering the materialized view, and stores the compacted and clustered materialized view in the database.

公开(公告)号：US12169490B2

公开(公告)日：2024-12-17

申请号：US18175007

申请日：2023-02-27

Applicant: Snowflake Inc.

Inventor： Varun Ganesh ,  Saiyang Gou ,  Prasanna Rajaperumal ,  Wenhao Song ,  Libo Wang ,  Jiaqi Yan

IPC: G06F16/00 ,  G06F16/22 ,  G06F16/2453 ,  G06F16/2455 ,  G06F16/28

Abstract: Methods, systems, and computer programs are presented for providing a cluster view method of a database to perform compaction and clustering of database objects, such as database materialized view. A cluster view system identifies a materialized view including data from one or more base tables, a portion of the data of the materialized view including stale data. The cluster view system performs an integrated task within a maintenance operation on a database, the integrated task including compacting the materialized view, the maintenance operation including clustering the materialized view, and stores the compacted and clustered materialized view in the database.

公开(公告)号：US11593368B1

公开(公告)日：2023-02-28

申请号：US17661545

申请日：2022-04-29

Applicant: Snowflake Inc.

Inventor： Varun Ganesh ,  Saiyang Gou ,  Prasanna Rajaperumal ,  Wenhao Song ,  Libo Wang ,  Jiaqi Yan

IPC: G06F16/00 ,  G06F16/2453 ,  G06F16/28 ,  G06F16/22 ,  G06F16/2455

Abstract: A cluster view method of a database to perform compaction and clustering of database objects, such as database materialized view is shown. The database can comprise a cache to store changes to storage units of tables of the database objects. The cluster view method can implement clustering to remove data based on the cache and clustering to group the data of the materialized view.