TWI409652B - Simulate the system log data synchronization system - Google Patents

Abstract

A data synchronization system for simulating a system log is disclosed, which comprises a first electronic device and a second electronic device. After a content recorded in a first data table is altered or updated, a first processing unit simulates a system log by means of executing a system log simulation procedure. When the first electronic device is communicatively connected to the second electronic device, the first processing unit executes a system log recovery procedure to recover a system log, such that the second electronic device synchronizes a second data table stored in the second electronic device with the first data table according to the records in the system log.

Description

Data synchronization system for simulating system logs

A data synchronization system, in particular, a data synchronization system that simulates a system log to synchronize a database.

A database, in simple terms, is a collection of materials with persistent data. Due to the use of the database to store and process data, it is possible to avoid data inconsistency, share data, provide transaction management, establish data standards, and ensure data security standards.

Due to the above advantages of the database, most enterprises or governments are complicated by their organizations, and their business is increasingly complicated. In order to effectively manage and execute various businesses, personnel information, form materials, revenue and expenditure management, inventory information, and books are usually used. Various information such as accounting system, volume content, etc. are stored in the database, and the database management system is used to control the classification and access of the data.

When the data is stored in each decentralized database, in order to keep the databases up to date, the database synchronization process is usually performed to synchronize the databases.

In the prior art, if each database is to be synchronized with each other, it is usually necessary to obtain a system log of the original database to know the information stored in the original system, the time of the data change, the content of the data change, and the like. Then, by executing the Redo program, the data between the databases is synchronized with each other. However, because the system log needs to be provided by the system vendor and is not open, if the two databases are developed and constructed by different vendors, if the system log cannot be obtained, the system maintenance personnel cannot synchronize them, and the application of the database is greatly restricted.

The main object of the present invention is to provide a system that can synchronize data by simulating system logs, so that each database can be synchronized with each other, thereby expanding its applicability.

To achieve the above objective, the present invention simulates a system log data synchronization system, which includes a first electronic device and a second electronic device. The first electronic device has a first processing unit and a second processing unit. The first memory unit stores a first data table and a data synchronization program. The data synchronization program includes a system log simulation program and a system log restore program. The second electronic device has a second processing unit and a second memory unit. The second memory unit stores a second data form. After the update of the recorded content of the first data table, the first processing unit simulates a system log by executing the system log simulation program, and when the first electronic device is communicatively connected to the second electronic device The first processing unit executes the system log restore program to restore the system log, so that the second electronic device synchronizes the second data table with the first data table according to the record of the system log. .

Among them, the system log simulator includes the following steps:

Performing an insert instruction, an update instruction, or a delete instruction in a trigger manner, generating or changing a first shadow data table from the first data table; and executing a trigger mode An insert command is used to generate or change a first shared sequence data table from the first shadow data table.

The first shadow data table includes a data change field and a data change field.

The first shared sequence data table includes a shared serial number field, a shadow form name field, and a data change time field.

The system log restore program includes the following steps: performing a selection (select) to select a common serial number field and a plurality of shadow table name fields corresponding to the plurality of pens from the first shared sequence data table; And executing a selection instruction to select a corresponding pre-change field, a post-change field, and a data change time field from the shared serial number field and the shadow form name field .

After receiving the system log, the second processing unit executes a redo process to synchronize the second data table with the first data table.

The first electronic device is a portable electronic device, and the second electronic device is a server.

The first electronic device is a portable electronic device, and the second electronic device is a portable electronic device.

The first electronic device is a server, and the second electronic device is a server.

The first electronic device further has an input unit for updating and changing the recorded content of the first data table.

In order for your review board to have a clear understanding of the contents of the present invention, please refer to the following description for matching drawings.

Please refer to FIG. 1 , FIG. 2 , FIG. 3 and FIG. 4 , which are block diagrams of the data synchronization system of the simulation system log of the present invention, a schematic diagram of the system log simulation program, a system log simulation program flow chart and a system. Log restore program flow chart. In the figure, the data synchronization system comprises a first electronic device 1 and a second electronic device 2.

