利索-全球专利检索

  1. 登录
  2. 注册

搜索结果

11 条记录 (耗时 0.027 秒)

    Independent deferred incremental refresh of materialized views
    2.
    发明授权
    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.

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

    Query optimizer system that detects and prevents mutating table violations of database integrity in a query before execution plan generation
    3.
    发明授权
    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查询，例如具有搜索和定位的插入，删除和更新的查询以及行级触发器。

    Incremental AST maintenance using work areas
    4.
    发明授权
    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内的代数函数。

    Retrieving data objects
    7.
    发明授权
    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，接收至少一个表的选择以及所选择的表中的至少一个列中的至少一列的选择。 基于选定的表和所选列生成语句。 执行该语句以获得结果。 处理结果以创建具有指示表之间的关系的层次结构的数据对象。

    Context quantifier transformation in XML query rewrite
    8.
    发明授权
    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）中的项目的分组而条件的。 。

    Retrieving data objects
    9.
    发明授权
    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.

    RETRIEVING DATA OBJECTS
    10.
    发明申请
    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.