Method and apparatus for interrupting updates to a database to provide read-only access
US7107294B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Jan 7, 2004 |
| Grant date | Sep 12, 2006 |
| Priority date | — |
| Expiry date | May 6, 2025 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99953
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method and system for suspending log-based updates to a database in a manner that permits resumption of log-based updating without reinitializing the database. The method and system thereby permit efficient alternation between a log-based update mode and a database access mode. Unplayed log records are protected as revisions of database pages at the time that the log-based update was suspended. This approach permits log-based updating to resume at the same point at which log-based updating was suspended. In order to ensure consistent data for access while in database access mode, a roll-back procedure creates consistent data pages that are used for access and discarded when log-based update resumes.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.