The first electronic device 1 has a first processing unit 11, a first memory unit 12 and an input unit 13. In this embodiment, the first electronic device 1 can be a portable electronic device or a server.

The first processing unit 11 can be a microprocessor, a system single chip or a microcontroller, but is not limited thereto.

The first memory unit 12 can be a dynamic access memory, a flash memory or a hard disk, but is not limited thereto. The first memory unit 12 stores a first data table 121 and a data synchronization program 122. The data synchronization program 122 includes a system log simulation program 1221 and a system log restore program 1222.

The input unit 13 can be a keyboard, a mouse, a touch input component or a laser virtual keyboard, but is not limited thereto.

The second electronic device 2 has a second processing unit 21 and a second memory unit 22.

The second processing unit 21 can be a microprocessor, a system single chip or a microcontroller, but is not limited thereto.

The second memory unit 22 can be a dynamic access memory, a flash memory or a hard disk, but is not limited thereto. The second memory unit 22 stores a second data table 221 and a redo program 222.

The second electronic device 2 can be a portable electronic device or a server.

For example, when the first electronic device 1 is a portable electronic device, such as a personal portable assistant or a smart phone, if a user, such as a toll collector, uses the first electronic device 1 to register the license plate number, the borrowing is performed. The input unit 13 inputs the license plate number, the registration time, and the like into the first electronic device 1, and changes the recorded content in the first data table 121.

When the first data table 121 records the content change, the system log simulation program 1221 performs an insert command, an update command, or a delete command in a trigger manner. A first shadow material table 1223 is generated or changed by the first data table 121 (step S11). Next, an insert command is executed in the manner of a trigger, and a first shared sequence data table 1224 is generated or changed by the first shadow data table 1223 (step S12). In this way, a system log 1220 can be simulated for subsequent restoration synchronization.

The first shadow data table 1223 includes a data change field 1225 and a data change field 1226. The first share sequence data table 1224 includes a shared serial number field 1227 and a shadow form name field 1228. And a data change time field 1229.

When the first electronic device 1 performs a communication connection with the second electronic device 2, the first processing unit 11 executes the system log restore program 1222. The system log restore program 1222 executes a select command, and selects a common serial number field 1227 and a plurality of shadow table name fields 1228 from the first shared sequence data table 1224 ( Step S21). Next, the system log restore program 1222 executes a select command to select the corresponding data change field 1225 from the shared serial number field 1227 and the shadow form name field 1228. The data change field 1226 and the data change time field 1229 (step S22). Thereby, the system log 1220 is restored.

Herein, the selection instruction refers to a standard instruction of the American National Standards Institute structured query language, which refers to executing a selection instruction and then extracting the result set in a loop manner. For example, if there are n records in the result set, then the loop performs n extraction operations.

After the system log 1220 is restored, after being transmitted to the second electronic device 2, after receiving the system log 1220, the second processing unit 21 executes a redo program 222 to make the second data. The table 221 is synchronized with the first data table 121.

The manner in which the first electronic device 1 and the second electronic device 2 are synchronized may be implemented by a wired network transmission connection, a wireless network transmission connection, a wireless Bluetooth transmission, an infrared transmission connection, or a USB connection, but Not limited to this.

In summary, due to the data synchronization system of the simulation system log of the present invention, as long as the database is a relational database of serial data forms, and the creation table (create table) and the creation trigger (create trigger) permission are obtained. By simulating and restoring the system log, the redo program (redo) can be applied to the database, and the database of two different forms can be synchronized, which greatly simplifies the system construction cost and management program. And improve compatibility to extend the scope of database applications.

The above is only the preferred embodiment of the present invention, and is not intended to limit the scope of the present invention, and the equivalent changes and modifications may be included in the present invention without departing from the spirit and scope of the invention. Within the scope of the invention patent.

