OPTIMIZING LOG USAGE FOR TEMPORARY OBJECT
    1.
    发明专利

    公开(公告)号:JP2003242010A

    公开(公告)日:2003-08-29

    申请号:JP2003025616

    申请日:2003-02-03

    Applicant: IBM

    Abstract: PROBLEM TO BE SOLVED: To provide a method and apparatus for managing log records during rollback of a group of changes within a unit of work in a database system. SOLUTION: In one embodiment, the 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 has 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. COPYRIGHT: (C)2003,JPO

    METHOD AND APPARATUS FOR CHUNK BASED TRANSACTION LOGGING WITH ASYNCHRONOUS INPUT/OUTPUT FOR A DATABASE MANAGEMENT SYSTEM

    公开(公告)号:CA2350721C

    公开(公告)日:2004-04-13

    申请号:CA2350721

    申请日:2001-06-15

    Applicant: IBM CANADA

    Abstract: A method and apparatus are provided for storing transaction data for a plurality of database applications in a multiple access database management system having permanent storage and a transaction log buffer to store data for said database applications before transferring said data to said permanent storage, wherein database connection agents associated with said applications are used to store data in said transaction by buffer, including granting exclusive write access reservations in said transaction log buffer to a plurality of requesting database connection agents; and allowing said plurality of requesting database connection agents to write transaction data records to previously granted write access reservations whi le granting exclusive access reservations to other database connection agents. The method and apparatus relate to the field of transaction logging in the storage of data in database management systems.

    OPTIMIZING LOG USAGE FOR TEMPORARY OBJECTS

    公开(公告)号:CA2370601A1

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

    申请号:CA2370601

    申请日:2002-02-05

    Applicant: IBM CANADA

    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.

    METHOD AND APPARATUS FOR CHUNK BASED TRANSACTION LOGGING WITH ASYNCHRONOUS INPUT/OUTPUT FOR A DATABASE MANAGEMENT SYSTEM

    公开(公告)号:CA2350721A1

    公开(公告)日:2002-12-15

    申请号:CA2350721

    申请日:2001-06-15

    Applicant: IBM CANADA

    Abstract: A method and apparatus are provided for storing transaction data for a plurality of database applications in a multiple access database management system having permanent storage and a transaction log buffer to store data for said database applications before transferring said data to said permanent storage, wherein database connection agents associated with said applications are used to store data in said transaction log buffer, includin g granting exclusive write access reservations in said transaction log buffer to a plurality of said database connection agents; and allowing database connection agents to write transaction data records to previously granted write access reservations while granting exclusive access reservatio ns to other database connection agents.

Patent Agency Ranking