CANONICAL MODEL TO NORMALIZE DISPARATE PERSISTENT DATA SOURCES
0 Assignments
0 Petitions
Accused Products
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.
-
Citations
28 Claims
-
1-18. -18. (canceled)
-
19. A system for normalizing persistent data that is monitored comprising:
-
a network; at least one remote server communicably coupled to the network; a plurality of source databases, each residing on an associated remote server, wherein each source database has its own lexical and semantic conventions for handling data and is capable of generating a transaction log such that associated database source transaction data is output to a corresponding event stream; a first server communicably coupled to each remote server through the network; a semantic database transaction monitor residing on the first server, the semantic database transaction monitor comprising; a reader program that reads the database source transaction data in each event stream; at least one source ontology containing metadata from at least one of the plurality of source databases, a common canonical ontology representing a canonical model that establishes both lexical and semantic rules for normalization of source transaction data and relationships between each source ontology and the common canonical ontology; an inference engine that infers and transforms the database source transaction data from each event stream into normalized destination canonical instances in a corresponding normalized transaction stream by transforming the database source transaction data according to a corresponding source ontology and then normalizing the transformed database source transaction data according to the common canonical ontology; and a normalized database that stores the normalized destination canonical instances; and a monitor that monitors the normalized transaction stream and conveys alert notifications based upon the transaction content of the normalized transaction stream. - View Dependent Claims (20, 21, 22)
-
-
23. A system for normalizing and monitoring data from a plurality of databases comprising:
-
a semantic database transaction monitor comprising; a program that streams database transaction data from at least one of the plurality of databases into a corresponding event stream; at least one source ontology for each of the plurality of databases, each source ontology containing metadata associated with its source database; a common canonical ontology that represents a canonical model that establishes both lexical and semantic rules for normalization of source transaction data and relationships between each source ontology and the common canonical ontology; and an inference engine that infers and transforms the database source transaction data from each event stream into normalized destination canonical instances in a corresponding normalized transaction stream; a transaction log comprising a plurality of event transactions from the plurality of databases, wherein the transaction log is configured to be output to a corresponding one of the event streams; wherein the transactions from each event stream are read and asserted into the inference engine, wherein the inference engine converts the transactions by transforming the database source transaction data according to a corresponding source ontology and then by normalizing the transformed database source transaction data according to the common canonical ontology; a normalized database that stores the normalized destination canonical instances; and a monitoring application that conveys the normalized destination canonical instances; and wherein the normalized data is monitored using the monitoring application that received the conveyed normalized canonical instances. - View Dependent Claims (24, 25, 26, 27, 28)
-
Specification