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

11. 发明申请

US20100042607A1 METHOD, APPARATUS, AND COMPUTER PROGRAM PRODUCT FOR ADAPTIVE QUERY PARALLELISM PARTITIONING WITH LOOK-AHEAD PROBING AND FEEDBACK 失效
标题翻译：方法，装置和计算机程序产品适应性查询和平分析与前瞻性探测和反馈
公开(公告)号：US20100042607A1
公开(公告)日：2010-02-18
申请号：US12190057
申请日：2008-08-12
申请人： Hong Min , Yefim Shuf , Terence Patrick Purcell , You-Chin Fuh , Chunfeng Pei , Ou Jin
发明人： Hong Min , Yefim Shuf , Terence Patrick Purcell , You-Chin Fuh , Chunfeng Pei , Ou Jin
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30445 , G06F17/30474 , G06F17/30536
摘要： A database query is partitioned into an initial partition including a plurality of parallel groups, and is executed, via an execution plan, based on the initial partition. A sampling subset of data is identified from the plurality of parallel groups. Substantially in parallel with the executing of the query, the execution plan is executed on the sampling subset of data as a sampling thread. The execution plan is modified based on feedback from the execution of the execution plan on the sampling subset of data.
摘要翻译：数据库查询被分割成包括多个并行组的初始分区，并且经由执行计划基于初始分区被执行。从多个并行组中识别数据的采样子集。与执行查询基本相同，执行计划作为采样线程在数据的采样子集上执行。执行计划根据执行计划对数据采样子集的反馈进行修改。

12. 发明申请

US20110196857A1 Generating Materialized Query Table Candidates 失效
标题翻译：生成物化查询表候选
公开(公告)号：US20110196857A1
公开(公告)日：2011-08-11
申请号：US12702384
申请日：2010-02-09
申请人： Dong Sheng Chen , Hong Min , Terence P. Purcell , Yefim Shuf , Xiao Bo Wang , Zhong Liang Zhang
发明人： Dong Sheng Chen , Hong Min , Terence P. Purcell , Yefim Shuf , Xiao Bo Wang , Zhong Liang Zhang
IPC分类号： G06F17/30
CPC分类号： G06F17/30457
摘要： Techniques for generating a set of one or more materialized query table (MQT) candidates for a workload are provided. The techniques include receiving a workload, wherein the workload comprises a set of one or more queries, generating one or more best matching MQTs (BMQTs) based on one or more query blocks of the one or more queries by removing syntax that is not qualified for a MQT re-write, determining one or more frequently used multi-joins in the workload, using the one or more BMQTs and the one or more frequently used multi-joins to generate a set of one or more workload MQTs (WMQTs), and grouping one or more WMQTs and one or more BMQTs into one or more groups to merge into a set of a smaller number of MQTs and to cover the workload.
摘要翻译：提供了用于生成用于工作负载的一个或多个物化查询表（MQT）候选的集合的技术。所述技术包括接收工作负载，其中所述工作负载包括一组一个或多个查询，基于所述一个或多个查询的一个或多个查询块生成一个或多个最佳匹配MQT（BMQT），通过除去不符合 MQT重写，使用所述一个或多个BMQT和所述一个或多个频繁使用的多连接来生成一组一个或多个工作负载MQT（WMQT）来确定所述工作负载中的一个或多个频繁使用的多连接，以及将一个或多个WMQT和一个或多个BMQT分组成一个或多个组合并成一组较少数量的MQT并覆盖工作负载。

13. 发明授权

US07930294B2 Method for partitioning a query 有权
标题翻译：分割查询的方法
公开(公告)号：US07930294B2
公开(公告)日：2011-04-19
申请号：US12190187
申请日：2008-08-12
申请人： Yefim Shuf , Hong Min , Terence Patrick Purcell , Ou Jin , Fen-Ling Lin , Brian Thinh-Vinh Tran , Patrick Dooling Bossman
发明人： Yefim Shuf , Hong Min , Terence Patrick Purcell , Ou Jin , Fen-Ling Lin , Brian Thinh-Vinh Tran , Patrick Dooling Bossman
IPC分类号： G06F17/30
CPC分类号： G06F17/30445
摘要： Techniques for partitioning a query are provided. The techniques include establishing one or more criterion for partitioning a query, wherein the query comprises one or more tables, materializing a first of the one or more tables, partitioning the first of the one or more tables until the one or more criterion have been satisfied, and partitioning and joining a remainder of the one or more tables of the query.
摘要翻译：提供了分割查询的技术。这些技术包括建立用于划分查询的一个或多个标准，其中该查询包括一个或多个表，实现该一个或多个表中的第一个表，划分一个或多个表中的第一个，直到满足一个或多个标准，以及分割和加入查询的一个或多个表的其余部分。

