Data processing: database and file management or data structures – Database design – Data structure types
Patent
1998-04-07
2000-11-21
Breene, John
Data processing: database and file management or data structures
Database design
Data structure types
707200, 707100, G06F 1730
Patent
active
061516082
ABSTRACT:
Method and system of the invention migrate data from one or more ASCII files and/or from one or more relational databases to one or more relational database tables without the need to write code. In doing so, the invention allows the user to define mapping templates and conditionals to assist in translating and transforming data values. The invention also enforces referential integrity, data dependencies, order of operations, and uniqueness constraints using a predefined set of migration rules templates that are based on the principles of relational design. The invention uses these mapping and migration rules templates to intelligently generate instructions for updating or populating relational database destination tables. The instructions control the data transfer, data translation, data transformation, data validation, foreign key insertion, and the addition of required codes and flags in the destination tables. A migration engine of the system includes a data map architect and an update processor which spawns the templates and migrates the data dynamically, utilizing the data definitions for the destination tables. In addition to supporting conversion efforts, the invention provides support for performing consolidation, restoration from an archive, migration to new instances, upgrading to a new release, adding bolt-ons and enhancements, and changing business requirements. The audit trail in the invention is complete enough that the entire migration process can be reversed without compromising the integrity of either the source or the destination application.
REFERENCES:
patent: 5278978 (1994-01-01), Demers et al.
patent: 5379419 (1995-01-01), Heffernan et al.
patent: 5416917 (1995-05-01), Adair et al.
patent: 5566332 (1996-10-01), Adair et al.
patent: 5596746 (1997-01-01), Shen et al.
patent: 5642505 (1997-06-01), Fushimi
patent: 5708828 (1998-01-01), Coleman
patent: 5745703 (1998-04-01), Cejtin et al.
patent: 5966704 (1999-10-01), Furegati et al.
patent: 5970490 (1999-10-01), Morgenstern
Breene John
Crystallize, Inc.
Robinson Greta L.
LandOfFree
Method and system for migrating data does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method and system for migrating data, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and system for migrating data will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-1266726