公开(公告)号：CA2369621C

公开(公告)日：2009-06-09

申请号：CA2369621

申请日：2002-01-25

Applicant: IBM CANADA

Inventor： WINER MICHAEL J ,  ZHENG ROGER L Q ,  HURAS MATTHEW A ,  GOSS JEFFREY J ,  FLASZA MIROSLAW A ,  POSNER SARAH ,  MEADOWCROFT LORYSA M ,  MCARTHUR CATHERINE S

IPC: G06F9/50 ,  G06F9/46 ,  G06F12/00 ,  G06F12/14 ,  G06F13/14 ,  G06F17/30

Abstract: The present invention is directed at a method and apparatus for handling resource transaction requests. By marking a waiting transaction request, having an access mode which is incompatible with the access mode of at least one of the executing transactions, with an ignore bit, a subsequent transaction request with an access mode compatible with the access mode(s) o f the executing transaction(s) may receive access to the resource. The subsequent transactio n request is then marked with a bypass indicator such that when the executing transactions are finish ed accessing the resource, the waiting transaction request may be notified it may have access to the resource. By including the ignore bit, each subsequent transaction request which arrives after ignore b it has been set, does not suffer from starvation.

公开(公告)号：CA2302981C

公开(公告)日：2004-06-01

申请号：CA2302981

申请日：2000-03-29

Applicant: IBM CANADA

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

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.

公开(公告)号：CA2383825A1

公开(公告)日：2003-10-24

申请号：CA2383825

申请日：2002-04-24

Applicant: IBM CANADA

Inventor： NG JACK HON WAI ,  TRUUVERT KAAREL ,  GOSS JEFFREY J ,  XUE XUN ,  PEREYRA HEBERT W

IPC: G06F9/50 ,  G06F17/30

Abstract: A database management system in which a plurality of nodes form a database instance, each node including a communication manager for dynamically configuring inter-nod al communication resources. The communicaton manager receives communication resource allocati on requests from clients or a self-tuning algorithm. A resource self-tuning mechanism allocat es or de-allocates memory blocks used for communication resource elements dynamically in real time without cycling the instance. Memory blocks are de-allocated asynchronously by placing associated communication resource elements in quarantine until all communication resource elements associated with the memory block are quarantined.

公开(公告)号：CA2249080A1

公开(公告)日：2000-03-25

申请号：CA2249080

申请日：1998-09-25

Applicant: IBM CANADA

Inventor： WINER MICHAEL J ,  HOP HING NELSON ,  HURAS MATTHEW A ,  LINDSAY BRUCE G ,  ROMANUFA KERILEY K ,  GOSS JEFFREY J

IPC: G06F17/30

Abstract: A method for efficiently searching free space in a relational database management system. The method limits the search to a finite number of space map pages in the free space map. If the configured number of space map pages in the free space map are searched and a page with free space is not found for the row, the row is inserted on the last page, or if no space is available on the last page a new page is created and the row is inserted on the new page. New rows are then appended until some predefined amount of space is filled before a search is done again. As a result, insertion of a row into the database management system does not incur the worst-case cost of searching the entire free space map.

公开(公告)号：CA2422176C

公开(公告)日：2009-07-21

申请号：CA2422176

申请日：2003-03-14

Applicant: IBM CANADA

Inventor： ZHENG ROGER L Q ,  MCINNIS DALE M ,  WINER MICHAEL J ,  MCARTHUR CATHERINE S ,  HURAS MATTHEW A ,  GOSS JEFFREY J ,  ROMANUFA KERILEY K

IPC: G06F16/11

Abstract: A method and system for suspending log-based updating of a database in a manner that permits its resumption without restore, to permit efficient alternation between a log-based update mode and a database access mode. Unplayed log records are protected, as re versions of database pages at a time when the log-based update was suspended. This permits log-based updating to resume where it left off. In order to ensure consistent data for access, a roll-back procedure creates consistent data pagers that are us ed for access, and discarded when log-based update resumes.

公开(公告)号：CA2422176A1

公开(公告)日：2004-09-14

申请号：CA2422176

申请日：2003-03-14

Applicant: IBM CANADA

Inventor： HURAS MATTHEW A ,  MCINNIS DALE M ,  WINER MICHAEL J ,  MCARTHUR CATHERINE S ,  GOSS JEFFREY J ,  ZHENG ROGER L Q ,  ROMANUFA KERILEY K

IPC: G06F16/11 ,  G06F17/30 ,  G06F17/40

Abstract: A method and system for suspending log-based updating of a database in a manner that permits its resumption without restore, to permit efficient alternation between a log-based update mode and a database access mode. Unplayed log records are protected, as re versions of database pages at a time when the log-based update was suspended. This permits log-based updating to resume where it left off. In order to ensure consistent data for access, a roll-back procedure creates consistent data pagers that are used for access, and discarded when log-based update resumes.

公开(公告)号：CA2369621A1

公开(公告)日：2003-07-25

申请号：CA2369621

申请日：2002-01-25

Applicant: IBM CANADA

Inventor： POSNER SARAH ,  FLASZA MIROSLAW A ,  WINER MICHAEL J ,  ZHENG ROGER L Q ,  HURAS MATTHEW A ,  GOSS JEFFREY J ,  MEADOWCROFT LORYSA M ,  MCARTHUR CATHERINE S

IPC: G06F9/46 ,  G06F12/00 ,  G06F12/14 ,  G06F13/14 ,  G06F17/30

Abstract: The present invention is directed at a method and apparatus for handling resource transaction requests. By marking a waiting transaction request, having an access mode which is incompatible with the access mode of at least one of the executing transactions, with an ignore bit, a subsequent transaction request with an access mode compatible with the access mode(s) of the executing transaction(s) may receive access to the resource. The subsequent transaction request is then marked with a bypass indicator such that when the executing transactions are finished accessing the resource, the waiting transaction request may be notified it may have access to the resource. By including the ignore bit, each subsequent transaction request which arrives after ignore bit has been set, does not suffer from starvation.

公开(公告)号：CA2249080C

公开(公告)日：2001-12-04

申请号：CA2249080

申请日：1998-09-25

Applicant: IBM CANADA

Inventor： ROMANUFA KERILEY K ,  HURAS MATTHEW A ,  WINER MICHAEL J ,  GOSS JEFFREY J ,  HOP HING NELSON ,  LINDSAY BRUCE G

IPC: G06F17/30

Abstract: A method for efficiently searching free space in a relational database management system. The method limits the search to a finite number of space map pages in the free space map. If the configured number of space map pages in the free space map are searched and a page with free space is not found for the row, the row is inserted on the last page, or if no space is available on the last page a new page is created and the row is inserted on the new page. New rows are then appended until some predefined amount of space is filled before a search is done again. As a result, insertion of a row into the database management system does not incur the worst-case cost of searching the entire free space map.

公开(公告)号：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.