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:
Sep. 19, 2023
Filed:
Sep. 13, 2022
Snowflake Inc., Bozeman, MT (US);
Tyler Arthur Akidau, Seattle, WA (US);
Fabian Hueske, Berlin, DE;
Tyler Jones, Redwood City, CA (US);
Daniel Mills, Seattle, WA (US);
Leon Papke, Berlin, DE;
Prasanna Rajaperumal, Bangalore, IN;
Daniel E. Sotolongo, Seattle, WA (US);
Snowflake Inc., Bozeman, MT (US);
Abstract
Provided herein are systems and methods for a database object (e.g., materialized table) configuration including using the database object for incremental maintenance of query results. For example, a method includes creating a materialized table using a table definition. The table definition includes a query on one or more base tables and a lag duration value. The lag duration value indicates a maximum time period that a result of a prior refresh of the query can lag behind a current time instance. A delta set for the one or more base tables is determined. The delta set includes at least one change applied to the one or more base tables since the prior refresh of the query. The delta set is merged with the materialized table to perform an incremental update of the materialized table.