Computer database synchronization method

• US 6,081,806 A
• Filed: 01/15/1998
• Issued: 06/27/2000
• Est. Priority Date: 01/15/1998
• Status: Expired due to Term

• Current Assignee: Inventec Corporation
• Original Assignee: Inventec Corporation
• Inventors: Chang, Ching-Sung, Tsai, Shih-Kuang, Ho, Dai-Shui, Qiu, Xu-Jun
• Primary Examiner(s): Amsbury, Wayne
• Assistant Examiner(s): Pardo, Thuy
• Application Number:
  US09/007,467
• Time in Patent Office: 894 Days
• Field of Search: 706/45, 707/8, 707/201, 707/202, 707/204, 707/3, 707/203
• US Class Current: 1/1
• CPC Class Codes: G06F 16/275 Synchronous replication
• CPC Class Codes: Y10S 707/99938 Concurrency, e.g. lock management in shared database
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

In a computer database synchronization method, a first database with first object data and a second database with second object data are established in a personal computer and an electronic dictionary, respectively. First and second synchronization status tables are established for each of the first and second object data, respectively. The synchronization status tables are modified from a first state, indicating that the corresponding object data is synchronized with the first or second database, to a second state, indicating that the corresponding object data is not synchronized with the first or second database, when the corresponding object data is edited. Synchronizing of the first and second databases can begin when a communications link is established between the personal computer and the electronic dictionary. During synchronizing, the personal computer retrieves the second synchronization status tables from the electronic dictionary, and compares the second synchronization status tables with the corresponding first synchronization status tables. Based on the results of the comparison, the personal computer retrieves the corresponding second object data from the electronic dictionary, and updates the first database with the retrieved second object data, or transmits the corresponding first object data to the electronic dictionary for updating the second database with the transmitted first object data.

Claims

1. A computer database synchronization method, comprising:

establishing a first database with first object data in a personal computer, and a second database with second object data corresponding to the first object data in an electronic dictionary;

establishing a first synchronization status table for each of the first object data in the personal computer, and modifying the first synchronization status table from a first state, indicating that the corresponding first object data is synchronized with the second database, to a second state, indicating that the corresponding first object data is not synchronized with the second database, when the corresponding first object data is edited;

establishing a second synchronization status table for each of the second object data in the electronic dictionary, and modifying the second synchronization status table from a first state, indicating that the corresponding second object data is synchronized with the first database, to a second state, indicating that the corresponding second object data is not synchronized with the first database, when the corresponding second object data is edited;

establishing a communications link between the personal computer and the electronic dictionary; and

synchronizing the first and second databases including

controlling the personal computer to retrieve the second synchronization status tables from the electronic dictionary, and to compare the second synchronization status tables with the corresponding first synchronization status tables,

when one of the first synchronization status tables is in the first state and the corresponding one of the second synchronization status tables is in the second state, controlling the personal computer to retrieve the corresponding one of the second object data from the electronic dictionary, and to update the first database with the corresponding one of the second object data retrieved from the electronic dictionary, and

when one of the first synchronization status tables is in the second state and the corresponding one of the second synchronization status tables is in the first state, controlling the personal computer to transmit the corresponding one of the first object data to the electronic dictionary and controlling the electronic dictionary to update the second database with the corresponding one of the first object data received from the personal computer.

2. The computer database synchronization method as claimed in claim 1, further comprising, after synchronizing the first object data and the corresponding second object data, clearing the first and second synchronization status tables from the second state back to the first state.

3. The computer database synchronization method as claimed in claim 2, further comprising, after synchronizing the first and second databases, terminating the communications link between the personal computer and the electronic dictionary.

4. The computer database synchronization method as claimed in claim 1, wherein the second synchronization status table includes a database identifier, a dictionary-assigned identifier to distinguish the corresponding second object data from the other second object data in the database, and a status identifier to indicate whether the second synchronization status table is in the first or second states.

5. The computer database synchronization method as claimed in claim 4, wherein the first synchronization status table includes a database identifier corresponding to the database identifier of the corresponding second synchronization status table, a computer-assigned identifier to distinguish the corresponding first object data from the other first object data in the first database, the dictionary-assigned identifier of the corresponding second synchronization status table, and a status identifier to indicate whether the first tag table is in the first or second states.

6. The computer database synchronization method as claimed in claim 1, wherein the second state of the first and second synchronization status tables is one of a dirty-shared state, indicating that the corresponding one of the first and second object data is a new object data or a modified object data, and a delete state, indicating that the corresponding one of the first and second object data is a deleted object data.