知搜-全球专利检索

  1. 登录
  2. 注册

搜索结果

572 条记录 (耗时 0.034 秒)

    Database replication for a remote deployment
    4.
    发明授权
    Database replication for a remote deployment 有权

    公开(公告)号：US12032595B2

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

    申请号：US18128130

    申请日：2023-03-29

    申请人： Snowflake Inc.

    发明人： Pui Kei Johnston Chu ,  Benoit Dageville ,  Shreyas Narendra Desai ,  Sameer Deshpande ,  Subramanian Muralidhar ,  Di Wu

    IPC分类号： G06F16/00 ,  G06F16/182 ,  G06F16/245 ,  G06F16/27

    CPC分类号： G06F16/273 ,  G06F16/1844 ,  G06F16/245

    摘要： Techniques for database replication for a remote deployment include a method performed by a data platform executing instructions on at least one hardware processor. The method includes detecting receipt of a database replication request associated with a data consumer. The database replication request is requesting availability of an instance of a primary deployment database at a remote deployment of a data platform. In response to detecting the receipt of the database replication request, an account of a data provider at the remote deployment of the data platform is provisioned with a set of replication-preparation objects associated with the primary deployment database. A database refresh operation is invoked, causing database data be pushed from the primary deployment database to a database shell in the account of the data provider at the remote deployment, to create the instance of the primary deployment database.

    Tracking intermediate changes in database data
    5.
    发明授权
    Tracking intermediate changes in database data 有权

    公开(公告)号：US12026153B2

    公开(公告)日：2024-07-02

    申请号：US18179762

    申请日：2023-03-07

    申请人： Snowflake Inc.

    发明人： Torsten Grabs ,  Istvan Cseri ,  Benoit Dageville

    IPC分类号： G06F16/00 ,  G06F16/22 ,  G06F16/23 ,  G06F16/2455

    CPC分类号： G06F16/2379 ,  G06F16/2282 ,  G06F16/24554 ,  G06F16/2456

    摘要： Systems, methods, and devices for tracking a series of changes to database data are disclosed. A method includes executing a transaction to modify data in a micro-partition of a table of a database by generating a new micro-partition that embodies the transaction. The method includes associating transaction data with the new micro-partition, wherein the transaction data comprises a timestamp when the transaction was fully executed, and further includes associating modification data with the new micro-partition that comprises an indication of one or more rows of the table that were modified by the transaction. The method includes joining the transaction data with the modification data to generate joined data and querying the joined data to determine a listing of intermediate modifications made to the table between a first timestamp and a second timestamp.

    Granting access to resources of a database
    6.
    发明授权
    Granting access to resources of a database 有权

    公开(公告)号：US12013960B2

    公开(公告)日：2024-06-18

    申请号：US18343361

    申请日：2023-06-28

    申请人： SNOWFLAKE INC.

    发明人： Benoit Dageville ,  Thierry Cruanes ,  Martin Hentschel ,  Peter Povinec

    IPC分类号： G06F21/62 ,  G06F16/25

    CPC分类号： G06F21/6218 ,  G06F16/256 ,  G06F2221/2145

    摘要： A method of sharing data in a multi-tenant database includes inspecting, by a processing device of a multiple tenant database, a sharer account to determine an existence of a link between an alias object in a target account and a database, wherein the database is linked to a first role object included in a share object in the sharer account. The method includes granting a second role object, in the target account, access rights to the alias object, wherein the first role object having one or more grants to one or more resources of the sharer account, and wherein the target account accesses the one or more resources using the one or more grants of the share object and using the alias object without at least one of copying the one or more resources or transmitting the one or more resources.