ClientSync - a synching method between a client computer or computers and server computer supporting one-to-many and many-to-one database synchronization when the network connection between the two is not always available or is a low-speed connection.

• US 20030229655A1
• Filed: 06/03/2003
• Published: 12/11/2003
• Est. Priority Date: 06/06/2002
• Status: Abandoned Application

• Current Assignee: Advanced Barcode Technology, Inc.
• Original Assignee: Advanced Barcode Technology, Inc.
• Inventors: Shivat, Zion, Bibas, Charles
• Application Number:
  US10/250,086
• Publication Number:
  US 20030229655A1
• Time in Patent Office: Days
• US Class Current: 707/203
• CPC Class Codes: H04L 67/1095 Replication or mirroring of data, e.g. scheduling or transport for data synchronisation between network nodes

Abstract

ClientSync is a module that allows a client computer or workstation to communicate with a central database stored on a server. When a network connection is present between the client and the server, the Sync application, running on a PC, allows the user to select a database which will then have its data re-created on the server. The data from the server will then be written back to the local database, thus ensuring all records are up-to-date.

Claims

1. A system for synchronizing data between one or more local databases and one or more central databases comprising:

local database(s), stored on a client computer, or multiple computers;

central database(s), stored on a server or servers;

a program interface, stored on and run from the host computer, which allows the user to select which primary database is to be synchronized with the secondary database, then performs the operation at timed intervals and/or at the command of the user.

2. The system of claim 1 wherein a network connection connects the client computer and the server.

3. The system of claim 1 wherein the central database is in a different format from the local database.

4. The system of claim 1 wherein data from the local database is written into a special table in the central database.

5. The table of claim 4 wherein the data in said table is translated as a series of instructions which will perform the operations necessary to re-create the data which will be stored in the central database.

6. The system of claim 1 wherein only records created on the local database subsequent to the previous synch procedure will be used in the current synch procedure.

7. The sequence of instructions in claim 5 are standard database operations which are compiled into the Sync program in claim 1.

8. The system of claim 1 wherein data from the central database is written to the local database, bringing it up to date.

9. The system of claim 8 is regulated by a version number, whereby, if the version numbers in the central and local databases are the same, no operation is performed, but if the numbers differ, the data record is copied from the central to the local.