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

1. 发明授权

US07007006B2 Method for recommending indexes and materialized views for a database workload 失效
公开(公告)号：US07007006B2
公开(公告)日：2006-02-28
申请号：US10177007
申请日：2002-06-21
申请人： Daniel C. Zilio , Gary G. Valentin , Guy M. Lohman , Calisto P. Zuzarte , Roberta J. Cochrane , Hamid Pirahesh , Markos Zaharioudakis , Kit Man Cheung , Kevin S. Beyer , David E. Simmen , Ting Y. Leung , Samuel S. Lightstone
发明人： Daniel C. Zilio , Gary G. Valentin , Guy M. Lohman , Calisto P. Zuzarte , Roberta J. Cochrane , Hamid Pirahesh , Markos Zaharioudakis , Kit Man Cheung , Kevin S. Beyer , David E. Simmen , Ting Y. Leung , Samuel S. Lightstone
IPC分类号： G06F17/30
CPC分类号： G06F17/30312 , Y10S707/99932 , Y10S707/99934 , Y10S707/99935
摘要： The invention herein provides method and apparatus, including software for determining a set of materialized views or indices of the contents or a subset of the contents of a database in a data processing system to be created for one or more users of the database. The method and apparatus provide method and means for evaluating a workload presented by a user to the database; evaluating the data processing system characteristics; evaluating the database characteristics; and, using the above evaluations for recommending a set of suitable materialized views or indices to the user. Another aspect of the invention, which may be used for a workload presented by a user of a database in a data processing system, provides method and apparatus, including software for determining a set of materialized views or indices of the contents or a subset of the contents of the database, by: generating a plurality of materialized view candidates from evaluation of the workload, data processing system characteristics and database characteristics; estimating statistics for the materialized view candidates such as the number of rows, row size, and column statistics; generating a plurality of potential index candidates by evaluating the workload, data processing system characteristics, database characteristics and the materialized view candidates; and, from the materialized view candidates and index candidates selecting a set of suitable materialized views and/or indices for submission to the user.

2. 发明授权

US07162505B2 Classification of data for insertion into a database 失效
标题翻译：用于插入数据库的数据分类
公开(公告)号：US07162505B2
公开(公告)日：2007-01-09
申请号：US10393852
申请日：2003-03-21
申请人： Serge Rielau , Roberta J. Cochrane , George Lapis , Hamid Pirahesh , Richard S. Sidle , Biao Zhu
发明人： Serge Rielau , Roberta J. Cochrane , George Lapis , Hamid Pirahesh , Richard S. Sidle , Biao Zhu
IPC分类号： G06F12/00 , G06F17/30
CPC分类号： G06F17/30365 , G06F17/30483 , Y10S707/99952 , Y10S707/99955
摘要： A method and system for use in a computing environment for selecting a subset of records from a set of records for placement of the subset of records in a plurality of destinations. A group of replica records is formed for a record of the subset of records, and a destination identification is assigned to each replica record, except one, of the group of replica records. A replica record associated with one of the plurality of destinations can be selected and can be placed in the associated destination.
摘要翻译：一种在计算环境中使用的方法和系统，用于从一组记录中选择记录的子集，以将记录子集放置在多个目的地中。为记录子集的记录形成一组副本记录，并且将目的地标识分配给每个副本记录，除复制记录组之外的一个。可以选择与多个目的地之一相关联的副本记录，并且可以将其放置在相关联的目的地中。

3. 发明授权

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.
摘要翻译：一种用于引导数据处理系统逐步处理基表和物化视图的系统和方法，其中物化视图与基表相关联，并且两者都存储在系统中。该方法包括设置具有识别附加到基表的新加载的标识符的标识符的基准表的完整性，以及如果位置不包含标识附加到基表的新加载的任何其他数据的任何其他标识符，则将标识符放置在位置中。在优选实施例中，使用标识符递增地刷新物化视图。

4. 发明授权

US07165063B2 Context quantifier transformation in XML query rewrite 失效
标题翻译： XML查询重写中的上下文量词变换
公开(公告)号：US07165063B2
公开(公告)日：2007-01-16
申请号：US10717870
申请日：2003-11-19
申请人： Kevin S. Beyer , Roberta J. Cochrane , Fatma Ozcan , Normen Seemann
发明人： Kevin S. Beyer , Roberta J. Cochrane , Fatma Ozcan , Normen Seemann
IPC分类号： G06F17/30
CPC分类号： G06F17/30935 , G06F17/30932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935
摘要： An XML query compilation processor (20) includes an execution compiler (42) that transforms an XML query into an executable XML query plan (22). A query rewrite processor (34) performs query transformations on the XML query. Said query transformations include transforming an expression input (60) received by an expression (62) conditional upon a set of items defined by an output (64) of the expression (62) being independent of grouping of items in the expression input (60).
摘要翻译： XML查询编译处理器（20）包括将XML查询转换成可执行XML查询计划（22）的执行编译器（42）。查询重写处理器（34）对XML查询执行查询转换。所述查询变换包括变换由表达式（62）接收的表达式输入（60），该表达式输入（60）是由表达式（62）的输出（64）定义的一组项独立于表达式输入（60）中的项目的分组而条件的。。

