CN1652116A - Database synchronous system and method - Google Patents
Database synchronous system and method Download PDFInfo
- Publication number
- CN1652116A CN1652116A CN 200510059390 CN200510059390A CN1652116A CN 1652116 A CN1652116 A CN 1652116A CN 200510059390 CN200510059390 CN 200510059390 CN 200510059390 A CN200510059390 A CN 200510059390A CN 1652116 A CN1652116 A CN 1652116A
- Authority
- CN
- China
- Prior art keywords
- database
- data
- subsystem
- refresh routine
- inquiry
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Multi Processors (AREA)
Abstract
The present invention relates to a data base synchronous system and its method. It includes a first subsystem and several subsystems, in which first subsystem contains a first data base, second subsystem respectively contains a second data base, a data extraction module and a data mergence module, in which the data extraction module executes a requirement update program so as to obtain the data in first data base from first subsystem, and the data mergence module can utilize a merge mode to make the data being in second data base and data being in first data base be synchronized. The merge mode includes insert, delete and update.
Description
Technical field
The present invention is about a kind of database synchronous system and method, particularly about a kind of synchro system and method for database of synchronous multiserver.
Background technology
Large enterprise is because human organization is huge, the research and development technology and the kind that manufactures a product are numerous and diverse, for various information such as the information such as occurrences in human life, production equipment, research and development flow process and finance in the effective management enterprise, enterprises is provided with database in the hope of can be momentarily and positively control above-mentioned important information.Yet the strong point of large enterprise is often crossed among the restriction on ocean and land is distributed in all over the world, information such as occurrences in human life, production equipment, research and development flow process and finance to each other also difference to some extent in these trans-regional strong points in the large enterprise, and the employed database in different strong points also may be different, the otherness of these data and database makes enterprises real-time integration information smoothly, enterprises employee must spend thought to obtain the information of each strong point data of integration.
Shown in Figure 1A, one user is left a data in three servers: first server 11, among second server 12 and the 3rd server 13, when the data of user among a client 14 is upgraded first server 11, second server 12 and the 3rd server 13 certainly will to be logined if will among second server 12 and the 3rd server 13, upgrade living data, and among second server 12 and the 3rd server 13, find out the data that to upgrade and upgraded, the method of this artificial regeneration is not only numerous and diverse for the user, if and the user is in a certain database input error data, or omit and do not upgrade a certain server, can cause like this should be that the same document of identical content but has different contents at different servers.Therefore, the data that only depends on manual type to upgrade in the multiserver is convenient inadequately also reliable inadequately, if can then can improve afore-mentioned with automatic update mechanism.
Shown in Figure 1B, the user is left a data among first server 11, second server 12 and the 3rd server 13, first server 11, second server 12 and the 3rd server 13 form a loop network, therein during the content update of a database, data for updating is upgraded data-base content on the cyclic path in regular turn according to clockwise or counterclockwise mode.When the user when a client 14 is upgraded data in first server 11, first server 11 is sent to second server 12 with data for updating, after second server 12 upgrades data for updating is sent to the 3rd server 13, data for updating is sent to first server 11 after the 3rd server update, last first server 11 just can know that whole data updating finishes again.
Though the ring-type server can data for updating, the user may not continue normally to use server in the process of upgrading.Under the situation of multiserver, transmit data for updating in regular turn according to cyclic path and need expend many times, make that the time of whole updating is longer, this situation when server be obvious especially interconnected the time with world-wide web, so the real-time and the correctness of data also is affected in each server.In addition, when server is to be connected to each other and data transmission time time with world-wide web, the situation that error of transmission or transmission the stop data that makes needs transmission again, and the reason of finding out transmission problem is also because network range is extensive, make that wrong scene may be dispersed in various places among the loop network, can't dwindle problem points in the active set, get rid of at need must various places the information manager work in coordination and coordinate to locate errors, the data of finding out problematic machine and locating errors, so error of transmission is difficult to effectively get rid of within the short time, the time of whole data updating also is affected.Moreover, can't effectively monitor the transmission of each server update data of keyholed back plate among the ring-type server, and then make each main frame transmission problem to each other be difficult to grasp clear that and the maintenance of system also relatively is not easy.
In view of this, a kind of database synchronous system and method are provided, in the hope of can be under the situation that does not influence the user data in the database of multiserver synchronously automatically, and monitor data updating flow process in the database of keyholed back plate multiserver, one of current just important topic.
Summary of the invention
Because above-mentioned problem, the invention provides the data in a kind of database that can upgrade multiserver automatically, and monitor the database synchronous system and the method for the data updating flow process in the database of keyholed back plate multiserver.
So, according to database synchronous system of the present invention, it comprises one first subsystem and a plurality of second subsystem, wherein first subsystem comprises one first database, second subsystem comprises one second database respectively, one data is chosen a module and a data Fusion Module, wherein data is chosen module execution one and is required refresh routine, so that the data in first subsystem is obtained first database, the data Fusion Module utilizes fusion (merge) mode to make that data and the data in first database in second database are synchronous, and wherein amalgamation mode comprises insertion (insert), deletion (delete) and renewal (update).
In addition, the invention provides a kind of database synchronization method, it cooperates with one first subsystem and a plurality of second subsystem, first subsystem comprises one first database and second subsystem comprises one second database respectively, comprise and carry out one respectively by second subsystem and require refresh routine, so that the data in first subsystem is obtained first database, and utilize an amalgamation mode to make that data and the data in first database in each second database are synchronous, wherein amalgamation mode comprises insertion, deletion and upgrades.
From the above, because of complying with database synchronous system of the present invention and method is to handle with amalgamation mode with the data of second database in first database, so can under the situation that does not influence the user, upgrade the data of a plurality of databases automatically, and can improve the real-time and the correctness of the data in each database; In addition, database synchronous system of the present invention and method can monitor the data updating flow process of keyholed back plate multiserver effectively, and then strengthen the grasp degree of each main frame transmission problem to each other, and make that the maintenance of system is simpler.
Description of drawings
Figure 1A is a synoptic diagram, shows known artificial regeneration data;
Figure 1B is a synoptic diagram, shows known with ring-type server update data;
Fig. 2 is a synoptic diagram, shows the database synchronous system according to preferred embodiment of the present invention;
Fig. 3 is a synoptic diagram, shows the database synchronous system according to preferred embodiment of the present invention, and wherein database synchronous system more comprises the inquiry update module;
Fig. 4 is a synoptic diagram, shows the database synchronous system according to preferred embodiment of the present invention, wherein monitors the window of user's interface display in monitor;
Fig. 5 is a process flow diagram, shows the database synchronization method according to preferred embodiment of the present invention; And
Fig. 6 is a process flow diagram, shows the database synchronization method according to preferred embodiment of the present invention, and wherein whether newly database synchronization method judges the interior data of second database data in first database.
The element numbers explanation:
11: the first servers
12: second server
13: the three servers
14: client
2: the first subsystems
21: the first databases
211: the first data
22: the inquiry update module
221: the inquiry refresh routine
23: the first renewal logging modles
24: log file is upgraded in inquiry
25: monitoring user interface
3: the second subsystems
31: the second databases
311: the second data
312: the three data
313: the four data
32: data is chosen module
321: require refresh routine
33: the data Fusion Module
34: the second renewal logging modles
35: require to upgrade log file
4: monitor
S01-S02: database synchronization method
S11-S15: database synchronization method
Embodiment
Hereinafter with reference to correlative type, database synchronous system and method according to preferred embodiment of the present invention are described.
Please refer to shown in Figure 2, database synchronous system according to preferred embodiment of the present invention, it comprises one first subsystem 2 and a plurality of second subsystem 3, wherein first subsystem 2 comprises that one first database, 21, the second subsystems 3 comprise one second database 31 respectively, a data is chosen a module 32 and a data Fusion Module 33.
Data is chosen module 32 execution one and is required refresh routine 321, so that the data in first subsystem 2 is obtained first database 21, second subsystem 3 more can regularly be carried out and require refresh routine 321.
Data Fusion Module 33 utilizes fusion (merge) mode to make that data and the data in first database 21 in second database 31 are synchronous, and wherein amalgamation mode comprises insertion (insert), deletion (delete) and renewal (update).When first data 211 that there is no in second database 31 in first database, insert one second data 311 at second database 31 according to first data 211, when 31 storages of second database do not see one the 3rd data 312 of first database 21, in second database, 31 deletions the 3rd data 312, when second database 31 stores pairing the 4th data 313 of first data 211, upgrade the 4th data 313 according to first data 211.
In the present embodiment, first subsystem 2 and second subsystem 3 can be online by world-wide web, and second database 31 can be heterogeneous database, and when second subsystem 3 and first subsystem 2 can't be online mutually as if because of the network on-line problem, when second subsystem 3 and first subsystem 2 recover online after, in addition integration synchronously of the difference data that can second database 31 and first database 21 be produced when can't be mutual online according to said method.
Please refer to shown in Figure 3ly, first subsystem 2 of present embodiment more can comprise an inquiry update module 22 and one first to be upgraded logging modle 23, the second subsystems 3 and more can comprise one second and upgrade logging modle 34.
Second upgrades logging modle 34 sets up a requirement renewal log file 35 according to the described refresh routine that requires.First upgrades logging modle 23 sets up an inquiry renewal log file 24 according to the inquiry refresh routine, and according to requiring refresh routine 321 and inquiry refresh routine 221 to set up a monitoring user interface 25, monitoring user interface 25 can be reacted the system state of present embodiment at any time.In addition, first upgrades logging modle 23 more can be only according to requiring refresh routine 321 to set up monitoring user interface 25, and also only foundation inquiry refresh routine 221 is set up monitoring user interface 25.
Please refer to shown in Figure 4, the window that monitoring user interface 25 may be displayed in the monitor 4, monitoring user interface 25 more can comprise requirement and upgrade log file 35 and inquire the content of upgrading log file 24, therefore system personnel can according to require to upgrade log file 35, log file 24 is upgraded in inquiry and the system status of present embodiment is learnt at monitoring user interface 25, and finds out related causes can make a mistake in system the time.
Please refer to shown in Figure 5, database synchronization method according to preferred embodiment of the present invention, it cooperates with one first subsystem and a plurality of second subsystem, and first subsystem comprises one first database and second subsystem comprises one second database respectively, comprises step S01 to step S02.
Among step S01, carry out one respectively by second subsystem and require refresh routine, so that the data in first subsystem is obtained first database.
Among step S02, utilize an amalgamation mode to make that data and the data in first database in each second database are synchronous, wherein amalgamation mode comprises insertion, deletion and upgrades.
Database synchronization method in the present embodiment was discussed in the embodiment of Fig. 2, so repeat no more.
Please refer to shown in Figure 6ly, the database synchronization method of present embodiment more can comprise step S11 to step S15.
Among step S11, carry out an inquiry refresh routine by first subsystem, judge the whether newly data in first database of the interior data of second database.
Among step S12,, transmit data to the second database in second database via first subsystem when the new data in first database of the data in second database.
Among step S13, require to upgrade log file according to requiring refresh routine to set up one by second subsystem.
Among step S14, set up an inquiry by first subsystem according to the inquiry refresh routine and upgrade log file.
Among step S15, monitor the user interface according to requiring refresh routine to set up one with the inquiry refresh routine by first subsystem.
Database synchronization method in the present embodiment was discussed in the embodiment of Fig. 3 and Fig. 4, so repeat no more.
In sum, because of according to database synchronous system of the present invention and method being handles the data in second database of first database of first subsystem and second subsystem with amalgamation mode, so can under the situation that does not influence the user, upgrade the data of a plurality of databases automatically, and can improve the real-time and the correctness of the data in each database; In addition, database synchronous system of the present invention and method can monitor the data updating flow process of keyholed back plate multiserver effectively, and then strengthen the grasp degree of each main frame transmission problem to each other, and make that the maintenance of system is simpler.
The above only is an illustrative, but not is restrictive.Anyly do not break away from spirit of the present invention and category, and it is carried out equivalent modifications or change, all should be contained in the appended claim.
Claims (10)
1, a kind of database synchronization method, it cooperates with one first subsystem and a plurality of second subsystem, and described first subsystem comprises one first database and described second subsystem comprises one second database respectively, and described database synchronization method comprises:
Carry out one respectively by described second subsystem and require refresh routine, so that the data in described first subsystem is obtained described first database; And
Utilize an amalgamation mode to make that data and the data in described first database in each described second database are synchronous, wherein said amalgamation mode comprises insertion, deletion and upgrades.
2, as 1 described database synchronization method of claim the, more comprise:
Regularly carrying out one requires refresh routine respectively by described second subsystem, so that the data in described first subsystem is obtained described first database.
3, as 1 described database synchronization method of claim the, more comprise:
Carry out an inquiry refresh routine by described first subsystem, judge the whether newly data in described first database of the interior data of each described second database;
When the data in each described second database newly during the data in described first database, transmit data in each described second database to each described second database via described first subsystem;
Regularly carry out an inquiry refresh routine by described first subsystem, judge the whether newly data in described first database of the interior data of each described second database;
Set up an inquiry by described first subsystem according to described inquiry refresh routine and upgrade log file; And
Set up a monitoring user interface by described first subsystem according to described inquiry refresh routine.
4, as 1 described database synchronization method of claim the, more comprise:
Set up a monitoring user interface by described first subsystem according to the described refresh routine that requires.
Set up a requirement renewal log file by described second subsystem according to the described refresh routine that requires.
5, as 1 described database synchronization method of claim the, wherein said first subsystem and each described second subsystem are online with world-wide web, and each described second database is a heterogeneous database.
6, a kind of database synchronous system comprises:
One first subsystem, it comprises one first database; And
A plurality of second subsystems, it comprises one second database respectively, a data is chosen a module and a data Fusion Module, wherein said data is chosen module execution one and is required refresh routine, so that the data in described first subsystem is obtained described first database, the data Fusion Module utilizes an amalgamation mode to make that data and the data in described first database in described second database are synchronous, and wherein said amalgamation mode comprises insertion, deletion and upgrades.
7, as 6 described database synchronous systems of claim the, regularly carry out one requires refresh routine to wherein said second subsystem respectively, so that the data in described first subsystem is obtained described first database.
8, as 6 described database synchronous systems of claim the, wherein said first subsystem more comprises:
One inquiry update module, it carries out an inquiry refresh routine, judge the whether newly data in described first database of the interior data of each described second database, when the data in each described second database newly during the data in described first database, transmit data in each described second database to each described second database via described first subsystem, whether newly wherein said first subsystem is regularly carried out described inquiry refresh routine, judge the interior data of each the described second database data in described first database; And
One first upgrades logging modle, and it is set up an inquiry according to described inquiry refresh routine and upgrades log file, sets up a monitoring user interface, sets up a monitoring user interface according to the described refresh routine that requires according to described inquiry refresh routine.
9, as 6 described database synchronous systems of claim the, wherein said second subsystem more comprises:
One second upgrades logging modle, and it sets up a requirement renewal log file according to the described refresh routine that requires.
10, as 6 described database synchronous systems of claim the, wherein said first subsystem and each described second subsystem are online with world-wide web, and each described second database is a heterogeneous database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB2005100593900A CN100445995C (en) | 2005-03-29 | 2005-03-29 | Database synchronous system and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB2005100593900A CN100445995C (en) | 2005-03-29 | 2005-03-29 | Database synchronous system and method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN1652116A true CN1652116A (en) | 2005-08-10 |
| CN100445995C CN100445995C (en) | 2008-12-24 |
Family
ID=34876823
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNB2005100593900A Active CN100445995C (en) | 2005-03-29 | 2005-03-29 | Database synchronous system and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN100445995C (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2009111965A1 (en) * | 2008-03-12 | 2009-09-17 | 华为技术有限公司 | Method, device and system of data synchronization |
| WO2010145277A1 (en) * | 2009-10-23 | 2010-12-23 | 中兴通讯股份有限公司 | Method, device and system for implementing data synchronization between source database and target database |
| CN104376055A (en) * | 2014-11-04 | 2015-02-25 | 国电南瑞科技股份有限公司 | Large-scale data comparison method based on fragmentation technology |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5933837A (en) * | 1997-05-09 | 1999-08-03 | At & T Corp. | Apparatus and method for maintaining integrated data consistency across multiple databases |
| SE515459C2 (en) * | 1999-02-10 | 2001-08-06 | Ericsson Telefon Ab L M | Method for synchronizing a host database and a remote database |
| CN1261877C (en) * | 2002-10-11 | 2006-06-28 | 鸿富锦精密工业（深圳）有限公司 | Multi-node file syn chronizing system and method |
-
2005
- 2005-03-29 CN CNB2005100593900A patent/CN100445995C/en active Active
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2009111965A1 (en) * | 2008-03-12 | 2009-09-17 | 华为技术有限公司 | Method, device and system of data synchronization |
| WO2010145277A1 (en) * | 2009-10-23 | 2010-12-23 | 中兴通讯股份有限公司 | Method, device and system for implementing data synchronization between source database and target database |
| US8655836B2 (en) | 2009-10-23 | 2014-02-18 | Zte Corporation | Method, device and system for implementing data synchronization between source database and target database |
| CN104376055A (en) * | 2014-11-04 | 2015-02-25 | 国电南瑞科技股份有限公司 | Large-scale data comparison method based on fragmentation technology |
| CN104376055B (en) * | 2014-11-04 | 2017-08-29 | 国电南瑞科技股份有限公司 | A kind of large-sized model data comparing method based on allocation methods |
Also Published As
| Publication number | Publication date |
|---|---|
| CN100445995C (en) | 2008-12-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11308092B2 (en) | Stream processing diagnostics | |
| US10747714B2 (en) | Scalable distributed data store | |
| US9910738B2 (en) | Data mining systems and methods for heterogeneous data sources | |
| US7200666B1 (en) | Live connection enhancement for data source interface | |
| US9727625B2 (en) | Parallel transaction messages for database replication | |
| CN1967503A (en) | Method for testing a software application | |
| US7673031B1 (en) | Resource mapping in a network environment | |
| US20220083529A1 (en) | Tracking database partition change log dependencies | |
| CN1573697A (en) | Apparatus and method for maintaining resource integrity in a software environment | |
| CN101063973A (en) | Method and system for the aggregation of data in multiple processing environments | |
| DE112019000143T5 (en) | VERSIONING VALIDATION FOR DATA TRANSFER BETWEEN HETEROGENIC DATA MEMORIES | |
| WO2021112909A1 (en) | Managing replication state for deleted objects | |
| CN111368165A (en) | Spatio-temporal streaming data integration platform | |
| US20180107722A1 (en) | Managing queries in business intelligence platforms | |
| CN1652116A (en) | Database synchronous system and method | |
| CN117643015A (en) | Snapshot-based client-side key modification of log records manages keys across a series of nodes | |
| CN114787780A (en) | System and method for blockchain based backup and restore | |
| US11868334B2 (en) | Integrating change tracking of storage objects of a distributed object storage database into a distributed storage system | |
| US10606823B2 (en) | Method and systems for monitoring changes for a server system | |
| US11838171B2 (en) | Proactive network application problem log analyzer | |
| CN113535519B (en) | Monitoring alarm method | |
| EP3255548A1 (en) | Method and systems for monitoring changes for a server system | |
| CN101046757A (en) | Backpu method | |
| US11836125B1 (en) | Scalable database dependency monitoring and visualization system | |
| CN1710571A (en) | Computer system for quality management system and method for operating said system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |