摘要
针对汽车检测线控制系统中数据库和数据库表异构现象明显的现状,研究了一种基于DTS的数据源转换技术。首先介绍了SQL Server中用于数据转换的软件组件DTS,分析了异构数据源转换的关键技术;然后利用汽车检测线数据库设计时的各种信息,包括各个表、字段的含义以及数据类型、数据值的约束条件等,通过DTS图形化设计器设计了汽车检测线异构数据源的DTS转换包;最后通过前端VB.net程序调用DTS包对象的Execute方法运行DTS转换包,实现了汽车检测线Access数据源到SQL Server数据源的转换,达到了统一和规范汽车检测线数据源的目的。
In view of various isomerism existed in vehicle inspection control systems, the data source conversion technology based on DTS was studied. Firstly, the component DTS for data conversion in SQL Server was introduced and the key technology of the transformation of heterogeneous data sources was analyzed. Then, DriPS conversion package of heterogeneous data sources of the vehicle inspection was designed via DTS Designer by a variety of information available in the process of the design of vehicle inspection database, including tables, meaning of fields and types of data, constraints of data value, etc. Finally, DTS conversion package runs successfully through calling the Execute DTS Package object method via front-end VB.net program, which not only realizes the conversion from Access data sources to SQL Server data sources of vehicle inspection line, but standardizes the vehicle inspection data source as well.
出处
《中国测试》
CAS
北大核心
2012年第4期79-82,共4页
China Measurement & Test
关键词
信息处理技术
异构数据源
转换
汽车检测线
Information processing technology
Heterogeneous data sources
Transformation
Vehicleinspection system