US5758150A
Expired / Lapsed
US
⏱️ 0.0 years remaining
System and method for database synchronization
Assignee: Comcast Cable Communications LLC
•
Filing: 1995-10-06
•
Granted: 1998-05-26
•
Expires: 2015-10-06
Abstract
Abstract A database synchronization system (10) is disclosed that synchronizes the content of a central database stored on a central computer (16) with one or more remote databases stored on one or more remote computers (18). A data extract and transfer application (20) is provided on each of the remote computers (18). A migrator application (26) processes the audit trail files (24) of the remote computer (18) to create a database of change (28). When the database of change (28) reaches a size threshold, the data extract and transfer application (20) shuts down the migrator application(26), processes the database of change (28), and restarts the migrator application (26) to begin the creation of another database of change. The data and information in the database of change are converted into a series of flat files (48) that are transferred over a communications line (14) from each of the remote computers (18) to the central computer (16).
Inventors
- 👤 Dennis Leroy Bell
- 👤 David Lawrence Cozzolino
- 👤 Michelle Lee Lee
- 👤 Richard Lee Hagen
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-26 20:35
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/27; G06F16/275; Y; Y10; Y10S; Y10S707/00; Y10S707/99951; Y10S707/99952; Y10S707/99953
Claims Analysis
Total Claims: 27
Claim 1
Independent Claim
161 words
A database synchronization system, comprising: a central computer storing a central database; at least one remote computer remote from the central computer and having at least one associated database; a communications link coupling the central computer to the remote computer; and a data extract and transfer application stored on the remote computer, including a plurality of audit trail files for storing changes to the associated database, a migrator application capable of processing the audit trail files to extract the changes thereto and convert the changes into a first database of change, a table move module capable of executing a database command to rename the first database of change to allow the migrator application to create a second database of change, a flat file module capable of converting the first database of change into flat files suitable for transfer to the central database, and a file transfer module capable of transferring the flat files to the central computer over the communications link.
Claim 2
Dependent Claim
161 words
A database synchronization system, comprising: a central computer storing a central database; at least one remote computer remote from the central computer and having at least one associated database; a communications link coupling the central computer to the remote computer; and a data extract and transfer application stored on the remote computer, including a plurality of audit trail files for storing changes to the associated database, a migrator application capable of processing the audit trail files to extract the changes thereto and convert the changes into a first database of change, a table move module capable of executing a database command to rename the first database of change to allow the migrator application to create a second database of change, a flat file module capable of converting the first database of change into flat files suitable for transfer to the central database, and a file transfer module capable of transferring the flat files to the central computer over the communications link.
Claim 3
Dependent Claim
32 words
The database synchronization system of claim 1, further comprising means stored on the remote computer for opening the audit trail files during processing of the audit trail files by the migrator application.
Claim 4
Dependent Claim
22 words
The database synchronization system of claim 1, further comprising means stored on the remote computer for dropping the first database of change.
Claim 5
Dependent Claim
46 words
The database synchronization system of claim 1, further comprising, means stored on the remote computer for opening the audit trail files during processing of the audit trail files by the migrator application; and means stored on the remote computer for dropping the first database of change.
Claim 6
Independent Claim
134 words
A method for synchronizing the content of a central database stored on a central computer with the content of a remote database stored on a remote computer, comprising the steps of: processing the audit trail files stored on the remote computer to create a first database of change stored on the remote computer; stopping the processing of the audit trail files when the database of change reaches a size threshold; processing the contents of the first database of change into a format suitable for transfer to the central database stored on the central computer; restarting the processing of the audit trail files to create a second database of change stored on the remote computer; and transferring the processed contents of the first database of change to the central database stored on the central computer.
Claim 7
Independent Claim
134 words
A method for synchronizing the content of a central database stored on a central computer with the content of a remote database stored on a remote computer, comprising the steps of: processing the audit trail files stored on the remote computer to create a first database of change stored on the remote computer; stopping the processing of the audit trail files when the database of change reaches a size threshold; processing the contents of the first database of change into a format suitable for transfer to the central database stored on the central computer; restarting the processing of the audit trail files to create a second database of change stored on the remote computer; and transferring the processed contents of the first database of change to the central database stored on the central computer.
Claim 8
Dependent Claim
76 words
The method for synchronizing the content of a central database stored on a central computer with the content of a remote database stored on a remote computer of claim 5, wherein the step of stopping the processing of the audit trail files when the database of change reaches a size threshold comprises the step of stopping the processing of the audit trail files when the Image Table of the database of change reaches a size threshold.
Claim 9
Dependent Claim
83 words
The method for synchronizing the content of a central database stored on a central computer with the content of a remote database stored on a remote computer of claim 5, wherein the step of stopping the processing of the audit trail files when the Image Table of the database of change reaches a size threshold comprises the step of stopping the processing of the audit trail files when the Image Table reaches a size threshold of between approximately eight and approximately twenty megabytes.
Claim 10
Dependent Claim
101 words
The method for synchronizing the content of a central database stored on a central computer with the content of a remote database stored on a remote computer of claim 5, wherein the step of processing the contents of the first database of change comprises the step of building flat files from the data stored on the first database of change; and wherein the step of transferring the processed contents of the first database of change to the central database stored on the central computer comprises the step of transferring the flat files to the central database stored on the central computer.
Claim 11
Dependent Claim
41 words
The method for synchronizing the content of a central database stored on a central computer with the content of a remote database stored on a remote computer of claim 8, further comprising the step of dropping the first database of change.
Claim 12
Dependent Claim
99 words
The method for synchronizing the content of a central database stored on a central computer with the content of a remote database stored on a remote computer of claim 8, wherein the step of building flat files from the data stored on the first database of change further comprises the steps of, selecting a processor and an associated data storage device on the remote computer for building one or more flat files; determining whether the processor is operational; selecting the data from the first database of change; and building flat files if the processor is determined to be operational.
Claim 13
Dependent Claim
127 words
The method for synchronizing the content of a central database stored on a central computer with the content of a remote database stored on a remote computer of claim 8, wherein the step of building flat files from the data stored on the first database of change further comprises the steps of, selecting a first processor of several available processors and an associated data storage device on the remote computer for building one or more flat files; determining whether the first processor is operational; selecting among the several available substitute processors if it is determined that the first processor is nonoperational and repeating the selection until an operational processor is found; selecting the data from the first database of change; building flat files on the selected processor.
Claim 14
Dependent Claim
101 words
The method for synchronizing the content of a central database stored on a central computer with the content of a remote database stored on a remote computer of claim 8, wherein the step of building flat files from the data stored on the first database of change further comprises the steps of, selecting a processor and an associated data storage device for building one or more flat files; determining whether the data storage device has available space; selecting the data from the first database of change; and building flat files if the data storage device is determined to have available space.
Claim 15
Dependent Claim
39 words
The method for synchronizing the content of a central database stored on a central computer with the content of a remote database stored on a remote computer of claim 8, wherein the data storage device is a disk drive.
Claim 16
Dependent Claim
41 words
The method for synchronizing the content of a central database stored on a central computer with the content of a remote database stored on a remote computer of claim 8, wherein the data storage device is a tape drive storage device.
Claim 17
Dependent Claim
41 words
The method for synchronizing the content of a central database stored on a central computer with the content of a remote database stored on a remote computer of claim 8, wherein the data storage device is an optical disk storage device.
Claim 18
Dependent Claim
115 words
The method for synchronizing the content of a central database stored on a central computer with the content of a remote database stored on a remote computer of claim 8, wherein the step of building flat files from the data stored on the first database of change further comprises the steps of, selecting a processor and an associated data storage device for building one or more flat files; determining whether the data storage device has available space; determining whether the processor is operational; selecting the data from the first database of change; and building flat files if the data storage device is determined to have available space and the processor is determined to be operational.
Claim 19
Dependent Claim
131 words
The method for synchronizing the content of a central database stored on a central computer with the content of a remote database stored on a remote computer of claim 5, wherein the step of processing the contents of the first database of change comprises the step of building flat files from the data stored on the first database of change; and wherein the step of transferring the processed contents of the first database of change to the central database stored on the central computer comprises the steps of, determining whether the communications line between the central computer and the remote computer is operational; and transferring the flat files from the remote computer to the central database stored on the central computer across the communications line when the communications line becomes operational.
Claim 20
Dependent Claim
41 words
The method for synchronizing the content of a central database stored on a central computer with the content of a remote database stored on a remote computer of claim 17, further comprising the step of dropping the first database of change.
Claim 21
Independent Claim
160 words
A method for synchronizing the content of a central database stored on a central computer with the content of a remote database stored on a remote computer, comprising the steps of: processing the audit trail files stored on the remote computer to create a first database of change stored on the remote computer; stopping the processing of the audit trail files when the database of change reaches a size threshold; restarting the processing of the audit trail files to create a second database of change in the remote computer; selecting a CPU and an associated disk drive for building one or more flat files; determining whether the CPU is operational; determining whether the disk drive has available space; selecting the data from the first database of change; building a plurality of flat files if the CPU is determined to be operational and the disk drive is determined to have available space; and transferring the flat files to the central computer.
Claim 22
Independent Claim
160 words
A method for synchronizing the content of a central database stored on a central computer with the content of a remote database stored on a remote computer, comprising the steps of: processing the audit trail files stored on the remote computer to create a first database of change stored on the remote computer; stopping the processing of the audit trail files when the database of change reaches a size threshold; restarting the processing of the audit trail files to create a second database of change in the remote computer; selecting a CPU and an associated disk drive for building one or more flat files; determining whether the CPU is operational; determining whether the disk drive has available space; selecting the data from the first database of change; building a plurality of flat files if the CPU is determined to be operational and the disk drive is determined to have available space; and transferring the flat files to the central computer.
Claim 23
Dependent Claim
54 words
The method for synchronizing the content of a central database stored on a central computer with the content of a remote database stored on a remote computer of claim 19, further comprising the step of dropping the first database of change after successful receipt of the plurality of flat files by the central computer.
Claim 24
Dependent Claim
76 words
The method for synchronizing the content of a central database stored on a central computer with the content of a remote database stored on a remote computer of claim 19, wherein the step of stopping the processing of the audit trail files when the database of change reaches a size threshold comprises the step of stopping the processing of the audit trail files when the Image Table of the database of change reaches a size threshold.
Claim 25
Dependent Claim
83 words
The method for synchronizing the content of a central database stored on a central computer with the content of a remote database stored on a remote computer of claim 19, wherein the step of stopping the processing of the audit trail files when the Image Table of the database of change reaches a size threshold comprises the step of stopping the processing of the audit trail files when the Image Table reaches a size threshold of between approximately eight and approximately twenty megabytes.
Claim 26
Dependent Claim
54 words
The method for synchronizing the content of a central database stored on a central computer with the content of a remote database stored on a remote computer of claim 19, further comprising the step of dropping the first database of change after successful receipt of the plurality of flat files by the central computer.
Claim 27
Dependent Claim
89 words
The method for synchronizing the content of a central database stored on a central computer with the content of a remote database stored on a remote computer of claim 19, wherein the step of transferring the flat files to the central computer comprises the steps of, determining whether the data line between the central computer and the remote computer is operational; and transferring the flat files from the remote computer to the central database stored on the central computer across the data line when the data line becomes operational.
References Cited (Backward Citations)
US4558413A
Cited
US4882674A
Cited
US4714996A
Cited
US4853843A
Cited
US5155847A
Cited
US5495610A
Cited
US5263165A
Cited
US5274806A
Cited
US5452450A
Cited
US5032979A
Cited
US5440730A
Cited
US5317729A
Cited
US5481700A
Cited
US5404508A
Cited
US5544320A
Cited
US5561797A
Cited
US5560005A
Cited
US5561795A
Cited
US5590274A
Cited
US5649195A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2001-05-25 | 2001-11-24 | 2002-05-26 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2005-05-25 | 2005-11-24 | 2006-05-26 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2009-05-25 | 2009-11-24 | 2010-05-26 | $7700.00 | Window Closed / Lapsed |