发明名称 |
Method and system for executing a query having multiple distinct key columns |
摘要 |
A method and system for executing a query to access data stored in a database, wherein the query includes a plurality of DISTINCT keys, is disclosed. The method and system 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.
|
申请公布号 |
US2004117356(A1) |
申请公布日期 |
2004.06.17 |
申请号 |
US20020320909 |
申请日期 |
2002.12.17 |
申请人 |
CHEN YAO-CHING;FUH YOU-CHIN;LEBOVITZ ALLAN B.;LEE LI-MEY;LIN FEN-LING;LIU LEE-CHIN HSU;WANG YUN;ZHEN BINGHUA |
发明人 |
CHEN YAO-CHING;FUH YOU-CHIN;LEBOVITZ ALLAN B.;LEE LI-MEY;LIN FEN-LING;LIU LEE-CHIN HSU;WANG YUN;ZHEN BINGHUA |
分类号 |
G06F17/30;(IPC1-7):G06F17/30 |
主分类号 |
G06F17/30 |
代理机构 |
|
代理人 |
|
主权项 |
|
地址 |
|