【作者】 李海波；

【导师】 孟军；

【作者基本信息】 大连理工大学 ， 计算机技术（专业学位）， 2015， 硕士

【摘要】 数据仓库技术已经经过多年的发展,在金融行业的应用已很普遍,国际市场上的几个大的数据仓库软件公司,提供了强大的存储服务器、大容量数据传输技术,为降低数据整合成本、提高数据利用效率提供了强大的软硬件保障。本文通过对数据仓库领域的研究,寻找一个可以有效解决大数据整合的数据仓库架构和实施方法,即数据仓库多层架构技术。ORACLE能够提供强大数据仓库并行数据库服务器和存储服务,思科提供了强大的数据传输交换机,大大降低数据整合的难度与实施周期。商业银行数据仓库系统是针对大型商业银行企业,进行大量业务系统数据整合的需求,提供一套强大的数据整合解决方案。商业银行数据仓库系统是一套分布式并行数据仓库系统,为各个业务部门、各分行、集团之间的数据进行整合,从技术实现跨地域、跨平台、跨系统的数据整合,从业务层面上屏蔽了数据共享壁垒。从业务数据需求人员和数据仓库服器两端,实现大数据的实时、高效、安全的共享传输。在深入研究数据仓库的实现原理、存储架构的基础上,结合商业银行的业务特点,以及金融业数据仓库系统特点,设计出适合银行业使用的数据仓库实现模型和部署方案,并在实施过程中不断优化,最终达到解决商业银行大数据量的整合问题。本文通过对数据仓库技术的研究,及商业银行数据仓库系统的数据需求分析,使用大容量存储技术、领先的数据整合模型、并行数据库服务器、大宽带网络传输技术,设计并实现商业银行数据仓库系统的大部分功能。并根据用户反馈,进行性能优化。更多还原

【Abstract】 Data warehouse technology is through the development at home and abroad for many years, used in financial industry has been very common, the international market of a few large data warehouse software company, providing large capacity data transmission technology in storage server, powerful, in order to reduce the cost of data integration, provides the hardware and software security powerful, improves data utilization efficiency. Through the research on the field of data warehouse, looking for an effectively data warehouse architecture and implementation method of large data integration theory, namely the data warehouse multi architecture technology. ORACLE can provide powerful data storage and parallel database server and storage service, Cisco provides data transmission, greatly reduces the difficulty of data integration and the implementation cycle.Commercial bank data warehouse systems for the enterprise of large commercial banks can be used to provide powerful set of data integration solutions for group data integration business models. Commercial bank data warehouse system is a distributed and parallel data warehouse system, integrate the data between the various business departments, branches and the group, use technology to implement data integration between cross regional, cross platform and cross system. Both ends of the business data requirements of personnel and data warehouse server require a large amount of data transmission in real time, efficiency and a secure transport. In a more in-depth study of the data warehouse implementation principle, storage infrastructure, service characteristics of commercial banks and financial data warehouse system characteristic and deployment scheme along with data warehouse resulted in the banking industry to solve the commercial banks big data integration problem.This paper studies the technology of data warehouse, and the commercial bank data warehouse system data requirements analysis, using large capacity storage technology, the leading data integration model, parallel database server and broadband network transmission technology to design and implement commercial bank data warehouse system features. And track the use effect of typical users along with program performance tuning.更多还原