Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2002-12-17
2009-02-03
Pannala, Sathyanarayan (Department: 2164)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000
Reexamination Certificate
active
07487140
ABSTRACT:
A method for executing a query to access data stored in a database, wherein the query includes a plurality of DISTINCT keys, is disclosed. The method of the present invention includes providing a first DISTINCT operation on a first DISTINCT key, storing data fetched from the first DISTINCT operation in a master workfile if more than one sort process is needed to execute the query, and utilizing the master workfile to perform subsequent DISTINCT operations for the other 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+368 pp.
Deciding distinctness of query results by discovered constraints. Bell S. Pact 96. Proce dings 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 LLP
LandOfFree
Method 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 Method 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 Method for executing a query having multiple distinct key... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4131493