公开(公告)号：CA2306946A1

公开(公告)日：2001-10-28

申请号：CA2306946

申请日：2000-04-28

Applicant: IBM CANADA

Inventor： ZILIO DANIEL C ,  FINLAY IAN R ,  LOHMAN GUY M ,  SHARPE DAVID C ,  LINDSAY BRUCE G

IPC: G06F17/30

Abstract: A query processing system having a data manager, and a query manager also includes a buffer. The query manager calls the data manager to access data based on a query. Where there is no predicate check or consumption operation on the record accessed, the data manager will notionally return the record to the query manager. However, the data manager accomplishes the retu rn by writing the relevant portions of the record to a buffer. The data manager maintains stabilization of the page containing the record while the buffer is being written to. The data manager continues to access records on the stabilized page and to write such records to the buffer where appropriate. The query manager retrieves the records from the buffer after the data manager has completed its operation resulting from the query manager call.

公开(公告)号：CA2302981A1

公开(公告)日：2001-09-29

申请号：CA2302981

申请日：2000-03-29

Applicant: IBM CANADA

Inventor： HOP HING NELSON ,  HURAS MATTHEW A ,  GOSS JEFFREY J ,  LINDSAY BRUCE G

IPC: G06F17/30 ,  G06F7/24

Abstract: A database table reorganization is defined to permit online access of the table during the reorganization. Records are reorganized in the database table by vacating records from a defined number of pages and then filling the pages with records in accordance with a desired ordering for the records. Temporary pointers to the new locations of moved records are us ed to prevent table scanner access to the database table from missing or duplicating records whi le scanning the database table during reorganization. Removal of the temporary pointers is synchroniz ed with the completion of scanning of all table scanners that are commenced during a time when records are being moved as part of a vacating or filling step.