INCREMENTAL CLUSTERING MAINTENANCE OF A TABLE
    2.
    发明申请
    INCREMENTAL CLUSTERING MAINTENANCE OF A TABLE 审中-公开
    增量式集群维护

    公开(公告)号:WO2018045372A1

    公开(公告)日:2018-03-08

    申请号:PCT/US2017/050075

    申请日:2017-09-05

    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.

    Abstract translation: 一种方法包括将表格的表格数据存储在多个分区中并用于保持近似或足够好的聚类。 该方法包括基于对表格的改变创建一个或多个新分区,其中一个或多个新分区中的至少一个与彼此重叠或先前分区重叠,导致表格聚类程度的降低。 该方法包括确定表格数据的聚类程度低于聚类阈值。 该方法进一步包括:响应于以下各项中的一项或多项来重新聚集表格的一个或多个分区以提高表格的聚类度:确定聚类度已经降至聚类阈值以下,来自用户的显式用户命令, 和/或作为DML命令的一部分。 可以通过增量步骤执行重新集群,以反复改进集群。

    RESOURCE PROVISIONING SYSTEMS AND METHODS
    5.
    发明申请

    公开(公告)号:WO2015126973A3

    公开(公告)日:2015-08-27

    申请号:PCT/US2015/016425

    申请日:2015-02-18

    Abstract: Example resource provisioning systems and methods are described. In one implementation, an execution platform accesses multiple remote storage devices. The execution platform includes multiple virtual warehouses, each of which includes a cache to store data retrieved from the remote storage devices and a processor that is independent of the remote storage devices. A resource manager is coupled to the execution platform and monitors received data processing requests and resource utilization. The resource manager also determines whether additional virtual warehouses are needed based on the data processing requests and the resource utilization. If additional virtual warehouses are needed, the resource manager provisions a new virtual warehouse.

Patent Agency Ranking