利索-全球专利检索

  1. 登录
  2. 注册

搜索结果

30 条记录 (耗时 0.035 秒)

    System and method for constraint checking bulk data in a database
    2.
    发明授权
    System and method for constraint checking bulk data in a database 失效
    用于约束检查数据库中批量数据的系统和方法

    公开(公告)号：US5706494A

    公开(公告)日：1998-01-06

    申请号：US387037

    申请日：1995-02-10

    申请人： Roberta Jo Cochrane ,  Mir Hamid Pirahesh ,  Richard Sefton Sidle ,  Calisto Paul Zuzarte

    发明人： Roberta Jo Cochrane ,  Mir Hamid Pirahesh ,  Richard Sefton Sidle ,  Calisto Paul Zuzarte

    IPC分类号： G06F12/00 ,  G06F17/30

    CPC分类号： G06F17/30595 ,  Y10S707/99932 ,  Y10S707/99934 ,  Y10S707/99942

    摘要： In a relational database management system (RDMS), a method and system for constraint checking of bulk data after storage in a base table. This invention generates a "dummy" INSERT inquiry to cause the compiler constraint rule engine to generate code for checking for constraint violations. After construction of a Query Graph Model by the compiler, a logic module replaces the INSERT inquiry with a SELECT inquiry to create code that when executed will select records from the bulk data table. Constraint violations are handled in several ways by this invention, including merely reporting that a constraint error exists or listing those records that violate constraint conditions. The logic also enforces referential integrity constraints by applying the SQL CASCADE command to the violating records to expand the violation list to include children records that would be orphaned when their parent records are later removed.

    摘要翻译： 在关系数据库管理系统（RDMS）中，用于在基表中存储之后批量数据的约束检查的方法和系统。 本发明生成“伪”INSERT查询，以使编译器约束规则引擎生成用于检查约束违规的代码。 在编译器构建查询图模型之后，逻辑模块将使用SELECT查询替换INSERT查询，以创建代码，当执行时将从批量数据表中选择记录。 通过本发明以多种方式处理约束违规，包括仅报告存在约束错误或列出违反约束条件的那些记录。 该逻辑还通过将SQL CASCADE命令应用于违规记录来扩展违例列表来强制执行引用完整性约束，以包括当其父记录稍后被删除时将成为孤立的子记录。

    Query optimization by transparently altering properties of relational tables using materialized views
    3.
    发明授权
    Query optimization by transparently altering properties of relational tables using materialized views 有权
    通过使用实例化视图透明地更改关系表的属性来进行查询优化

    公开(公告)号：US06339769B1

    公开(公告)日：2002-01-15

    申请号：US09152551

    申请日：1998-09-14

    申请人： Roberta Jo Cochrane ,  George Lapis ,  Ting Yu Leung ,  Mir Hamid Pirahesh ,  Monica Sachiye Urata ,  Richard Sefton Sidle ,  David E. Simmen ,  Calisto Paul Zuzarte

    发明人： Roberta Jo Cochrane ,  George Lapis ,  Ting Yu Leung ,  Mir Hamid Pirahesh ,  Monica Sachiye Urata ,  Richard Sefton Sidle ,  David E. Simmen ,  Calisto Paul Zuzarte

    IPC分类号： G06F1730

    CPC分类号： G06F17/30457 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99945

    摘要： A method, apparatus, and article of manufacture for optimizing database queries using a materialized view for a table referenced in the query, wherein the materialized view has different properties than the referenced table. The materialized view may be replicated across multiple processors of the computer system, so that some or all of the query can be executed in a local fashion wherein there is no data movement required to perform the operations. The materialized view also may be partitioned across multiple processors of the computer system using a different partitioning key than the referenced table. The materialized view may be a vertical and/or horizontal subset of the table, so that only selected columns and/or tuples from the table are present therein. Columns may be added to the materialized view to contain pre-computed results of complex expressions, and indices may be created on the columns of the materialized view.

    摘要翻译： 使用查询中引用的表的实例化视图优化数据库查询的方法，装置和制品，其中物化视图具有与所引用的表不同的属性。 实体化视图可以复制在计算机系统的多个处理器上，使得可以以本地方式执行部分或全部查询，其中不存在执行操作所需的数据移动。 实体化视图还可以使用与参考表不同的分区键在计算机系统的多个处理器上分区。 实例化视图可以是表的垂直和/或水平子集，使得仅在表中存在所选择的列和/或元组。 可以将列添加到物化视图以包含复合表达式的预计算结果，并且可以在物化视图的列上创建索引。

    Method, system, and program for query optimization with algebraic rules
    4.
    发明授权
    Method, system, and program for query optimization with algebraic rules 失效
    用代数规则进行查询优化的方法，系统和程序

    公开(公告)号：US07240078B2

    公开(公告)日：2007-07-03

    申请号：US10721802

    申请日：2003-11-25

    申请人： Qi Cheng ,  Mir Hamid Pirahesh ,  Yang Sun ,  Calisto Paul Zuzarte

    发明人： Qi Cheng ,  Mir Hamid Pirahesh ,  Yang Sun ,  Calisto Paul Zuzarte

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30457 ,  Y10S707/99933 ,  Y10S707/99954

    摘要： A query is matched to an outlier materialized query table that stores exception data. The query is searched for a source predicate. An outlier predicate in the outlier materialized query table that corresponds to the source predicate is searched for a target column that corresponds to a source column in the source predicate. A new range predicate is derived based on the target column and introduced into the query, wherein the query is executed to retrieve data from one or more data stores.

    摘要翻译： 查询与存储异常数据的异常值物化查询表进行匹配。 查询查询源谓词。 搜索与源谓词对应的离群物质化查询表中的异常谓词，找出与源谓词中的源列相对应的目标列。 基于目标列导出新的范围谓词并将其引入到查询中，其中执行查询以从一个或多个数据存储中检索数据。

    Method, system, and program for query optimization with algebraic rules
    5.
    发明授权
    Method, system, and program for query optimization with algebraic rules 有权
    用代数规则进行查询优化的方法，系统和程序

    公开(公告)号：US07945557B2

    公开(公告)日：2011-05-17

    申请号：US11754213

    申请日：2007-05-25

    申请人： Qi Cheng ,  Mir Hamid Pirahesh ,  Yang Sun ,  Calisto Paul Zuzarte

    发明人： Qi Cheng ,  Mir Hamid Pirahesh ,  Yang Sun ,  Calisto Paul Zuzarte

    IPC分类号： G06F17/30 ,  G06F15/16

    CPC分类号： G06F17/30457 ,  Y10S707/99933 ,  Y10S707/99954

    摘要： A set of algebraic rules applicable to a query are identified, wherein each of the algebraic rules represents a relationship between two columns in a relational database table. A source column is identified by searching the query for a source predicate, wherein the source predicate is a range predicate. One or more candidate target columns are identified by searching the set of algebraic rules, wherein each of the candidate target columns occurs on one side of a binding expression and the source column occurs on the other side of the binding expression. For each of the one or more candidate target columns, a bounds subquery that provides a lower bound and an upper bound for a new range predicate is derived and he new range predicate is introduced into the query, wherein the query is executed to retrieve data from one or more data stores.

    摘要翻译： 识别适用于查询的一组代数规则，其中每个代数规则表示关系数据库表中两列之间的关系。 通过搜索查询源标识来识别源列，其中源谓词是范围谓词。 通过搜索代数规则集来识别一个或多个候选目标列，其中候选目标列中的每一个出现在绑定表达式的一侧上，并且源列出现在绑定表达式的另一侧上。 对于一个或多个候选目标列中的每一个，导出提供新范围谓词的下限和上限的边界子查询，并且将新范围谓词引入到查询中，其中执行查询以从 一个或多个数据存储。

    Method, system and program for executing a query having a union operator
    6.
    发明授权
    Method, system and program for executing a query having a union operator 有权
    用于执行具有联合运算符的查询的方法，系统和程序

    公开(公告)号：US07539667B2

    公开(公告)日：2009-05-26

    申请号：US10982441

    申请日：2004-11-05

    申请人： Bruce Gilbert Lindsay ,  Linqi Liu ,  Robert Paul Neugebauer ,  Mir Hamid Pirahesh ,  David C. Sharpe ,  Nattavut Sutyanyong ,  Calisto Paul Zuzarte

    发明人： Bruce Gilbert Lindsay ,  Linqi Liu ,  Robert Paul Neugebauer ,  Mir Hamid Pirahesh ,  David C. Sharpe ,  Nattavut Sutyanyong ,  Calisto Paul Zuzarte

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30454 ,  Y10S707/99932 ,  Y10S707/99933

    摘要： Disclosed is a data processing system implemented method, a data processing system and an article of manufacture for executing a query having a union operator. A data processing system implemented method direct the data processing system to execute a query against a database having data objects. The query has sub-queries and having a union operator. The union operator is operable on sub-queries associated with the query. The database is operatively coupled to the data processing system. The data processing system implemented method including grouping the sub-queries of the union operator according to identified structural similarities, the identified structural similarities being based on an analysis of the sub-queries, grouping the data objects of the database according to the grouped sub-queries, replacing the grouped data objects and any sub-queries associated with the grouped data objects with a reference to a representative data object and a representative sub-query, and accessing at least one member of the grouped data objects, the accessing of the at least one member of the grouped data object being based on the reference.

    摘要翻译： 公开了一种用于执行具有联合运算符的查询的数据处理系统实现方法，数据处理系统和制品。 数据处理系统实现的方法指导数据处理系统对具有数据对象的数据库执行查询。 该查询具有子查询并具有联合运算符。 联合运算符可用于与查询相关联的子查询。 数据库可操作地耦合到数据处理系统。 所述数据处理系统实现方法包括根据所识别的结构相似性对所述联合运算符的子查询进行分组，所识别的结构相似性基于所述子查询的分析，根据所述分组子集对数据库的数据对象进行分组， 查询，通过参考代表性数据对象和代表性子查询替换分组数据对象和与分组数据对象相关联的任何子查询，以及访问分组数据对象的至少一个成员，访问at 分组数据对象的至少一个成员基于参考。

    Method, system and program for executing a query having a UNION operator
    7.
    发明授权
    Method, system and program for executing a query having a UNION operator 失效
    用于执行具有UNION运算符的查询的方法，系统和程序

    公开(公告)号：US07409385B2

    公开(公告)日：2008-08-05

    申请号：US10982337

    申请日：2004-11-05

    申请人： Bruce Gilbert Lindsay ,  Linqi Liu ,  Robert Paul Neugebauer ,  Mir Hamid Pirahesh ,  David C. Sharpe ,  Nattavut Sutyanyong ,  Calisto Paul Zuzarte

    发明人： Bruce Gilbert Lindsay ,  Linqi Liu ,  Robert Paul Neugebauer ,  Mir Hamid Pirahesh ,  David C. Sharpe ,  Nattavut Sutyanyong ,  Calisto Paul Zuzarte

    IPC分类号： G06F7/00 ,  G06F17/00

    CPC分类号： G06F17/30454 ,  Y10S707/99933 ,  Y10S707/99934

    摘要： Disclosed is a data processing system implemented method, a data processing system and an article of manufacture for executing a query having a union operator. The data processing system implemented method directs the data processing system to process a query against data objects. The data objects are operatively coupled to the data processing system. The query includes a parent operator. The parent operator references a union operator. The union operator references sub-queries. The sub-queries reference the data objects. The data processing system implemented method includes noting a set of partitionings for the union operator, the noted set of partitionings being based on the sub-queries and being based on the data objects reference by the sub-queries, and executing the query having the union operator, the execution of the query being based on the noted set of partitionings and the parent operator.

    摘要翻译： 公开了一种用于执行具有联合运算符的查询的数据处理系统实现方法，数据处理系统和制品。 数据处理系统实现的方法指导数据处理系统处理对数据对象的查询。 数据对象可操作地耦合到数据处理系统。 该查询包括父操作符。 父操作员引用联合运算符。 联合运算符引用子查询。 子查询引用数据对象。 所述数据处理系统实现的方法包括注意用于联合运算符的一组分区，所述一组分区基于子查询，并且基于由子查询引用的数据对象，并且执行具有联合的查询 操作员，查询的执行是基于所述的一组分区和父操作符。