14. 发明授权

US08620899B2 Generating materialized query table candidates 失效
标题翻译：生成物化查询表候选
公开(公告)号：US08620899B2
公开(公告)日：2013-12-31
申请号：US12702384
申请日：2010-02-09
申请人： Dongsheng Chen , Hong Min , Terence P. Purcell , Yefim Shuf , Xiaobo Wang , Zhongliang Zhang
发明人： Dongsheng Chen , Hong Min , Terence P. Purcell , Yefim Shuf , Xiaobo Wang , Zhongliang Zhang
IPC分类号： G06F17/30 , G06F7/00
CPC分类号： G06F17/30457
摘要： Techniques for generating a set of one or more materialized query table (MQT) candidates for a workload are provided. The techniques include receiving a workload, wherein the workload comprises a set of one or more queries, generating one or more best matching MQTs (BMQTs) based on one or more query blocks of the one or more queries by removing syntax that is not qualified for a MQT re-write, determining one or more frequently used multi-joins in the workload, using the one or more BMQTs and the one or more frequently used multi-joins to generate a set of one or more workload MQTs (WMQTs), and grouping one or more WMQTs and one or more BMQTs into one or more groups to merge into a set of a smaller number of MQTs and to cover the workload.
摘要翻译：提供了用于生成用于工作负载的一个或多个物化查询表（MQT）候选的集合的技术。所述技术包括接收工作负载，其中所述工作负载包括一组一个或多个查询，基于所述一个或多个查询的一个或多个查询块生成一个或多个最佳匹配MQT（BMQT），通过除去不符合 MQT重写，使用所述一个或多个BMQT和所述一个或多个频繁使用的多连接来生成一组一个或多个工作负载MQT（WMQT）来确定所述工作负载中的一个或多个频繁使用的多连接，以及将一个或多个WMQT和一个或多个BMQT分组成一个或多个组合并成一组较少数量的MQT并覆盖工作负载。

15. 发明授权

US08832046B2 Encoded data processing 有权
标题翻译：编码数据处理
公开(公告)号：US08832046B2
公开(公告)日：2014-09-09
申请号：US13617614
申请日：2012-09-14
申请人： Hubertus Franke , Balakrishna R. Iyer , Hong Min , Terence P. Purcell , Guogen Zhang
发明人： Hubertus Franke , Balakrishna R. Iyer , Hong Min , Terence P. Purcell , Guogen Zhang
IPC分类号： G06F17/00 , G06F17/30 , H03M7/30
CPC分类号： G06F17/30286 , G06F17/30076 , G06F17/30339 , H03M7/30
摘要： Techniques are provided for encoded data processing which allows for continuous data processing as encoded data changes. Data is decomposed into one or more blocks with each block containing at least one data record. At least one data record within a given block is encoded with a first encoding process selected from one or more encoding processes. The first encoding process is associated with the given data block. Techniques evaluate whether or not to implement an encoding change for a given block when updating a given data record in the given block. Responsive to the evaluation, the given block is re-encoded with a second encoding process. Responsive to the re-encoding, the association of the given block is updated. A map is formed to convert the given data record encoded with the first encoding process to the second encoding process so as to preserve comparative relationships of the given data record.
摘要翻译：为编码数据处理提供技术，其允许作为编码数据变化的连续数据处理。数据被分解为一个或多个块，每个块包含至少一个数据记录。使用从一个或多个编码过程中选择的第一编码过程对给定块内的至少一个数据记录进行编码。第一编码过程与给定的数据块相关联。技术评估在给定块中更新给定数据记录时是否实现给定块的编码更改。响应于评估，给定的块用第二编码过程重新编码。响应于重新编码，给定块的关联更新。形成地图以将用第一编码处理编码的给定数据记录转换为第二编码处理，以便保持给定数据记录的比较关系。

