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

1. 发明授权

US07028022B1 Heuristic-based conditional data indexing 有权
标题翻译：基于启发式的条件数据索引
公开(公告)号：US07028022B1
公开(公告)日：2006-04-11
申请号：US09627662
申请日：2000-07-28
申请人： Sam S. Lightstone , Catherine S. McArthur , William T. O'Connell , Miroslaw A. Flasza
发明人： Sam S. Lightstone , Catherine S. McArthur , William T. O'Connell , Miroslaw A. Flasza
IPC分类号： G06F17/30
CPC分类号： G06F17/30336 , Y10S707/99932 , Y10S707/99933 , Y10S707/99943 , Y10S707/99945
摘要： A computer system for the indexing of data in which a heuristic determination function is applied to predict an efficient index updating approach. The system is able to update an index relating to a first data set by incrementally updating the index or by a rebuild of the index at the completion of the addition of a second set of data to the first set of data. The system applies a heuristic determination function to the characteristics of the first set of data, its index, and the second set of data, to predict whether an incremental update or a rebuild update of the index will result in a more efficient rebuild of the data. The system applies this approach to a restore and rollforward recovery or a data load operation to improve the efficiency of these operations.
摘要翻译：一种用于索引其中应用启发式确定功能以预测有效的索引更新方法的数据的计算机系统。该系统能够通过在第二组数据的添加完成时递增地更新索引或通过重建索引来更新与第一数据集有关的索引。该系统将启发式确定函数应用于第一组数据，其索引和第二组数据的特征，以预测索引的增量更新或重建更新是否将导致更有效地重建数据。该系统将此方法应用于还原和前滚恢复或数据加载操作，以提高这些操作的效率。

2. 发明授权

US07043469B2 Method and system for slow materialization of scrollable cursor result sets 有权
公开(公告)号：US07043469B2
公开(公告)日：2006-05-09
申请号：US10183749
申请日：2002-06-26
申请人： Iqbal A. Goralwalla , William T. O'Connell , David C. Sharpe
发明人： Iqbal A. Goralwalla , William T. O'Connell , David C. Sharpe
IPC分类号： G06F17/30
CPC分类号： G06F17/3041 , Y10S707/99932 , Y10S707/99933
摘要： The present invention provides a system and a method for materializing records in a result set in response to a query. The computer system comprises a server and a client. The server has a database and a database management system for providing access to the database. The client is operatively coupled to the database management system. The client is adapted to provide a query to the database management system and the database management system is adapted to materialize a number of records in a result set in response to the query. The number of materialized records is selected to reduce inefficient materialization of records from the database in response to the query.

3. 发明授权

US07302441B2 System and method for gradually bringing rolled in data online with incremental deferred integrity processing 失效
标题翻译：系统和方法逐渐使用增量延迟完整性处理在网上滚动数据
公开(公告)号：US07302441B2
公开(公告)日：2007-11-27
申请号：US10896154
申请日：2004-07-20
申请人： Petrus Kai Chung Chan , Miroslaw Adam Flasza , Dieu Quang La , Bruce Gilbert Lindsay , William T. O'Connell
发明人： Petrus Kai Chung Chan , Miroslaw Adam Flasza , Dieu Quang La , Bruce Gilbert Lindsay , William T. O'Connell
IPC分类号： G06F17/00
CPC分类号： G06F17/3051 , G06F17/30312 , G06F17/30371 , Y10S707/99942 , Y10S707/99943 , Y10S707/99944 , Y10S707/99945
摘要： Disclosed is a data processing system, a data processing system-implemented method and an article of manufacture for providing general user availability while integrity processing of rolled-in data is deferred and performed incrementally. The data processing system includes a data warehouse administration module for administering a data warehouse to include a table dividable into portions for containing rows of rolled-in data, a first and a second delimiter delimiting the start and the end respectively of each portion, a metadata element having an entry corresponding to the start and end delimiters delimiting each portion, a third delimiter for delimiting, between the first delimiter and the third delimiter, a sub-portion of the portion, and an operations management module having operation mechanisms for performing operations on the data warehouse responsive to the delimiters.
摘要翻译：公开了一种数据处理系统，数据处理系统实现的方法和用于提供一般用户可用性的制品，并且递推数据的完整性处理被延迟并执行。数据处理系统包括数据仓库管理模块，用于管理数据仓库以将可分割的表分成用于包含滚动数据行的部分，分隔每个部分的开始和结束的第一和第二定界符，元数据元素，其具有对应于限定每个部分的开始和结束分隔符的条目，用于在第一定界符和第三分隔符之间划分第三分隔符的第三分隔符，该部分的子部分，以及具有用于执行操作的操作机制的操作管理模块数据仓库响应分隔符。

