Method and system for a generic metadata-based mechanism to...

Data processing: database and file management or data structures – Database design – Data structure types

Reexamination Certificate

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

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.

LandOfFree

Say what you really think

Search LandOfFree.com for the USA inventors and patents. Rate them and share your experience with other people.

Rating

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.

Rate now

     

Profile ID: LFUS-PAI-O-4063096

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.