利索-全球专利检索

  1. 登录
  2. 注册

搜索结果

7 条记录 (耗时 0.016 秒)

    Query plan management in shared distributed data stores
    1.
    发明授权
    Query plan management in shared distributed data stores 有权
    共享分布式数据存储中的查询计划管理

    公开(公告)号：US09002824B1

    公开(公告)日：2015-04-07

    申请号：US13529501

    申请日：2012-06-21

    申请人： Gavin Sherry ,  Radhika Reddy ,  Caleb E. Welton

    发明人： Gavin Sherry ,  Radhika Reddy ,  Caleb E. Welton

    IPC分类号： G06F7/00 ,  G06F17/00 ,  G06F17/30

    CPC分类号： G06F17/30463 ,  G06F17/30371 ,  G06F17/30424 ,  G06F17/30545 ,  G06F17/30961

    摘要： The invention identifies and caches query plans in a shared-nothing distributed data store that are unlikely to become invalid because they do not reference objects that are likely to be changed or deleted. Plans that are likely to become invalid and are not cached are those plans that reference data that is partitioned across segment/query execution nodes of the data store, plans that are complex, and plans that reference objects that are not “built-in” (primitive) objects. The effect is that most plans which are generated on a query dispatch (master) node are not cached, whereas most plans generated on an execution (segment) node are cached.

    摘要翻译： 本发明在无共享的分布式数据存储中识别和缓存查询计划，因为它们不引用可能被更改或删除的对象，因此不太可能变得无效。 可能无效并且未被缓存的计划是那些引用在数据存储区段/查询执行节点之间分区的数据的计划，复杂的计划以及引用不是“内置”的对象的计划（ 原始）对象。 效果是，在查询分派（主）节点上生成的大多数计划不会被缓存，而在执行（段）节点上生成的大多数计划都被缓存。

    Inverse distribution function operations in a parallel relational database
    2.
    发明授权
    Inverse distribution function operations in a parallel relational database 有权
    并行关系数据库中的反向分布函数操作

    公开(公告)号：US08880481B1

    公开(公告)日：2014-11-04

    申请号：US13434442

    申请日：2012-03-29

    申请人： Hitoshi Harada ,  Caleb E. Welton ,  Gavin Sherry

    发明人： Hitoshi Harada ,  Caleb E. Welton ,  Gavin Sherry

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30156 ,  G06F17/30445 ,  G06F17/30539 ,  G06F17/30598

    摘要： Inverse distribution operations are performed on a large distributed parallel database comprising a plurality of distributed data segments to determine a data value at a predetermined percentile of a sorted dataset formed on one segment. Data elements from across the segments may be first grouped, either by partitioning keys or by hashing, the groups are sorted into a predetermined order, and data values corresponding to the desired percentile are picked up at a row location of the corresponding data element of each group. For a global dataset that is spread across the database segments, a local sort of data elements is performed on each segment, and the data elements from the local sorts are streamed in overall sorted order to one segment to form the sorted dataset.

    摘要翻译： 在包括多个分布式数据段的大型分布式并行数据库上执行反向分发操作，以确定在一个段上形成的排序数据集的预定百分位数处的数据值。 来自跨段的数据元素可以首先通过分区键或通过散列进行分组，将这些组排列成预定顺序，并且在每个的对应数据元素的行位置处拾取与所需百分位数对应的数据值 组。 对于分布在数据库段中的全局数据集，对每个段执行本地数据元素，并将来自本地排序的数据元素按照整体排序顺序流式传输到一个段以形成排序的数据集。

    Systematic verification of database metadata upgrade
    3.
    发明授权
    Systematic verification of database metadata upgrade 有权
    数据库元数据升级的系统验证

    公开(公告)号：US08738569B1

    公开(公告)日：2014-05-27

    申请号：US13371337

    申请日：2012-02-10

    申请人： King Lun Choi ,  Caleb E. Welton ,  Jeffrey Ira Cohen ,  Gavin Sherry

    发明人： King Lun Choi ,  Caleb E. Welton ,  Jeffrey Ira Cohen ,  Gavin Sherry

    IPC分类号： G06F17/00

    CPC分类号： G06F17/303

    摘要： A script is run on a database to transform the metadata and produce an upgraded database. A new database corresponding to the upgraded database is initialized, and the metadata in the new database catalog is verified by comparing it to the upgraded database metadata. A fast verification is performed on a partial upgrade by dumping the catalogs of master nodes and comparing the results, and a thorough verification is performed on a full upgrade by querying and comparing both master node catalogs and segment node catalogs.

    摘要翻译： 在数据库上运行脚本来转换元数据并生成升级的数据库。 初始化与升级的数据库对应的新数据库，并通过将其与升级的数据库元数据进行比较来验证新数据库目录中的元数据。 通过转储主节点的目录并比较结果，对部分升级进行快速验证，并通过查询和比较主节点目录和分段节点目录，对完全升级执行彻底的验证。

    Registration and utilization of arbitrary data conversion schemes in a shared data store
    4.
    发明授权
    Registration and utilization of arbitrary data conversion schemes in a shared data store 有权
    在共享数据存储中注册和利用任意数据转换方案

    公开(公告)号：US09330150B1

    公开(公告)日：2016-05-03

    申请号：US13777226

    申请日：2013-02-26

    申请人： Gavin Sherry

    发明人： Gavin Sherry

    IPC分类号： G06F17/30 ,  H03M7/30

    CPC分类号： G06F17/30569 ,  H03M7/30

    摘要： Data conversion algorithms such as compression and decompression algorithms or encryption and decryption algorithms are registered in a shared data store for selective use on data by creating implementations of a plurality of functions that as a group characterize the algorithms, converting the implementations to executable code and storing the code in a shared library, and creating and registering data store objects in a data store catalog with a common identifier that enables the algorithm to be selectively called and applied to data.

    摘要翻译： 诸如压缩和解压缩算法或加密和解密算法之类的数据转换算法被登记在共享数据存储器中，用于通过创建多个功能的实现来选择性地使用数据，该组作为组特征化算法，将实现转换成可执行代码并存储 共享库中的代码，以及使用通用标识符创建和注册数据存储目录中的数据存储目录，使得该算法能够被选择性地调用并应用于数据。

    Reliable in-place bootstrap metadata transformation in a shared data store
    5.
    发明授权
    Reliable in-place bootstrap metadata transformation in a shared data store 有权
    在共享数据存储中可靠的就地引导元数据转换

    公开(公告)号：US08862550B1

    公开(公告)日：2014-10-14

    申请号：US13631917

    申请日：2012-09-29

    申请人： Gavin Sherry ,  Caleb Welton

    发明人： Gavin Sherry ,  Caleb Welton

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30359 ,  G06F17/30345 ,  G06F17/30348

    摘要： A method for upgrading software in a shared data store comprises a reliable, safe in-place method of transformation of metadata in which a metadata catalog is cloned, stored in the data store, and the cloned metadata is transformed in-place using the data store engine and SQL declarative language. The original and transformed cloned catalog files are swapped atomically, and the system upgrade is validated using the new version of software. If errors are encountered during the upgrade, the original catalog can be swapped back and the system returned to its original state.

    摘要翻译： 一种用于升级共享数据存储中的软件的方法包括：将元数据目录克隆到其中的可变的，安全的就地转换方法，存储在数据存储中，并且克隆的元数据使用数据存储 引擎和SQL声明语言。 原始和转换的克隆目录文件被原子交换，系统升级使用新版本的软件进行验证。 如果在升级期间遇到错误，则可以将原始目录交换回来，并将系统恢复到原来的状态。