CA2505885A1 - System and method for synchronizing data records between multiple databases - Google Patents
System and method for synchronizing data records between multiple databases Download PDFInfo
- Publication number
- CA2505885A1 CA2505885A1 CA002505885A CA2505885A CA2505885A1 CA 2505885 A1 CA2505885 A1 CA 2505885A1 CA 002505885 A CA002505885 A CA 002505885A CA 2505885 A CA2505885 A CA 2505885A CA 2505885 A1 CA2505885 A1 CA 2505885A1
- Authority
- CA
- Canada
- Prior art keywords
- database
- data
- record
- databases
- delete
- 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.)
- Granted
Links
Abstract
A system and method for synchronizing data records between multiple database s is provided. Each database includes data records that are modified to include a t least one pair of synchronization parameters. In a two-database system including a fir st database and a second database, each data record is modified to include synchronization parameters for both the first and second databases. When an update is made to a data record at one of the databases, an update message is transmitted to the other database including both synchronization parameters from the database where the update is made, along with the updated data record. An efficient master-slav e configuration between the databases then enables either database to resolve conflicts without further communications. The system and method scale to systems havin g more than two databases by modifying the data records in at least one of the databases to include a pair of synchronization parameters for each of the other databases to which it is being synchronized, and by providing a multi-level master-slave configuration. The system and method permits the ability to add and delete records and to securely communicate between all synchronized databases.
Claims (9)
1. ~A method of deleting a data record from a first database and a second database, comprising the steps of:
selecting a data record stored in the first database for deletion;
preparing a delete record message including the data record;
transmitting the delete record message to the second database;
deleting the data record from the first database;
receiving the delete record message at the second database; and deleting the data record from the second database.
selecting a data record stored in the first database for deletion;
preparing a delete record message including the data record;
transmitting the delete record message to the second database;
deleting the data record from the first database;
receiving the delete record message at the second database; and deleting the data record from the second database.
2. ~The method of claim 1, wherein the step of preparing a delete record message comprises the step of encrypting the delete record message.
3. ~The method of claim 2, wherein the step of receiving the delete record message comprises the step of decrypting the delete record message.
4. ~A system for deleting a data record from a first database and a second database, comprising:
means for selecting a data record for deletion from the first database;
means for preparing a delete record message including the data record;
means for deleting the data record from the first database;
a transmitter for transmitting the delete record message to the second database;
means for receiving the deleted record message at the second database; and means responsive to the means for receiving for deleting the data record from the second database.
means for selecting a data record for deletion from the first database;
means for preparing a delete record message including the data record;
means for deleting the data record from the first database;
a transmitter for transmitting the delete record message to the second database;
means for receiving the deleted record message at the second database; and means responsive to the means for receiving for deleting the data record from the second database.
5. A data structure, comprising a data portion comprising one or more data fields;
a first parameter associated with a first data store in which the data fields are stored; and a second parameter associated with a second data store in which the data fields are stored.
a first parameter associated with a first data store in which the data fields are stored; and a second parameter associated with a second data store in which the data fields are stored.
6. The data structure of claim 1, wherein the first synchronization parameter is incremented when the data portion is modified in the first data store.
7. The data structure of claim 1, wherein the second synchronization parameter is incremented when the data portion is modified in the second data store.
8. The data structure of claim 1, further comprising a data record identifier.
9. The data structure of claim 8, wherein the data record identifier.
Applications Claiming Priority (3)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| US09/545,964 | 2000-04-10 | ||
| US09/545,964 US6820088B1 (en) | 2000-04-10 | 2000-04-10 | System and method for synchronizing data records between multiple databases |
| CA002343580A CA2343580C (en) | 2000-04-10 | 2001-04-09 | System and method for synchronizing data records between multiple databases |
Related Parent Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CA002343580A Division CA2343580C (en) | 2000-04-10 | 2001-04-09 | System and method for synchronizing data records between multiple databases |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CA2505885A1 true CA2505885A1 (en) | 2001-10-10 |
| CA2505885C CA2505885C (en) | 2009-12-15 |
Family
ID=34701684
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CA002505885A Expired - Lifetime CA2505885C (en) | 2000-04-10 | 2001-04-09 | System and method for synchronizing data records between multiple databases |
Country Status (1)
| Country | Link |
|---|---|
| CA (1) | CA2505885C (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7490112B1 (en) * | 1997-04-15 | 2009-02-10 | Intellisync Corporation | System and methods for synchronizing information among disparate datasets |
| CN115189994A (en) * | 2022-07-08 | 2022-10-14 | 中国联合网络通信集团有限公司 | Data synchronization method and device and computer readable storage medium |
-
2001
- 2001-04-09 CA CA002505885A patent/CA2505885C/en not_active Expired - Lifetime
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7490112B1 (en) * | 1997-04-15 | 2009-02-10 | Intellisync Corporation | System and methods for synchronizing information among disparate datasets |
| CN115189994A (en) * | 2022-07-08 | 2022-10-14 | 中国联合网络通信集团有限公司 | Data synchronization method and device and computer readable storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CA2505885C (en) | 2009-12-15 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CA2343580A1 (en) | System and method for synchronizing data records between multiple databases | |
| US6643669B1 (en) | Method for optimization of synchronization between a client's database and a server database | |
| US6892210B1 (en) | Database management and synchronization across a peer-to-peer network | |
| WO1999045451A3 (en) | Remote data access and synchronization | |
| US8171171B2 (en) | Data synchronization method and system between devices | |
| CA2447821A1 (en) | Synchronization of database data | |
| US6047289A (en) | Method and apparatus for directed data propagation | |
| KR100945221B1 (en) | Arrangement of data synchronization in a telecommunications system | |
| US20020059299A1 (en) | System and method for synchronizing databases | |
| US20050198084A1 (en) | System and method of synchronizing data between a server and a client | |
| CA2094657A1 (en) | Communication System Links Different Independent Databases and Provides Automatic Updating of Corresponding Records in the Databases | |
| EP1024441A3 (en) | Method and apparatus for synchronizing multiple databases | |
| WO2002013062A2 (en) | Data updating method and related information processing device | |
| MX9800830A (en) | Personal information manager for updating a telecommunmication subscriber probile. | |
| WO2000005903A3 (en) | Method and apparatus for synchronizing information browsing among multiple systems | |
| AU5325198A (en) | Method for repeater management | |
| AU1392001A (en) | Methods and arrangements in a telecommunications system | |
| MX9800829A (en) | Method and apparatus for providing telecommunication services. | |
| CA2287391A1 (en) | Method and system for authorization, routing, and delivery of transmissions | |
| GB2328537A8 (en) | Message searching system and terminal | |
| MY146705A (en) | Method, device and system for synchronizing of data providing for the handling of an interrupted synchronization process | |
| JPH05204739A (en) | System for synchronizing overlapped distributed data bases | |
| KR20000042580A (en) | System and method for synchronizing database between elementary management system and network element | |
| AU731020B2 (en) | Method of preventing data inconsistency between master exchange data and backup exchange data | |
| CA2505885A1 (en) | System and method for synchronizing data records between multiple databases |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| EEER | Examination request | ||
| MKEX | Expiry |
Effective date: 20210409 |