Invention Grant
US07991742B2 System for detecting migration differences of a customized database schema
失效
用于检测定制数据库模式的迁移差异的系统
- Patent Title: System for detecting migration differences of a customized database schema
- Patent Title (中): 用于检测定制数据库模式的迁移差异的系统
-
Application No.: US12353216Application Date: 2009-01-13
-
Publication No.: US07991742B2Publication Date: 2011-08-02
- Inventor: Peng Li , Ke Fei Wang , Bing Jiang Sun
- Applicant: Peng Li , Ke Fei Wang , Bing Jiang Sun
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Konrad Raynes & Victor LLP
- Agent Janaki K. Davda
- Main IPC: G06F17/00
- IPC: G06F17/00

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.
Public/Granted literature
- US20090119319A1 SYSTEM FOR DETECTING MIGRATION DIFFERENCES OF A CUSTOMIZED DATABASE SCHEMA Public/Granted day:2009-05-07
Information query