基于数据仓库的数据转换服务(DTS)技术的应用

数据仓库系统是在学校各部门系统的基础上发展而来的,其内部存储的数据来自于事务处理的各个系统和外部数据源。因为学校的业务系统是在不同时期、不同背景、面对不同应用、不同开发人员等各种客观前提下建立的,其数据结构、存储平台、系统平台均存在很大的异构性,所以学校各种源数据缺少统一的标准,数据难以转化为有用的信息,原始数据的不一致导致决策时可信度的降低。本论文着重介绍了在数据仓库中利用数据转换服务(DTS)技术对于不同的数据源的数据进行转换,使得最终的数据实现完整性和一致性的统一。

The Application of DTS Technology on the Basis of the Data Warehouse

The data warehouse system develops in the school's various departments system,Its interior saves the data comes from each system and exterior data pool which processes to business. But in the school various sources data lacks the unification the standard and its data transforms with difficulty as the useful information, the primary data no uniformity causes when the decision-making its confidence level reducing, because the school operational channel is in the different time, the different background, facing the different application, the different development personnel and so on under each kind of objective premise establishes, its construction of data, the platform of saving, the system platform has the very big isomerism. The paper emphatically introduced has carried on the transformation in the data warehouse regarding the different data pool data using the DTS may realize data conversion, caused the final data to realize the integrity and the uniform unification.