Detecting migration differences of a customized database schema

Details Detecting migration differences of a customized database schema Detecting migration differences of a customized database schema

2006-06-26

2009-02-24

Lee, Wilson (Department: 2163)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000

Reexamination Certificate

active

07496596

ABSTRACT:
Provided is a database schema migration difference detecting technique for detecting differences of a customized database schema before and after database migration by using XML technology, including: extracting a first database schema from a fresh database of a release and saving the first database schema in a first XML file; extracting a customized database schema from a customized database of the release and saving the customized database schema in a second XML file; comparing the first and second XML files, filtering the identical content in the first and second XML files and saving differences in a delta XML file; and comparing the delta XML file with a new database to detect a state of the customized database schema after migration. The detecting state indicates whether there is any loss or change in the customized database schema after migration, as well as, conflicts with the database schema in a database of a new release.

REFERENCES:
patent: 6772180 (2004-08-01), Li et al.
patent: 6792605 (2004-09-01), Roberts et al.
patent: 7281018 (2007-10-01), Begun et al.
patent: 7379978 (2008-05-01), Anderson et al.
patent: 2004/0153469 (2004-08-01), Keith-Hill
patent: 2004/0153968 (2004-08-01), Ching et al.
patent: 2004/0194016 (2004-09-01), Liggitt
patent: 2004/0268230 (2004-12-01), Liu et al.
patent: 2005/0204347 (2005-09-01), Jurkiewicz et al.
patent: 2007/0220065 (2007-09-01), Coyle et al.
Bychkov, Y. and J.H. Jahnke, “Interactive Migration of Legacy Databases to Net-Centric Technologies”,Proceedings of the Eighth Working Conference on Reverse Engineering, Oct. 2001, pp. 328-334.
Fernandes, H. and G. Hu, “Migration of Relational Databases”,Proceedings of the ISCA Seventeenth International Conference on Computers and their Applications, Apr. 2002, pp. 188-191.
IBM Corporation, “A Process for Migration of Database Application to Enterprise Java Environment”,IBM Research Disclosure, No. 448117, Aug. 2001, pp. 1390-1391.
Lau, T.C., J. Lu, E. Hedges, and E. Xing, “Migrating E-Commerce Database Applications to an Enterprise Java Environment”,Proceedings of the 2001 Conference of the Centre for Advanced Studies on Collaborative Research, Nov. 2001, 11 pgs.
Lee, T., M. Chams, R. Nado, S. Madnick, and M. Siegel, “Information Integration with Attribution Support for Corporate Profiles”,Proceedings of the ACM Conference on Information and Knowledge Management, Nov. 1999, pp. 423-429.
Stonebraker, M. and J.M. Hellerstein, “Content Integration for E-Business”,Proceedings of the ACM SIGMOD International Conference on Management of Data, May 2001, pp. 552-560.

Affiliated with

Also associated with

Rating

Detecting migration differences of a customized database schema does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Detecting migration differences of a customized database schema, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Detecting migration differences of a customized database schema will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4059446