|
系统工程理论与实践 2007
Schema Optimization and Conflict Mechanism in Relational Database System Migration
|
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.