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:
Jun. 03, 2025
Filed:
Oct. 30, 2023
Snowflake Inc., Bozeman, MT (US);
Xinzhu Cai, San Mateo, CA (US);
Bowei Chen, San Bruno, CA (US);
Prateek Gaur, San Jose, CA (US);
Dmitry A. Lychagin, San Jose, CA (US);
Muthunagappan Muthuraman, Sunnyvale, CA (US);
Zhuo Peng, San Jose, CA (US);
Mengran Wang, San Jose, CA (US);
Jiaqi Yan, Menlo Park, CA (US);
Snowflake Inc., Bozeman, MT (US);
Abstract
The subject technology receives a query, the query referencing a unified representation for structured type data and semi-structured type data, the unified representation being provided in storage and in memory during query processing, the unified representation comprising a set of structured type fields that include a set of semi-structured typed fields that enables type safety and enforcement for the set of structured type fields, and flexibility for the set of semi-structured typed fields in a same column, the unified representation in storage including type information for the semi-structured type data as part of the semi-structured type data, the unified representation being utilized for structured type data and semi-structured type data. The subject technology processes the query using the unified representation stored in the memory, the unified representation providing performance parity between structured type data and semi-structured type data.