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

1. 发明授权

US07831590B2 Techniques for partitioning indexes 有权
标题翻译：分区索引的技术
公开(公告)号：US07831590B2
公开(公告)日：2010-11-09
申请号：US11848634
申请日：2007-08-31
申请人： Amaranatha Reddy Gangarapu , Louis Burger , Frank Roderic Vandervort
发明人： Amaranatha Reddy Gangarapu , Louis Burger , Frank Roderic Vandervort
IPC分类号： G06F17/30
CPC分类号： G06F17/30321 , Y10S707/97
摘要： Techniques for partitioning indexes are provided. A predefined data type associated with a column of a database table is acquired. Column value statistics for the column are acquired. The values are analyzed to produce multiple partitions for the values. Each partition includes each of the values and each partition includes multiple groupings of the values. Also, each grouping of a particular partition includes a subset or range of the values. Furthermore, each grouping of a partition includes a same distribution for the values as other groupings of that partition. Each partition represents a potential partitioning index for the column and its values.
摘要翻译：提供了分区索引的技术。获取与数据库表的列相关联的预定义数据类型。获取列的列值统计信息。分析这些值以产生值的多个分区。每个分区包括每个值，每个分区包括多个值分组。此外，特定分区的每个分组包括值的子集或范围。此外，分区的每个分组包括与该分区的其他分组相同的值的分布。每个分区表示列及其值的潜在分区索引。

2. 发明申请

US20100106708A1 Eliminating unnecessary statistics collections for query optimization 有权
标题翻译：消除用于查询优化的不必要的统计数据集
公开(公告)号：US20100106708A1
公开(公告)日：2010-04-29
申请号：US12290088
申请日：2008-10-27
申请人： Louis M. Burger , Frank Roderic Vandervort
发明人： Louis M. Burger , Frank Roderic Vandervort
IPC分类号： G06F17/30 , G06F7/00
CPC分类号： G06F17/30474
摘要： A method and system for eliminating unnecessary statistics collections for query optimization in a database stored on a computer. Statistics are unnecessary when a re-generated query execution plan that does not use the statistics is equivalent to an original query execution plan that uses the statistics. To determine this, an original query execution plan is created for each query in a specified workload using the statistics in the database. A search is performed of the statistics in order to enumerate one or more candidate sets of statistics to be eliminated. One or more of the candidate sets of statistics are removed from consideration prior to creating the re-generated query execution plan for each query in the specified workload. The re-generated query execution plan, which was created with one or more of the candidate sets of statistics removed from consideration, is compared with the original query execution plan, which was created using the statistics, in order to determine whether the re-generated query execution plan and the original query execution plan are equivalent. The one or more of the candidate sets of statistics removed from consideration are identified as unnecessary when the re-generated query execution plan and the original query execution plan are equivalent.
摘要翻译：一种用于消除在计算机上存储的数据库中用于查询优化的不必要统计数据收集的方法和系统。当不使用统计信息的重新生成的查询执行计划等同于使用统计信息的原始查询执行计划时，不需要统计信息。要确定这一点，将使用数据库中的统计信息为指定工作负载中的每个查询创建原始查询执行计划。对统计数据执行搜索，以枚举要消除的一个或多个候选统计数据集。在为指定工作负载中的每个查询创建重新生成的查询执行计划之前，将从考虑中删除一个或多个候选的统计信息。将从考虑中删除的一个或多个候选的统计数据集创建的重新生成的查询执行计划与使用统计信息创建的原始查询执行计划进行比较，以确定是否重新生成查询执行计划和原始查询执行计划是等效的。当重新生成的查询执行计划和原始查询执行计划相当时，从考虑中删除的一组或多个候选统计信息被标识为不必要的。

3. 发明申请

