公开(公告)号：CA2283052A1

公开(公告)日：2001-03-23

申请号：CA2283052

申请日：1999-09-23

Applicant: IBM CANADA

Inventor： RJAIBI WALID ,  LUMBY JOHN E ,  HORNIBROOK JOHN F ,  ZUZARTE CALISTO PAUL

IPC: G06F11/34 ,  G06F11/30 ,  G06F17/60

Abstract: A system and process for evaluating the performance of an operational databa se system without interfering with the normal operation of the operational database system is described. The process involves the creation of a test database which contains the system catalogs of the operational database system as user tables. The test database is used to compile queries using these simulated system catalogs. The access plan generated by the compilation in the test database can then be used to evaluate the performance of the queries.

公开(公告)号：CA2427216A1

公开(公告)日：2004-10-30

申请号：CA2427216

申请日：2003-04-30

Applicant: IBM CANADA

Inventor： HORNIBROOK JOHN F ,  STORM ADAM J ,  ZILIO DANIELE C ,  FINLAY IAN R ,  FLASZA MIROSLAW A

IPC: G06F7/24 ,  G06F17/30 ,  G06F9/44

Abstract: The invention improves performance of a query in a database system when a pl an for the query includes sorting an input that is at least partially sorted such that a slow materialization sort can be applied. The invention applies the slow materialization sort by determini ng a sequence of subsets in accordance with the partially sorted input. As each of the subset s is determined, the subset is output for further processing. Advantageously, the invention reduc es the waiting period for obtaining results from a sorting operation under certain circumstances.

公开(公告)号：CA2283052C

公开(公告)日：2002-11-05

申请号：CA2283052

申请日：1999-09-23

Applicant: IBM CANADA

Inventor： LUMBY JOHN E ,  RJAIBI WALID ,  ZUZARTE CALISTO PAUL ,  HORNIBROOK JOHN F

IPC: G06F11/34 ,  G06F11/30 ,  G06F17/60

Abstract: A system and process for evaluating the performance of an operational databa se system without interfering with the normal operation of the operational database system is described. The process involves the creation of a test database which contains the system catalogs of the operational database system as user tables. The test database is used to compile queries using these simulated system catalogs. The access plan generated by the compilation in the test database can then be used to evaluate the performance of the queries.