Invention Grant
US08108375B2 Processing database queries by returning results of a first query to subsequent queries
失效
通过将第一个查询的结果返回到后续查询来处理数据库查询
- Patent Title: Processing database queries by returning results of a first query to subsequent queries
- Patent Title (中): 通过将第一个查询的结果返回到后续查询来处理数据库查询
-
Application No.: US12351826Application Date: 2009-01-10
-
Publication No.: US08108375B2Publication Date: 2012-01-31
- Inventor: Eric Lawrence Barsness , Richard Dean Dettinger , Mark Robert Funk , Ross E. Johnson
- Applicant: Eric Lawrence Barsness , Richard Dean Dettinger , Mark Robert Funk , Ross E. Johnson
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Martin & Associates LLC
- Agent Derek P. Martin
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
Multiple database queries are satisfied with the same data in a manner that assures the data is current and without having to interrogate the database for each query. In a first embodiment, all queries that are received during the processing of a first query after interrogation of the database has begun for the first query are evaluated to determine whether the result set returned for the first query will satisfy the queries received during processing of the first query. If so, the result set returned for the first query is used to generate result sets for the subsequent compatible queries received during the processing of the first query. In a second embodiment, queries are delayed and grouped, and a new query is then processed for each group that returns a result set that satisfies all of the queries in the group. In both cases, the result set for one query is used to generate a result set for a different query.
Public/Granted literature
- US20090138448A1 PROCESSING DATABASE QUERIES BY RETURNING RESULTS OF A FIRST QUERY TO SUBSEQUENT QUERIES Public/Granted day:2009-05-28
Information query