A system (10) and method (150) for maintaining large-grained database concurrency with a log monitor (26) incorporating dynamically redefinable business logic (94) are described. Operations expressed in a data manipulation language are executed against a source database (51). At least one operation constitutes a commit operation that completes each database transaction. A current rule set (55) is defined. Each rule includes business logic (94) specifying a data selection criteria for records stored in the stored in the source database. A log entry (70) is periodically generated in a log (54) for each transaction committed to the source database (51). Each log entry (70) identifies an affected record and includes transactional data. The transaction identified in each log entry (70) is evaluated against the data selection criteria specified in the current rule set (55). A new record (57) is built in accordance with metadata (56) describing a destination database (58). The new record (57) contains select transactional data from the log entry (70) of each transaction meeting the selection criteria. The new record (57) is stored into the destination database(58). The data stored in the destination database (58) includes at least a partial subset of the source database (51).
展开▼
