Research And Implementation Of ODS In The Banking Industry System

After years of financial electronic construction, banks have accumulated large amounts of the bank's business management activity data, however, due to the early construction of the information is a gradually process, a lack of unified planning and information standards, caused to disunity of data source, data island, inconsistent data, data quality is not high, low security problems hampered the operation and management of the bank intelligent analysis, the subject of the current study is based on data storage drawbacks of the banks, focus on the ODS system in the banking application.In this paper, in the full understanding of Data warehouwe and Operational Data Store (ODS) on the basis of the theory, the ODS and Data warehouwe were compared, emphasized ODS's function and advantage. And regarding the present situation of the banking, the original DB-DW architecture, by adding ODS, which formed a DB-ODS-DW's three-tier architecture.According to the banking case, This paper puts forward the structure of data process by ODS in banking, data storage solutions, and ETL architecture design, analysis the data storage in the Data Quality Control, and finally study the design ofextensibility design.