Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method and apparatus for synchronizing foreground and background databases

A database, front-end and back-end technology, applied in the computer field, can solve the problems of front-end and back-end database synchronization process errors, reduce user experience, and reduce the execution efficiency of front-end and back-end database synchronization processes, so as to reduce dependencies, shorten time, and improve efficiency.

Inactive Publication Date: 2009-04-29
ALIBABA CLOUD COMPUTING LTD
View PDF0 Cites 21 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and apparatus for synchronizing foreground and background databases
  • Method and apparatus for synchronizing foreground and background databases
  • Method and apparatus for synchronizing foreground and background databases

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0022] In order to improve the execution efficiency of the synchronization process of the front and back databases, in the embodiment of the present invention, taking the Oracle database as an example, when synchronizing the data stored in the front and back databases, first obtain the preset task content for completing the synchronization of the front and back databases , and divide the preset task content into several subtasks; then group the several subtasks, and each group contains at least one subtask; then, execute the subtasks in each group; wherein, each group task is executed in parallel.

[0023] Preferred embodiments of the present invention will be described in detail below in conjunction with the accompanying drawings.

[0024] refer to Figure 1A As shown, in this embodiment, the foreground and background databases that need to be synchronized are respectively installed in the foreground database server and the background database server. , the latter case is tak...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

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...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
Inventor 王玮晨
Owner ALIBABA CLOUD COMPUTING LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com