Method and apparatus for propagating commit times between a plurality of database servers
US6243702A · kind A · utility
Assignee
Inventors
Key dates
| Filing date | Jun 22, 1998 |
| Grant date | Jun 5, 2001 |
| Priority date | — |
| Expiry date | Jun 22, 2018 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99952
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method and system for removing propagation delays between a plurality of database servers that have access to a common database is provided. According to the method, each database server is associated with a logical clock. In response to initiating a commit of a transaction executing on a database server, a commit time for the transaction is determined and broadcast to one or more other database servers. The broadcast is overlapped with a transaction log force. Upon receiving the commit time, the database servers compare the transmitted commit time to the time indicated by their logical clock. If the commit time is greater than the time indicated by their logical clock, the database server sets its logical time to reflect a time that is at least as recent as the time reflected by the transmitted commit time.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.