Canonical model to normalize disparate persistent data sources
US7941384B2 · kind B2 · utility
Assignee
Inventor
Key dates
| Filing date | Aug 21, 2008 |
| Grant date | May 10, 2011 |
| Priority date | — |
| Expiry date | Nov 5, 2029 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/254
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A semantic database transaction monitor is provided that monitors database transactions by taking advantage of database replication technology. The invention receives one or more event streams of transaction data from one or more database replication software agents, originally from transaction logs, and then classifies each transaction, utilizing an inference engine populated with one or more source ontologies and a canonical ontology so that transaction metadata are normalized. The invention then can be utilized to create a data store across multiple databases for reporting and analysis. The invention can also be used to feed normalized database transactions to real-time graphics software for real-time reporting or alerting. Because the process obtains data from event streams, it does not significantly drain the resources of the databases and can provide virtually real-time monitoring. Moreover, it does not require recoding for updates to the databases, but only changes to the ontologies read at runtime.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.