【摘要】 以整合银行数据为例,提出了数据处理的二级架构形式。指出数据处理的概念模型设计、数据源分析和数据抽取转换的方法策略。以目标数据为依据,针对数据源中存在的冗余数据和语义冲突数据、不完整数据和错误数据以及格式或定义不一致的数据分别给出清洗的业务规则,使用SQL Server的DTS工具予以实现并上线使用。更多还原

【Abstract】 Take the integrating bank data as examples,bringing forward a two-level framework for data process.Indicate the method and strategy of concept model design,data sources analysis and data extraction and transformation in data process.According to the target data,give the business rules respectively to the redundancy and semantic conflict data,incomplete and error data,format or definition inconsistent data existing in data sources.The system has been realized by using the SQL Server DTS.更多还原