公开(公告)号：US20240111735A1

公开(公告)日：2024-04-04

申请号：US18051447

申请日：2022-10-31

Applicant: Snowflake Inc.

Inventor： Durga Mahesh Arikatla ,  Robert K. Chao ,  Li He ,  Joyce Lam ,  Xinyue Liu ,  Subramanian Muralidhar ,  Vishnu Dutt Paladugu ,  Shakhina Pulatova ,  Stephanie Stillman ,  Xin Wen ,  Di Wu ,  Ziqi Xu

IPC: G06F16/21

CPC classification number: G06F16/213

Abstract: A data dictionary generation system automatically populates and updates a data dictionary for listings offering shared data. A data dictionary includes metadata describing the shared data, including the individual objects, such as the individual tables, schemas, views, and functions. The shared data and each individual data object may be described in the data dictionary by a set of data fields that corresponds to the shared dataset or the object type of the individual object. The data dictionary can be presented to data consumers along with the description of the listing to provide data consumers with a comprehensive description of the shared data provided by a listing, including a high-level summary of the shared data and description of each individual object included in the shared data. The data dictionary allows data consumers to understand the contents of the shared data and how to use the shared data.

公开(公告)号：US20250013663A1

公开(公告)日：2025-01-09

申请号：US18897473

申请日：2024-09-26

Applicant: Snowflake Inc.

Inventor： Durga Mahesh Arikatla ,  Subramanian Muralidhar ,  Vishnu Dutt Paladugu ,  Shakhina Pulatova ,  Di Wu ,  Ziqi Xu

IPC: G06F16/27 ,  G06Q30/0201 ,  G06Q30/0601

Abstract: A data dictionary generation system automatically populates and updates a data dictionary for listings offering shared data. The data listing distribution component distributes the data dictionaries to various remote deployments in a data exchange by using a global messaging framework and replication method. For example, the data listing distribution component replicates a data dictionary generated for the listing and its shared data from a source deployment to one or more destination deployments associated with various geographic regions. The data listing distribution component distributes the listing to the various remote deployments to allow for the listing, including its shared data and data dictionary, to be accessed by users within the geographic region associated with the remote deployment.

公开(公告)号：US12099625B2

公开(公告)日：2024-09-24

申请号：US17665027

申请日：2022-02-04

Applicant: Snowflake Inc.

Inventor： Emily B. Dillon ,  Travis Kaufman ,  Adil Lalani ,  Paul O. Lanzoni ,  Shakhina Pulatova

IPC: G06F21/62 ,  G06F16/2458 ,  G06F16/28

CPC classification number: G06F21/6227 ,  G06F16/2465 ,  G06F16/283 ,  G06F2221/2113 ,  G06F2221/2141

Abstract: Embodiments of the present disclosure provide techniques for associating use case data with data listings in a structured manner, thereby allowing for data listings to be organized and/filtered based on use case information. A processing device may provide a listing creation interface that is used to assign a set of use cases to a first data listing and publish the data listing on a data exchange. The data listing is one of a plurality of data listings published on the data exchange and the processing device may provide a data listing interface for displaying the plurality of data listings and an interactable menu including a selectable indication of each of the plurality of use cases. In response to receiving a selection of one or more of the plurality of use cases via the interactable menu, the processing device may display in the data listing interface, each of the plurality of data listings that have been assigned any of the selected one or more use cases.

公开(公告)号：US11989164B2

公开(公告)日：2024-05-21

申请号：US18051447

申请日：2022-10-31

Applicant: Snowflake Inc.

Inventor： Durga Mahesh Arikatla ,  Robert K. Chao ,  Li He ,  Joyce Lam ,  Xinyue Liu ,  Subramanian Muralidhar ,  Vishnu Dutt Paladugu ,  Shakhina Pulatova ,  Stephanie Stillman ,  Xin Wen ,  Di Wu ,  Ziqi Xu

IPC: G06F16/21

CPC classification number: G06F16/213

