Data processing: database and file management or data structures – Database design – Data structure types
Patent
1996-07-23
1999-11-30
Amsbury, Wayne
Data processing: database and file management or data structures
Database design
Data structure types
707203, 707 10, G06F 1730
Patent
active
059959800
ABSTRACT:
The present invention provides a new, high-performance system and method for updating databases or other data compilations with changes entered in a source database or data compilation. Updates are preprocessed to reduce system update demands while increasing update flexibility for remote processing sites. Data update records are captured or collected and extracted into one or more channel or other criterion-specific batches. Transaction boundaries within a batch are collapsed, and the records coalesced into a package comprising a sequence of updates that reflect the cumulated impact of the extracted records. In a preferred embodiment, the batched records are sorted by extracted sort key entries and the package is converted to the physical format of respective targets. The created update package is, therefore, organized and physically formatted in correspondence with the target database. The update package is then directly applied to the target database without resort to the traditional front door processing through the local database manager. The processing typically required in database update replication is, thereby, avoided and the update process significantly streamlined. The update packages may be moved to targets by a variety of methods. The packages can be conveyed across network or Internet connections or between disconnected computers. The packages may be stored in computer readable media such as disks or CD ROMs, for example, from which the packages may be accessed by target systems. The update packages may also be made available through modems to field users or clients to allow fiexible update scheduling. The invention results in a high performance, database update system and method that significantly reduces system update burdens while increasing update flexibility and minimizing impacts from failures during updating. Updates are performed in significantly less time with a system and method that requires little administrative oversight and minimal personnel training.
REFERENCES:
patent: 4631673 (1986-12-01), Haas et al.
patent: 4714992 (1987-12-01), Gladney et al.
patent: 4714995 (1987-12-01), Materna et al.
patent: 4809170 (1989-02-01), Leblang et al.
patent: 5357629 (1994-10-01), Dinnis et al.
patent: 5600832 (1997-02-01), Eisenberg et al.
patent: 5649195 (1997-07-01), Scott et al.
patent: 5737601 (1998-04-01), Jain et al.
patent: 5819251 (1998-10-01), Kremer et al.
Olson Jack E.
Price Thomas G.
Amsbury Wayne
Denko J. Scott
LandOfFree
System and method for database update replication does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with System and method for database update replication, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for database update replication will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-1687376