Asynchronous acid event-driven data processing using audit trail tools for transaction systems
US8332349B1 · kind B1 · utility
Assignee
Inventor
Key dates
| Filing date | Jan 6, 2012 |
| Grant date | Dec 11, 2012 |
| Priority date | — |
| Expiry date | Jan 6, 2032 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2358
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
An audit system structured for auditing at least one operational table of a transaction system during an audit event is provided. In an embodiment, the audit system includes at least one audit history table operatively associated with the operational table of the transaction system, and each audit history table includes at least one database trigger configured for monitoring one or more data changes in the operational table. The database trigger generates an XML message for a monitored data change and transmits it to an SQL server service broker queue, which activates a procedure to transmit the message to at least one subscriber service broker queue, which activates an asynchronous data processing service for the monitored data change.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.