Schema Optimization and Conflict Mechanism in Relational Database System Migration

Jun XU,Hao DAI,Yong-qiang XIE,Meng XIAO,Bao-sheng LIU
DOI: https://doi.org/10.3321/j.issn:1000-6788.2007.11.017
2007-01-01
Abstract:In the process of database migration, effective preserving information resource with data integrity and accuracy is a critical problem. By analyzing existing migration techniques, we find these methods haven't effectively solved various conflicts occurring in the migration process and in result can't achieve migration with high quality. Based on research into schema and SQL syntax diversity in heterogeneous database, this paper designs an automatic conflict detecting and eliminating mechanism. This mechanism avoids conflict by effective adjusting on underlying conflict items. For wrapping structural adjustment to upper application, it proposes dynamic adjustment on operational request to assure veracity of database operation.
What problem does this paper attempt to address?