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

1. 发明申请

US20060112093A1 Method, system, and program for collecting statistics of data stored in a database 有权
标题翻译：用于收集数据库中存储的数据的统计信息的方法，系统和程序
公开(公告)号：US20060112093A1
公开(公告)日：2006-05-25
申请号：US10996197
申请日：2004-11-22
申请人： Sam Lightstone , Ivan Popivanov , Kevin Rose
发明人： Sam Lightstone , Ivan Popivanov , Kevin Rose
IPC分类号： G06F17/30
CPC分类号： G06F17/30315
摘要： The present invention relates to collecting statistics automatically for data in a database. There is provided a method for automated statistics collection comprising determining a likelihood that statistics for data have changed; and collecting statistics for data in response to the likelihood. Indicators of the likelihood that statistics have changed may be useful to trigger automated statistics collection. Tables having statistics that change significantly may be collected more often than statistics of tables that are stable. A preferred model is provided to facilitate the collection of statistics that are more relevant: a table is scheduled for collection in accordance with observed patterns of table activity; a table is considered for collection if it meets a threshold level of activity; and a table is sampled to predict whether the statistics to be collected have changed. When collecting statistics, throttling and lock contention can minimize impact on a database user's response experience.
摘要翻译：本发明涉及为数据库中的数据自动采集统计信息。提供了一种用于自动统计收集的方法，包括确定数据的统计数据已经改变的可能性; 并根据可能性收集数据的统计数据。统计变更可能性的指标可能有助于触发自动统计收集。具有显着变化的统计数据的表可能比稳定表的统计数据更频繁地收集。提供了一个优选模型，以便于收集更相关的统计数据：按照观察到的表格模式计划收集表格; 如果满足阈值水平的活动，则考虑表的收集; 并对表进行采样，以预测要收集的统计信息是否发生变化。收集统计信息时，限制和锁定争用可以最小化对数据库用户的响应体验的影响。

2. 发明申请

US20050192978A1 Method, system and program for optimizing compression of a workload processed by a database management system 有权
标题翻译：用于优化由数据库管理系统处理的工作负载的压缩的方法，系统和程序
公开(公告)号：US20050192978A1
公开(公告)日：2005-09-01
申请号：US10788583
申请日：2004-02-27
申请人： Sam Lightstone , Guy Lohman , Ivan Popivanov , Jun Rao , Adam Storm , Daniele Zilio
发明人： Sam Lightstone , Guy Lohman , Ivan Popivanov , Jun Rao , Adam Storm , Daniele Zilio
IPC分类号： G06F7/00 , 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.
摘要翻译：本发明提供一种用于优化由数据库管理系统处理的工作负载的压缩的方法，系统和程序。在本发明的实施例中，提供了优化数据库工作负载的压缩的方法。首先，确定根据诸如执行时间或存储器消耗的定义的度量的每个查询的执行成本的估计。然后根据预定的压缩阈值百分比或从分配的工作负载执行时间导出的阈值百分比，从工作负荷中选择相对于定义的压缩度量最贵的成本最低的成本的子集。然后对所选择的查询子集（即将从压缩中获益最多的那些）执行压缩，以实现工作负载压缩成本与工作负载执行成本之间的净有益权衡。

3. 发明授权

US08140490B2 Method, system and program for prioritizing maintenance of database tables 失效
标题翻译：方法，系统和程序，用于优先维护数据库表
公开(公告)号：US08140490B2
公开(公告)日：2012-03-20
申请号：US12059129
申请日：2008-03-31
申请人： Ashraf Ismail Aboulnaga , Peter Jay Haas , Sam Sampson Lightstone , Volker Gerhard Markl , Ivan Popivanov , Vijayshankar Raman
发明人： Ashraf Ismail Aboulnaga , Peter Jay Haas , Sam Sampson Lightstone , Volker Gerhard Markl , Ivan Popivanov , Vijayshankar Raman
IPC分类号： G06F17/30
CPC分类号： G06F17/30339
摘要： There is disclosed a data processing system implemented method, a data processing system, and an article of manufacture for directing a data processing system to maintain a database table associated with an initial maintenance scheduling interval. The data processing system implemented method includes selecting a randomizing factor, and selecting a new maintenance scheduling interval for the database table based on the initial maintenance scheduling interval and the selected randomizing factor.
摘要翻译：公开了一种数据处理系统实现的方法，数据处理系统和用于指导数据处理系统维护与初始维护调度间隔相关联的数据库表的制品。所述数据处理系统实现方法包括：选择随机化因子，并且基于所述初始维护调度间隔和所选择的随机化因子为所述数据库表选择新的维护调度间隔。

4. 发明授权