5. 发明授权

US5546576A Query optimizer system that detects and prevents mutating table violations of database integrity in a query before execution plan generation 失效
标题翻译：在执行计划生成之前，查询优化器系统检测和防止在查询中突变表违反数据库完整性
公开(公告)号：US5546576A
公开(公告)日：1996-08-13
申请号：US390196
申请日：1995-02-17
申请人： Roberta J. Cochrane , Mir H. Pirahesh , Richard S. Sidle
发明人： Roberta J. Cochrane , Mir H. Pirahesh , Richard S. Sidle
IPC分类号： G06F17/30
CPC分类号： G06F17/30448 , G06F17/30371 , G06F17/3051 , Y10S707/99932
摘要： An automated system for detecting and preventing mutating table violations of database integrity in a SQL query before generation and selection of an optimal query execution plan (QEP). This system modifies the query graph model (QGM) to restrict the choice of execution plans to those that avoid mutating table integrity (MTI) violations, thereby forcing database integrity during table mutation when executing the optimal QEP. Mutating table integrity violations are detected by evaluating the position in the QGM of each write-node referencing a particular base table with respect to each of the positions of all other read- and write-nodes referencing of the same base table. Every common-referencing node pair is tested for sequencing conflicts and a data-flow dam is inserted in the QGM where necessary to force the completion of the execution of one node before initiating execution of the other common-referencing node. The system of this invention allows processing of all non-cyclic and most cyclic SQL queries known to cause mutating table integrity violations, such as queries having searched and positioned inserts, deletes and updates, and row-level triggers.
摘要翻译：一种用于在生成和选择最优查询执行计划（QEP）之前，在SQL查询中检测和防止突变表违反数据库完整性的自动化系统。该系统修改查询图模型（QGM），将执行计划的选择限制为避免突变表完整性（MTI）违规的选择，从而在执行最佳QEP时强制表突变期间的数据库完整性。通过评估参考相同基准表的所有其他读 - 写节点的每个位置的引用特定基表的每个写节点的QGM中的位置来检测突变表完整性违反。测试每个共同参考节点对的排序冲突，并且在QGM中插入数据流大坝，必要时强制完成一个节点的执行，然后再启动其他公共引用节点的执行。本发明的系统允许处理已知导致突变表完整性违例的所有非循环和大多数循环SQL查询，例如具有搜索和定位的插入，删除和更新的查询以及行级触发器。

6. 发明授权

US07240054B2 Techniques to preserve data constraints and referential integrity in asynchronous transactional replication of relational tables 失效
标题翻译：在关系表的异步事务复制中保留数据约束和引用完整性的技术
公开(公告)号：US07240054B2
公开(公告)日：2007-07-03
申请号：US10788651
申请日：2004-02-27
申请人： Nicolas G. Adiba , Roberta J. Cochrane , Elizabeth B. Hamel , Somil D. Kulkarni , Bruce G. Lindsay
发明人： Nicolas G. Adiba , Roberta J. Cochrane , Elizabeth B. Hamel , Somil D. Kulkarni , Bruce G. Lindsay
IPC分类号： G06F17/30
CPC分类号： G06F17/30371 , G06F17/30578 , Y10S707/99934
摘要： An improved method and system for preserving data constraints during parallel apply in asynchronous transaction replication in a database system have been disclosed. The method and system preserves secondary unique constraints and referential integrity constraints, while also allowing a high degree of parallelism in the application of asynchronous replication transactions. The method and system also detects and resolves ordering problems introduced by referential integrity cascade deletes, and allows the parallel initial loading of parent and child tables of a referential integrity constraint.
摘要翻译：已经公开了一种用于在数据库系统中的异步事务复制中并行地保留数据约束的改进的方法和系统。该方法和系统保留次要唯一约束和引用完整性约束，同时还允许应用异步复制事务的高度并行性。该方法和系统还检测和解决引用完整性级联删除引入的排序问题，并允许并行初始加载父表和子表的引用完整性约束。

7. 发明授权

