Method of processing a synchronization point in a database management system to assure a database version using update logs from accumulated transactions
US5778388A · kind A · utility
Assignees
Inventors
Key dates
| Filing date | Sep 15, 1995 |
| Grant date | Jul 7, 1998 |
| Priority date | — |
| Expiry date | Sep 15, 2015 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99954
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
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.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.