Invention Grant
US07958105B2 System and method for filtering database results using dynamic composite queries
有权
使用动态复合查询过滤数据库结果的系统和方法
- Patent Title: System and method for filtering database results using dynamic composite queries
- Patent Title (中): 使用动态复合查询过滤数据库结果的系统和方法
-
Application No.: US12044395Application Date: 2008-03-07
-
Publication No.: US07958105B2Publication Date: 2011-06-07
- Inventor: Avraham Leff , James T. Rayfield , Timo J. Salo , Brandon J. W. Smith
- Applicant: Avraham Leff , James T. Rayfield , Timo J. Salo , Brandon J. W. Smith
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agent Ido Tuchman; William J. Stock
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
A method, system and computer program product for retrieving data records to a client computer. An identifier of a base query is received from the client computer. The base query is configured to select a set of data records from a database that the client computer has permission to access. A modifying clause is also received from the client computer. The modifying clause comprises a directive restricting the set of data records to a subset of data records. The modifying clause may optionally comprise an expression for sorting. A combined query is generated from the base query and the modifying clause. The query is configured to return the subset of data records. The combined query is further configured to sort the subset of data records based on the value of the expression if the expression is present. The combined query is executed at the database.
Public/Granted literature
- US20090228440A1 SYSTEM AND METHOD FOR FILTERING DATABASE RESULTS USING DYNAMIC COMPOSITE QUERIES Public/Granted day:2009-09-10
Information query