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

Schema Optimization and Conflict Mechanism in Relational Database System Migration

作　　者：徐军[1] 戴浩 谢永强 肖孟[1] 刘宝生[1] 

机构地区：[1]解放军理工大学通信工程学院,南京210007 [2]中国电子系统工程公司研究所,北京100039

出　　处：《系统工程理论与实践》2007年第11期124-129,共6页Systems Engineering-Theory & Practice

基　　金：国家高技术研究发展计划课题:基于自主安全操作系统的军事信息网安全认证与信息发布(2003AA1Z2250)

摘　　要：在深入研究异构数据库在模式和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.

关 键 词：数据库移植 模式冲突 模式映射 

分 类 号：TP311.13[自动化与计算机技术—计算机软件与理论]