Data processing: database and file management or data structures – Database design – Data structure types
Patent
1995-09-15
1998-07-07
Black, Thomas G.
Data processing: database and file management or data structures
Database design
Data structure types
707202, 707 2, G06K 1730
Patent
active
057783888
ABSTRACT:
In a database management method and a database management system in which transactions need not be stopped at a synchronization point (syncpoint) acquired at a fixed interval of time, when a point to acquire a syncpoint is reached in a database control procedure, a syncpoint acquisition start log is output and then a syncpoint acquisition flag is set ON in a page control table of each updated page existing in a buffer pool. In the operation, a list of update page control tables is also created to write in the database the pages which are indicated in the list thus prepared. However, for a transaction accessing the pertinent updated page prior to the write operation thereof in the database, the data write operation is performed before the page is referenced, thereby enabling the access to be performed to the database without interrupting the transaction.
REFERENCES:
patent: 4507751 (1985-03-01), Gawlick et al.
patent: 4697266 (1987-09-01), Finley et al.
patent: 4853843 (1989-08-01), Ecklund
patent: 4945474 (1990-07-01), Elliott et al.
patent: 5065311 (1991-11-01), Masai et al.
patent: 5175849 (1992-12-01), Schneider
patent: 5265245 (1993-11-01), Nordstrom et al.
patent: 5317727 (1994-05-01), Tsuchida et al.
patent: 5319773 (1994-06-01), Britton et al.
patent: 5319774 (1994-06-01), Ainsworth et al.
patent: 5333303 (1994-07-01), Mohan
patent: 5333314 (1994-07-01), Masai et al.
patent: 5465328 (1995-11-01), Dievendorff et al.
Mhan et al., "Aries: A Transaction Recovery Method Supporting Fine-Granularity Locking and PartialRollbacks Using Write-Ahead Logging", ACM Transactions on Database Systems, v.17 n1, pp. 120-131, Mar. 1992.
Kawamura Nobuo
Masai Kazuo
Nagai Hiroshi
Yamashita Nobuyuki
Black Thomas G.
Hitachi , Ltd.
Hitachi Software Engineering Company, Ltd.
Rones Charles
LandOfFree
Method of processing a synchronization point in a database manag does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method of processing a synchronization point in a database manag, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method of processing a synchronization point in a database manag will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-1218155