Synchronizing databases

• US 6,799,190 B1
• Filed: 04/11/2002
• Issued: 09/28/2004
• Est. Priority Date: 11/13/1996
• Status: Expired due to Term

• Current Assignee: Intellisync Corporation (Nokia Corporation)
• Original Assignee: Intellisync Corporation (Nokia Corporation)
• Inventors: Boothby, David J.
• Primary Examiner(s): Mizrahi, Diane D.
• Application Number:
  US10/122,704
• Time in Patent Office: 901 Days
• Field of Search: 707/200, 707/201, 707/202, 707/203, 707/204, 707/205, 707/8, 707/10
• 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
• CPC Class Codes: Y10S 707/99955 Archiving or backup

Abstract

A computer program and a computer implemented method are provided for synchronizing two databases by attempting to identify a plurality of records of the second database storing a span of information stored in a record of the first database and synchronizing the first database and the second database based on the results of the attempt. The computer program and a computer implemented can also store a record of a first database in a second database where the record of the first database stores a span of information and the second database is not capable of storing such span of information in a single record. To do so, a plurality of records of the second database are generated to store the span of information of the record of the first database, each of the plurality of the records of the second database storing a portion of the span of the information, where the plurality of records of the second database in combination store a selected segment of the span of information less than the entirety of the span of information.

Claims

1. A computer implemented method of synchronizing at least a first and a second database comprising:

identifying a plurality of records of the second database storing a span of information stored in a record of the first database; and

synchronizing the first database and the second database based on the results of the identifying,

wherein the span of information represented by the record of the first database includes date-bearing information,

wherein the date-bearing information includes recurring date-bearing information,

wherein the span of information has a starting time and date and an ending time and date which span a continuous period of time,

wherein the continuous period of time is longer than a period of time permitted by the second database,

further comprising identifying the plurality of records of the second database as storing the span of information stored in the record of the first database, wherein each of the identified plurality of the records of the second database stores a portion of the span of the information, wherein the identified plurality of records of the second database in combination store a selected segment of the span of information, and

wherein the identified plurality of records of the second database includes a recurring record.