4. 发明授权

US07945543B2 Method and system for deferred maintenance of database indexes 有权
标题翻译：数据库索引延期维护的方法和系统
公开(公告)号：US07945543B2
公开(公告)日：2011-05-17
申请号：US11278125
申请日：2006-03-30
申请人： John Paul Kennedy , Quanhua Hong , William T. O'Connell , Leslie Anne Buback
发明人： John Paul Kennedy , Quanhua Hong , William T. O'Connell , Leslie Anne Buback
IPC分类号： G06F7/00 , G06F17/00 , G06F12/00 , G06F17/30
CPC分类号： G06F17/30306
摘要： Rectifying discrepancies between a table, from which a segment of data has been removed, and an index for the table may be deferred. Each entry in the index is sequentially analyzed to remove entries therefrom referring to any removed segment referenced in the starting location list. During this process, if a segment newly removed from the table is detected, then analysis of the index entries continues and an indicator is set that another segment has been removed. Analysis of the entries continues in a looping fashion until each entry has been assessed to determine if it makes a reference to any of the removed segments. If a query is received before rectification is complete then the query is amended by establishing search boundaries based so that the query does not produce any entries in the index referring to removed segments.
摘要翻译：纠正已删除数据段的表与表的索引之间的差异可能会被推迟。依次分析索引中的每个条目，以从其中删除条目，参考起始位置列表中引用的任何已删除的段。在此过程中，如果检测到从表中新删除的段，则索引条目的分析继续，并且设置了另一个段已被删除的指示符。条目的分析以循环方式继续，直到每个条目被评估以确定其是否引用任何被去除的段。如果在纠正完成之前收到查询，则通过建立搜索边界来修改查询，以便查询不会在索引中产生引用已删除的段的任何条目。

5. 发明授权

US07359923B2 Online incremental deferred integrity processing and maintenance of rolled in and rolled out data 有权
标题翻译：在线增量延期完整性处理和维护滚动和滚出数据
公开(公告)号：US07359923B2
公开(公告)日：2008-04-15
申请号：US10923547
申请日：2004-08-20
申请人： Kevin Leo Beck , Paul Michael Brett , Jeffrey James Goss , Dieu Quang La , Catherine Suzanne McArthur , William T. O'Connell
发明人： Kevin Leo Beck , Paul Michael Brett , Jeffrey James Goss , Dieu Quang La , Catherine Suzanne McArthur , William T. O'Connell
IPC分类号： G06F12/00 , G06F17/30
CPC分类号： G06F17/30592 , Y10S707/99952 , Y10S707/99953
摘要： A system and a method for the deferral and incremental performance of integrity processing for data rolled into a table of a data warehouse and for the deferral and incremental performance of maintenance on data rolled out of a table of the data warehouse while permitting general users online access to other data contained in the table. The rolled in and rolled out data are contained within specific data partitions of the table. Each data partition in the table has an associated distinguishable partition ID. Each data partition can also have associated attributes corresponding to containing rolled-in and rolled-out data respectively. Table operation mechanisms are arranged such that general users of the table do not access rolled in data in a partition for which integrity processing has not yet been performed and do not access rolled out data.
摘要翻译：一种系统和方法，用于对数据仓库的数据进行完整性处理的推迟和增量执行，以及对数据仓库表格上推出的数据进行维护的延期和增量执行，同时允许一般用户在线访问到表中包含的其他数据。滚动和滚出的数据包含在表的特定数据分区中。表中的每个数据分区都具有相关的可区分分区ID。每个数据分区还可以分别具有对应于包含滚动和滚出数据的关联属性。安排表操作机制，使得表的一般用户不访问尚未执行完整性处理的分区中的数据中的卷，并且不访问推出的数据。

6. 发明授权