16. 发明授权

US08631000B2 Scan sharing for query predicate evaluations in column-based in-memory database systems 有权
标题翻译：基于列的内存数据库系统中的查询谓词评估扫描共享
公开(公告)号：US08631000B2
公开(公告)日：2014-01-14
申请号：US12894370
申请日：2010-09-30
申请人： Hubertus Franke , Hong Min
发明人： Hubertus Franke , Hong Min
IPC分类号： G06F17/30
CPC分类号： G06F17/30587
摘要： A plurality of queries of an in-memory column-oriented database are obtained. Each of the queries has at least one column predicate. For each of the queries, it is determined which of a plurality of columns in the in-memory column-oriented database need to be scanned. The plurality of queries are grouped into a plurality of scan groups, based at least in part on the determining step. The column predicates are evaluated for those of the queries in a given one of the scan groups in accordance with a scheduling scheme. The grouping step and the scheduling scheme take into account real time scan information.
摘要翻译：获得存储器内列的数据库的多个查询。每个查询至少有一个列谓词。对于每个查询，确定需要扫描存储器中的列内数据库中的多个列中的哪一列。至少部分地基于确定步骤，将多个查询分组为多个扫描组。根据调度方案，对给定的一个扫描组中的查询的列的谓词进行评估。分组步骤和调度方案考虑实时扫描信息。

17. 发明申请

US20120084278A1 SCAN SHARING FOR QUERY PREDICATE EVALUATIONS IN COLUMN-BASED IN-MEMORY DATABASE SYSTEMS 有权
标题翻译：基于列的内存数据库系统扫描查询预测评估
公开(公告)号：US20120084278A1
公开(公告)日：2012-04-05
申请号：US12894370
申请日：2010-09-30
申请人： Hubertus Franke , Hong Min
发明人： Hubertus Franke , Hong Min
IPC分类号： G06F17/30
CPC分类号： G06F17/30587
摘要： A plurality of queries of an in-memory column-oriented database are obtained. Each of the queries has at least one column predicate. For each of the queries, it is determined which of a plurality of columns in the in-memory column-oriented database need to be scanned. The plurality of queries are grouped into a plurality of scan groups, based at least in part on the determining step. The column predicates are evaluated for those of the queries in a given one of the scan groups in accordance with a scheduling scheme. The grouping step and the scheduling scheme take into account real time scan information.
摘要翻译：获得存储器内列的数据库的多个查询。每个查询至少有一个列谓词。对于每个查询，确定需要扫描存储器中的列内数据库中的多个列中的哪一列。至少部分地基于确定步骤，将多个查询分组为多个扫描组。根据调度方案，对给定的一个扫描组中的查询的列的谓词进行评估。分组步骤和调度方案考虑实时扫描信息。

18. 发明申请

US20140019472A1 ENCODED DATA PROCESSING 失效
标题翻译：编码数据处理
公开(公告)号：US20140019472A1
公开(公告)日：2014-01-16
申请号：US13545522
申请日：2012-07-10
申请人： Hubertus Franke , Balakrishna R. Iyer , Hong Min , Terence P. Purcell , Guogen Zhang
发明人： Hubertus Franke , Balakrishna R. Iyer , Hong Min , Terence P. Purcell , Guogen Zhang
IPC分类号： G06F17/30
CPC分类号： G06F17/30286 , G06F17/30076 , G06F17/30339 , H03M7/30
摘要： Techniques for encoded data processing which allow for continuous data processing as encoded data changes. Data is decomposed into one or more blocks with each block containing at least one data record. At least one data record within a given block is encoded with a first encoding process selected from one or more encoding processes. The first encoding process is associated with the given data block. Techniques evaluate whether or not to implement an encoding change for a given block when updating a given data record in the given block. Responsive to the evaluation, the given block is re-encoded with a second encoding process. Responsive to the re-encoding, the association of the given block is updated. A map is formed to convert the given data record encoded with the first encoding process to the second encoding process so as to preserve comparative relationships of the given data record.
摘要翻译：用于编码数据处理的技术，其允许作为编码数据的连续数据处理改变。数据被分解为一个或多个块，每个块包含至少一个数据记录。使用从一个或多个编码过程中选择的第一编码过程对给定块内的至少一个数据记录进行编码。第一编码过程与给定的数据块相关联。技术评估在给定块中更新给定数据记录时是否实现给定块的编码更改。响应于评估，给定的块用第二编码过程重新编码。响应于重新编码，给定块的关联更新。形成地图以将用第一编码处理编码的给定数据记录转换为第二编码处理，以便保持给定数据记录的比较关系。

