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

1. 发明授权

US08626724B2 Method for automated design of row compression on tables in a relational database 有权
标题翻译：在关系数据库中的表上自动设计行压缩的方法
公开(公告)号：US08626724B2
公开(公告)日：2014-01-07
申请号：US12021330
申请日：2008-01-29
申请人： John Hornibrook , Laurent S. Mignet , William R. Minor , Sumit Negi , Daniele C. Zilio
发明人： John Hornibrook , Laurent S. Mignet , William R. Minor , Sumit Negi , Daniele C. Zilio
IPC分类号： G06F7/00
CPC分类号： G06F17/30595
摘要： A workload specification is obtained for the database. Based on the workload specification, candidate ones of the tables are identified and ranked. Compression impact is evaluated for the candidate ones of the tables. A design for the database is developed, specifying at least one of: (i) which of the tables should be compressed, and (ii) which of the tables should not be compressed.
摘要翻译：为数据库获取工作量规范。根据工作负载规范，对表中的候选表进行识别和排序。对候选表中的压缩影响进行评估。开发了数据库的设计，指定以下至少一个：（i）应压缩哪些表，以及（ii）不应压缩哪些表。

2. 发明申请

US20090193042A1 SYSTEM AND COMPUTER PROGRAM PRODUCT FOR AUTOMATED DESIGN OF ROW COMPRESSION ON TABLES IN A RELATIONAL DATABASE 审中-公开
标题翻译：系统和计算机程序产品自动设计在相关数据库中的表格压缩
公开(公告)号：US20090193042A1
公开(公告)日：2009-07-30
申请号：US12021365
申请日：2008-01-29
申请人： John Hornibrook , Laurent S. Mignet , William R. Minor , Sumit Negi , Daniele C. Zilio
发明人： John Hornibrook , Laurent S. Mignet , William R. Minor , Sumit Negi , Daniele C. Zilio
IPC分类号： G06F17/30
CPC分类号： G06F16/284
摘要： A workload specification is obtained for the database. Based on the workload specification, candidate ones of the tables are identified and ranked. Compression impact is evaluated for the candidate ones of the tables. A design for the database is developed, specifying at least one of: (i) which of the tables should be compressed, and (ii) which of the tables should not be compressed.
摘要翻译：为数据库获取工作量规范。根据工作负载规范，对表中的候选表进行识别和排序。对候选表中的压缩影响进行评估。开发了数据库的设计，指定以下至少一个：（i）应压缩哪些表，以及（ii）不应压缩哪些表。

3. 发明申请

US20090193041A1 METHOD FOR AUTOMATED DESIGN OF ROW COMPRESSION ON TABLES IN A RELATIONAL DATABASE 有权
标题翻译：自动设计在相关数据库中的表格压缩方法
公开(公告)号：US20090193041A1
公开(公告)日：2009-07-30
申请号：US12021330
申请日：2008-01-29
申请人： John Hornibrook , Laurent S. Mignet , William R. Minor , Sumit Negi , Daniele C. Zilio
发明人： John Hornibrook , Laurent S. Mignet , William R. Minor , Sumit Negi , Daniele C. Zilio
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30595
摘要： A workload specification is obtained for the database. Based on the workload specification, candidate ones of the tables are identified and ranked. Compression impact is evaluated for the candidate ones of the tables. A design for the database is developed, specifying at least one of: (i) which of the tables should be compressed, and (ii) which of the tables should not be compressed.
摘要翻译：为数据库获取工作量规范。根据工作负载规范，对表中的候选表进行识别和排序。对候选表中的压缩影响进行评估。开发了数据库的设计，指定以下至少一个：（i）应压缩哪些表，以及（ii）不应压缩哪些表。

4. 发明授权

