201224804 六、發明說明： 【發明所屬之技術領域】 一種資料同步系統，特別是指一種模 言态以同步資料庫之資料同步系統。 【先前技術】 資料庫（database)，簡單來說，其為具 I 資料（persistent data)之資料彙集的地方。 資料庫來儲存及處理資料，具有避免資料 資料可以共享、提供異動管理、可建立資 確保資料安全標準。 由於資料庫具有上述優點，因此，大 業或政府因其組織龐大，業務日趨複雜， 管理及執行各業務，通常會把人事資料，表 收支管理、庫存資訊、書籍、會計系統、卷 _ 等各種資訊儲存於資料庫内，再藉由資料 統，來控制資料的分類及存取。 而當資料儲存於各分散式之資料庫時 資料庫能隨時維持在最新狀態，通常會藉 料庫同步的程序，以完成資料庫之間 (synchronize) 〇 於S知技術中，若欲使各資料庫之 步’通常需取得原資料庫之系統曰諸，以 系統所存之資料，資料變動時間，資料變 擬系統日 有不變性 由於使用 不一致、 料標準、 部份的企 為了有效 :單資料、 案内容... 庫管理系 ，為使各 由執行資 相互同步 間相互同 得知原始 動内容... 3 201224804 等相關參數資訊，再藉由執行重做（Red〇)程序以 將各資料庫之間的資料相互同步。然而，由於系統 曰誌’需系統廠商提供而不開放，因此，若兩資料 庫是由不同廠商開發建構，若無法取得系統曰钱， 系統維護人員便無法使其相同步，而使得資料庫之 應用大大受到限制。 【發明内容】 本發明之主要目砧，t 的曰在棱供一種可藉由模擬 系統曰誌以達資料回舟夕& β 貝㈣步之系統，而使各資料庫之間 可相互同步，藉以擴展其應用性。 為達上述目的’本發明模擬系統日誌之資料同 步系統’其係包含-第-電子裝置及-第二電子裝 置。該第一電子梦罟且右—货 ^ 卞裒置具有第一處理單元及一第二 處理單元。該第一記憶單元係儲存-第-資料表格 及-資料同步程式。該資料同步程式包括一系統曰 誌模擬程序及-系統曰誌還原程序。該第二電 置具：：第二處理單元及一第二記憶單元。該第二 S己憶單7G係儲存_第二資料表格。其中，當該第一 資料表格之記錄内容更新變動後，該第一處理單元 係藉由執行該系統日㈣擬程序，以模擬出一系= 曰誌’當該第-電子裝置通訊連接該第二電子裝置 時，則該第一處理單元係執行該系統日諸還i程 序’以還原出該系統曰詰’使該第二電子裝置根據 4 201224804 該系統日誌之記錄，將該第二資料表格與該第一資 料表格相同步。 其中’該系統日諸模擬程序包含下列步驟： 以觸發（trigger)方式執行一插入（insert)指令、— 更新（update)指令或一刪除（delete)指令，由該第— 資料表格產生或變更一第一影子資料表格；及以觸 發方式執行一插入（insert)指令，由該第一影子資料 表格產生或變更一第一共用序列資料表格。 其中，5亥第一影子資料表格包含一資料變更前 欄位及一資料變更後欄位。 其中，該第一共用序列資料表格包括一共用序 列號攔位、一影子表格名稱欄位及一資料變動時間 襴位。 其中，該系統日誌還原程序包含下列步驟：執 行一選擇（select)，以從該第一共用序列資料表格 中’選擇出複數筆相對應之共用序列號攔位及複數 筆影子表格名稱欄位；及執行一選擇指令，以從該 等共用序列號攔位及該等影子表格名稱欄位中，選 擇出相對應之該資料變更前欄位、該資料變更後欄 位及該資料變動時間攔位。 其中，該第二處理單元接收到該系統日誌後， 執行一重做（redo)程序，使該第二資料表格與該第一 資料表格相同步。 其中，該第一電子裝置係為一可攜式電子裝 5 201224804 置、該第二電子裝置係為一飼服器。 其中’該第-電子裝置係為一可攜式電子震 置、該第二電子裝置係為一可攜式電子裝置。、 其中，該第一電子裝置係為-伺服器，該第二 電子裝置係為一伺服器。 其中，該第一電子裝置更具有一輸入單元，該 輸入單元係供更新變動該第一資料表格之記錄= 容。 【實施方式】 為使貴審查委員能清楚了解本發明之内容， Ιϊ 以下列說明搭配圖式，敬請參閱。 請參閱第1圖、第2圖、第3圖及第4圖所示， 其係為本發明模擬系統日誌之資料同步系統之方塊 圖、系統日誌模擬程序示意圖、系統日誌模擬程序 bit程圖及系統日s志還原程序流程圖。圖中，該資料 同步系統包含一第一電子裝置丨及一第二電子裝置 1。 該第一電子裝置1具有一第一處理單元11、一 第一記憶單元12及一輸入單元13。在本實施例中， "玄第電子裝置1可為一可攜式電子裝置或一伺服 器。 / 该第一處理單元11可為一微處理器、一系統單 晶片或是一微控制器，但不以此為限。 s第°己隐單元12則可為一動態存取記憶體、 201224804 該第一記 資料同步 系統日誌 一快閃記憶體或一硬碟，但不以此為限。 憶單元1 2係儲存一第一資料表格i 2丨及一 程式122 *該資料同步程式丨22則包括一 模擬程序1 2 2 1及一系統日該還原程序1 2 2 2。 該輸入單元13可為一鍵盤、一滑鼠、一觸控式 輸入元件或一雷射虛擬鍵盤，但不以此為限。201224804 VI. Description of the invention: [Technical field to which the invention pertains] A data synchronization system, in particular, a data synchronization system in which a mode is used to synchronize a database. [Prior Art] A database, in a nutshell, is a place where data of persistent data is collected. The database is used to store and process data, to avoid sharing of data, to provide transaction management, and to establish data security standards. Because the database has the above advantages, the big business or the government, due to its large organization, increasingly complex business, management and execution of various businesses, usually will be personnel information, table revenue management, inventory information, books, accounting systems, volumes _, etc. Various information is stored in the database, and the data is controlled to control the classification and access of the data. When the data is stored in various decentralized databases, the database can be kept up-to-date at any time. Usually, the program synchronized by the library is used to complete the synchronization between the databases and the S-knowledge technology. The step of the database 'usually needs to obtain the system of the original database. The data stored in the system, the time of data change, the invariance of the data transformation system, due to inconsistent use, material standards, and some enterprises are effective: single data , the contents of the case... The library management system, in order to make each of the executive resources synchronized with each other to learn the original dynamic content... 3 201224804 and other related parameter information, and then by performing the redo (Red〇) program to each The data between the databases is synchronized with each other. However, since the system is not required to be provided by the system manufacturer, if the two databases are developed and constructed by different vendors, if the system cannot save the system, the system maintenance personnel cannot synchronize them, and the database is Applications are greatly limited. SUMMARY OF THE INVENTION The main anvil of the present invention, t is in the edge of a system that can be synchronized by the simulation system to get the data back to the boat & beta shell (four) step, so that the databases can be synchronized with each other In order to expand its applicability. In order to achieve the above object, the data synchronization system of the simulation system log of the present invention includes - a - electronic device and - a second electronic device. The first electronic nightmare and the right-handling device have a first processing unit and a second processing unit. The first memory unit stores a - a data table and a data synchronization program. The data synchronization program includes a system simulation program and a system recovery program. The second electrical device: a second processing unit and a second memory unit. The second S-reviewed 7G system stores the second data table. After the update of the recorded content of the first data table, the first processing unit simulates a system by performing the system (4) program to simulate the first electronic device communication connection. In the case of two electronic devices, the first processing unit executes the system and the program 'restores the system 曰诘' to cause the second electronic device to record the system log according to 4 201224804, the second data table Synchronized with the first data form. Wherein the system simulation program comprises the following steps: executing an insert instruction, an update instruction or a delete instruction in a trigger manner, generating or changing one from the first data table a first shadow data table; and executing an insert command in a trigger manner to generate or change a first shared sequence data table from the first shadow data table. Among them, the 5th first shadow data form includes a data change field and a data change field. The first shared sequence data table includes a shared serial number block, a shadow form name field, and a data change time unit. The system log restore program includes the following steps: performing a select (select) to select a common serial number block 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 block from the shared serial number block and the shadow form name fields. . 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 5 201224804, and the second electronic device is a feeding device. Wherein 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 record of the first data table. [Embodiment] In order to make the contents of the present invention clear to you, Ιϊ use the following description to match the drawings, please refer to it. 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 bit diagram and System day s recovery program flow chart. In the figure, the data synchronization system comprises a first electronic device and a second electronic device 1. 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 "Xiaodian 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 s°° hidden unit 12 can be a dynamic access memory, 201224804, the first data synchronization system log, a flash memory or a hard disk, but not limited thereto. The memory unit 1 2 stores a first data table i 2 and a program 122. The data synchronization program 22 includes an emulation program 1 2 2 1 and a system date reduction program 1 2 2 2 . The input unit 13 can be a keyboard, a mouse, a touch input component or a laser virtual keyboard, but is not limited thereto.
該第二電子裝置2則具有一第二處理單元21及 一第二記憶單元22。 該第二處理單元21可為一微處理器、一系統單 晶片或一微控制器’但不以此為限。 該第二記憶單元22可為一動態存取記憶體、一 快閃記憶體或一硬碟，但不以此為限。其中該第二 記憶單元22係儲存一第二資料表格221'及:重: (redo)程序 222 »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 weight: (redo) program 222 »
其中，該第二電子裝置2 置或為一伺服器。 可為一可攜式電子裝 舉例而言，當該第一電子裝詈1 A -r λ* r 1為可攜式電子 裝置，如個人隨身助理或智慧型手機時，若使用者， 如收費員，利用該第一電子裴奘蒈,仪^ ^ 电丁衣衮置1登記車牌號 碼’則藉由該輸入單元13將車胧妹版 ^ ^ 啊平砰唬碼、登記時間等 資料輸入至該第一電子裝置1肉 ^ 衣罝1内，而變動該第一資 料表格1 2 1内之記錄内容。 當該第一資料表格 則該系統日誌模擬程序 121記錄内容變動的同時， 1221則以觸發（trigger)的方 201224804 式執行一插入（insert)指令、一更新（Update)指令或一 刪除（delete)指令’由該第一資料表格121產生或變 更一第一影子資料表格1223(步驟SI 1)。接著，以 觸發（trigger)之方式’執行一插入（insert)指令，由 該第一影子資料表格1223產生或變更一第一共用 序列資料表格1 224(步驟S 1 2)。藉此，而可模擬出 一系統日誌1 220 ’以供後續還原同步所使用。 其中’該第一影子資料表格1223包含一資料變 更前攔位1225及一資料變更後攔位1226，該第— 共用序列資料表格1224包括一共用序列號攔位 1227、一影子表格名稱襴位lug及一資料變動時間 欄位1229。 當該第一電子裝置1與該第二電子裝置2進行 一通訊連接時’則該第一處理單元丨丨執行該系統曰 s志還原程序1222。其中’該系統曰總還原程序1 222 執行一選擇（select)指令，從該第一共用序列資料表 格1224中’選擇出複數筆相對應之共用序列號攔位 1227及複數筆影子表格名稱攔位ι228(步驟S21)。 接著，該系統日誌還原程序1222執行一選擇（select) 指令’以從該等共用序列號欄位1227及該等影子表 格名稱攔位1228中，選擇出相對應之該資料變更前 攔位1225、該資料變更後攔位1226及該資料變動 時間欄位1229(步驟S22)。藉此，以還原出該系統 日誌1220 。 201224804 在此一併說明，該選擇（select)指令，係指一美國 國家標準協會結構化查詢語言之標準指令，其係指 執行一次選擇指令，然後以迴圈方式提取結果华 合。舉例而言，假設結果集合内有η筆記錄，則該 迴圈進行η次之提取動作。 當該系統日誌1 220還原出來後，則傳送至該第 二電子裝置2後，該第二處理單元2 1收到該系統日 言志1220後，則執行一重做（red〇)程序222，使該第 二資料表格221與該第一資料表格121相同步。 其中’該第一電子裝置1與該第二電子裝置2 同步的方式，可以有線網路傳輸連接、無線網路傳 輸連接、無線藍芽傳輸、紅外線傳輸連接或U s B連 線等方式來實施，但不以此為限。 綜上所述’由於本發明模擬系統日誌之資料同 步系統’只要資料庫為串列（serial)資料形態之關連 式負料庫，並取得創建表格（create table)、創建觸發 程序（create trigger)權限，即可藉由模擬及還原系統 曰誌的方式’而可套用資料庫本身具有之重做（red〇) 程序，將兩種不同形態之資料庫予以同步化，大幅 簡化系統建置成本及管理程序，及提昇相容性，以 擴展資料庫應用範圍。 唯以上所述者，僅為本發明之較佳實施例而 已，並非用以限定本發明實施之範圍，在不脫離本 發明之精神與範圍下所作之均等變化與修飾，皆應 201224804 涵蓋於本發明之專利範圍内。 綜上所述，本發明之模擬系統日誌之資料同步 系統，係具有專利之發明性，及對產業的利用價值； 申請人爰依專利法之規定，向 鈞局提起發明專利 之申請。The second electronic device 2 is configured as a server. For a portable electronic device, for example, when the first electronic device 1 A - r λ * r 1 is a portable electronic device, such as a personal portable assistant or a smart phone, if the user, such as a charge Using the first electronic 裴奘蒈, the instrument ^ ^ 丁 衮 1 1 registration license plate number ', through the input unit 13 to enter the car sister ^ ^ ah ping code, registration time and other information into the first An electronic device 1 is inside the clothing 1 and changes the recorded content in the first data table 1 2 1 . While the first data table records the content change of the system log simulation program 121, 1221 executes an insert command, an update command, or a delete command with a trigger method 201224804. The instruction 'generates or changes a first shadow data table 1223 from the first data table 121 (step SI 1). Next, an insert command is executed in a "trigger" manner, and a first shared sequence data table 1 224 is generated or changed by the first shadow data table 1223 (step S12). Thereby, a system log 1 220 ' can be simulated for subsequent restoration synchronization. The first shadow data table 1223 includes a data change pre-block 1225 and a data change post 1226. The first share sequence data table 1224 includes a shared serial number block 1227 and a shadow form name. And a data change time field 1229. When the first electronic device 1 and the second electronic device 2 are in a communication connection, the first processing unit executes the system recovery program 1222. The system 曰 total reduction program 1 222 executes a select command, and selects the shared serial number block 1227 and the plurality of shadow table name blocks corresponding to the plurality of pens from the first shared sequence data table 1224. Ι228 (step S21). Next, the system log restore program 1222 executes a select command to select the corresponding pre-change block 1225 from the shared serial number field 1227 and the shadow form name block 1228. The data is changed after the block 1226 and the data change time field 1229 (step S22). This is used to restore the system log 1220. 201224804 It is also stated here that the select instruction refers to a standard instruction of the American National Standards Institute structured query language, which refers to the execution of a selection instruction and then extracts the result in a loop. For example, if there are η pen records in the result set, then the loop performs η extraction operations. After the system log 1 220 is restored, after being transmitted to the second electronic device 2, the second processing unit 2 1 receives the system log 1220, and then executes a redo program 222. The second data 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 means of a wired network transmission connection, a wireless network transmission connection, a wireless Bluetooth transmission, an infrared transmission connection, or a U s B connection. , but not limited to this. In summary, the data synchronization system of the simulation system log according to the present invention is as long as the database is a serial data store of a serial data form, and a create table and a create trigger are created. Permissions, you can use the redo process of the database itself by simulating and restoring the system's ambitions, synchronizing the two different forms of the database, greatly simplifying the system construction cost and Manage programs and improve compatibility to extend the reach of your database. The above is only the preferred embodiment of the present invention, and is not intended to limit the scope of the present invention. The equivalent changes and modifications made without departing from the spirit and scope of the present invention should be covered by this 201224804. 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 value of the use of the industry; the applicant applies for an invention patent to the bureau in accordance with the provisions of the Patent Law.
10 201224804 【圖式簡單說明】 第1圖，為本發明模擬系統日誌之資料同步系統之 方塊圖。 第2圖，為本發明模擬系統日誌之資料同步系統較 佳實施例之系統日誌模擬程序模擬系統日誌之示意圖。 第3圖，為本發明模擬系統日誌之資料同步系統較 佳實施例之系統日誌模擬程序流程圖。 第4圖，為本發明模擬系統日誌之資料同步系統較 佳實施例之系統日誌還原程序流程圖。 【主要元件符號說明】 I 第一電子裝置 II 第一處理單元 12 第一記憶單元 121 第一資料表格 122 資料同步程式 1220系統日誌 1221系統日誌模擬程序 1222系統日誌還原程序 1223第一影子資料表格 1224第一共用序列資料表格 1225資料變更前欄位 1226資料變更後欄位 1227共用序列號欄位 11 201224804 1228 1229 13 2 21 22 221 222 S11〜 S21〜 影子表格名稱欄位 資料變動時間欄位 輸入單元 第二電子裝置 第二處理單元 第二記憶單元 第二資料表格 重做程序 S 1 2步驟流程 S22步驟流程10 201224804 [Simplified description of the drawings] Fig. 1 is a block diagram of a data synchronization system for simulating system logs of the present invention. Fig. 2 is a schematic diagram showing a system log simulation program simulation system log of a preferred embodiment of the data synchronization system for simulating system logs of the present invention. Figure 3 is a flow chart showing the system log simulation program of the preferred embodiment of the data synchronization system for simulating system logs of the present invention. Figure 4 is a flow chart showing the system log restore procedure of a preferred embodiment of the data synchronization system for simulating system logs of the present invention. [Main component symbol description] I First electronic device II First processing unit 12 First memory unit 121 First data table 122 Data synchronization program 1220 System log 1221 System log simulation program 1222 System log restore program 1223 First shadow data table 1224 First shared sequence data table 1225 Data change field 1226 Data change field 1227 shared serial number field 11 201224804 1228 1229 13 2 21 22 221 222 S11~ S21~ Shadow table name field data change time field input unit Second electronic device second processing unit second memory unit second data table redo program S 1 2 step flow S22 step flow
1212