Abstract: A database system having a sequential log that is shared by multiple computer systems is described. The database system receives data records generated by multiple computer systems, and stores such data records in the sequential log. The database system periodically reorganizes the data records in the sequential log such that the data records are stored in sequential physical memory locations of the sequential log by order of their creation.
Type:
Grant
Filed:
June 5, 1995
Date of Patent:
June 30, 1998
Assignee:
International Business Machines Corp.
Inventors:
Mark Walter Harbinski, Francis Joseph Ricchio
Abstract: Described herein is a computer program product comprising a computer useable medium having computer program logic recorded thereon for enabling a processor in a computer system to manage a plurality of data structures stored in a computer storage medium. The computer storage medium includes a primary storage medium and an overflow storage medium. The computer program logic enables the processor to receive a request to store a data object in a target data structure, and enables the processor to determine whether an overflow mode condition currently exists. If it is determined that an overflow mode condition does not currently exist, then the computer program product enables the processor to determine whether a combined size of all data structures stored in the primary storage medium plus a size of the data object is greater than a predetermined threshold.
Type:
Grant
Filed:
July 28, 1995
Date of Patent:
November 25, 1997
Assignee:
International Business Machines Corp.
Inventors:
Jim W. Bahls, George S. Denny, Richard G. Hannan, Janna L. Mansker, Bruce E. Naylor, Betty J. Patterson, Sandra L. Stoob, Judy Y. Tse, Anuradha V. Vakkalagadda
Abstract: A system and method for a computer based system having one or more consuming DBMSs and one or more producing DBMSs such that the producing DBMSs produce workfiles for the consuming DBMSs. A producing DBMS uniquely identifies the bufferpool pages comprising a workfile, uniquely identifies the workfile, and flushes only the bufferpool pages corresponding to the workfile to a storage device. The producing DBMS further notifies the consuming DBMS that the workfile is available and receives a reply from the consuming DBMS indicating that the consuming device retrieved the data from the storage device. The consuming device receives notification from the producing DBMS, retrieves the workfile, and replies to the producing DBMS that it has retrieved the workfile.
Type:
Grant
Filed:
October 5, 1995
Date of Patent:
November 25, 1997
Assignee:
International Business Machines Corporation
Inventors:
Paramesh Sampatrai Desai, Bryan Frederick Smith, James Zu-chia Teng, Kou Horng Allen Yang
Abstract: A system and method of pass through in a heterogeneous distributed database environment allows a client to specify syntax that is only understood and processed by a database instance of a back-end server even if it is not understood by an interface module. A hybrid pass through feature provides a combination of both a pass through mode and a native mode allowing statements to be passed through to the database instance or to be processed by the interface module. To accomplish this, a pass through session is established. The scope of the pass through session is defined by statements that establish and terminate the session. Rules determine whether dynamic statements are handled in pass through mode or in native mode based on whether the statements are within or outside of the scope of the pass through session. Input host variable support is provided to database instances that don't otherwise support host variables.
Type:
Grant
Filed:
June 7, 1995
Date of Patent:
July 15, 1997
Assignee:
International Business Machines Corporation
Abstract: A system and method are provided for recovering a computerized database. During transaction processing of a database, at least one log range is tracked comprising update transaction log records. The log range has a begin value and an end value. The begin value corresponds to a log RBA location of a first access of the database by an updating transaction. The end value corresponds to a log RBA location at a commit or abort of a last updating transaction. The end value corresponds to a point when the database is designated as being read only (called pseudo open). During recovery of the database, the update transaction log records in the log range are applied to a version of the database stored in non-volatile memory.
Type:
Grant
Filed:
March 15, 1993
Date of Patent:
December 3, 1996
Assignee:
International Business Machines Corporation
Abstract: A system and method are provided for recovering a computerized database. During transaction processing of a database, at least one log range is tracked comprising update transaction log records. The log range has a begin value and an end value. The begin value corresponds to a log RBA location of a first access of the database by an updating transaction. The end value corresponds to a log RBA location at a commit or abort of a last updating transaction. The end value corresponds to a point when the database is designated as being read only (called pseudo open). During recovery of the database, the update transaction log records in the log range are applied to a version of the database stored in non-volatile memory.
Type:
Grant
Filed:
June 7, 1995
Date of Patent:
October 1, 1996
Assignee:
International Business Machines Corporation
Abstract: Method and system for incrementally processing a source representation of a set of objects into intermediate representation is disclosed. The invention is used after the objects have been processed once and, therefore, have a previous intermediate representation. The object of the invention is to re-process only those objects which have been changed in some way when a modification is made. Each changed facet of a changed object is selected in turn for processing. If the selected changed facet affects the object itself, then the previous intermediate representation of the object is modified. If the selected changed facet affects objects referencing or being referenced by the first object, then the references to the first object are detached and the intermediate representation of the objects referencing or being referenced by the object are modified accordingly. If the selected changed facet modifies an attribute of other objects, due to inter-relationships such as inheritance, etc.
Type:
Grant
Filed:
June 7, 1995
Date of Patent:
October 1, 1996
Assignee:
International Business Machines Corporation