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

    公开(公告)号:US07539667B2

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

    申请号:US10982441

    申请日:2004-11-05

    IPC分类号: G06F17/30

    摘要: 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 all operator and data modifying operations
    3.
    发明授权
    Method, system, and program for executing a query having a union all operator and data modifying operations 失效
    用于执行具有联合的所有操作符和数据修改操作的查询的方法,系统和程序

    公开(公告)号:US07533087B2

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

    申请号:US10982367

    申请日:2004-11-05

    IPC分类号: G06F17/30

    摘要: 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操作符引用数据对象。 数据处理系统实现的方法包括防止所有操作员的联合被应用于数据对象,并且对数据对象应用一组数据修改运算符。

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

    公开(公告)号:US07409385B2

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

    申请号:US10982337

    申请日:2004-11-05

    IPC分类号: G06F7/00 G06F17/00

    摘要: 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.

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