US07363324B2 Method, system and program for prioritizing maintenance of database tables 失效
标题翻译：方法，系统和程序，用于优先维护数据库表
公开(公告)号：US07363324B2
公开(公告)日：2008-04-22
申请号：US11016233
申请日：2004-12-17
申请人： Ashraf Ismail Aboulnaga , Peter Jay Haas , Sam Sampson Lightstone , Volker Gerhard Markl , Ivan Popivanov , Vijayshankar Raman
发明人： Ashraf Ismail Aboulnaga , Peter Jay Haas , Sam Sampson Lightstone , Volker Gerhard Markl , Ivan Popivanov , Vijayshankar Raman
IPC分类号： G06F17/30
CPC分类号： G06F17/30339
摘要： There is disclosed a data processing system implemented method, a data processing system, and an article of manufacture for directing a data processing system to maintain a database table associated with an initial maintenance scheduling interval. The data processing system implemented method includes selecting a randomizing factor, and selecting a new maintenance scheduling interval for the database table based on the initial maintenance scheduling interval and the selected randomizing factor.
摘要翻译：公开了一种数据处理系统实现的方法，数据处理系统和用于指导数据处理系统维护与初始维护调度间隔相关联的数据库表的制品。所述数据处理系统实现方法包括：选择随机化因子，并且基于所述初始维护调度间隔和所选择的随机化因子为所述数据库表选择新的维护调度间隔。

5. 发明授权

US07774163B2 Method, system, program for determining frequency of updating database histograms 失效
标题翻译：用于确定数据库直方图更新频率的方法，系统，程序
公开(公告)号：US07774163B2
公开(公告)日：2010-08-10
申请号：US11834569
申请日：2007-08-06
申请人： Ivan Popivanov
发明人： Ivan Popivanov
IPC分类号： G06F11/30
CPC分类号： G06F17/30289 , Y10S707/99931 , Y10S707/99932
摘要： A method, system and computer program product for a database management system to be operatively coupled to a data processing system. The data processing system includes memory for storing a data table. The method, system and computer program product for determining frequency of updating a histogram of the data table. The method includes determining sampled histograms for sample portions of the data table from time to time, computing a difference between at least two of the determined sampled histograms, and determining a frequency with which to update the histogram of the data table depending on the amount of the computed difference.
摘要翻译：一种用于可操作地耦合到数据处理系统的数据库管理系统的方法，系统和计算机程序产品。数据处理系统包括用于存储数据表的存储器。用于确定更新数据表直方图的频率的方法，系统和计算机程序产品。该方法包括：不时地对数据表的采样部分确定采样的直方图，计算确定的采样直方图中的至少两个之间的差，以及根据数据表的数量确定更新数据表的直方图的频率计算差值。

6. 发明申请

US20090216709A1 OPTIMIZED COLLECTION OF JUST-IN-TIME STATISTICS FOR DATABASE QUERY OPTIMIZATION 失效
标题翻译：优化收集用于数据库查询优化的即时统计
公开(公告)号：US20090216709A1
公开(公告)日：2009-08-27
申请号：US12038054
申请日：2008-02-27
申请人： Qi Cheng , John Frederick Hornibrook , Wing Yan Lau , Ivan Popivanov , Xiaoyan Qian , Michael Joshua Snowbell , Michael Arthur Franciscus Stuy , Calisto Paul Zuzarte
发明人： Qi Cheng , John Frederick Hornibrook , Wing Yan Lau , Ivan Popivanov , Xiaoyan Qian , Michael Joshua Snowbell , Michael Arthur Franciscus Stuy , Calisto Paul Zuzarte
IPC分类号： G06F7/06
CPC分类号： G06F17/30442
摘要： A system and method are provided for updating database statistics for use in generating query execution plans. A first query for a database is received, for example by a compiler, and the compiler accesses statistics associated with the first query for optimizing a query execution plan for the first query. The statistics may be accessed from a first cache. If the statistics retrieved from the first cache are determined to be stale, the system obtains updated statistics and may store them in a temporary cache. The stale statistics in the first cache are marked as invalid. Existing queries using the first cache may continue to use the first cache, while new queries may be provided with updated statistics.
摘要翻译：提供了一种用于更新数据库统计信息以用于生成查询执行计划的系统和方法。例如由编译器接收对数据库的第一个查询，并且编译器访问与第一个查询关联的统计信息，以优化第一个查询的查询执行计划。可以从第一缓存访问统计信息。如果从第一个缓存检索到的统计信息被确定为陈旧，系统将获得更新的统计信息，并将其存储在临时缓存中。第一个缓存中的陈旧统计信息被标记为无效。使用第一缓存的现有查询可以继续使用第一高速缓存，而可以向更新的统计信息提供新的查询。

7. 发明授权

