Patent ID: 8229887
Filing Date: 2012-07-24
Classification: G06F

Abstract:
1. A method of integrating large volumes of updates in a database system, the method comprising: receiving updates from data providers and an active image repository answering queries issued by end-users of the database system and storing the received updates in a master file repository of the database system; integrating the updates supplied by a data provider into a master file repository of the database system, the integrating step including the steps of: obtaining for each individual update comprised of a coherent set of data records a unique modification identifier from a logistic table of the database system; updating the master file repository with the coherent set of data records of each uniquely identified individual update; each individual update being stored in the master file (MF) repository in a form of one or more MF keys each comprising a meaningful minimum set of data which, in combination, serve to build the coherent set of data records, each individual update being thereby identified by a unique ModifID and involving a variable numbers of different records or MFkeys, further obtaining from the logistic table a unique commit identifier for each individual update that has been committed by the master file, the commit identifier containing an order in which each individual update is loaded in the active image repository; loading the updates into an active image repository of the database system, the updates being stored in the active image repository in a form of one or more AI keys, each comprising a meaningful minimum set of data for the end-users of the database system, the loading step including the steps of: retrieving from the master file repository the coherent set of data records of each uniquely identified individual update; synchronizing the active image repository by successively propagating into the active image repository, in the order specified by the commit identifier, each individual update, completing the propagation of each individual update into the active image repository when the loading of each corresponding set of data records is committed by the active image repository; thereby, allowing end-users of the database system to start querying immediately the propagated updates from the active image repository.