US08838598B2 System and computer program product for automated design of range partitioned tables for relational databases 有权
标题翻译：用于关系数据库的范围分区表的自动设计的系统和计算机程序产品
公开(公告)号：US08838598B2
公开(公告)日：2014-09-16
申请号：US11948435
申请日：2007-11-30
申请人： Manish A. Bhide , Sam S. Lightstone , Laurent S. Mignet , Sumit Negi , Daniele C. Zilio
发明人： Manish A. Bhide , Sam S. Lightstone , Laurent S. Mignet , Sumit Negi , Daniele C. Zilio
IPC分类号： G06F17/30
CPC分类号： G06F17/30312
摘要： A workload specification, detailing specific queries and a frequency of execution of each of the queries, and a set of partitions, are obtained for the database, as inputs. A number of candidate tables are identified for the database, the tables having a plurality of attributes. A chosen attribute is allocated for each of the tables, to obtain a set of tables and a set of appropriate partitions for each of the tables.
摘要翻译：作为输入，为数据库获取工作负载规范，详细说明特定查询和每个查询的执行频率以及一组分区。为数据库识别多个候选表，表具有多个属性。为每个表分配一个选定的属性，以便为每个表获取一组表和一组适当的分区。

5. 发明申请

US20090144235A1 METHOD FOR AUTOMATED DESIGN OF RANGE PARTITIONED TABLES FOR RELATIONAL DATABASES 有权
标题翻译：自动设计用于关系数据库的范围分区表的方法
公开(公告)号：US20090144235A1
公开(公告)日：2009-06-04
申请号：US11948360
申请日：2007-11-30
申请人： Manish A. Bhide , Sam S. Lightstone , Laurent S. Mignet , Sumit Negi , Daniele C. Zilio
发明人： Manish A. Bhide , Sam S. Lightstone , Laurent S. Mignet , Sumit Negi , Daniele C. Zilio
IPC分类号： G06F7/06 , G06F17/30
CPC分类号： G06F17/30445 , G06F17/30339 , Y10S707/972
摘要： A workload specification, detailing specific queries and a frequency of execution of each of the queries, and a set of partitions, are obtained for the database, as inputs. A number of candidate tables are identified for the database, the tables having a plurality of attributes. A chosen attribute is allocated for each of the tables, to obtain a set of tables and a set of appropriate partitions for each of the tables.
摘要翻译：作为输入，为数据库获取工作负载规范，详细说明特定查询和每个查询的执行频率以及一组分区。为数据库识别多个候选表，表具有多个属性。为每个表分配一个选定的属性，以便为每个表获取一组表和一组适当的分区。

6. 发明授权

US07917512B2 Method for automated design of range partitioned tables for relational databases 有权
标题翻译：用于关系数据库的范围分区表的自动设计方法
公开(公告)号：US07917512B2
公开(公告)日：2011-03-29
申请号：US11948360
申请日：2007-11-30
申请人： Manish A. Bhide , Sam S. Lightstone , Laurent S. Mignet , Sumit Negi , Daniele C. Zilio
发明人： Manish A. Bhide , Sam S. Lightstone , Laurent S. Mignet , Sumit Negi , Daniele C. Zilio
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30445 , G06F17/30339 , Y10S707/972
摘要： A workload specification, detailing specific queries and a frequency of execution of each of the queries, and a set of partitions, are obtained for the database, as inputs. A number of candidate tables are identified for the database, the tables having a plurality of attributes. A chosen attribute is allocated for each of the tables, to obtain a set of tables and a set of appropriate partitions for each of the tables.
摘要翻译：作为输入，为数据库获取工作负载规范，详细说明特定查询和每个查询的执行频率以及一组分区。为数据库识别多个候选表，表具有多个属性。为每个表分配一个选定的属性，以便为每个表获取一组表和一组适当的分区。

7. 发明申请

US20090144303A1 SYSTEM AND COMPUTER PROGRAM PRODUCT FOR AUTOMATED DESIGN OF RANGE PARTITIONED TABLES FOR RELATIONAL DATABASES 有权
标题翻译：用于关系数据库的范围分区表自动设计的系统和计算机程序产品
公开(公告)号：US20090144303A1
公开(公告)日：2009-06-04
申请号：US11948435
申请日：2007-11-30
申请人： Manish A. Bhide , Sam S. Lightstone , Laurent S. Mignet , Sumit Negi , Daniele C. Zilio
发明人： Manish A. Bhide , Sam S. Lightstone , Laurent S. Mignet , Sumit Negi , Daniele C. Zilio
IPC分类号： G06F7/06 , G06F17/30
CPC分类号： G06F17/30312
摘要： A workload specification, detailing specific queries and a frequency of execution of each of the queries, and a set of partitions, are obtained for the database, as inputs. A number of candidate tables are identified for the database, the tables having a plurality of attributes. A chosen attribute is allocated for each of the tables, to obtain a set of tables and a set of appropriate partitions for each of the tables.
摘要翻译：作为输入，为数据库获取工作负载规范，详细说明特定查询和每个查询的执行频率以及一组分区。为数据库识别多个候选表，表具有多个属性。为每个表分配一个选定的属性，以便为每个表获取一组表和一组适当的分区。