US08170999B2 Online incremental deferred integrity processing and maintenance of rolled in and rolled out data 失效
标题翻译：在线增量延期完整性处理和维护滚动和滚出数据
公开(公告)号：US08170999B2
公开(公告)日：2012-05-01
申请号：US11968666
申请日：2008-01-03
申请人： Kevin Leo Beck , Paul Michael Brett , Jeffrey James Goss , Dieu Quang La , Catherine Suzanne McArthur , William T. O'Connell
发明人： Kevin Leo Beck , Paul Michael Brett , Jeffrey James Goss , Dieu Quang La , Catherine Suzanne McArthur , William T. O'Connell
IPC分类号： G06F17/30
CPC分类号： G06F17/30592 , Y10S707/99952 , Y10S707/99953
摘要： A system and a method for the deferral and incremental performance of integrity processing for data rolled into a table of a data warehouse and for the deferral and incremental performance of maintenance on data rolled out of a table of the data warehouse while permitting general users online access to other data contained in the table. The rolled in and rolled out data are contained within specific data partitions of the table. Each data partition in the table has an associated distinguishable partition ID. Each data partition can also have associated attributes corresponding to containing rolled-in and rolled-out data respectively. Table operation mechanisms are arranged such that general users of the table do not access rolled in data in a partition for which integrity processing has not yet been performed and do not access rolled out data.
摘要翻译：一种系统和方法，用于对数据仓库的数据进行完整性处理的推迟和增量执行，以及对数据仓库表格上推出的数据进行维护的延期和增量执行，同时允许一般用户在线访问到表中包含的其他数据。滚动和滚出的数据包含在表的特定数据分区中。表中的每个数据分区都具有相关的可区分分区ID。每个数据分区还可以分别具有对应于包含滚动和滚出数据的关联属性。安排表操作机制，使得表的一般用户不访问尚未执行完整性处理的分区中的数据中的卷，并且不访问推出的数据。

7. 发明授权

US07290214B2 Independent deferred incremental refresh of materialized views 有权
标题翻译：独立延期递增刷新物化视图
公开(公告)号：US07290214B2
公开(公告)日：2007-10-30
申请号：US10427382
申请日：2003-04-29
申请人： Richard S. Sidle , Dieu Q. La , Petrus Kai Chung Chan , Roberta J. Cochrane , William T. O'Connell , M. Hamid. Pirahesh
发明人： Richard S. Sidle , Dieu Q. La , Petrus Kai Chung Chan , Roberta J. Cochrane , William T. O'Connell , M. Hamid. Pirahesh
IPC分类号： G06F3/00 , G06F17/30
CPC分类号： G06F17/30383 , Y10S707/99932
摘要： A system and method for directing a data processing system to incrementally process a base table and a materialized view, wherein the materialized view is associated with the base table, and both are stored in the system, is disclosed. The method includes setting integrity of the base table having an identifier identifying data newly load appended to the base table, and placing the identifier into a location if the location does not contain any other identifier identifying any other data newly load appended to the base table. In a preferred embodiment, the materialized view is incrementally refreshed using the identifier.
摘要翻译：一种用于引导数据处理系统逐步处理基表和物化视图的系统和方法，其中物化视图与基表相关联，并且两者都存储在系统中。该方法包括设置具有识别附加到基表的新加载的标识符的标识符的基准表的完整性，以及如果位置不包含标识附加到基表的新加载的任何其他数据的任何其他标识符，则将标识符放置在位置中。在优选实施例中，使用标识符递增地刷新物化视图。

8. 发明授权

US08161015B2 Method and system for deferred maintenance of database indexes 失效
标题翻译：数据库索引延期维护的方法和系统
公开(公告)号：US08161015B2
公开(公告)日：2012-04-17
申请号：US13083973
申请日：2011-04-11
申请人： John Paul Kennedy , Quanhua Hong , William T. O'Connell , Leslie Anne Buback
发明人： John Paul Kennedy , Quanhua Hong , William T. O'Connell , Leslie Anne Buback
IPC分类号： G06F7/00 , G06F17/00 , G06F12/16 , G06F17/30
CPC分类号： G06F17/30306
摘要： Rectifying discrepancies between a table, from which a segment of data has been removed, and an index for the table may be deferred. Each entry in the index is sequentially analyzed to remove entries therefrom referring to any removed segment referenced in the starting location list. During this process, if a segment newly removed from the table is detected, then analysis of the index entries continues and an indicator is set that another segment has been removed. Analysis of the entries continues in a looping fashion until each entry has been assessed to determine if it makes a reference to any of the removed segments. If a query is received before rectification is complete then the query is amended by establishing search boundaries based so that the query does not produce any entries in the index referring to removed segments.
摘要翻译：纠正已删除数据段的表与表的索引之间的差异可能会被推迟。依次分析索引中的每个条目，以从其中删除条目，参考起始位置列表中引用的任何已删除的段。在此过程中，如果检测到从表中新删除的段，则索引条目的分析继续，并且设置了另一个段已被删除的指示符。条目的分析以循环方式继续，直到每个条目被评估以确定其是否引用任何被去除的段。如果在纠正完成之前收到查询，则通过建立搜索边界来修改查询，以便查询不会在索引中产生引用已删除的段的任何条目。

