专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

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

2. 发明授权

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

3. 发明授权

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

4. 发明授权

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

5. 发明授权

US08862550B1 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声明语言。原始和转换的克隆目录文件被原子交换，系统升级使用新版本的软件进行验证。如果在升级期间遇到错误，则可以将原始目录交换回来，并将系统恢复到原来的状态。

6. 发明授权

US08768973B2 Apparatus and method for expanding a shared-nothing system 有权
标题翻译：用于扩展无共享系统的装置和方法
公开(公告)号：US08768973B2
公开(公告)日：2014-07-01
申请号：US12788256
申请日：2010-05-26
申请人： Brian Hagenbuch , Gavin Sherry , Jeffrey Ira Cohen , Chris Pedrotti , John Eshleman , Florian Michael Waas , Joy Kent
发明人： Brian Hagenbuch , Gavin Sherry , Jeffrey Ira Cohen , Chris Pedrotti , John Eshleman , Florian Michael Waas , Joy Kent
IPC分类号： G06F17/30
CPC分类号： G06F17/30289 , G06F9/485 , G06F9/4881 , G06F9/5083 , G06F17/30575
摘要： A computer readable storage medium includes executable instructions to evaluate an expanded shared-nothing data store configuration. A data redistribution schedule table with specified parameters is formed. Data is redistributed within the expanded shared-nothing data store in accordance with the data redistribution schedule table.
摘要翻译：计算机可读存储介质包括用于评估扩展的无共享数据存储配置的可执行指令。形成具有指定参数的数据再分发计划表。数据根据数据再分发计划表在扩展的无共享数据存储中重新分配。

7. 发明申请

US20110295907A1 Apparatus and Method for Expanding a Shared-Nothing System 有权
标题翻译：用于扩展共享系统的装置和方法
公开(公告)号：US20110295907A1
公开(公告)日：2011-12-01
申请号：US12788256
申请日：2010-05-26
申请人： Brian Hagenbuch , Gavin Sherry , Jeffrey Ira Cohen , Chris Pedrotti , John Eshleman , Florian Michael Waas , Joy Kent
发明人： Brian Hagenbuch , Gavin Sherry , Jeffrey Ira Cohen , Chris Pedrotti , John Eshleman , Florian Michael Waas , Joy Kent
IPC分类号： G06F17/30
CPC分类号： G06F17/30289 , G06F9/485 , G06F9/4881 , G06F9/5083 , G06F17/30575
摘要： A computer readable storage medium includes executable instructions to evaluate an expanded shared-nothing data store configuration. A data redistribution schedule table with specified parameters is formed. Data is redistributed within the expanded shared-nothing data store in accordance with the data redistribution schedule table.
摘要翻译：计算机可读存储介质包括用于评估扩展的无共享数据存储配置的可执行指令。形成具有指定参数的数据再分发计划表。数据根据数据再分发计划表在扩展的无共享数据存储中重新分配。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式