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:
Apr. 14, 2025
Filed:
Dec. 20, 2023
Snowflake Inc., Bozeman, MT (US);
Srilakshmi Chintala, Seattle, WA (US);
Jianzhun Du, Kirkland, WA (US);
Naresh Kumar, Santa Clara, CA (US);
Srinath Shankar, Belmont, CA (US);
Leonhard Franz Spiegelberg, San Francisco, CA (US);
Eric Shawn Vandenberg, Saratoga, CA (US);
Andong Zhan, San Mateo, CA (US);
Yun Zou, Sunnyvale, CA (US);
Snowflake Inc., Bozeman, MT (US);
Abstract
A method provides deterministic row ordering for query result sets in a database system. A framework receives a query referencing a database table and generating a row index column in response. The framework generates the row index column that involves determining an order associated with source files underlying the referenced table and assigns each table row a unique index value based on the file order and row position within the files. The framework executes the received query to produce a result set ordered by the generated row index column. The framework determines row order based on analyzing underlying data file metadata and facilitates returning the result set with consistent, reliable ordering, enabling stable positional-based access semantics when querying distributed database tables.