Method and apparatus for a combined bulk and transactional database synchronous scheme

摘要

Methods and apparatus are disclosed for a combined bulk and transactional database synchronization scheme. A dynamically changing primary database is initially duplicated to a secondary database using bulk and transactional updates. Then, the secondary database is maintained in synchronization with the primary database using transactional updates. In one implementation, the primary database is divided into synchronization groups. Initially, all the groups are marked as requiring bulk synchronization. Systematically, entries from a group are combined into a bulk update message and relayed to a secondary device or component to bulk update the secondary database. When a new update to the primary database is made, if the group to which it belongs is in the process of, or still requires bulk updating, this new update will be propagated to the secondary database in due course with a subsequent bulk update. Otherwise, the new update is placed in transactional update message.