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

1. 发明授权

US07539667B2 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 分组数据对象的至少一个成员基于参考。

2. 发明授权

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

3. 发明授权

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

4. 发明授权

US07275056B2 System and method for transforming queries using window aggregation 有权
标题翻译：使用窗口聚合转换查询的系统和方法
公开(公告)号：US07275056B2
公开(公告)日：2007-09-25
申请号：US10425343
申请日：2003-04-29
申请人： Qi Cheng , Linqi Liu , Wenbin Ma , Mir Hamid Pirahesh , Calisto P. Zuzarte
发明人： Qi Cheng , Linqi Liu , Wenbin Ma , Mir Hamid Pirahesh , Calisto P. Zuzarte
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30451 , Y10S707/99934 , Y10S707/99935
摘要： A system and method transform queries with subqueries, using window aggregation. An optimizer in a relational database management system transforms queries to optimize their efficiency and speed. The method transforms queries that have a subquery, replacing the subquery with a window aggregation function. In the case of a correlated subquery, the window aggregation function is partitioned by a correlated column of a correlated table. All data in the main select clause, or outer block, of the query that was obtained through references to the correlated table is instead obtained through the new window aggregation subquery. By using window aggregation, the aggregation is performed at the same time as the selection of relevant data from the correlated table, thereby compiling all needed data in a single pass through the table or view. Reducing the number of times that tables or views are accessed reduces the computational demands of a query.
摘要翻译：系统和方法使用子查询转换查询，使用窗口聚合。关系数据库管理系统中的优化器可以转换查询以优化其效率和速度。该方法转换具有子查询的查询，使用窗口聚合函数替换子查询。在相关子查询的情况下，窗口聚合函数由相关表的相关列划分。通过引用相关表获得的查询的main select子句或外部块中的所有数据都是通过新的窗口聚合子查询得到的。通过使用窗口聚合，在从相关表中选择相关数据的同时进行聚合，从而在通过表或视图的单次传递中编译所有需要的数据。降低访问表或视图的次数减少了查询的计算需求。

5. 发明申请

US20060101044A1 Method, system and program for excuting a query having a union all operator and data modifying operations 失效
标题翻译：用于排除具有联合的所有操作符和数据修改操作的查询的方法，系统和程序
公开(公告)号：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操作符引用数据对象。数据处理系统实现的方法包括防止所有操作员的联合被应用于数据对象，并且对数据对象应用一组数据修改运算符。

6. 发明申请

US20060101011A1 Method, system and program for executing a query having a union 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.

7. 发明申请

US20060101001A1 Method, system and program for executing a query having a UNION operator 失效
标题翻译：用于执行具有UNION运算符的查询的方法，系统和程序
公开(公告)号：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.
摘要翻译：公开了一种用于执行具有联合运算符的查询的数据处理系统实现方法，数据处理系统和制品。数据处理系统实现的方法指导数据处理系统处理对数据对象的查询。数据对象可操作地耦合到数据处理系统。该查询包括父操作符。父操作员引用联合运算符。联合运算符引用子查询。子查询引用数据对象。所述数据处理系统实现的方法包括注意用于联合运算符的一组分区，所述一组分区基于子查询，并且基于由子查询引用的数据对象，并且执行具有联合的查询操作员，查询的执行是基于所述的一组分区和父操作符。

8. 发明授权

US07840531B2 System and computer program for inserting records into a database 有权
标题翻译：用于将记录插入数据库的系统和计算机程序
公开(公告)号：US07840531B2
公开(公告)日：2010-11-23
申请号：US12020462
申请日：2008-01-25
申请人： Zhimin Chen , Linqi Liu , Xiaoyan Qian , Serge Philippe Rielau
发明人： Zhimin Chen , Linqi Liu , Xiaoyan Qian , Serge Philippe Rielau
IPC分类号： G06F7/00 , G06F17/00
CPC分类号： G06F17/30377 , Y10S707/99953
摘要： For a data processing system having memory for storing a database, a method, a system and a computer program product for directing the data processing system to process a record to be inserted into the database is disclosed. The database includes a plurality of base tables. The method includes the steps of making a record copy matching the record, for each base table to be selected from the plurality of base tables: providing a base table candidate indication for a selected base table, the base table candidate indication indicating whether the selected base table is a candidate base table that may receive the record, the base table candidate indication being determined on an outcome of executing before triggers and an outcome of testing constraints in association with the record copy, the before triggers and the constraints being associated with the selected base table; and restoring the record copy so that the record copy matches the record before providing a next subsequent base table candidate indication for another base table to be selected.
摘要翻译：对于具有用于存储数据库的存储器的数据处理系统，公开了一种用于指导数据处理系统处理要插入数据库的记录的方法，系统和计算机程序产品。数据库包括多个基表。该方法包括以下步骤：对于从多个基表中选择的每个基表，制作与记录相匹配的记录拷贝：为所选择的基表提供基表候选指示，所述基表候选指示指示所选基数表是可以接收记录的候选基表，基于表的候选指示是根据在触发之前执行的结果确定的，以及与记录副本相关联的测试约束的结果，前触发和约束与所选择的相关联基地台以及恢复所述记录副本，使得所述记录副本与为所选择的另一基表提供下一个后续基表候选指示之前匹配所述记录。

