公开(公告)号：CA2370601A1

公开(公告)日：2003-08-05

申请号：CA2370601

申请日：2002-02-05

Applicant: IBM CANADA

Inventor： LEE JESSE ,  ZHENG ROGER LUO QUAN ,  WINER MICHAEL J

IPC: G06F12/00 ,  G06F17/30 ,  G06F17/40

Abstract: A method and apparatus for managing log records during rollback of a group o f changes within a unit of work in a database system. In one embodiment, a method includes determining for each change being rolled back if the change was performed on a temporary database object or a permanent database object; for each change that was performed on a permanent database object, creating an associated compensation log record indicating that the change ha s been rolled back; and for each change that was performed on a temporary database object, assessing if a compensation record is desired based on predetermined criteria, and selectively creating, based on the assessment, an associated compensation log record indicating that the change to the temporary object has been rolled back.

公开(公告)号：CA2310578A1

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

申请号：CA2310578

申请日：2000-06-02

Applicant: IBM CANADA

Inventor： LEE JESSE ,  SEE YEUNG-KUEN ,  SNOWBELL MICHAEL J ,  PEREYRA HEBERT W ,  WONG CATHARINA K ,  BIRD PAUL M ,  CHAN YUK KUEN

IPC: G06F17/30

Abstract: The invention herein provides a mufti-node relational database management system that can be embodied in software for managing a database having declared temporar y tables associated with respective software application programs, comprising: a plurality of nodes, including: a catalog node for maintaining a list of identification for declared temporary tables associated with any application; a coordinator node for an application; at least one subordinate node for the application, the subordinate node having at least one partition of the declared temporary tables of the application; and a declared temporary table manager for causing the coordinator node to maintain for the application a list of declared temporar y tables.