Optimizing tables with too many columns in a database

    公开(公告)号:US10042872B2

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

    申请号:US14746465

    申请日:2015-06-22

    Abstract: Methods and systems for database optimization include detecting a plurality of columns in an unoptimized database that co-appear in queries to the database. The plurality of columns are compacted into a single hyper-column to form an optimized database. Each entry in the hyper-column includes data from a corresponding entry in each of the plurality of columns. An interface is generated for the optimized database that accepts queries according to a schema for the unoptimized database and translates the queries into queries according to a schema for the optimized database.

    Massive time series correlation similarity computation

    公开(公告)号:US10997176B2

    公开(公告)日:2021-05-04

    申请号:US14749709

    申请日:2015-06-25

    Abstract: A system, computer program product, and method for computing a correlation matrix with respect to massive of time-series is described where a threshold ε is specified. The correlations greater than ε do not need to be computed. A distance tree is constructed and used. The distance tree organizes the time-series by their correlation estimations. The correlation similarity is computed with MapReduce function by taking advantage of the distance tree. In an efficient MapReduce manner, there is a small I/O waste for overlapped partition. The load is balanced for uneven data distribution and there is early pruning for unnecessary computation. There is no reliance on dimensional reduction and no reliance on coordinates.

    OPTIMIZING TABLES WITH TOO MANY COLUMNS IN A DATABASE
    9.
    发明申请
    OPTIMIZING TABLES WITH TOO MANY COLUMNS IN A DATABASE 有权
    在数据库中使用多个列的优化表

    公开(公告)号:US20160342634A1

    公开(公告)日:2016-11-24

    申请号:US14719433

    申请日:2015-05-22

    Abstract: Methods and systems for database optimization include detecting a plurality of columns in an unoptimized database that co-appear in queries to the database. The plurality of columns are compacted into a single hyper-column to form an optimized database. Each entry in the hyper-column includes data from a corresponding entry in each of the plurality of columns. An interface is generated for the optimized database that accepts queries according to a schema for the unoptimized database and translates the queries into queries according to a schema for the optimized database.

    Abstract translation: 用于数据库优化的方法和系统包括检测在对数据库的查询中共同出现的未优化的数据库中的多个列。 多个列被压缩成单个超列以形成优化的数据库。 超列中的每个条目包括来自多个列中的每一列中的对应条目的数据。 为优化的数据库生成接口,该数据库根据未优化数据库的模式接受查询,并根据优化数据库的模式将查询转换为查询。

Patent Agency Ranking