Data processing: database and file management or data structures – Database and file access – Record – file – and data search and comparisons
Reexamination Certificate
2008-09-17
2011-10-18
Pannala, Sathyanarayan (Department: 2164)
Data processing: database and file management or data structures
Database and file access
Record, file, and data search and comparisons
Reexamination Certificate
active
08041726
ABSTRACT:
A system and computer readable medium for executing a query to access data stored in a database, wherein the query includes a plurality of DISTINCT keys, is disclosed. The system and computer readable medium includes a capture module for identifying each of the plurality of DISTINCT keys in the query and a sort module coupled to the capture module for determining if more than one sort is needed to execute the query, performing a first DISTINCT operation on a first DISTINCT key of the plurality of DISTINCT keys, storing data fetched from the first DISTINCT operation in a master workfile only if more than one sort process is needed to execute the query, and utilizing the master workfile to perform subsequent DISTINCT operations on the other of the plurality of DISTINCT keys.
REFERENCES:
patent: 4595995 (1986-06-01), Alles
patent: 5027388 (1991-06-01), Bradshaw et al.
patent: 5519860 (1996-05-01), Liu et al.
patent: 5548758 (1996-08-01), Pirahesh et al.
patent: 5615361 (1997-03-01), Leung et al.
patent: 5706495 (1998-01-01), Chadha et al.
patent: 5713015 (1998-01-01), Goel et al.
patent: 5806074 (1998-09-01), Souder et al.
patent: 5822748 (1998-10-01), Cohen et al.
patent: 5857180 (1999-01-01), Hallmark
patent: 5864842 (1999-01-01), Pederson et al.
patent: 6009265 (1999-12-01), Huang et al.
patent: 6112198 (2000-08-01), Lohman et al.
patent: 6289334 (2001-09-01), Reiner et al.
patent: 6341277 (2002-01-01), Coden et al.
patent: 6356888 (2002-03-01), Egan et al.
patent: 6430550 (2002-08-01), Leo et al.
patent: 6438538 (2002-08-01), Goldring
patent: 6449605 (2002-09-01), Witkowski
patent: 6529917 (2003-03-01), Zoltan
patent: 6668260 (2003-12-01), Zoltan
patent: 2002/0133507 (2002-09-01), Holenstein et al.
patent: 2002/0152422 (2002-10-01), Sharma et al.
patent: 2002/0188624 (2002-12-01), Landin
patent: 2003/0037029 (2003-02-01), Holenstein et al.
patent: 2003/0131027 (2003-07-01), Holenstein et al.
patent: 2003/0158852 (2003-08-01), Zoltan
patent: 2000172714 (1998-01-01), None
A Framework for global optimization of aggregate queries. Chengwen Liu; Ursu A Proceedings of the Sixth International Conference on Information and Knowledge Management. CIKM'97, pp. 262-269, Published: New York, NY, USA, 1997, ix+378 pp.
Deciding distinctness of query results by discovered constraints. Bell S. Pact 96. Proceedings of the Second International Conference on the Practical Application of Constraint Technology, pp. 399-416, Published: Blackpool, UK, 1996, 464 pp.
Optimization of sequences of relational queries in decision-support environments. Badia A; Niehues M. Data Warehousing and Knowledge Discovery. First International Conference, DawaK '99. Proceedings (Lecture Notes in Computer Science vol. 1676), pp. 126-131, Published Berlin Germany, 1999, xii+400 pp.
Chen Yao-Ching
Fuh You-Chin
Lebovitz Allan B.
Lee Li-Mey
Lin Fen-Ling
International Business Machines - Corporation
Pannala Sathyanarayan
Sawyer Law Group P.C.
LandOfFree
System for executing a query having multiple distinct key... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with System for executing a query having multiple distinct key..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System for executing a query having multiple distinct key... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4294714