System and method for maintaining large-grained database concurrency with a log monitor incorporating dynamically redefinable business logic
US6832229B2 · kind B2 · utility
Assignee
Inventor
Key dates
| Filing date | Mar 9, 2001 |
| Grant date | Dec 14, 2004 |
| Priority date | — |
| Expiry date | Oct 1, 2022 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99953
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A system and method for maintaining large-grained database concurrency with a log monitor incorporating dynamically redefinable business logic are described. Operations expressed in a data manipulation language are executed against a source database. At least one operation constitutes a commit operation that completes each database transaction. A current rule set is defined. Each rule includes business logic specifying a data selection criteria for records stored in the source database. A log entry is periodically generated in a log for each transaction committed to the source database. Each log entry identifies an affected record and includes transactional data. The transaction identified in each log entry is evaluated against the data selection criteria specified in the current rule set. A new record is built in accordance with metadata describing a destination database. The new record contains select transactional data from the log entry of each transaction meeting the selection criteria. The new record is stored into the destination database. The data stored in the destination database includes at least a partial subset of the source database.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.