US20080275840A1 SELECTIVE DATABASE STATISTICS RECOLLECTION 有权
标题翻译：选择性数据库统计资料
公开(公告)号：US20080275840A1
公开(公告)日：2008-11-06
申请号：US11743897
申请日：2007-05-03
申请人： Louis Burger , Frank Roderic Vandervort
发明人： Louis Burger , Frank Roderic Vandervort
IPC分类号： G06F17/30
CPC分类号： G06F17/30536 , G06F17/30398
摘要： The subject mater herein relates to database management and, more particularly, to selective database statistics recollection. Various embodiments provide one or more of system, methods, and software that identify database column and index states when statistics become stale to a point where query execution plans against respective columns and indexes fail to be efficient. These and other embodiments provide a way to update column and index statistics only when the statistics are determined to be stale. As a result, adverse database performance as a result of needless updating of database statistics is mitigated.
摘要翻译：本文的主题涉及数据库管理，更具体地说涉及选择性数据库统计回忆。各种实施例提供系统，方法和软件中的一个或多个，当统计信息变得不稳定到对相应的列和索引的查询执行计划不能有效时，识别数据库列和索引状态。这些和其他实施例提供了仅在统计信息被确定为陈旧时才更新列和索引统计量的方法。因此，减少了数据库统计数据不必要的更新导致的不利的数据库性能。

4. 发明申请

US20130085984A1 MANAGING EXCESS CAPACITY OF DATABASE SYSTEMS IN A CAPACITY CONTROLLED COMPUTING ENVIRONMENT 有权
标题翻译：管理能力控制计算环境中数据库系统的超能力
公开(公告)号：US20130085984A1
公开(公告)日：2013-04-04
申请号：US13250150
申请日：2011-09-30
申请人： Louis Burger , Douglas P. Brown , Thomas Julien , Frank Roderic Vandervort
发明人： Louis Burger , Douglas P. Brown , Thomas Julien , Frank Roderic Vandervort
IPC分类号： G06F17/30
CPC分类号： G06F17/30442 , G06F17/30471
摘要： Excess capacity available to a database system in a capacity controlled environment can be effectively managed. In particular, excess capacity that is not made available for normal operations of a database system can be used to manage errors, especially situations that may hinder expected performance of the database system. In addition, excess capacity can be used to optimize or further optimize database queries, especially those that meet a criterion (e.g., not fully optimize, not optimized as expected).
摘要翻译：可以有效地管理在容量受控环境中可用于数据库系统的可用容量。特别是，不能用于数据库系统的正常操作的额外容量可用于管理错误，特别是可能阻碍数据库系统的预期性能的情况。此外，可以使用多余的容量来优化或进一步优化数据库查询，特别是符合标准的查询（例如，未完全优化，未按预期进行优化）。

5. 发明授权

US07840555B2 System and a method for identifying a selection of index candidates for a database 有权
标题翻译：系统和用于识别数据库的索引候选的选择的方法
公开(公告)号：US07840555B2
公开(公告)日：2010-11-23
申请号：US11530991
申请日：2006-09-12
申请人： Louis Burger , Frank Roderic Vandervort
发明人： Louis Burger , Frank Roderic Vandervort
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30336
摘要： A system and method for identifying a selection of index candidates for a relational database. The system includes a Predicate Analyzer for examining database queries in workload and recording column and predicate information; a Search Engine for performing a combinatorial search of index candidates; an Index Emulator for emulating the existence of a set of candidate indexes by making necessary “fake” entries into the relational database management system data dictionary; and a Query Optimizer for estimating the cost of a given query within a given index configuration. In accordance with the method, data indicative of a workload comprising one or more queries is received, and predicates are then analysed and organized into column groups for each basic predicate type. Statistics are collected on each of these groups. Non-predicate portions of each query are scanned to obtain additional covering columns. A combinational search is performed on the column groups to identify covering and non-covering candidates. These are then used in conjunction with collected statistics and baseline costs are calculated to perform a cost bases analysis of the candidates and generate index candidate recommendations.
摘要翻译：一种用于识别关系数据库的索引候选的选择的系统和方法。该系统包括用于检查工作负载中的数据库查询和记录列和谓词信息的谓词分析器; 用于执行索引候选者的组合搜索的搜索引擎; 索引模拟器，用于通过在关系数据库管理系统数据字典中进行必要的“伪造”条目来模拟一组候选索引的存在; 以及用于估计给定索引配置中给定查询的成本的查询优化器。根据该方法，接收指示包含一个或多个查询的工作负载的数据，然后将谓词分析并组织成每个基本谓词类型的列组。对这些组中的每一组收集统计数据。扫描每个查询的非谓词部分以获得其他覆盖列。对列组进行组合搜索以识别覆盖和不覆盖候选。然后将这些与收集的统计数据结合使用，并计算基准成本以对候选人进行成本基准分析并生成索引候选人建议。

