公开(公告)号：US20080040334A1

公开(公告)日：2008-02-14

申请号：US11463314

申请日：2006-08-09

申请人： Gad Haber ,  Andre Heilper ,  Ariel Landau ,  Nattavut Sutyanyong ,  Gary Valentin ,  Calisto Zuzarte

发明人： Gad Haber ,  Andre Heilper ,  Ariel Landau ,  Nattavut Sutyanyong ,  Gary Valentin ,  Calisto Zuzarte

IPC分类号： G06F17/30

CPC分类号： G06F16/24534

摘要： Methods and systems are provided to facilitate the optimization process of existing relational database managers when processing complex queries. Specialized constraining clauses are inserted in or added to SQL queries, which do not affect the semantics of the queries. This operation causes the RDBMS to partition the query into sub-queries, and to apply a more efficient optimization for each sub-query. A condition in which the execution time of the modified query substantially exceeds that of the original query may indicate a design flaw in the RDBMS query optimizer.

摘要翻译： 提供方法和系统，以便在处理复杂查询时促进现有关系数据库管理器的优化过程。 专门的约束条款插入或添加到SQL查询，这不会影响查询的语义。 此操作使RDBMS将查询分割为子查询，并为每个子查询应用更有效的优化。 修改查询的执行时间大大超过原始查询的执行时间的条件可能表示RDBMS查询优化器中的设计缺陷。

公开(公告)号：US20060101044A1

公开(公告)日：2006-05-11

申请号：US10982367

申请日：2004-11-05

申请人： Linqi Liu ,  Robert Neugebauer ,  David Sharpe ,  Nattavut Sutyanyong ,  Calisto Zuzarte

发明人： Linqi Liu ,  Robert Neugebauer ,  David Sharpe ,  Nattavut Sutyanyong ,  Calisto Zuzarte

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

CPC分类号： G06F17/30418 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99942

摘要： Disclosed is a data processing system, a data processing system implemented method and an article of manufacture for executing a query having a union all operator. The data processing system implemented method directs the data processing system to execute a query against a data object. The query has a union all operator and has a set of data modifying operators. The set of data modifying operators is associated with the union all operator. The union all operator references the data object. The data processing system implemented method includes preventing the union all operator from being applied to the data object, and applying the set of data modifying operators against the data object.

摘要翻译： 公开了一种数据处理系统，数据处理系统实现方法和用于执行具有联合全部操作者的查询的制品。 数据处理系统实现的方法指导数据处理系统对数据对象执行查询。 该查询具有一个union all运算符，并具有一组数据修改运算符。 数据修改运算符的集合与union all运算符相关联。 union all操作符引用数据对象。 数据处理系统实现的方法包括防止所有操作员的联合被应用于数据对象，并且对数据对象应用一组数据修改运算符。

公开(公告)号：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 分组数据对象的至少一个成员基于参考。

公开(公告)号：US07533087B2

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

申请号：US10982367

申请日：2004-11-05

申请人： Linqi Liu ,  Robert Paul Neugebauer ,  David C. Sharpe ,  Nattavut Sutyanyong ,  Calisto Paul Zuzarte

发明人： Linqi Liu ,  Robert Paul Neugebauer ,  David C. Sharpe ,  Nattavut Sutyanyong ,  Calisto Paul Zuzarte

IPC分类号： G06F17/30

CPC分类号： G06F17/30418 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99942

摘要： Disclosed is a data processing system, a data processing system implemented method and an article of manufacture for executing a query having a union all operator. The data processing system implemented method directs the data processing system to execute a query against a data object. The query has a union all operator and has a set of data modifying operators. The set of data modifying operators is associated with the union all operator. The union all operator references the data object. The data processing system implemented method includes preventing the union all operator from being applied to the data object, and applying the set of data modifying operators against the data object.

摘要翻译： 公开了一种数据处理系统，数据处理系统实现方法和用于执行具有联合全部操作者的查询的制品。 数据处理系统实现的方法指导数据处理系统对数据对象执行查询。 该查询具有一个union all运算符，并具有一组数据修改运算符。 数据修改运算符的集合与union all运算符相关联。 union all操作符引用数据对象。 数据处理系统实现的方法包括防止所有操作员的联合被应用于数据对象，并且对数据对象应用一组数据修改运算符。

公开(公告)号：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.

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

公开(公告)号：US20060101011A1

公开(公告)日：2006-05-11

申请号：US10982441

申请日：2004-11-05

申请人： Bruce Lindsay ,  Linqi Liu ,  Robert Neugebauer ,  Mir Pirahesh ,  David Sharpe ,  Nattavut Sutyanyong ,  Calisto Zuzarte

发明人： Bruce Lindsay ,  Linqi Liu ,  Robert Neugebauer ,  Mir Pirahesh ,  David Sharpe ,  Nattavut Sutyanyong ,  Calisto Zuzarte

IPC分类号： G06F7/00 ,  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.

公开(公告)号：US20060101001A1

公开(公告)日：2006-05-11

申请号：US10982337

申请日：2004-11-05

申请人： Bruce Lindsay ,  Linqi Liu ,  Robert Neugebauer ,  Mir Pirahesh ,  David Sharpe ,  Nattavut Sutyanyong ,  Calisto Zuzarte

发明人： Bruce Lindsay ,  Linqi Liu ,  Robert Neugebauer ,  Mir Pirahesh ,  David Sharpe ,  Nattavut Sutyanyong ,  Calisto Zuzarte

IPC分类号： G06F17/30

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.

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