Synchronizing databases

• US 7,302,446 B1
• Filed: 09/20/2004
• Issued: 11/27/2007
• Est. Priority Date: 11/13/1996
• Status: Expired due to Fees

• 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/945,486
• Time in Patent Office: 1,163 Days
• Field of Search: 707 1- 10, 707100-1041, 707200-206, 707/102
• US Class Current: 707/610
• CPC Class Codes: G06F 16/275 Synchronous replication
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

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 program product for synchronizing at least a first and a second database, the computer program product comprising at least one computer-readable storage medium having computer readable program code portions encoded therein, the computer-readable program code portions comprising instructions which when executed configure a computer to:

identifying a plurality of records of the second database storing a span of information stored in a record of the first database, the span of information being represented by the record of the first database including date-bearing information that includes recurring date-bearing information, the span of information having a starting time and date and an ending time and date which span a continuous period of time that is longer than a period of time permitted by the second database;

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

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

the identified plurality of records of the second database including instances of a recurring date-bearing record.