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

1. 发明授权

US07272589B1 Database index validation mechanism 有权
标题翻译：数据库索引验证机制
公开(公告)号：US07272589B1
公开(公告)日：2007-09-18
申请号：US09703909
申请日：2000-11-01
申请人： Todd P. Guay , Gregory S. Smith , Ari W. Mozes , Gaylen D. Royal
发明人： Todd P. Guay , Gregory S. Smith , Ari W. Mozes , Gaylen D. Royal
IPC分类号： G06F17/30
CPC分类号： G06F17/30312 , Y10S707/954 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935
摘要： A method evaluates a plurality of candidate index sets for a workload of database statements in a database system by first generating baseline statistics for each statement in the workload. An index superset is formed by combining an existing or current index set and a proposed index set. A candidate index set is derived from the index superset, the candidate index being one of the plurality of candidate index sets. Statistics for a statement are generated by first creating an execution plan which represents an efficient series of steps for executing the statement given the candidate index set. The execution plan is evaluated, and statistics based on the evaluation of the execution plan are generated and recorded. The cost of the execution plan is then determined and statistics are generated. Statistics for each candidate index set are rolled up and presented to a user or an index tuning mechanism.
摘要翻译：一种方法通过首先为工作负载中的每个语句生成基准统计量来评估数据库系统中数据库语句的工作负荷的多个候选索引集。索引超集是通过组合现有或当前索引集合和提出的索引集合来形成的。候选索引集是从索引超集导出的，候选索引是多个候选索引集之一。通过首先创建执行计划来生成语句的统计信息，该执行计划代表给出候选索引集的执行语句的有效的一系列步骤。对执行计划进行评估，生成并记录基于执行计划的评估的统计。然后确定执行计划的成本，并生成统计信息。每个候选索引集的统计信息被卷起并呈现给用户或索引调整机制。

2. 发明授权

US09230007B2 Preserving sets of information in rollup tables 有权
标题翻译：在汇总表中保留信息集
公开(公告)号：US09230007B2
公开(公告)日：2016-01-05
申请号：US10678800
申请日：2003-10-03
申请人： Todd P. Guay , Dimitris Nakos
发明人： Todd P. Guay , Dimitris Nakos
IPC分类号： G06F17/30 , G06F11/34
CPC分类号： G06F17/30595 , G06F11/3447 , G06F11/3495 , G06F17/30368 , G06F17/30412
摘要： Techniques for making aggregated entries in a database table which aggregate information from other entries in tables in the database system. The techniques permit the aggregated entries to contain not only metric values aggregated from the other entries by techniques such as averaging in which the individual values are lost, but also sets of individual values from the other entries. One area of application for the techniques is the roll up tables used in the management systems for database management systems to reduce the size of historic information about events that have occurred in the database management system. Each roll up entry in a roll up table is an aggregated entry that contains information about some number of events. A roll up entry that uses the techniques contains a representation of a set whose values are the occurrence times of the events that are represented by the rollup record. Among the techniques that can be used to represent the set of occurrence times are a comma list of the occurrence times and a bit map which has a bit for each second in a day. Roll up entries that contain such representations of sets of occurrence times may be analyzed to determine whether occurrences of events are related, and if they are, the fact of the relationship can be used to design filters that can be applied in the roll up process, in error reporting, and in the analysis of the roll up tables.
摘要翻译：在数据库表中进行聚合条目的技术，该数据库表从数据库系统中的表中的其他条目聚合信息。这些技术允许聚合条目不仅包含通过诸如丢失各个值的平均的技术从其他条目聚合的度量值，还包含来自其他条目的各个值的集合。该技术的一个应用领域是用于数据库管理系统的管理系统中的卷起表，以减少关于在数据库管理系统中发生的事件的历史信息的大小。汇总表中的每个汇总条目是包含有关某些事件数量的信息的聚合条目。使用这些技术的汇总条目包含一个集合的表示，其值是由汇总记录表示的事件的发生时间。可以用于表示发生次数的技术之一是发生时间的逗号列表和在一天中每秒钟有位的位图。可以分析包含发生时间集合的这种表示的汇总条目以确定事件的发生是否相关，并且如果是，该关系的事实可以用于设计可以在卷起过程中应用的过滤器，在错误报告中，以及在卷入表的分析中。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式