Patents by Inventor Linqi Liu
Linqi Liu has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).
-
Patent number: 7860845Abstract: 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.Type: GrantFiled: July 23, 2007Date of Patent: December 28, 2010Assignee: International Business Machines CorporationInventors: Zhimin Chen, Linqi Liu, Xiaoyan Qian, Serge Philippe Rielau
-
Patent number: 7840531Abstract: 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.Type: GrantFiled: January 25, 2008Date of Patent: November 23, 2010Assignee: International Business Machines CorporationInventors: Zhimin Chen, Linqi Liu, Xiaoyan Qian, Serge Philippe Rielau
-
Patent number: 7539667Abstract: 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.Type: GrantFiled: November 5, 2004Date of Patent: May 26, 2009Assignee: International Business Machines CorporationInventors: Bruce Gilbert Lindsay, Linqi Liu, Robert Paul Neugebauer, Mir Hamid Pirahesh, David C. Sharpe, Nattavut Sutyanyong, Calisto Paul Zuzarte
-
Patent number: 7533087Abstract: 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.Type: GrantFiled: November 5, 2004Date of Patent: May 12, 2009Assignee: International Business Machines CorporationInventors: Linqi Liu, Robert Paul Neugebauer, David C. Sharpe, Nattavut Sutyanyong, Calisto Paul Zuzarte
-
Patent number: 7409385Abstract: 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.Type: GrantFiled: November 5, 2004Date of Patent: August 5, 2008Assignee: International Business Machines CorporationInventors: Bruce Gilbert Lindsay, Linqi Liu, Robert Paul Neugebauer, Mir Hamid Pirahesh, David C. Sharpe, Nattavut Sutyanyong, Calisto Paul Zuzarte
-
Publication number: 20080140689Abstract: 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.Type: ApplicationFiled: January 25, 2008Publication date: June 12, 2008Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Zhimin Chen, Linqi Liu, Xiaoyan Qian, Serge Philippe Rielau
-
Patent number: 7349910Abstract: 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.Type: GrantFiled: August 20, 2004Date of Patent: March 25, 2008Assignee: International Business Machines CorporationInventors: Zhimin Chen, Linqi Liu, Xiaoyan Qian, Serge Philippe Rielau
-
Publication number: 20070288492Abstract: 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.Type: ApplicationFiled: July 23, 2007Publication date: December 13, 2007Applicant: INTERNATIONAL BUSINESS MACHINESInventors: Zhimin Chen, Linqi Liu, Xiaoyan Qian, Serge Rielau
-
Patent number: 7275056Abstract: 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.Type: GrantFiled: April 29, 2003Date of Patent: September 25, 2007Assignee: International Business Machines CorporationInventors: Qi Cheng, Linqi Liu, Wenbin Ma, Mir Hamid Pirahesh, Calisto P. Zuzarte
-
Publication number: 20060101011Abstract: 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.Type: ApplicationFiled: November 5, 2004Publication date: May 11, 2006Applicant: International Business Machines CorporationInventors: Bruce Lindsay, Linqi Liu, Robert Neugebauer, Mir Pirahesh, David Sharpe, Nattavut Sutyanyong, Calisto Zuzarte
-
Publication number: 20060101044Abstract: 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.Type: ApplicationFiled: November 5, 2004Publication date: May 11, 2006Inventors: Linqi Liu, Robert Neugebauer, David Sharpe, Nattavut Sutyanyong, Calisto Zuzarte
-
Publication number: 20060101001Abstract: 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.Type: ApplicationFiled: November 5, 2004Publication date: May 11, 2006Applicant: International Business Machines CorporationInventors: Bruce Lindsay, Linqi Liu, Robert Neugebauer, Mir Pirahesh, David Sharpe, Nattavut Sutyanyong, Calisto Zuzarte
-
Publication number: 20060041566Abstract: 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.Type: ApplicationFiled: August 20, 2004Publication date: February 23, 2006Applicant: International Business Machines CorporationInventors: Zhimin Chen, Linqi Liu, Xiaoyan Qian, Serge Rielau
-
Publication number: 20040153448Abstract: 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.Type: ApplicationFiled: April 29, 2003Publication date: August 5, 2004Applicant: International Business Machines CorporationInventors: Qi Cheng, Linqi Liu, Wenbin Ma, Mir Hamid Pirahesh, Calisto P. Zuzarte