6. 发明申请

US20090248557A1 METHOD FOR AGGREGATING AND ANALYZING CONSUMER BUSINESS DATA 审中-公开
标题翻译：用于聚合和分析消费者业务数据的方法
公开(公告)号：US20090248557A1
公开(公告)日：2009-10-01
申请号：US12055363
申请日：2008-03-26
申请人： Michael Reed , Frank Roderic Vandervort , Carol Thomas
发明人： Michael Reed , Frank Roderic Vandervort , Carol Thomas
IPC分类号： G06Q40/00
CPC分类号： G06Q30/02 , G06Q40/00
摘要： A method and system of aggregating consumer business data such as transactions between a consumer and a pluralityy of vendors. The method includes receiving a request from a consumer to maintain consumer business data in a data warehouse. An electronic receipt is received from a vendor following conclusion of a transaction between the consumer and the vendor. A report is generated at the request of the consumer. The report is provided to the consumer.
摘要翻译：聚合消费者业务数据的方法和系统，例如消费者和多个供应商之间的交易。该方法包括从消费者接收请求以将消费者业务数据维护在数据仓库中。在消费者和供应商之间的交易结束后，从供应商处收到电子收据。报告是根据消费者的要求生成的。该报告提供给消费者。

7. 发明授权

US09747334B2 Managing excess capacity of database systems in a capacity controlled computing environment 有权
公开(公告)号：US09747334B2
公开(公告)日：2017-08-29
申请号：US13250150
申请日：2011-09-30
申请人： Louis Burger , Douglas P. Brown , Thomas Julien , Frank Roderic Vandervort
发明人： Louis Burger , Douglas P. Brown , Thomas Julien , Frank Roderic Vandervort
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30
CPC分类号： G06F17/30442 , G06F17/30471
摘要： Excess capacity available to a database system in a capacity controlled environment can be effectively managed. In particular, excess capacity that is not made available for normal operations of a database system can be used to manage errors, especially situations that may hinder expected performance of the database system. In addition, excess capacity can be used to optimize or further optimize database queries, especially those that meet a criterion (e.g., not fully optimize, not optimized as expected).

8. 发明授权

US09244838B2 System, method, and computer-readable medium for grouping database level object access counts per processing module in a parallel processing system 有权
标题翻译：用于在并行处理系统中对每个处理模块分组数据库级对象访问计数的系统，方法和计算机可读介质
公开(公告)号：US09244838B2
公开(公告)日：2016-01-26
申请号：US12346915
申请日：2008-12-31
申请人： Arthur Vargas Lopes , Jeffrey Shelton , Douglas Brown , Thomas Julien , Frank Roderic Vandervort
发明人： Arthur Vargas Lopes , Jeffrey Shelton , Douglas Brown , Thomas Julien , Frank Roderic Vandervort
IPC分类号： G06F17/30 , G06F12/08
CPC分类号： G06F12/0804 , G06F12/0866 , G06F17/30489
摘要： A system, method, and computer-readable medium for grouping of database object access counts per processing module in a parallel processing system. Each processing module manages an intermediate cache allocated thereto that stores database object access counts local to the respective processing module. The processing modules are configured in a hierarchical configuration. The intermediate caches managed by the processing modules at the lowest level of the configuration are forwarded to a parent processing module and merged with the intermediate cache allocated to the parent processing module. A root processing module merges the intermediate caches received from one or more parent processing modules with the root processing module's intermediate cache to generate a final cache. An objects access count data structure is then generated by the root processing module.
摘要翻译：一种用于在并行处理系统中对每个处理模块分组数据库对象访问计数的系统，方法和计算机可读介质。每个处理模块管理分配给它的中间缓存，其存储对相应处理模块本地的数据库对象访问计数。处理模块以分层结构配置。由配置的最低级别处理模块管理的中间缓存被转发到父处理模块，并与分配给父处理模块的中间缓存进行合并。根处理模块将从一个或多个父处理模块接收的中间缓存与根处理模块的中间缓存合并以生成最终高速缓存。然后由根处理模块生成对象访问计数数据结构。

