Database Fusion Using Atom

This paper describes a database fusion infrastructure that produces a local database consisting of aggregated information that is selected from multiple remote databases and is transformed into a common table format and data representation in the local database. The database fusion infrastructure provides reliable data distribution (RDD), consistent data replication (CDR), and database aggregation (DBA) and is based on the atom syndication technology. RDD ensures that the publisher knows that a consumer has received the data intended for it and, thus, that the publisher can garbage collect the data. CDR uses RDD to provide data replication from a source database to a target database for the purposes of security, high availability and fast local access. DBA uses CDR to aggregate information from remote database sources, possibly deployed on different computing platforms in different enterprises, using different databases from different vendors, different database schemas and different communication protocols.