Synchronization of databases with record sanitizing and intelligent comparison
First Claim
1. A computer implemented method of synchronizing records of first and second databases, the records of the first and second databases being characterized respectively by first and second record structures, wherein the first record structure is different from the second record structure thereby making the first and second databases incompatible, wherein at least one field of records of the first database is subject to a first rule of data value to which the corresponding field of records of the second database is not subject, the method comprising:
- comparing the content of the one field to the content of the corresponding field of the second database and in performing the comparison applying the first rule of data value, thereby comparing the records of the incompatible databases;
taking synchronization actions based on the outcome of the comparison,wherein applying the first rule of data value consists of one of;
a) comparing only a portion of the content of the one field to the content of the corresponding field;
b) comparing only a portion of the content of the corresponding field to the content of the one field;
c) omitting comparison of the content of the one field with the content of the corresponding field;
d) setting a first specified value of the one field equivalent to a second specified value of the corresponding field.
3 Assignments
0 Petitions
Accused Products
Abstract
A method of synchronizing at least a first and a second database each containing dated records such as events, wherein the records of the first and second databases are synchronized across a narrow date range narrower than the date range of the records of at least one of the databases. A prior synchronization can be performed across a prior date range. The date range of the prior synchronization is stored, along with the history file containing information representative of the content of the databases following the prior synchronization. When a current synchronization is performed, it is performed across a date range that combines the prior date range with the current date range.
257 Citations
4 Claims
-
1. A computer implemented method of synchronizing records of first and second databases, the records of the first and second databases being characterized respectively by first and second record structures, wherein the first record structure is different from the second record structure thereby making the first and second databases incompatible, wherein at least one field of records of the first database is subject to a first rule of data value to which the corresponding field of records of the second database is not subject, the method comprising:
-
comparing the content of the one field to the content of the corresponding field of the second database and in performing the comparison applying the first rule of data value, thereby comparing the records of the incompatible databases; taking synchronization actions based on the outcome of the comparison, wherein applying the first rule of data value consists of one of; a) comparing only a portion of the content of the one field to the content of the corresponding field; b) comparing only a portion of the content of the corresponding field to the content of the one field; c) omitting comparison of the content of the one field with the content of the corresponding field; d) setting a first specified value of the one field equivalent to a second specified value of the corresponding field.
-
-
2. A computer implemented method of synchronizing records of first and second databases, the records of the first and second databases being characterized respectively by first and second record structures, wherein the first record structure is different from the second record structure thereby making the first and second databases incompatible, wherein at least one field of records of the first database is subject to a first rule of data value to which the corresponding field of records of the second database is not subject, the method comprising:
-
comparing the content of the one field to the content of the corresponding field of the second database and in performing the comparison applying the first rule of data value, thereby comparing the records of the incompatible databases; taking synchronization actions based on the outcome of the comparison, wherein the first rule of data value consists of one of; a requirement that the content of the one field be in upper case; a requirement that the content of the one field have a specified form of punctuation; a requirement that the content of the one field have a specified form of spacing; a requirement that the content of the one field have a value limited to a specified range of values; a requirement that the content of the one field have a first specified value based on the content of another field; a requirement that the content of the one field be limited to a specified length; and a requirement that the content of the one field include a specified code.
-
-
3. A computer program, resident on a computer readable medium, for synchronizing records of first and second databases, the records of the first and second databases being characterized respectively by first and second record structures, wherein the first record structure is different from the second record structure thereby making the first and second databases incompatible, wherein at least one field of records of the first database is subject to a first rule of data value to which the corresponding field of records of the second database is not subject, the computer program comprising the steps for:
-
comparing the content of the one field to the content of the corresponding field of the second database and in performing the comparison applying the first rule of data value, thereby comparing the records of the incompatible databases; taking synchronization actions based on the outcome of the comparison, wherein applying the first rule of data value consists of one of; a) comparing only a portion of the content of the one field to the content of the corresponding field; b) comparing only a portion of the content of the corresponding field to the content of the one field; c) omitting comparison of the content of the one field with the content of the corresponding field; d) setting a first specified value of the one field equivalent to a second specified value of the corresponding field.
-
-
4. A computer program, resident on a computer readable medium, for synchronizing records of first and second databases, the records of the first and second databases being characterized respectively by first and second record structures, wherein the first record structure is different from the second record structure thereby making the first and second databases incompatible, wherein at least one field of records of the first database is subject to a first rule of data value to which the corresponding field of records of the second database is not subject, the computer program comprising the steps for:
-
comparing the content of the one field to the content of the corresponding field of the second database and in performing the comparison applying the first rule of data value, thereby comparing the records of the incompatible databases; taking synchronization actions based on the outcome of the comparison, wherein the first rule of data value consists of one of; a requirement that the content of the one field be in upper case; a requirement that the content of the one field have a specified form of punctuation; a requirement that the content of the one field have a specified form of spacing; a requirement that the content of the one field have a value limited to a specified range of values; a requirement that the content of the one field have a first specified value based on the content of another field; a requirement that the content of the one field be limited to a specified length; and a requirement that the content of the one field include a specified code.
-
Specification