基于DB2的某银行ODS系统设计研究

发布时间：2019-03-13 14:29

【摘要】：本论文在分析了已经实施的ODS系统基础上，以现有的数据仓库技术以及目前在DB2数据库中的技术实现，介绍了ODS系统在银行中数据模型的设计思路及难点，并提出提出了设计方案。在阐明该系统的模型架构的基础上，阐述了根据银行业务系统如何分层设计。实现了银行ODS系统模型设计的标准化。目前该模型已经在相关银行实施运用。本论文完成了以下几项工作：（1）模型架构的研究，并用图文并茂的方式将银行ODS模型架构阐述，以便于以后类似的项目实施借鉴。（2）数据模型设计研究，本论文对三个层次做了详细研究。ODM层是最基础的一层，从业务系统直接抽取到数据仓库。抽取过来是增量数据，因此在ETL过程中对源业务系统中全量卸载的数据需要进行增量剥离。SDM和ODM类似，其结构采用类似业务系统中的结构，通过对ODM数据清洗、转换、编码标准化等，实现数据标准化，通过系统调研并对需要标准化编码的字段进行分类分析。（3）详细设计研究，FDM层是最重要的一层，和银行的其他业务系统也有很大关联，因此FDM的模型设计的总体思路是必须能够满足对银行企业多种业务分散的数据源进行有效整合，便于对银行业务数据按主题概念进行理解和规范，对不同类型的数据进行统一管理，对不同类型的应用统一进行支持。
[Abstract]:Based on the analysis of the ODS system that has been implemented, this paper introduces the design ideas and difficulties of the data model of the ODS system in the bank based on the existing data warehouse technology and the implementation of the current technology in the DB2 database. At the same time, the design scheme is put forward. On the basis of elucidating the model structure of the system, this paper expounds how to design the bank business system according to the hierarchy. The standardization of the model design of bank ODS system is realized. At present, the model has been implemented in the relevant banks. The following works have been completed in this thesis: (1) the research of the model architecture and the illustration of the bank ODS model architecture in order to facilitate the future implementation of similar projects. (2) the design of data model, this paper makes a detailed study of three levels. ODM layer is the most basic layer, directly extracted from the business system to the data warehouse. The extracted data is incremental data, so in the process of ETL, the data unloaded in the source business system needs to be split incrementally. SDM and ODM are similar, its structure is similar to that in the service system, by cleaning and transforming the ODM data. Coding standardization, data standardization, through systematic investigation and classification of the fields that need standardized coding. (3) detailed design study, the FDM layer is the most important layer, and the other business systems of the bank are also closely related. Therefore, the overall idea of FDM model design is that it must be able to satisfy the effective integration of diversified business data sources of banks and enterprises, which is convenient for understanding and standardizing the banking business data according to the subject concept. Unified management of different types of data and support for different types of application unification.
【学位授予单位】：电子科技大学
【学位级别】：硕士
【学位授予年份】：2013
【分类号】：TP333;TP311.13

【参考文献】