9. 发明授权

US08688629B2 System maintenance and tuning of databases by using excess capacity in capacity controlled environment 有权
标题翻译：通过在容量受控环境中使用过剩容量来对数据库进行系统维护和调优
公开(公告)号：US08688629B2
公开(公告)日：2014-04-01
申请号：US13285313
申请日：2011-10-31
申请人： Louis Burger , Douglas P. Brown , Thomas P. Julien , Frank Roderic Vandervort
发明人： Louis Burger , Douglas P. Brown , Thomas P. Julien , Frank Roderic Vandervort
IPC分类号： G06F17/30
CPC分类号： G06F9/505 , G06F2209/483
摘要： Excess capacity available to a database system in a capacity controlled environment can be effectively managed for maintenance and/or tuning activities. In this context, excess capacity can be used as needed and/or on a temporary basis. Furthermore, maintenance and/or tuning activities can be performed without requiring the use of the configured or allotted capacity. As a result, these operations can be performed without adversely affecting other operations which may be deemed more critical by the users of databases. System maintenance and tuning (or fine tuning) of a database environment can, for example, include operations associated with “Physical Tuning,” and “Index Tuning”. Some exemplary operations include collecting Statistics, analyzing a database workload, sampling, analyzing an execution plan, creating indexes.
摘要翻译：可以对容量受控环境中的数据库系统可用的足够的容量进行维护和/或调优活动。在这种情况下，可以根据需要和/或暂时使用超额产能。此外，可以执行维护和/或调试活动，而不需要使用配置或分配的容量。因此，可以执行这些操作而不会不利地影响数据库用户可能被认为更为关键的其他操作。例如，数据库环境的系统维护和调优（或微调）可以包括与“物理调谐”和“索引调整”相关联的操作。一些示例性操作包括收集统计信息，分析数据库工作负载，采样，分析执行计划，创建索引。

10. 发明授权

US08533216B2 Database system workload management method and system 有权
标题翻译：数据库系统工作负载管理方法和系统
公开(公告)号：US08533216B2
公开(公告)日：2013-09-10
申请号：US11554113
申请日：2006-10-30
申请人： Louis Burger , Thomas Julien , Frank Roderic Vandervort
发明人： Louis Burger , Thomas Julien , Frank Roderic Vandervort
IPC分类号： G06F17/30
CPC分类号： G06F17/30498
摘要： An improved workload management system and method for a database system. The improved workload management system evaluates certain workload management rules dynamically at key points during database query execution rather than relying on enforcement prior to query activation. In the case of product join operations, the workload management system evaluates the potential impact on system performance by the product join operation after input tables have been populated, but prior to the execution of the join operation. Delaying workload management enforcement to this point ensures that the sizes of inputs and outputs are reliably known and improves system performance impact estimates at a point early enough to prevent any serious performance degradation from an inefficient product join.
摘要翻译：改进了数据库系统的工作负载管理系统和方法。改进的工作负载管理系统在数据库查询执行期间的关键点动态评估某些工作负载管理规则，而不是在查询激活之前依赖执行。在产品加入操作的情况下，工作负载管理系统通过输入表填充之后，但在执行连接操作之前，通过产品连接操作评估对系统性能的潜在影响。延迟工作负载管理实施到这一点可以确保输入和输出的大小可靠地被知道，并提前一个时间点提高系统性能影响估计，以防止任何严重的性能下降从低效的产品连接。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式