Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2000-11-21
2009-11-17
Robinson, Greta L (Department: 2169)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C711S161000
Reexamination Certificate
active
07620665
ABSTRACT:
A method and system for migrating data between databases is provided. Metadata is obtained from a source database and used to determine the manner in which the data within the source database should be migrated to a target database. The metadata provides a mechanism for structuring queries to retrieve the data within the source database in a generic manner, thereby providing a generic determination of the structure of the data to be migrated. The dependencies among tables in the source database are discovered, thereby providing an order to the migration operations to be performed when migrating the data. This order ensures that the data can be migrated correctly in the presence of referential integrity (foreign key) constraints. In addition, custom mapping operations may be performed during the migration operations so that the data from the source database is modified before writing the data to the target database.
REFERENCES:
patent: 5133068 (1992-07-01), Crus et al.
patent: 5537585 (1996-07-01), Blickenstaff et al.
patent: 5566332 (1996-10-01), Adair et al.
patent: 5630092 (1997-05-01), Carreiro et al.
patent: 5642505 (1997-06-01), Fushimi
patent: 5644766 (1997-07-01), Coy et al.
patent: 5680640 (1997-10-01), Ofek et al.
patent: 5737549 (1998-04-01), Hersch et al.
patent: 5758150 (1998-05-01), Bell et al.
patent: 5819086 (1998-10-01), Kroenke
patent: 5819254 (1998-10-01), Kawai
patent: 5966717 (1999-10-01), Sass
patent: 6151608 (2000-11-01), Abrams
patent: 6240422 (2001-05-01), Atkins et al.
patent: 6269382 (2001-07-01), Cabrera et al.
patent: 6289357 (2001-09-01), Parker
patent: 6304882 (2001-10-01), Strellis et al.
patent: 6571258 (2003-05-01), Borowsky et al.
patent: 6591272 (2003-07-01), Williams
patent: 6615253 (2003-09-01), Bowman-Amuah
patent: 6633878 (2003-10-01), Underwood
patent: 6636876 (2003-10-01), Ishihara et al.
patent: 6874141 (2005-03-01), Swamy et al.
patent: 7080085 (2006-07-01), Choy et al.
“Object Framework for Database Management and Connectivity”, Disclosure #41393,Research Disclosure, p. 1240, Sep. 1998.
George Joseph Mulavelil
Krychniak Piotr
International Business Machines - Corporation
LaBaw Jeffrey S.
Robinson Greta L
Yee & Associates P.C.
LandOfFree
Method and system for a generic metadata-based mechanism to... 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 a generic metadata-based mechanism to..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and system for a generic metadata-based mechanism to... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4063096