中科微点-全球专利检索

  1. Login
  2. Sign Up

Search Results

610 records (took 0.017 seconds)

    Data sharing in a multi-tenant database system
    462.
    发明授权
    Data sharing in a multi-tenant database system 有权

    公开(公告)号：US10817616B2

    公开(公告)日：2020-10-27

    申请号：US16833482

    申请日：2020-03-27

    Applicant: Snowflake Inc.

    Inventor： Benoit Dageville ,  Thierry Cruanes ,  Martin Hentschel ,  Peter Povinec

    IPC: G06F21/62 ,  G06F16/25

    Abstract: A method for sharing data in a multi-tenant database includes generating a share object in a first account comprising a share role. The method includes associating one or more access rights with the share role, wherein the one or more access rights indicate which objects in the first account are accessible based on the share object. The method includes granting, to a second account, cross-account access rights to the share role or share object in the first account. The method includes receiving a request from the second account to access data or services of the first account. The method further includes providing a response to the second account based on the data or services of the first account.

    Incremental clustering maintenance of a table
    463.
    发明授权
    Incremental clustering maintenance of a table 有权

    公开(公告)号：US10817540B2

    公开(公告)日：2020-10-27

    申请号：US15694436

    申请日：2017-09-01

    Applicant: SNOWFLAKE INC.

    Inventor： Thierry Cruanes ,  Marcin Zukowski ,  Benoit Dageville ,  Jiaqi Yan

    IPC: G06F16/30 ,  G06F16/28 ,  G06F16/21 ,  G06F16/245 ,  G06F16/22 ,  G06F16/00

    Abstract: A method includes storing table data for a table in a plurality of partitions and for maintaining approximate or good enough clustering. The method includes creating one or more new partitions based on changes to the table, wherein at least one of the one or more new partitions overlap with each other or previous partitions resulting in a decrease in a degree of clustering of the table. The method includes determining that a degree of clustering of the table data is below a clustering threshold. The method further includes reclustering one or more partitions of the table to improve the degree of clustering of the table in response to one or more of: determining that the degree of clustering has fallen below the clustering threshold, an explicit user command from a user, and/or as part of a DML command. Reclustering may be performed in incremental steps to iteratively improve clustering.

    Automated Maintenance of External Tables in Database Systems
    464.
    发明申请
    Automated Maintenance of External Tables in Database Systems 审中-公开

    公开(公告)号：US20200334240A1

    公开(公告)日：2020-10-22

    申请号：US16385837

    申请日：2019-04-16

    Applicant: Snowflake Inc.

    Inventor： Subramanian Muralidhar ,  Benoit Dageville ,  Thierry Cruanes ,  Nileema Shingte ,  Saurin Shah ,  Torsten Grabs ,  Istvan Cseri

    IPC: G06F16/242 ,  G06F16/23 ,  G06F3/06 ,  G06F16/25 ,  G06F16/16 ,  G06F16/22 ,  G06F9/54

    Abstract: Systems, methods, and devices for automated maintenance of external tables in database systems are disclosed. A method includes receiving, by a database platform, read access to content in an external data storage platform that is separate from the database platform. The method includes defining an external table based on the content in the external data storage platform. The method includes connecting the database platform to the external table such that the database platform has read access for the external table and does not have write access for the external table. The method includes generating metadata for the external table, the metadata comprising information about data stored in the external table. The method includes receiving a notification that a modification has been made to the content in the external data storage platform, the modification comprising one or more of an addition of a file, a deletion of a file, or an update to a file in a source location for the external table. The method includes refreshing the metadata for the external table in response to the modification being made to the content in the external data storage platform.

    Multi-Level Metadata in Database Systems
    469.
    发明申请
    Multi-Level Metadata in Database Systems 审中-公开

    公开(公告)号：US20200272637A1

    公开(公告)日：2020-08-27

    申请号：US16283431

    申请日：2019-02-22

    Applicant: Snowflake Inc.

    Inventor： Ashish Motivala ,  Yi Fang ,  Martin Hentschel ,  Benoit Dageville ,  Spyros Triantafyllis ,  Yizhi Zhu

    IPC: G06F16/27 ,  G06F16/245 ,  G06F16/22

    Abstract: Systems, methods, and devices for multiple level metadata organization in database systems. A system includes a plurality of shared storage devices collectively storing database data across a plurality of tables that each comprise one or more micro-partitions constituting immutable storage devices. The system includes a resource manager configured to manage the storage of database data stored in a table across one or more of the plurality of shared storage devices. The resource manager is configured to manage the storage of metadata for the table. The metadata includes a column expression property with information about data stored in a column, a micro-partition expression property with information about data stored in a micro-partition, a grouping expression property with information about data stored in two or more micro-partitions, and cumulative table metadata with global information about all micro-partitions of the table.

Patent Agency Ranking