Highly available, highly scalable multi-source logical database with low latency

摘要

A database architecture providing high availability and scalability is provided. According to embodiments of the present invention, multiple data sources are supported by multiple source databases. Partial copies of data stored in one or more of the source databases are provided to a consolidated database in response to requests for data received by the consolidated database from a data client. Multiple consolidated databases may support multiple data clients and data clients that are geographically dispersed. A sparse replication component operates to retrieve data from the source databases for storage in consolidated databases. The sparse data replication component can also monitor source databases for updates to requested data, and retrieve such data for storage in a consolidated database. In addition, each consolidated database may be associated with a data rationalization component to ensure that the data stored in the associated consolidated database does not include pathological data redundancies.