Abstract: A data dictionary generation system automatically populates and updates a data dictionary for listings offering shared data. A data dictionary includes metadata describing the shared data, including the individual objects, such as the individual tables, schemas, views, and functions. The shared data and each individual data object may be described in the data dictionary by a set of data fields that corresponds to the shared dataset or the object type of the individual object. The data dictionary can be presented to data consumers along with the description of the listing to provide data consumers with a comprehensive description of the shared data provided by a listing, including a high-level summary of the shared data and description of each individual object included in the shared data. The data dictionary allows data consumers to understand the contents of the shared data and how to use the shared data.

公开(公告)号：US20240111885A1

公开(公告)日：2024-04-04

申请号：US18306704

申请日：2023-04-25

Applicant: Snowflake Inc.

Inventor： Durga Mahesh Arikatla ,  Subramanian Muralidhar ,  Vishnu Dutt Paladugu ,  Shakhina Pulatova ,  Di Wu ,  Ziqi Xu

IPC: G06F21/62 ,  G06F21/60

CPC classification number: G06F21/6218 ,  G06F21/604 ,  G06F2221/2141

Abstract: A data dictionary generation system utilizes a background service that is programmed to automatically populate and update a data dictionary for listings offering shared data. A data dictionary includes metadata describing the shared data overall as well as the individual objects included in the listing, such as the individual tables, schemas, views, and functions. To generate the data dictionary, the data dictionary generation system analyzes the shared data to identify objects, identifies a set of data fields associated with each identified object and populates the set of data fields associated with each identified object based on the shared data offered by the listing. To ensure that a data dictionary for each listing remains up to date, the data dictionary generation system periodically scans the listings to identify any changes to share access granted to the listings.

公开(公告)号：US20230401185A1

公开(公告)日：2023-12-14

申请号：US18112934

申请日：2023-02-22

Applicant: Snowflake Inc.

Inventor： Orestis Kostakis ,  Prasanna V. Krishnan ,  Subramanian Muralidhar ,  Shakhina Pulatova ,  Megan Marie Schoendorf

IPC: G06F16/215 ,  G06F16/2457 ,  G06F16/25 ,  G06F16/176

CPC classification number: G06F16/215 ,  G06F16/24578 ,  G06F16/256 ,  G06F16/176

Abstract: A set of affinity metrics may be determined for a set of listings, each listing of the set of listings comprising data to be shared through a data exchange, wherein the set of affinity metrics includes a set of characteristics allowing identification of a listing having one or more characteristics in the set of characteristics. For each pair of listings of the set of listings, an affinity score can be calculated, using the set of affinity metrics, and stored as part of the record in an affinity store. One or more listings of the set of listings using the affinity score between the first listing of the set of listings and the one or more listings of the set of listings can be presented.

公开(公告)号：US11669630B1

公开(公告)日：2023-06-06

申请号：US18051401

申请日：2022-10-31

Applicant: Snowflake Inc.

Inventor： Durga Mahesh Arikatla ,  Subramanian Muralidhar ,  Vishnu Dutt Paladugu ,  Shakhina Pulatova ,  Di Wu ,  Ziqi Xu

IPC: G06F21/62 ,  G06F21/78 ,  G06F21/60 ,  G06F21/64

CPC classification number: G06F21/6218 ,  G06F21/604 ,  G06F2221/2141

Abstract: A data dictionary generation system utilizes a background service that is programmed to automatically populate and update a data dictionary for listings offering shared data. A data dictionary includes metadata describing the shared data overall as well as the individual objects included in the listing, such as the individual tables, schemas, views, and functions. To generate the data dictionary, the data dictionary generation system analyzes the shared data to identify objects, identifies a set of data fields associated with each identified object and populates the set of data fields associated with each identified object based on the shared data offered by the listing. To ensure that a data dictionary for each listing remains up to date, the data dictionary generation system periodically scans the listings to identify any changes to share access granted to the listings.