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:
Feb. 28, 2023
Filed:
Jan. 21, 2022
Snowflake Inc., Bozeman, MT (US);
Tyler Arthur Akidau, Seattle, WA (US);
Istvan Cseri, Seattle, WA (US);
Fabian Hueske, Berlin, DE;
Tyler Jones, Redwood City, CA (US);
Yevgeniy Kogan, Kirkland, WA (US);
Dzmitry Pauliukevich, Berlin, DE;
Daniel E. Sotolongo, Seattle, WA (US);
Snowflake Inc., Bozeman, MT (US);
Abstract
Techniques described herein can accelerate change data capture determinations such as stream reads, which show changes made to a table between two points in time. Three distinct row bitests that mark deleted, updated, inserted, rows in micro-partitions can be added as metadata for the table. These bitsets can be generated during DML operations and then stored as metadata of the new partition generated by the DML operations. The bitsets can then be used to generate streams showing the changes in the table between two points in time (changes interval).