8. 发明授权

US07689538B2 Autonomic recommendation and placement of materialized query tables for load distribution 有权
标题翻译：自动推荐和放置用于负载分配的物化查询表
公开(公告)号：US07689538B2
公开(公告)日：2010-03-30
申请号：US11340203
申请日：2006-01-26
申请人： Wen-Syan Li , Daniele C. Zilio
发明人： Wen-Syan Li , Daniele C. Zilio
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30457 , Y10S707/99932
摘要： A system and method of evaluating queries in distributed databases with MQTs comprises deriving MQTs; replicating the derived MQTs from a local server to at least one remote server; and distributing data and replicated derived MQTs to a plurality of other remote servers, wherein the distributing increases overall query execution efficiency. The databases may comprise heterogeneous databases. The query execution efficiency comprises observed response time at a frontend database and associated costs comprising computational central processing unit costs, input/output costs, and network communication costs. All of the associated costs comprise statistically estimated costs. The method further comprises running a MQT advisor at a frontend database, and considering the costs of at least one MQT placed at the frontend database. The method further comprises running a MQT advisor at a non-frontend database. Additionally, the increased overall query execution efficiency may consider all dependencies of all involved database instances and associated costs.
摘要翻译：使用MQT对分布式数据库中的查询进行评估的系统和方法包括导出MQT; 将派生的MQT从本地服务器复制到至少一个远程服务器; 以及将数据和复制的导出MQT分发到多个其他远程服务器，其中所述分发增加了整体查询执行效率。数据库可以包括异构数据库。查询执行效率包括在前端数据库处的观察到的响应时间和包括计算中央处理单元成本，输入/输出成本和网络通信成本的相关费用。所有相关成本包括统计估计成本。该方法还包括在前端数据库上运行MQT顾问，并考虑放置在前端数据库中的至少一个MQT的成本。该方法还包括在非前端数据库上运行MQT顾问。此外，增加的整体查询执行效率可以考虑所有相关数据库实例和相关成本的所有依赖关系。

9. 发明授权

US07281004B2 Method, system and program for optimizing compression of a workload processed by a database management system 有权
标题翻译：用于优化由数据库管理系统处理的工作负载的压缩的方法，系统和程序
公开(公告)号：US07281004B2
公开(公告)日：2007-10-09
申请号：US10788583
申请日：2004-02-27
申请人： Sam S. Lightstone , Guy M. Lohman , Ivan Popivanov , Jun Rao , Adam J. Storm , Daniele C. Zilio
发明人： Sam S. Lightstone , Guy M. Lohman , Ivan Popivanov , Jun Rao , Adam J. Storm , Daniele C. Zilio
IPC分类号： G06F17/30
CPC分类号： G06F17/3046 , Y10S707/99934
摘要： The present invention provides a method, system and program for optimizing compression of a workload processed by a database management system. In an embodiment of the present invention a method of optimizing the compression of database workloads is provided. Initially, an estimate of a cost of execution for each query according to a defined metric such as execution time or memory consumption is determined. A sub-set of queries is then selected from the workload in order of the most costly to least costly relative to the defined metric for compression according to either a predetermined compression threshold percentage or a threshold percentage derived from an allotted workload execution time. Compression is then performed on the selected sub-set of queries (i.e. those that will benefit the most from the compression) to achieve a net beneficial trade-off between the cost of workload compression and the cost of workload execution.
摘要翻译：本发明提供一种用于优化由数据库管理系统处理的工作负载的压缩的方法，系统和程序。在本发明的实施例中，提供了优化数据库工作负载的压缩的方法。首先，确定根据诸如执行时间或存储器消耗的定义的度量的每个查询的执行成本的估计。然后根据预定的压缩阈值百分比或从分配的工作负载执行时间导出的阈值百分比，从工作负荷中选择相对于定义的压缩度量最贵的成本最低的成本的子集。然后对所选择的查询子集（即将从压缩中获益最多的那些）执行压缩，以实现工作负载压缩成本与工作负载执行成本之间的净有益权衡。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式