Method and apparatus for synchronizing foreground and background databases

Abstract

The invention discloses a synchronization method of a foreground-background database. The method comprises: the content of a task which is preset and used for completing the synchronization of a foreground-background database is obtained, and the content of the preset task is divided into a plurality of sub-tasks; the sub-tasks are grouped, wherein, each group comprises at least one sub-task; the sub-task in each group is implemented, wherein, the task of each group is implemented in parallel. Therefore, compared with the way that each sub-task is implemented in series in the prior art, the way that each sub-task belonging to different groups is implemented in parallel causes the sub-task in each group to be independent with each other, so the dependency among sub-tasks is reduced, the time needed by the implementation of the sub-task is shortened to a certain extent, and thus the efficiency for a foreground-background database synchronization flow is further improved effectively. The invention simultaneously discloses a server.

Description

technical field [0001] The invention relates to the field of computers, in particular to a method and device for synchronizing front and back databases. Background technique [0002] With the development of computer technology, users have higher and higher requirements for data storage management. Correspondingly, various data storage services have emerged as the times require. Among them, Oracle database technology is one of the widely used data storage management technologies. The heterogeneous service of Oracle database technology is a major feature of this technology. The so-called heterogeneous service means that there are two databases, one is the front-end database, which is used to collect user-related data in real time, and the other is the background database, which is used to collect Organize and save relevant user data. The data stored in the foreground database and the background database should be synchronized regularly to maintain consistency. [0003] Howe...

AI Technical Summary

Problems solved by technology

[0004] 1. In the front-end and back-end database synchronization process, there are no independently executed tasks, and all tasks are executed serially in accordance with the set order, that is, each task needs to be started after the execution of the previous task is completed. In this way, a But if an error occurs in a certain task, then the entire front-end and back-end database synchronization process will be terminated, and it needs to be manually maintained, and then restarted from the beginning. Obviously, this seriously reduces the execution efficiency of the front-end and back-end database synchronization process. Reduced user experience to some extent

[0005] 2. The execution of the entire front-end and back-end database synchronization process needs to read the sql statement developed by people. In this way, it is easy to cause errors in the front-end and back-end database synchronization process due to human errors

Images