9. 发明申请

US20070288492A1 METHOD, SYSTEM AND COMPUTER PROGRAM FOR INSERTING RECORDS INTO A DATABASE 有权
标题翻译：方法，将记录插入数据库的系统和计算机程序
公开(公告)号：US20070288492A1
公开(公告)日：2007-12-13
申请号：US11781841
申请日：2007-07-23
申请人： Zhimin Chen , Linqi Liu , Xiaoyan Qian , Serge Rielau
发明人： Zhimin Chen , Linqi Liu , Xiaoyan Qian , Serge Rielau
IPC分类号： G06F7/00
CPC分类号： G06F17/30377 , Y10S707/99953
摘要： For a data processing system having memory for storing a database, a method, a system and a computer program product for directing the data processing system to process a record to be inserted into the database is disclosed. The database includes a plurality of base tables. The method includes the steps of making a record copy matching the record, for each base table to be selected from the plurality of base tables: providing a base table candidate indication for a selected base table, the base table candidate indication indicating whether the selected base table is a candidate base table that may receive the record, the base table candidate indication being determined on an outcome of executing before triggers and an outcome of testing constraints in association with the record copy, the before triggers and the constraints being associated with the selected base table; and restoring the record copy so that the record copy matches the record before providing a next subsequent base table candidate indication for another base table to be selected.
摘要翻译：对于具有用于存储数据库的存储器的数据处理系统，公开了一种用于指导数据处理系统处理要插入数据库的记录的方法，系统和计算机程序产品。数据库包括多个基表。该方法包括以下步骤：对于从多个基表中选择的每个基表，制作与记录相匹配的记录拷贝：为所选择的基表提供基表候选指示，所述基表候选指示指示所选基数表是可以接收记录的候选基表，基于表的候选指示是根据在触发之前执行的结果确定的，以及与记录副本相关联的测试约束的结果，前触发和约束与所选择的相关联基地台以及恢复所述记录副本，使得所述记录副本与为所选择的另一基表提供下一个后续基表候选指示之前匹配所述记录。

10. 发明申请

US20060041566A1 Method, system and computer program for inserting records into a database 有权
标题翻译：用于将记录插入数据库的方法，系统和计算机程序
公开(公告)号：US20060041566A1
公开(公告)日：2006-02-23
申请号：US10923548
申请日：2004-08-20
申请人： Zhimin Chen , Linqi Liu , Xiaoyan Qian , Serge Rielau
发明人： Zhimin Chen , Linqi Liu , Xiaoyan Qian , Serge Rielau
IPC分类号： G06F7/00
CPC分类号： G06F17/30377 , Y10S707/99953
摘要： For a data processing system having memory for storing a database, a method, a system and a computer program product for directing the data processing system to process a record to be inserted into the database is disclosed. The database includes a plurality of base tables. The method includes the steps of making a record copy matching the record, for each base table to be selected from the plurality of base tables: providing a base table candidate indication for a selected base table, the base table candidate indication indicating whether the selected base table is a candidate base table that may receive the record, the base table candidate indication being determined on an outcome of executing before triggers and an outcome of testing constraints in association with the record copy, the before triggers and the constraints being associated with the selected base table; and restoring the record copy so that the record copy matches the record before providing a next subsequent base table candidate indication for another base table to be selected.
摘要翻译：对于具有用于存储数据库的存储器的数据处理系统，公开了一种用于指导数据处理系统处理要插入数据库的记录的方法，系统和计算机程序产品。数据库包括多个基表。该方法包括以下步骤：对于从多个基表中选择的每个基表，制作与记录相匹配的记录拷贝：为所选择的基表提供基表候选指示，所述基表候选指示指示所选基数表是可以接收记录的候选基表，基于表的候选指示是根据在触发之前执行的结果确定的，以及与记录副本相关联的测试约束的结果，前触发和约束与所选择的相关联基地台以及恢复所述记录副本，使得所述记录副本与为所选择的另一基表提供下一个后续基表候选指示之前匹配所述记录。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式