| 摘要 |
A method of integrating large volumes of updates in a database system (200) is described. The method comprises a step of integrating the updates supplied by a data provider (220) into a master file (MF) (210) of the database system (200). The integrating step includes the steps of: receiving the updates at the master file (210); defining in the master file (210) a coherent set of data records (511 ) for each update; during the definition of the coherent set of data records (511), for each update, generating through a logistic table (360) of the database system a unique modification identifier to uniquely identify the coherent set of data records (511); receiving the modification identifier at the master file (210); at the master file (210), assigning the modification identifier to the coherent set of data records (511); committing each update by updating (515) the master file (210) with the coherent set of data records of each update and with the modification identifier assigned to the coherent set of data records (511); further obtaining from the logistic table (360) a unique commit identifier (523) for each update that has been committed by the master file (210), the commit identifier (523) being a number that reflects the order in which the committing step is completed for each update. The method also comprises a step of loading the updates into an active image (Al) (230) of the database system. The loading step includes the steps of: retrieving (533) from the master file (210) the coherent set of data record of each update; synchronizing (535) the active image (230) and the master file (210) by successively propagating into the active image (230), in the order specified by the commit identifier, each update; completing the propagation of each update into the active image (230) when the loading of each corresponding set of data records is committed (537) by the active image (230). This allows end-users of the database system to start querying immediately the propagated updates from the active image repository.
|
