Methods and apparatus for creating a centralized data store

摘要

A system extracts data from at least one database. The data is extracted into a data set. The system performs a transformation function on the data extracted into the data set. The transformation function is performed for the purpose of determining a preferred version of data from at least one database. The database is capable of being updated with the preferred version of data such that the database is capable of being synchronized with the centralized data store. The system loads the preferred version of data into the centralized data store.

主权项

1. A method of creating a centralized data store from a plurality of databases, the method comprising:
receiving a request for data from an application; extracting data responsive to the request for data from each database of the plurality of databases into a data set respective to each database of the plurality of databases, the plurality of databases having a plurality of respective versions of data responsive to the request for data; determining a preferred version of the data responsive to the request for data from the plurality of data sets extracted from the plurality of databases for loading into the centralized data store by performing a transformation function on the respective data sets; updating each database of the plurality of databases with the preferred version of the data responsive to the request for data from the plurality of data sets extracted from the plurality of databases according to a result of the transformation function such that the plurality of databases is configured to synchronize with the centralized data store; loading the preferred version of the data responsive to the request for data into the centralized data store; and returning the preferred version of the data from the centralized data store to the application in response to the request for data.