19. 发明授权

US08756208B2 Encoded data processing 失效
标题翻译：编码数据处理
公开(公告)号：US08756208B2
公开(公告)日：2014-06-17
申请号：US13545522
申请日：2012-07-10
申请人： Hubertus Franke , Balakrishna R. Iyer , Hong Min , Terence P. Purcell , Guogen Zhang
发明人： Hubertus Franke , Balakrishna R. Iyer , Hong Min , Terence P. Purcell , Guogen Zhang
IPC分类号： G06F17/00 , G06F17/30
CPC分类号： G06F17/30286 , G06F17/30076 , G06F17/30339 , H03M7/30
摘要： Techniques for encoded data processing which allow for continuous data processing as encoded data changes. Data is decomposed into one or more blocks with each block containing at least one data record. At least one data record within a given block is encoded with a first encoding process selected from one or more encoding processes. The first encoding process is associated with the given data block. Techniques evaluate whether or not to implement an encoding change for a given block when updating a given data record in the given block. Responsive to the evaluation, the given block is re-encoded with a second encoding process. Responsive to the re-encoding, the association of the given block is updated. A map is formed to convert the given data record encoded with the first encoding process to the second encoding process so as to preserve comparative relationships of the given data record.
摘要翻译：用于编码数据处理的技术，其允许作为编码数据的连续数据处理改变。数据被分解为一个或多个块，每个块包含至少一个数据记录。使用从一个或多个编码过程中选择的第一编码过程对给定块内的至少一个数据记录进行编码。第一编码过程与给定的数据块相关联。技术评估在给定块中更新给定数据记录时是否实现给定块的编码更改。响应于评估，给定的块用第二编码过程重新编码。响应于重新编码，给定块的关联更新。形成地图以将用第一编码处理编码的给定数据记录转换为第二编码处理，以便保持给定数据记录的比较关系。

20. 发明申请

US20140019422A1 ENCODED DATA PROCESSING 有权
标题翻译：编码数据处理
公开(公告)号：US20140019422A1
公开(公告)日：2014-01-16
申请号：US13617614
申请日：2012-09-14
申请人： Hubertus Franke , Balakrishna R. Iyer , Hong Min , Terence P. Purcell , Guogen Zhang
发明人： Hubertus Franke , Balakrishna R. Iyer , Hong Min , Terence P. Purcell , Guogen Zhang
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30286 , G06F17/30076 , G06F17/30339 , H03M7/30
摘要： Techniques are provided for encoded data processing which allows for continuous data processing as encoded data changes. Data is decomposed into one or more blocks with each block containing at least one data record. At least one data record within a given block is encoded with a first encoding process selected from one or more encoding processes. The first encoding process is associated with the given data block. Techniques evaluate whether or not to implement an encoding change for a given block when updating a given data record in the given block. Responsive to the evaluation, the given block is re-encoded with a second encoding process. Responsive to the re-encoding, the association of the given block is updated. A map is formed to convert the given data record encoded with the first encoding process to the second encoding process so as to preserve comparative relationships of the given data record.
摘要翻译：为编码数据处理提供技术，其允许作为编码数据变化的连续数据处理。数据被分解为一个或多个块，每个块包含至少一个数据记录。使用从一个或多个编码过程中选择的第一编码过程对给定块内的至少一个数据记录进行编码。第一编码过程与给定的数据块相关联。技术评估在给定块中更新给定数据记录时是否实现给定块的编码更改。响应于评估，给定的块用第二编码过程重新编码。响应于重新编码，给定块的关联更新。形成地图以将用第一编码处理编码的给定数据记录转换为第二编码处理，以便保持给定数据记录的比较关系。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式