US07505957B2 Incremental AST maintenance using work areas 有权
标题翻译：使用工作区域增量AST维护
公开(公告)号：US07505957B2
公开(公告)日：2009-03-17
申请号：US10643644
申请日：2003-08-19
申请人： Roberta J. Cochrane , Mir H. Pirahesh , Richard S. Sidle
发明人： Roberta J. Cochrane , Mir H. Pirahesh , Richard S. Sidle
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30457 , G06F17/30489 , Y10S707/99932 , Y10S707/99933
摘要： Disclosed is a method and system for incrementally maintaining algebraic functions in automatic summary tables (ASTs) of at least one relational database. The method associates a work area with each algebraic function in each AST. Each work area is comprised of one or more variables. The method populates the variables within each work area for each algebraic function when each AST is created and when each AST is updated. The method maintains each work area by adding and subtracting to and from its associated variables when the associated data changes in the relational database. The functions that compute the variables of the work areas are distributive and thus incrementally maintainable. The method computes and recomputes the algebraic function within an AST after the updates have changed one or more of the variables of its work area.
摘要翻译：公开了一种用于在至少一个关系数据库的自动汇总表（AST）中逐渐维持代数函数的方法和系统。该方法将工作区域与每个AST中的每个代数函数相关联。每个工作区域都包含一个或多个变量。当创建每个AST和更新每个AST时，该方法为每个代数函数填充每个工作区域内的变量。该方法通过在关系数据库中相关联的数据更改时向其关联变量添加和减少来维护每个工作区域。计算工作区变量的函数是分布式的，因此可以逐步维护。该方法在更新改变其工作区域的一个或多个变量之后，计算并重新计算AST内的代数函数。

8. 发明授权

US09069830B2 Retrieving data objects 有权
标题翻译：检索数据对象
公开(公告)号：US09069830B2
公开(公告)日：2015-06-30
申请号：US13074472
申请日：2011-03-29
申请人： Roberta J. Cochrane , Ronald C. Leung , Louis S. W. Mau
发明人： Roberta J. Cochrane , Ronald C. Leung , Louis S. W. Mau
IPC分类号： G06F17/30
CPC分类号： G06F17/30572
摘要： Provided are techniques for generating a Graphical User Interface (GUI) based on relationships between tables identified in a data model and displaying the GUI to enable selection of the tables and columns in the tables. Via the GUI, a selection of at least one of the tables and a selection of at least one of the columns in the at least one of the selected tables are received. A statement is generated based on the selected tables and the selected columns. The statement is executed to obtain results. The results are processed to create a data object having a hierarchical structure that indicates the relationships between the tables.
摘要翻译：提供了基于在数据模型中识别的表之间的关系生成图形用户界面（GUI）的技术，并且显示GUI以使得能够选择表中的表和列。通过GUI，接收至少一个表的选择以及所选择的表中的至少一个列中的至少一列的选择。基于选定的表和所选列生成语句。执行该语句以获得结果。处理结果以创建具有指示表之间的关系的层次结构的数据对象。

9. 发明授权

US09069831B2 Retrieving data objects 有权
公开(公告)号：US09069831B2
公开(公告)日：2015-06-30
申请号：US13543552
申请日：2012-07-06
申请人： Roberta J. Cochrane , Ronald C. Leung , Louis S. W. Mau
发明人： Roberta J. Cochrane , Ronald C. Leung , Louis S. W. Mau
IPC分类号： G06F17/30
CPC分类号： G06F17/30572
摘要： Provided are techniques for generating a Graphical User Interface (GUI) based on relationships between tables identified in a data model and displaying the GUI to enable selection of the tables and columns in the tables. Via the GUI, a selection of at least one of the tables and a selection of at least one of the columns in the at least one of the selected tables are received. A statement is generated based on the selected tables and the selected columns. The statement is executed to obtain results. The results are processed to create a data object having a hierarchical structure that indicates the relationships between the tables.

10. 发明申请

US20120278306A1 RETRIEVING DATA OBJECTS 审中-公开
公开(公告)号：US20120278306A1
公开(公告)日：2012-11-01
申请号：US13543552
申请日：2012-07-06
申请人： Roberta J. Cochrane , Ronald C. Leung , Louis S.W. Mau
发明人： Roberta J. Cochrane , Ronald C. Leung , Louis S.W. Mau
IPC分类号： G06F17/30
CPC分类号： G06F17/30572
摘要： Provided are techniques for generating a Graphical User Interface (GUI) based on relationships between tables identified in a data model and displaying the GUI to enable selection of the tables and columns in the tables. Via the GUI, a selection of at least one of the tables and a selection of at least one of the columns in the at least one of the selected tables are received. A statement is generated based on the selected tables and the selected columns. The statement is executed to obtain results. The results are processed to create a data object having a hierarchical structure that indicates the relationships between the tables.

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式