-
公开(公告)号：US11822582B2
公开(公告)日：2023-11-21
申请号：US17896446
申请日：2022-08-26
Applicant: SNOWFLAKE INC.
Inventor： Yi Fang , Varun Ganesh , Xinglian Liu , Ryan Michael Thomas Shelly , Jiaqi Yan , Yizhi Zhu
IPC: G06F16/28
CPC classification number: G06F16/285
Abstract: Embodiments of the present disclosure describe systems, methods, and computer program products for improving query processing of a database. An example method can include: storing table data for a table in a plurality of micro-partitions, each micro-partition comprising a portion of the table data for the table; for each micro-partition of the plurality of micro-partitions, storing metadata for the micro-partition in at least one of a plurality of expression properties; and selecting, by a processing device, a subset of the plurality of expression properties to be grouped into a grouping expression property based at least partially on the metadata of the subset of the plurality of the expression properties. The grouping expression property may include cumulative metadata associated with the metadata of the subset of the plurality of expression properties.
-
Patent Agency Ranking
公开(公告)号：US11899646B2
公开(公告)日：2024-02-13
申请号：US18193069
申请日：2023-03-30
Applicant: Snowflake Inc.
Inventor： Selcuk Aya , Thierry Cruanes , Istvan Cseri , Benoit Dageville , Marcia Feitel , Steven P. Herbert , Xinglian Liu , James Malone , Subramanian Muralidhar , Muthunagappan Muthuraman , Polita Paulus , Marianne Shaw , Nileema Shingte , Wai Sing Wong , Jiaqi Yan
CPC classification number: G06F16/2282 , G06F16/2379 , G06F16/258
Abstract: The subject technology receives a command to commit a table in a different table format on an external volume. The subject technology generates a first snapshot of the table on internal storage. The subject technology generates a first list of metadata files on the internal storage. The subject technology generates, based on the first list of metadata files, a first set of metadata files on the internal storage. The subject technology generates a second snapshot of the table on the external volume. The subject technology generates a second list of metadata files on the external volume. The subject technology generates, based on the second list of metadata files, a second set of metadata files on the external volume. The subject technology generates a first set of data files in a different file format on the external volume.
-
公开(公告)号：US20230401193A1
公开(公告)日：2023-12-14
申请号：US18193069
申请日：2023-03-30
Applicant: Snowflake Inc.
Inventor： Selcuk Aya , Thierry Cruanes , Istvan Cseri , Benoit Dageville , Marcia Feitel , Steven P. Herbert , Xinglian Liu , James Malone , Subramanian Muralidhar , Muthunagappan Muthuraman , Polita Paulus , Marianne Shaw , Nileema Shingte , Wai Sing Wong , Jiaqi Yan
CPC classification number: G06F16/2282 , G06F16/2379 , G06F16/258
Abstract: The subject technology receives a command to commit a table in a different table format on an external volume. The subject technology generates a first snapshot of the table on internal storage. The subject technology generates a first list of metadata files on the internal storage. The subject technology generates, based on the first list of metadata files, a first set of metadata files on the internal storage. The subject technology generates a second snapshot of the table on the external volume. The subject technology generates a second list of metadata files on the external volume. The subject technology generates, based on the second list of metadata files, a second set of metadata files on the external volume. The subject technology generates a first set of data files in a different file format on the external volume.
-
4.发明申请公开(公告)号：US20240427755A1
公开(公告)日：2024-12-26
申请号：US18517744
申请日：2023-11-22
Applicant: Snowflake Inc.
Inventor： Selcuk Aya , Thierry Cruanes , Istvan Cseri , Benoit Dageville , Marcia Feitel , Steven P. Herbert , Dennis Huo , Xinglian Liu , Nithin Mahesh , James Malone , Subramanian Muralidhar , Muthunagappan Muthuraman , Ronald Lee Ortloff , Polita Paulus , Marianne Shaw , Nileema Shingte , Wai Sing Wong , Jiaqi Yan
IPC: G06F16/22 , G06F16/215 , G06F16/2457
Abstract: The subject technology provides embodiments for supporting a unified table which may be a managed table or an unmanaged table. Managed tables are those where the subject technology manages the metastore/catalog for the table, whereas unmanaged tables are tables where an external catalog controls the table and the subject technology integrates with that catalog to work with the table, but does not assume control of the table.
-
5.发明授权公开(公告)号：US12050582B1
公开(公告)日：2024-07-30
申请号：US18498463
申请日：2023-10-31
Applicant: Snowflake Inc.
Inventor： Selcuk Aya , Thierry Cruanes , Istvan Cseri , Benoit Dageville , Marcia Feitel , Steven P. Herbert , Dennis Huo , Xinglian Liu , Nithin Mahesh , James Malone , Subramanian Muralidhar , Muthunagappan Muthuraman , Ronald Lee Ortloff , Polita Paulus , Marianne Shaw , Nileema Shingte , Wai Sing Wong , Jiaqi Yan
IPC: G06F16/22 , G06F16/215 , G06F16/2457
CPC classification number: G06F16/2282 , G06F16/215 , G06F16/24573
Abstract: The subject technology provides embodiments for supporting a unified table which may be a managed table or an unmanaged table. Managed tables are those where the subject technology manages the metastore/catalog for the table, whereas unmanaged tables are tables where an external catalog controls the table and the subject technology integrates with that catalog to work with the table, but does not assume control of the table.
-
公开(公告)号：US20230229676A1
公开(公告)日：2023-07-20
申请号：US17896446
申请日：2022-08-26
Applicant: SNOWFLAKE INC.
Inventor： Yi Fang , Varun Ganesh , Xinglian Liu , Ryan Michael Thomas Shelly , Jiaqi Yan , Yizhi Zhu
IPC: G06F16/28
CPC classification number: G06F16/285
Abstract: Embodiments of the present disclosure describe systems, methods, and computer program products for improving query processing of a database. An example method can include: storing table data for a table in a plurality of micro-partitions, each micro-partition comprising a portion of the table data for the table; for each micro-partition of the plurality of micro-partitions, storing metadata for the micro-partition in at least one of a plurality of expression properties; and selecting, by a processing device, a subset of the plurality of expression properties to be grouped into a grouping expression property based at least partially on the metadata of the subset of the plurality of the expression properties. The grouping expression property may include cumulative metadata associated with the metadata of the subset of the plurality of expression properties.
-
-
-
-
-
Search Results
6
records
(took 0.019 seconds)
