System for optimization of database replication/synchronization

• US 7,359,926 B1
• Filed: 02/13/2003
• Issued: 04/15/2008
• Est. Priority Date: 02/13/2003
• Status: Active Grant

• Current Assignee: Comtech Satellite Network Technologies, Inc. (Comtech Telecommunications Corporation)
• Original Assignee: Stampede Technologies, Inc. (Comtech Telecommunications Corporation)
• Inventors: Morris, Brian C., Yohe, Thomas P.
• Primary Examiner(s): Lee; Wilson
• Assistant Examiner(s): Brown; Sheree N
• Application Number:
  US10/367,250
• Time in Patent Office: 1,888 Days
• Field of Search: 707/200, 707/204, 709/205, 709/212
• US Class Current: 707/610
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: Y10S 707/99953 Recoverability
• CPC Class Codes: Y10S 707/99955 Archiving or backup

Abstract

A system for optimization of database replication/synchronization includes a first computer-based device having software thereon for obtaining a state of condition a database object and associating a unique identifier with such database object, for altering form of the data and associating another unique identifier with such altered database object, and for determining the database object using the unique identifiers. The system can receive a replication request for updating data from a second computer for a database object on the second computer wherein the request contains a unique identifier comparatively equating to one of the identifiers on the first computer and sends either an instruction to second computer to perform a like alteration on the data or to send the changes to the database object.

Claims

1. A system for optimization of database replication/synchronization, including:

a first computer-based device having software thereon with means for associating a first unique identifier with a first database object;

means for performing a first alteration upon said first database object to provide an altered second database object and associating a second unique identifier with said altered second database object, wherein said first alteration includes a transformation operation comprising compression, expansion, encryption, de-encryption, conversion, and de-conversion;

means for determining said database objects to be replicated either in altered form or unaltered form using said unique identifiers; and

means for receiving a replication request for updating data for a third database object from a second computer based device containing a third unique identifier and comparatively equating said third unique identifier to one of said first and second identifiers and for sending an instruction to said second computer based device to perform said first alteration upon said third database object thereon to maintain said database objects in sync and for sending said requested updated data when said second computer lacks means for performing said first alteration.

2. The system of claim 1, wherein said unique identifier includes a sequence number.

3. The system of claim 1, wherein said second computer-based device has complementary software thereon with means for associating a third unique identifier with condition of said third database object thereon;

means for performing a second alteration upon said third database object to provide an altered fourth database object thereon and associating a fourth unique identifier with said fourth altered database object, wherein said second alteration includes a transformation operation comprising compression, expansion, encryption, de-encryption, conversion, and de-conversion determining said database object using said unique identifiers, and

means for receiving a replication request from said first computer for updating data and containing one of said first and second unique identifiers and comparatively equating to one of said other identifiers and for sending an instruction to said first computer based device to perform said second alteration upon data thereon to maintain said database objects in sync.

4. The system of claim 1, wherein said replication/synchronization is characterized to be performed transparent to a user.

5. A method for optimization of database replication/synchronization, including:

employing a first computer-based device having software thereon with means associating a first unique identifier with a first database object;

performing a first alteration upon said first database object to provide an altered second database object, wherein said first alteration includes a transformation operation comprising at least one of compression, expansion, encryption, de-encryption, conversion, and de-conversion;

associating a second unique identifier with said altered second database object;

determining said database objects to be replicated either in altered form or unaltered form using said unique identifiers; and

receiving a replication request for updating data for a third database object from a second computer containing a third unique identifier and comparatively equating said third unique identifier to one of said first and second identifiers and for sending an instruction to said second computer based device to perform said first alteration upon of said third database object thereon to maintain said database objects in sync and for sending said requested updated data when said second computer lacks means for performing said first alteration.

6. The method of claim 5, wherein said unique identifier includes a sequence number.

7. The method of claim 5, wherein said second computer-based device has complementary software thereon with and includes the step of associating a third unique identifier with said third database object thereon;

performing a second alteration upon said third database object to provide an altered fourth database object thereon and associating a fourth unique identifier with said fourth altered database object, wherein said second alteration includes a transformation operation comprising at least one of compression, expansion, encryption, de-encryption, conversion, and de-conversion;

determining said database objects to be replicated either in altered form or unaltered form using said unique identifiers; and

receiving a replication request from said first computer for updating data and containing one of said first and second unique identifiers and comparatively equating to one of said other identifiers and for sending an instruction to said first computer based device to perform said second alteration upon data thereon to maintain said database objects in sync.

8. The method of claim 5, wherein said replication/synchronization is characterized to be performed transparent to a user.

9. A system for optimization of database replication/synchronization, including:

a first computer-based device having software thereon with means for associating a first unique identifier with a first database object;

means for performing a first alteration upon said first database object to provide an altered second database object and associating a second unique identifier with said altered second database object, wherein said first alteration includes a transformation operation comprising at least one of compression, expansion, encryption, de-encryption, conversion, and de-conversion;

means for determining said database objects to be replicated either in altered form or unaltered form using said unique identifiers; and

means for receiving a replication request for updating data for a third database object from a second computer based device containing a third unique identifier and comparatively equating said third unique identifier to one of said first and second identifiers and for sending an instruction to said second computer based device to perform said first alteration upon said third database object thereon to maintain said database objects in sync and for sending said requested updated data when said second computer lacks means for performing said first alteration.

10. The system of claim 9, wherein said second computer-based device has complementary software thereon with means for associating a third unique identifier with said third database object thereon;

means for performing a second alteration upon said third database object to provide an altered fourth database object thereon and associating a fourth unique identifier with said fourth altered database object, wherein said second alteration includes a transformation operation comprising at least one of compression, expansion, encryption, de-encryption, conversion, and de-conversion determining said database object using said unique identifiers, and

means for receiving a replication request from said first computer for updating data and containing one of said first and second unique identifiers and comparatively equating to one of said other identifiers and for sending an instruction to said first computer based device to perform said second alteration upon data thereon to maintain said database objects in sync.

11. The system of claim 9, wherein said replication/synchronization is characterized to be performed transparent to a user.