基于.NET的通用数据库转换系统的设计与实现  

Design and Implementation of A Universal Database Conversion System Based on .NET

作　　者：王美琴[1] WANG Mei-qin(Zhejiang Tongji Vocational College of Science and Technology, Hangzhou 311231, China)

机构地区：[1]浙江同济科技职业学院,浙江杭州311231

出　　处：《中国非金属矿工业导刊》2017年第4期50-53,60,共5页China Non-Metallic Minerals industry

摘　　要：在信息化时代,企业面对爆发式的数据增长和各种新应用的出现,随着数据库应用环境复杂性的增加,数据库的结构和管理系统发生很大的变化,而历史数据的价值不容忽视,因此企业越来越重视不同数据库的数据转换问题。本文针对现有数据转换系统的研究现状与存在问题,在结合ADO.NET与XML的基础上,设计了一种灵活、通用、高效、可靠的通用数据库转换系统。系统分为数据库配置与转换两大功能模块,用户通过简单的交互操作就可以完成复杂的数据库之间的数据迁移与数据结构转换。本系统已在某水利信息系统升级中得到了实际应用。In the digital age, rapid data growth and adoption of latest applications are leading to growing environmental complex- ity and fundamental changes in the database structure and managementsystem of commercial corporate databases. Meanwhile, the value of historical data should not be ignored. Therefore,corporations are putting more and more efforts into migrating data across different databases. To analyze the problems with the current database conversion system, we designed an agile,universal, efficient and reliable database conversion system based on ADO.NET and XML. The system is divided into two function modules： database configuration and conversion. With this system, the users would be able to complete data migration and data structure conversion across complex databases through simple interactive operations. The system has already been applied to upgrade a database of Water Resources Bureau.

关 键 词：数据转换 数据迁移 ADO.NET XML 

分 类 号：TP392[自动化与计算机技术—计算机应用技术]