Method and apparatus for insuring database data integrity without data recovery logging
US6651073B1 · kind B1 · utility
Assignee
Inventors
Key dates
| Filing date | May 23, 2000 |
| Grant date | Nov 18, 2003 |
| Priority date | — |
| Expiry date | May 23, 2020 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99953
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Database tables which are to be loaded with large data objects are defined with a special logging attribute that causes the associated database management system to suspend recovery logging for the databases so defined, but to continue with logging control information, such as space management changes. During a two-phase commit operation for a database transaction in a distributed system, at each database all modified data pages are written to disk before the end of the phase 1 commit, if the pages have not been previously written. This and other write operations are monitored for errors. If any of the changed data pages cannot be written to disk successfully before the end the phase 1 commit operation, then the transaction is rolled back at all databases.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.