METHOD FOR EXECUTING A QUERY HAVING MULTIPLE DISTINCT KEY COLUMNS

Patent №

US 7,487,140

Granted

2009-02-03

Filed 2002

Owner

IBM CORPORATION

AI components

4

nlp · kr · planning · hardware

Assignment

Recorded

Dataset

AIPD

2023_r1 edition

Application

10320909

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.

AI classification

Natural language0.97
Knowledge representation0.97
Planning0.80
AI hardware0.75
Speech0.02
Machine learning0.01
Evolutionary computation0.00
Vision0.00

Ownership

IBM CORPORATION

assignment · 135980319

Assignors

CHEN, YAO-CHING, FUH, YOU-CHIN, LEBOVITZ, ALLAN B., LEE, LI-MEY, LIN, FEN-LING, LIU, LEE-CHIN HSU, WANG, YUN, ZHEN, BINGHUA

On an employer assignment, the assignors are typically the inventors.

© 2026 NYSGPT2525 LLC