CN102567338A - Data synchronization system capable of simulating system logs - Google Patents
Data synchronization system capable of simulating system logs Download PDFInfo
- Publication number
- CN102567338A CN102567338A CN2010105909811A CN201010590981A CN102567338A CN 102567338 A CN102567338 A CN 102567338A CN 2010105909811 A CN2010105909811 A CN 2010105909811A CN 201010590981 A CN201010590981 A CN 201010590981A CN 102567338 A CN102567338 A CN 102567338A
- Authority
- CN
- China
- Prior art keywords
- data
- daily record
- data form
- electronic device
- journal
- 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.)
- Pending
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a data synchronization system capable of simulating system logs. The system comprises a first electronic device and a second electronic device. When the record content of a first data table is updated and changed, a first processing unit executes a system log simulation program so as to simulate one system log. When the first electronic device is n a communication connection with the second electronic device, the first processing unit executes a system log restoring program to restore one system log, and the second electronic device synchronizes a second data table stored in the second electronic device with the first data table according to the record of the system log.
Description
Technical field
The present invention relates to a kind of data synchronous system, be meant the data synchronous system of a kind of simulation system daily record especially with sync database.
Background technology
Database (database), in simple terms, the place that it compiles for the data with unchangeability data (persistent data).Owing to use database to store and deal with data, have that the data of avoiding are inconsistent, data can be shared, the unusual fluctuation management is provided, can set up data standard, guarantee the data security standard.
Because database has above-mentioned advantage, therefore, most enterprise or government organize huge because of it; Professional increasingly sophisticated; In order effectively to manage and carry out each business, usually can be the occurrences in human life data, various information such as form data, revenue and expenditure control, stock's information, books, accounting system, record of a case content are stored in the database; By data base management system (DBMS), come the classification and the access of control data again.
And, can maintain last state at any time for making each database when data storing during in each distributed database, usually can be through carrying out the program of database synchronization, to accomplish phase mutually synchronization (synchronize) between the database.
In prior art; If desire to make phase mutually synchronization between each database, need obtain the system journal of former database usually, with the data of learning that primal system is deposited; The data movement time; Data movement content ... wait the correlation parameter information is again through execution (Redo) program of reforming, with the data phase mutually synchronization between each database.Yet because system journal needs system manufacturer to provide and not open, therefore, if two databases are by different vendor's exploitation construction, if can't obtain system journal, the system maintenance personnel just can't make its synchronised, and make the application of database be restricted greatly.
Summary of the invention
Fundamental purpose of the present invention, aim to provide a kind of can be through the simulation system daily record reaching data synchronization system, but and make phase mutually synchronization between each database, to expand its application.
For reaching above-mentioned purpose, the data synchronous system of simulation system daily record of the present invention, it comprises one first electronic installation and a second electronic device.This first electronic installation has one first processing unit and one second processing unit.This first cell stores, one first data form and a data sync formula.This data sync formula comprises a system journal simulator program and a system journal reducing program.This second electronic device has one second processing unit and one second storage unit.This second cell stores, one second data form.Wherein, after the recorded content of this first data form upgraded change, this first processing unit was by carrying out this system journal simulator program; To simulate a system journal; When this first electronic installation communication connected this second electronic device, then this first processing unit was carried out this system journal reducing program, to restore this system journal; Make the record of this second electronic device, with this second data form and this first data form synchronised according to this system journal.
Wherein, this system journal simulator program comprises the following step:
(trigger) mode is carried out insertion (insert) instruction, a renewal (update) is instructed or a deletion (delete) is instructed, and produces or change one first shadow data form by this first data form to trigger; And carry out one with triggering mode and insert (insert) instruction, produce or change one first shared sequence data form by this first shadow data form.
Wherein, this first shadow data form comprises before the data change field behind the field and a data change.
Wherein, this first shared sequence data form comprises a shared sequence number field, a shadow form denominational position and a data movement time field.
Wherein, this system journal reducing program comprises the following step: carry out one and select (select), with from this first shared sequence data form, select many corresponding shared sequence number fields and many shadow form denominational positions; And carry out a selection instruction, with from these shared sequence number fields and these shadow form denominational positions, select field and this data movement time field behind field before corresponding this data change, this data change.
Wherein, after this second processing unit receives this system journal, carry out (redo) program of reforming, make this second data form and this first data form synchronised.
Wherein, this first electronic installation is that a portable electronic devices, this second electronic device are servomechanisms.
Wherein, this first electronic installation is that a portable electronic devices, this second electronic device are portable electronic devices.
Wherein, this first electronic installation is a servomechanism, and this second electronic device is a servomechanism.
Wherein, this first electronic installation has more an input block, and this input block supplies to upgrade the recorded content of this first data form of change.
Compared with prior art, the data synchronous system of simulation system daily record of the present invention can be through the simulation system daily record reaching data sync,, but and make phase mutually synchronization between each database, to expand its application.
Description of drawings
Fig. 1 is the calcspar of the data synchronous system of simulation system daily record of the present invention;
Fig. 2 is the synoptic diagram of the system journal simulator program simulation system daily record of the data synchronous system preferred embodiment of simulation system daily record of the present invention;
Fig. 3 is the system journal simulator program process flow diagram of the data synchronous system preferred embodiment of simulation system daily record of the present invention;
Fig. 4 is the system journal reducing program process flow diagram of the data synchronous system preferred embodiment of simulation system daily record of the present invention.
Description of reference numerals: 1-first electronic installation; 11-first processing unit; 12-first storage unit; 121-first data form; 122-data sync formula; The 1220-system journal; 1221-system journal simulator program; 1222-system journal reducing program; The 1223-first shadow data form; The 1224-first shared sequence data form; Field before the 1225-data change; Field behind the 1226-data change; The shared sequence number field of 1227-; 1228-shadow form denominational position; 1229-data movement time field; The 13-input block; The 2-second electronic device; 21-second processing unit; 22-second storage unit; 221-second data form; The 222-Procedure For Rework; S11～S12-steps flow chart; S21～S22-steps flow chart.
Embodiment
For being known, your juror understands content of the present invention, and sincerely graphic with the description collocation, please consult.
See also Fig. 1, Fig. 2, Fig. 3 and shown in Figure 4, it is calcspar, system journal simulator program synoptic diagram, system journal simulator program process flow diagram and the system journal reducing program process flow diagram of the data synchronous system of simulation system daily record of the present invention.Among the figure, this data synchronous system comprises one first electronic installation 1 and a second electronic device 2.
This first electronic installation 1 has one first processing unit 11, one first storage unit 12 and an input block 13.In the present embodiment, this first electronic installation 1 can be a portable electronic devices or a servomechanism.
This first processing unit 11 can be a microprocessor, a SoC or a microcontroller, but not as limit.
12 of this first storage unit can be a dynamic access memory bank, a flash body or a hard disk, but not as limit.This first storage unit 12 stores one first data form 121 and a data sync formula 122.122 of this data sync formulas comprise a system journal simulator program 1221 and a system journal reducing program 1222.
This input block 13 can be a keyboard, a mouse, a touch input element or a laser dummy keyboard, but not as limit.
2 of this second electronic devices have one second processing unit 21 and one second storage unit 22.
This second processing unit 21 can be a microprocessor, a SoC or a microcontroller, but not as limit.
This second storage unit 22 can be a dynamic access memory bank, a flash body or a hard disk, but not as limit.Wherein this second storage unit 22 is to store one second data form 221 and (redo) program 222 of reforming.
Wherein, this second electronic device 2 can be a portable electronic devices or is a servomechanism.
For example; When this first electronic installation 1 is a portable electronic devices, during like carry-on assistant of individual or Smartphone, if the user; Like the fee-collector; Utilize this first electronics assembling device, 1 registration number-plate number, then data such as the number-plate number, enrollment time are inputed in this first electronic installation 1, and change the recorded content in this first data form 121 by this input block 13.
In the time of this first data form, 121 recorded contents change; Then 1221 of this system journal simulator programs are carried out one with the mode that triggers (trigger) and are inserted (insert) instruction, renewal (update) instruction or deletion (delete) instruction, produce or change one first shadow data form 1223 (step S11) by this first data form 121.Then,, carry out one and insert (insert) instruction, produce or change one first shared sequence data form 1224 (step S12) by this first shadow data form 1223 to trigger the mode of (trigger).By this, and can simulate a system journal 1220, use synchronously for follow-up reduction.
Wherein, This first shadow data form 1223 comprises before the data change field 1226 behind the field 1225 and a data change, and this first shared sequence data form 1224 comprises a shared sequence number field 1227, a shadow form denominational position 1228 and a data movement time field 1229.
When this first electronic installation 1 and this second electronic device 2 carried out a communication and be connected, then this first processing unit 11 was carried out these system journal reducing programs 1222.Wherein, this system journal reducing program 1222 is carried out one and is selected (select) instruction, from this first shared sequence data form 1224, selects many corresponding shared sequence number fields 1227 and many shadow form denominational position 1228 (step S21).Then; This system journal reducing program 1222 is carried out one and is selected (select) instruction; With from these shared sequence number fields 1227 and these shadow form denominational positions 1228, select field 1226 and this data movement time field 1229 (step S22) behind field 1225 before corresponding this data change, this data change.By this, to restore this system journal 1220.
Explain in the lump that at this this selection (select) is instructed, refer to the stereotyped command of ANSI's SQL, it refers to carry out selection instruction one time, extracts results set with the loop mode then.For example, suppose to have in the results set n notes record, then this loop carries out n time extraction action.
After this system journal 1220 restores; After then being sent to this second electronic device 2; After this second processing unit 21 is received this system journal 1220, then carry out (redo) program 222 of reforming, make this second data form 221 and these first data form, 121 synchronised.
Wherein, the mode that this first electronic installation 1 and this second electronic device 2 are synchronous can the transmission of wired networking connects, the Wi-Fi transmission connects, the wireless blue tooth transmission, infrared transmission connects or modes such as USB line are implemented, but not as limit.
In sum; Because the data synchronous system of simulation system daily record of the present invention as long as database is the RDB of tandem (serial) data form, and is obtained and is created form (create table), establishment trigger (create trigger) authority; Can be through the mode of simulation and restoring system daily record; And can apply mechanically (redo) program of reforming that database itself has, and the database of two kinds of different shapes is given synchronization, significantly simplified system is built and is set to originally and supervisory routine; And promote compatibility, with the extending database range of application.
But the above is merely preferred embodiment of the present invention, is not in order to limit the scope that the present invention implements, not breaking away from the equalization variation of being done under spirit of the present invention and the scope and modification, all should be covered by in the claim of the present invention.
In sum, the data synchronous system of simulation system daily record of the present invention, the invention with patent reaches the value to industry; The applicant mentions the application of patent of invention according to the regulation of Patent Law to an ancient unit of weight office.
Claims (10)
1. the data synchronous system of a simulation system daily record is characterized in that, comprises:
One first electronic installation has:
One first processing unit;
One first storage unit, this first cell stores:
One first data form;
One data sync formula comprises:
One system journal simulator program; And
One system journal reducing program;
One second electronic device has:
One second processing unit; And
One second storage unit, this second cell stores, one second data form;
Wherein, After the recorded content of this first data form upgraded change, this first processing unit was through carrying out this system journal simulator program, to simulate a system journal; When this first electronic installation communication connects this second electronic device; Then this first processing unit is carried out this system journal reducing program to restore this system journal, makes the record of this second electronic device according to this system journal, with this second data form and this first data form synchronised.
2. the data synchronous system of simulation system daily record as claimed in claim 1 is characterized in that, this system journal simulator program comprises the following step:
Carry out one with triggering mode and insert instruction, a update instruction or a delete instruction, produce or change one first shadow data form by this first data form; And
Carry out one with triggering mode and insert instruction, produce or change one first shared sequence data form by this first shadow data form.
3. the data synchronous system of simulation system daily record as claimed in claim 2 is characterized in that, this first shadow data form comprises before the data change field behind the field and a data change.
4. the data synchronous system of simulation system daily record as claimed in claim 3 is characterized in that, this first shared sequence data form comprises a shared sequence number field, a shadow form denominational position and a data movement time field.
5. the data synchronous system of simulation system daily record as claimed in claim 4 is characterized in that, this system journal reducing program comprises the following step:
Carry out a selection instruction, from this first shared sequence data form, to select many corresponding shared sequence number fields and many shadow form denominational positions; And
Carry out a selection instruction,, select field and this data movement time field behind field before corresponding this data change, this data change with from these shared sequence number fields and these shadow form denominational positions.
6. the data synchronous system of simulation system daily record as claimed in claim 1 is characterized in that, after this second processing unit receives this system journal, carries out a Procedure For Rework, makes this second data form and this first data form synchronised.
7. the data synchronous system of simulation system daily record as claimed in claim 1 is characterized in that, this first electronic installation is that a portable electronic devices, this second electronic device are servomechanisms.
8. the data synchronous system of simulation system daily record as claimed in claim 1 is characterized in that, this first electronic installation is that a portable electronic devices, this second electronic device are portable electronic devices.
9. the data synchronous system of simulation system daily record as claimed in claim 1 is characterized in that, this first electronic installation is a servomechanism, and this second electronic device is a servomechanism.
10. the data synchronous system of simulation system daily record as claimed in claim 1 is characterized in that, this first electronic installation has more an input block, and this input block supplies to upgrade the recorded content of this first data form of change.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010105909811A CN102567338A (en) | 2010-12-16 | 2010-12-16 | Data synchronization system capable of simulating system logs |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010105909811A CN102567338A (en) | 2010-12-16 | 2010-12-16 | Data synchronization system capable of simulating system logs |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102567338A true CN102567338A (en) | 2012-07-11 |
Family
ID=46412779
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2010105909811A Pending CN102567338A (en) | 2010-12-16 | 2010-12-16 | Data synchronization system capable of simulating system logs |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102567338A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2014059804A1 (en) * | 2012-10-18 | 2014-04-24 | 腾讯科技（深圳）有限公司 | Method and system for data synchronization |
| CN104090948A (en) * | 2014-07-02 | 2014-10-08 | 中广核工程有限公司 | Method, device and system for processing mass data of nuclear power station |
| CN105653267A (en) * | 2015-12-28 | 2016-06-08 | 心动网络股份有限公司 | Electronic device and data processing method |
| CN108710602A (en) * | 2018-05-15 | 2018-10-26 | 深圳市继尧信息技术有限公司 | Processing method, device, computer equipment and the storage medium of achievement data |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6466951B1 (en) * | 1999-02-10 | 2002-10-15 | Telefonaktiebolaget Lm Ericsson (Publ) | Data base synchronizing system with at least two host databases and a remote database |
| CN1567298A (en) * | 2003-06-10 | 2005-01-19 | 鸿富锦精密工业（深圳）有限公司 | Arrangement procedure of database copy and reduction, named system and method |
| CN101741760A (en) * | 2008-11-26 | 2010-06-16 | 宏碁股份有限公司 | Synchronous transmission file technology for remote computer |
-
2010
- 2010-12-16 CN CN2010105909811A patent/CN102567338A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6466951B1 (en) * | 1999-02-10 | 2002-10-15 | Telefonaktiebolaget Lm Ericsson (Publ) | Data base synchronizing system with at least two host databases and a remote database |
| CN1567298A (en) * | 2003-06-10 | 2005-01-19 | 鸿富锦精密工业（深圳）有限公司 | Arrangement procedure of database copy and reduction, named system and method |
| CN101741760A (en) * | 2008-11-26 | 2010-06-16 | 宏碁股份有限公司 | Synchronous transmission file technology for remote computer |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2014059804A1 (en) * | 2012-10-18 | 2014-04-24 | 腾讯科技（深圳）有限公司 | Method and system for data synchronization |
| CN103780638A (en) * | 2012-10-18 | 2014-05-07 | 腾讯科技（深圳）有限公司 | Data synchronization method and system |
| CN103780638B (en) * | 2012-10-18 | 2019-02-19 | 腾讯科技（深圳）有限公司 | Method of data synchronization and system |
| CN104090948A (en) * | 2014-07-02 | 2014-10-08 | 中广核工程有限公司 | Method, device and system for processing mass data of nuclear power station |
| CN105653267A (en) * | 2015-12-28 | 2016-06-08 | 心动网络股份有限公司 | Electronic device and data processing method |
| CN105653267B (en) * | 2015-12-28 | 2019-05-07 | 心动网络股份有限公司 | Electronic equipment and data processing method |
| CN108710602A (en) * | 2018-05-15 | 2018-10-26 | 深圳市继尧信息技术有限公司 | Processing method, device, computer equipment and the storage medium of achievement data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| EP4022427B1 (en) | Generating software artifacts from a conceptual data model | |
| CN104049968B (en) | Popularize the method and system of the metadata driven version management service in environment | |
| CN109558440A (en) | Batch data processing method, device, computer equipment and storage medium | |
| CN109906448A (en) | Promote the operation on pluggable database using individual logical time stamp service | |
| CN103457905A (en) | Data synchronizing method, data synchronizing system and data synchronizing device | |
| CN102982130A (en) | Synchronized method for not only structured query language (NOSQL) and relational database management system (RDBMS) database and system thereof | |
| CN103970833A (en) | Method for achieving two-way synchronous data circulation in heterogeneous database synchronizing system based on logs | |
| CN103699638A (en) | Method for realizing cross-database type synchronous data based on configuration parameters | |
| CN110019498A (en) | Log synchronous method and device, storage medium, electronic equipment | |
| KR20150130039A (en) | CRM based data migration system and method | |
| CN102567338A (en) | Data synchronization system capable of simulating system logs | |
| CN103825918B (en) | Method of data synchronization, terminal device, server and system | |
| CN102272751A (en) | Data integrity in a database environment through background synchronization | |
| CN108536745A (en) | Tables of data extracting method, terminal, equipment and storage medium based on Shell | |
| EP2965492B1 (en) | Selection of data storage settings for an application | |
| CN107832448A (en) | Database operation method, device and equipment | |
| CN105812469A (en) | Address book synchronization method and device | |
| CN108345684A (en) | Intelligent analysis system and analysis method based on various dimensions multi objective system | |
| CN103645895B (en) | Automatic configuration method and cloud compiling system | |
| US7739232B2 (en) | Programming system for occasionally-connected mobile business applications | |
| CN109376148B (en) | Data processing method and device for slow change dimension table and electronic equipment | |
| CN114417390A (en) | Method and device for synchronizing data of network disk organization account, network disk and storage medium | |
| CN109271448A (en) | It is the data synchronous system and method for platform based on database | |
| CN106682158A (en) | Wetland park visualization system | |
| CN111061724B (en) | High-speed real-time database management method and device for power distribution automation 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 | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20120711 |