The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Dec. 17, 2024
Filed:
Feb. 27, 2023
Snowflake Inc., Bozeman, MT (US);
Varun Ganesh, San Bruno, CA (US);
Saiyang Gou, Los Angeles, CA (US);
Prasanna Rajaperumal, Bangalore, IN;
Wenhao Song, Seattle, WA (US);
Libo Wang, Foster City, CA (US);
Jiaqi Yan, Menlo Park, CA (US);
Snowflake Inc., Bozeman, MT (US);
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.