公开(公告)号：US20240427790A1

公开(公告)日：2024-12-26

申请号：US18497746

申请日：2023-10-30

Applicant: Snowflake Inc.

Inventor： Xinzhu Cai ,  Bowei Chen ,  Prateek Gaur ,  Dmitry A. Lychagin ,  Muthunagappan Muthuraman ,  Zhuo Peng ,  Mengran Wang ,  Jiaqi Yan

IPC: G06F16/25 ,  G06F16/835

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.