中科微点-全球专利检索

  1. Login
  2. Sign Up

Search Results

610 records (took 0.017 seconds)

    Data pruning based on metadata
    91.
    发明授权
    Data pruning based on metadata 有权

    公开(公告)号：US10678753B2

    公开(公告)日：2020-06-09

    申请号：US16688888

    申请日：2019-11-19

    Applicant: Snowflake Inc.

    Inventor： Marcin Zukowski ,  Benoit Dageville ,  Thierry Cruanes ,  Ashish Motivala

    IPC: G06F16/00 ,  G06F16/16 ,  G06F16/22 ,  G06F16/215 ,  G06F16/9535 ,  G06F16/2453

    Abstract: A system and method for pruning data based on metadata. The method may include receiving a query that includes a plurality of predicates and identifying one or more applicable files including database data satisfying at least one of the plurality of predicates. The identifying the one or more applicable files including reading metadata stored in a metadata store that is separate from the database data. The method further includes pruning inapplicable files comprising database data that does not satisfy at least one of the plurality of predicates to create a reduced set of files and reading the reduced set of files to execute the query.

    Managing persistent database result sets
    92.
    发明授权
    Managing persistent database result sets 审中-公开

    公开(公告)号：US10671605B2

    公开(公告)日：2020-06-02

    申请号：US15097107

    申请日：2016-04-12

    Applicant: SNOWFLAKE INC.

    Inventor： Benoit Dageville ,  Jiansheng Huang ,  Shige Takeda ,  Abdul Q. Munir

    IPC: G06F16/2453 ,  G06F16/14 ,  G06F16/2455 ,  G06F16/11 ,  G06F16/16

    Abstract: A method, system, and apparatus for managing a persistent query result set are disclosed. A resource manager is disclosed that receives a query from a client over a computer network. A computer database server is disclosed that executes the query and generates a result set based on and in response to the received query. An execution platform is disclosed that divides the result set into a plurality of chunks, wherein each chunk comprises a portion of the generated result set. The resource manager adds metadata to each of the plurality of chunks. A first chunk of the plurality of chunks comprises metadata pointing to the plurality of chunks. The resource manager delivers at least the first chunk of the plurality of chunks to the client in response to the query. The execution platform offloads the remaining plurality of chunks to cloud storage in parallel.

    Task Scheduling In Database Systems
    93.
    发明申请
    Task Scheduling In Database Systems 审中-公开

    公开(公告)号：US20200167340A1

    公开(公告)日：2020-05-28

    申请号：US16203322

    申请日：2018-11-28

    Applicant: Snowflake Inc.

    Inventor： Istvan Cseri ,  Torsten Grabs ,  Benoit Dageville

    IPC: G06F16/23 ,  G06F9/46

    Abstract: Systems, methods, and devices for executing a task on database data in response to a trigger event are disclosed. A method includes executing a transaction on a table comprising database data, wherein executing the transaction comprises generating a new table version. The method includes, in response to the transaction being fully executed, generating a change tracking entry comprising an indication of one or more modifications made to the table by the transaction and storing the change tracking entry in a change tracking stream. The method includes executing a task on the new table version in response to a trigger event.

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

    公开(公告)号：US10642993B1

    公开(公告)日：2020-05-05

    申请号：US16779103

    申请日：2020-01-31

    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.

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

    公开(公告)号：US10592681B2

    公开(公告)日：2020-03-17

    申请号：US15402906

    申请日：2017-01-10

    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.

    DIRECTING QUERIES TO DATABASE FILES
    100.
    发明申请
    DIRECTING QUERIES TO DATABASE FILES 有权

    公开(公告)号：US20250053680A1

    公开(公告)日：2025-02-13

    申请号：US18928687

    申请日：2024-10-28

    Applicant: Snowflake Inc.

    Inventor： Benoit Dageville ,  Peter Povinec ,  Philipp Thomas Unterbrunner ,  Martin Hentschel

    IPC: G06F21/62 ,  G06F21/60

    Abstract: A method of preventing queries from accessing database files based on metadata. The method includes determining a first metadata associated with a particular file and a second metadata associated with a changed version of the particular file. The method includes directing, based on the first metadata associated with the particular file, a first query for the particular file to a first file that is associated with the particular file. The method includes preventing a second query for the particular file from accessing the particular file by directing, based on the second metadata associated with the changed version of the particular file, the second query to the changed version of the particular file instead of the particular file.

Patent Agency Ranking