中科微点-全球专利检索

  1. Login
  2. Sign Up

Search Results

86 records (took 0.019 seconds)

    Internal resource provisioning in database systems
    41.
    发明授权
    Internal resource provisioning in database systems 有权

    公开(公告)号：US11379492B2

    公开(公告)日：2022-07-05

    申请号：US17477663

    申请日：2021-09-17

    Applicant: Snowflake Inc.

    Inventor： Jeffrey Rosen ,  Abdul Munir ,  Jiaqi Yan ,  William Waddington ,  Prasanna Rajaperumal ,  Thierry Cruanes

    IPC: G06F16/2458 ,  G06F16/2453 ,  G06F9/50 ,  G06F16/2455

    Abstract: Resource provisioning systems and methods are described. In an embodiment, a system includes a plurality of shared storage devices collectively storing database data, an execution platform, and a compute service manager. The compute service manager is configured to determine a task to be executed in response to a trigger event and determine a query plan for executing the task, wherein the query plan comprises a plurality of discrete subtasks. The compute service manager is further configured to assign the plurality of discrete subtasks to one or more nodes of a plurality of nodes of the execution platform, determine whether execution of the task is complete, and in response to determining the execution of the task is complete, store a record in the plurality of shared storage devices indicating the task was completed.

    Data Sharing And Materialized Views In Multiple Tenant Database Systems
    43.
    发明申请
    Data Sharing And Materialized Views In Multiple Tenant Database Systems 审中-公开

    公开(公告)号：US20200379993A1

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

    申请号：US16428367

    申请日：2019-05-31

    Applicant: Snowflake Inc.

    Inventor： Prasanna Rajaperumal ,  Thierry Cruanes ,  Allison Waingold Lee ,  Igor Demura ,  Jiaqi Yan ,  Benoit Dageville

    IPC: G06F16/2453

    Abstract: Systems, methods, and devices for generating and updating cross-account materialized views in multiple tenant database systems. A methods includes defining a share object in a first account wherein the share object includes data associated with the first account. The method includes granting cross-account access rights to the share object to a second account such that the second account has access to the share object without copying the share object. The method includes generating a materialized view over the share object. The method includes updating the data associated with the first account. The method includes identifying whether the materialized view is stale with respect to the share object by merging the materialized view and the share object.

    FLEXIBLE COMPUTING
    45.
    发明公开
    FLEXIBLE COMPUTING 审中-公开

    公开(公告)号：US20240078135A1

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

    申请号：US18140086

    申请日：2023-04-27

    Applicant: Snowflake Inc.

    Inventor： Thierry Cruanes ,  Igor Demura ,  Varun Ganesh ,  Prasanna Rajaperumal ,  Libo Wang ,  Jiaqi Yan

    IPC: G06F9/50 ,  G06F9/54 ,  H04L67/1001

    CPC classification number: G06F9/5027 ,  G06F9/5077 ,  G06F9/5083 ,  G06F9/542 ,  H04L67/1001 ,  G06F2209/5011

    Abstract: Embodiments of the present disclosure may provide dynamic and fair assignment techniques for allocating resources on a demand basis. Assignment control may be separated into at least two components: a local component and a global component. Each component may have an active dialog with each other; the dialog may include two aspects: 1) a demand for computing resources, and 2) a total allowed number of computing resources. The global component may allocate resources from a pool of resources to different local components, and the local components in turn may assign their allocated resources to local competing requests. The allocation may also be throttled or limited at various levels.

    INCREMENTAL REFRESH OF A MATERIALIZED VIEW
    49.
    发明申请
    INCREMENTAL REFRESH OF A MATERIALIZED VIEW 有权

    公开(公告)号：US20230004552A1

    公开(公告)日：2023-01-05

    申请号：US17930177

    申请日：2022-09-07

    Applicant: Snowflake Inc.

    Inventor： Thierry Cruanes ,  Benoit Dageville ,  Prasanna Rajaperumal ,  Jiaqi Yan

    IPC: G06F16/23 ,  G06F16/24 ,  G06F16/27 ,  G06F16/22

    Abstract: Systems, methods, and devices for incrementally refreshing a materialized view are disclosed. A method includes generating a materialized view based on a source table. The method includes merging the source table and the materialized view to generate a merged table to identify whether an update has been executed on the source table that is not reflected in the materialized view. The method includes, in response to detecting an update made to the source table that is not reflected in the materialized view, applying the update to the materialized view.

    SELECTING PARTITIONS FOR RECLUSTERING BASED ON DISTRIBUTION OF OVERLAPPING PARTITIONS
    50.
    发明申请
    SELECTING PARTITIONS FOR RECLUSTERING BASED ON DISTRIBUTION OF OVERLAPPING PARTITIONS 有权

    公开(公告)号：US20220197886A1

    公开(公告)日：2022-06-23

    申请号：US17654296

    申请日：2022-03-10

    Applicant: Snowflake Inc.

    Inventor： Jiaqi Yan ,  Thierry Cruanes ,  Jeffrey Rosen ,  William Waddington ,  Prasanna Rajaperumal ,  Abdul Munir

    IPC: G06F16/22 ,  G06F16/27 ,  G06F7/08 ,  G06F16/28

    Abstract: Disclosed herein are embodiments of systems and methods for selecting partitions for reclustering based on distribution of overlapping partitions. In an example, a database platform makes a determination to at least partially recluster a database table that includes data stored across a plurality of partitions. The database platform responsively selects a subset of the partitions. The selecting of the subset includes identifying a point on a domain of a clustering key that corresponds to a local maximum of overlapping partitions, and also includes selecting the subset from among a group of overlapping partitions. The group includes at least one partition that overlaps the identified point on the domain of the clustering key. Each partition in the selected subset is above a reduction goal of overlapping partitions. The database platform at least partially reclusters the selected subset based on the clustering key.

Patent Agency Ranking