US07299248B2 Method, system, program for determining frequency of updating database histograms 有权
标题翻译：用于确定数据库直方图更新频率的方法，系统，程序
公开(公告)号：US07299248B2
公开(公告)日：2007-11-20
申请号：US10885532
申请日：2004-06-29
申请人： Ivan Popivanov
发明人： Ivan Popivanov
IPC分类号： G06F17/30
CPC分类号： G06F17/30289 , Y10S707/99931 , Y10S707/99932
摘要： A method, system and computer program product for a database management system to be operatively coupled to a data processing system. The data processing system includes memory for storing a data table. The method, system and computer program product for determining frequency of updating a histogram of the data table. The method includes determining sampled histograms for sample portions of the data table from time to time, computing a difference between at least two of the determined sampled histograms, and determining a frequency with which to update the histogram of the data table depending on the amount of the computed difference.
摘要翻译：一种用于可操作地耦合到数据处理系统的数据库管理系统的方法，系统和计算机程序产品。数据处理系统包括用于存储数据表的存储器。用于确定更新数据表直方图的频率的方法，系统和计算机程序产品。该方法包括：不时地对数据表的采样部分确定采样的直方图，计算确定的采样直方图中的至少两个之间的差，以及根据数据表的数量确定更新数据表的直方图的频率计算差值。

8. 发明授权

US08990169B2 Statistics collection for database tables 有权
标题翻译：数据库表的统计数据收集
公开(公告)号：US08990169B2
公开(公告)日：2015-03-24
申请号：US11849154
申请日：2007-08-31
申请人： Dimple Bhatia , John F. Hornibrook , Harold Hotelling Lee , Eileen Tien Lin , Ivan Popivanov , Daniele Costante Zilio
发明人： Dimple Bhatia , John F. Hornibrook , Harold Hotelling Lee , Eileen Tien Lin , Ivan Popivanov , Daniele Costante Zilio
IPC分类号： G06F17/30
CPC分类号： G06F17/30536
摘要： A method and system for collecting statistics on database tables. In one embodiment, the method includes identifying a plurality of tables for statistics collection, wherein each table of the plurality of tables are remote tables; examining at least one attribute for each table identified for statistics collection; prioritizing the tables for statistics collection based on the at least one attribute; and collecting statistics on the identified tables in a priority sequence.
摘要翻译：一种收集数据库表统计信息的方法和系统。在一个实施例中，所述方法包括识别用于统计收集的多个表，其中所述多个表中的每个表是远程表; 检查为统计收集确定的每个表格的至少一个属性; 基于至少一个属性对统计数据收集的表进行优先级排序; 并以优先级顺序收集所识别的表的统计信息。

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.
摘要翻译：本发明提供一种用于优化由数据库管理系统处理的工作负载的压缩的方法，系统和程序。在本发明的实施例中，提供了优化数据库工作负载的压缩的方法。首先，确定根据诸如执行时间或存储器消耗的定义的度量的每个查询的执行成本的估计。然后根据预定的压缩阈值百分比或从分配的工作负载执行时间导出的阈值百分比，从工作负荷中选择相对于定义的压缩度量最贵的成本最低的成本的子集。然后对所选择的查询子集（即将从压缩中获益最多的那些）执行压缩，以实现工作负载压缩成本与工作负载执行成本之间的净有益权衡。

10. 发明申请

US20060136499A1 Method, system and program for prioritizing maintenance of database tables 失效
标题翻译：方法，系统和程序，用于优先维护数据库表
公开(公告)号：US20060136499A1
公开(公告)日：2006-06-22
申请号：US11016233
申请日：2004-12-17
申请人： Ashraf Ismail Aboulnaga , Peter Jay Haas , Sam Sampson Lightstone , Volker Gerhard Markl , Ivan Popivanov , Vijayshankar Raman
发明人： Ashraf Ismail Aboulnaga , Peter Jay Haas , Sam Sampson Lightstone , Volker Gerhard Markl , Ivan Popivanov , Vijayshankar Raman
IPC分类号： G06F17/30
CPC分类号： G06F17/30339
摘要： There is disclosed a data processing system implemented method, a data processing system, and an article of manufacture for directing a data processing system to maintain a database table associated with an initial maintenance scheduling interval. The data processing system implemented method includes selecting a randomizing factor, and selecting a new maintenance scheduling interval for the database table based on the initial maintenance scheduling interval and the selected randomizing factor.
摘要翻译：公开了一种数据处理系统实现的方法，数据处理系统和用于指导数据处理系统维护与初始维护调度间隔相关联的数据库表的制品。所述数据处理系统实现方法包括：选择随机化因子，并且基于所述初始维护调度间隔和所选择的随机化因子为所述数据库表选择新的维护调度间隔。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式