关系数据库系统移植中模式优化与冲突机制的设计

Schema Optimization and Conflict Mechanism in Relational Database System Migration

在深入研究异构数据库在模式和SQL语法等方面差异的基础上,设计了可扩展的冲突检查和处理机制,通过对潜在的冲突元素进行针对性调整避免模式冲突的不利影响.同时为了向上层应用程序屏蔽数据库移植中的模式调整,提出了在运行期间动态调整操作请求来保证数据库操作的准确性.

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.