9. 发明授权

US07730057B2 Computer data systems implemented using a virtual solution architecture 有权
标题翻译：使用虚拟解决方案架构实现的计算机数据系统
公开(公告)号：US07730057B2
公开(公告)日：2010-06-01
申请号：US11146830
申请日：2005-06-06
申请人： John W. Bell , Simon Ashley Field , Jason Michael Gartner , Randall R. Holmes , Nancy A. Kopp , William T. O'Connell , Paulo Roberto Rosa Pereira
发明人： John W. Bell , Simon Ashley Field , Jason Michael Gartner , Randall R. Holmes , Nancy A. Kopp , William T. O'Connell , Paulo Roberto Rosa Pereira
IPC分类号： G06F17/30
CPC分类号： G06F17/30592 , G06F9/5077 , G06F11/2035 , G06F11/2048 , G06F17/30566
摘要： Virtual solution architecture for computer data systems. In one aspect, providing an architecture for a computer data system includes creating a virtual solution architecture that includes a plurality of building blocks, each building block characterized by balanced operation, and mapping the virtual solution architecture to a physical solution architecture for the computer data system. Another aspect includes providing at least one balanced configuration unit (BCU) in a computer data system, the BCU including at least one balanced partition unit (BPU) that includes computer resources to provide balanced operation for the BPU.
摘要翻译：计算机数据系统的虚拟解决方案架构。在一个方面，提供用于计算机数据系统的架构包括创建包括多个构建块的虚拟解决方案架构，每个构建块的特征在于平衡操作，并将虚拟解决方案架构映射到计算机数据系统的物理解决方案架构。另一方面包括在计算机数据系统中提供至少一个平衡配置单元（BCU），该BCU包括至少一个平衡分区单元（BPU），其包括用于为BPU提供平衡操作的计算机资源。

10. 发明授权

US07447681B2 Method, system and program for selection of database characteristics 有权
标题翻译：用于选择数据库特征的方法，系统和程序
公开(公告)号：US07447681B2
公开(公告)日：2008-11-04
申请号：US11060009
申请日：2005-02-17
申请人： Sam Sampson Lightstone , Guy Maring Lohman , William T. O'Connell , Jun Rao , Robin D. Van Boeschoten , Daniele Costante Zilio , Calisto Paul Zuzarte
发明人： Sam Sampson Lightstone , Guy Maring Lohman , William T. O'Connell , Jun Rao , Robin D. Van Boeschoten , Daniele Costante Zilio , Calisto Paul Zuzarte
IPC分类号： G06F17/30
CPC分类号： G06F11/3447 , G06F2201/80 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935 , Y10S707/99942
摘要： Disclosed is a method for directing a data processing system, the data processing system and an article of manufacture. The data processing system has memory for storing a database. The method directs the data processing system to configuring the database based on a database workload having a performance metric. The method includes selecting a plurality of database characteristics based upon the database workload, each of the database characteristics having an associated estimated performance metric for the database workload, selecting a set of database characteristics from the plurality of database characteristics for which the associated estimated performance metric is lower than the database workload performance metric, and configuring the database using the selected set of database characteristics.
摘要翻译：公开了一种用于指导数据处理系统，数据处理系统和制品的方法。数据处理系统具有用于存储数据库的存储器。该方法指导数据处理系统基于具有性能度量的数据库工作负载配置数据库。该方法包括基于数据库工作负载来选择多个数据库特征，每个数据库特征具有数据库工作负载的相关联的估计性能度量，从多个数据库特征中选择一组数据库特征，对于该数据库特征，相关联的估计性能度量低于数据库工作负载性能指标，并使用所选数据库特征集来配置数据库。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式