Invention Grant
- Patent Title: Method for unordered relational database retrieval returning distinct values
- Patent Title (中): 无序关系数据库检索返回不同值的方法
-
Application No.: US10188569Application Date: 2002-07-02
-
Publication No.: US07752160B2Publication Date: 2010-07-06
- Inventor: Ian R. Finlay , Tony Wen Hsun Lai , Daniel C. Zilio , Calisto Paul Zuzarte
- Applicant: Ian R. Finlay , Tony Wen Hsun Lai , Daniel C. Zilio , Calisto Paul Zuzarte
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Sawyer Law Group, P.C.
- Priority: CA2353015 20010712
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
The retrieval of distinct tuples in a relational database management system. In response to a request from a consumer process for distinct tuples in a relational database table matching a defined criteria, a distinct operator component sequentially requests tuples from a source component. The source component access the database table and returns a tuple in the sequence to the distinct operator component. The distinct operator component passes each tuple in the sequence to an auxiliary logger. The auxiliary component receives a tuples from the distinct component and determines if it is distinct from other previously received tuples in the sequence to verify its uniqueness to the distinct operator. Tuples that are verified as unique by the auxiliary logger are returned to the consumer process by the distinct operator upon verification.
Public/Granted literature
- US20030014390A1 Method and system for unordered relational database retrieval returning distinct values Public/Granted day:2003-01-16
Information query