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.

Date of Patent:
Dec. 23, 2025

Filed:

Jun. 24, 2025
Applicant:

Snowflake Inc., Bozeman, MT (US);

Inventors:

Dmitrii Maksimenko, Berlin, DE;

Noble Mushtak, San Mateo, CA (US);

Ankur Sharma, Berlin, DE;

Malek Souissi, Berlin, DE;

Lars Volker, Los Altos, CA (US);

Assignee:

Snowflake Inc., Bozeman, MT (US);

Attorney:
Primary Examiner:
Int. Cl.
CPC ...
G06F 16/21 (2019.01); G06F 16/215 (2019.01); G06F 16/23 (2019.01);
U.S. Cl.
CPC ...
G06F 16/219 (2019.01); G06F 16/215 (2019.01); G06F 16/235 (2019.01); G06F 16/2365 (2019.01);
Abstract

The subject technology provides modifying data in a partition stores a version identifier and a set of physical row positions in a header, including minimum and maximum value occurrences for each column. When a query to modify data is received, the subject technology determines which rows to modify, checks eligibility for skipping partition scanning, and compares the to-be-modified positions with the stored positions. If no stored positions are modified, the subject technology skips scanning and maintains existing statistics, and creates a new combined partition without recalculating statistics. If modifications are made, the subject technology evaluates eligibility for processing using delta files and a bitset, or performs a copy-on-write process if ineligible.


Find Patent Forward Citations

Loading…