In summary, the data synchronization system of the simulation system log of the present invention has the patented invention and the use value of the industry; the applicant filed an application for an invention patent to the bureau according to the provisions of the patent law.

1. . . First electronic device

11. . . First processing unit

12. . . First memory unit

121. . . First data form

122. . . Data synchronization program

1220. . . System log

1221. . . System log simulator

1222. . . System log restore program

1223. . . First shadow data form

1224. . . First shared sequence data form

1225. . . Pre-change field

1226. . . Field after data change

1227. . . Shared serial number field

1228. . . Shadow table name field

1229. . . Data change time field

13. . . Input unit

2. . . Second electronic device

twenty one. . . Second processing unit

twenty two. . . Second memory unit

221. . . Second data form

222. . . Redo program

S11~S12. . . Step flow

S21~S22. . . Step flow

Figure 1 is a block diagram of a data synchronization system for simulating system logs of the present invention.

2 is a schematic diagram of a system log simulation program simulation system log of a preferred embodiment of a data synchronization system for simulating system logs according to the present invention.

3 is a flow chart of a system log simulation program of a preferred embodiment of a data synchronization system for simulating system logs according to the present invention.

4 is a flow chart of a system log restore procedure of a preferred embodiment of a data synchronization system for simulating system logs according to the present invention.

1. . . First electronic device

11. . . First processing unit

12. . . First memory unit

121. . . First data form

122. . . Data synchronization program

1220. . . System log

1221. . . System log simulator

1222. . . System log restore program

1223. . . First shadow data form

1224. . . First shared sequence data form

2. . . Second electronic device

twenty one. . . Second processing unit

twenty two. . . Second memory unit

221. . . Second data form

222. . . Redo program

Claims (10)

A data synchronization system for simulating a system log, comprising: a first electronic device, having: a first processing unit; a first memory unit, wherein the first memory unit stores: a first data table; a data synchronization program; The system includes: a system log simulation program; and a system log restore program; a second electronic device having: a second processing unit; and a second memory unit, wherein the second memory unit stores a second data table; After the record content of the first data table is updated, the first processing unit simulates a system log by executing the system log simulation program, when the first electronic device is communicatively connected to the second electronic device. And the first processing unit executes the system log restore program to restore the system log, so that the second electronic device synchronizes the second data table with the first data table according to the record of the system log. The data synchronization system of the simulation system log according to claim 1, wherein the system log simulation program comprises the following steps: performing an insert instruction, an update instruction, or a trigger method. a delete command, by the first capital The material table generates or changes a first shadow data table; and executes an insert command in a trigger manner to generate or change a first shared sequence data table from the first shadow data table. For example, the data synchronization system of the simulation system log described in claim 2, wherein the first shadow data table includes a data change field and a data change field. The data synchronization system of the simulation system log according to claim 3, wherein the first shared sequence data table includes a shared serial number field, a shadow form name field, and a data change time field. The data synchronization system of the simulation system log according to claim 4, wherein the system log restoration program comprises the following steps: executing a select instruction to select a plural number from the first shared sequence data table. a corresponding serial number field and a plurality of shadow table name fields corresponding to the pen; and executing a select instruction to select a corresponding one from the shared serial number field and the shadow form name field The field before the change of the data, the field after the change of the data and the time field of the change of the data. The data synchronization system of the simulation system log according to claim 1, wherein the second processing unit receives a redo (redo) program to make the second data table and the first A data table is synchronized. The data synchronization system of the analog system log according to claim 1, wherein the first electronic device is a portable electronic device, and the second electronic device is a server. The data synchronization system of the analog system log according to claim 1, wherein the first electronic device is a portable electronic device, and the second electronic device is a portable electronic device. The data synchronization system of the simulation system log according to claim 1, wherein the first electronic device is a server, and the second electronic device is a server. The data synchronization system of the simulation system log according to claim 1, wherein the first electronic device further has an input unit for updating and changing the recorded content of the first data table.