银行操作数据存储系统的分析与应用
摘要
随着中国金融业体制改革的不断深入和开放,金融产品越来越丰富。相关的业务运行系统不断增多,这些系统各自独立或重叠,数据源也相应增多。这样造成了后台管理的诸多不便。为有效地解决目前各系统存在的数据孤岛、数据表现形式各异和系统接口繁杂等问题,总行建立了统一的操作数据存储系统各模型。
本文所描述的内容,主要对总行数据模型进行分析,包括基础数据层、汇总数据层和数据集市层,充分研究其设计思路。结合分行实际,对各业务部门进行需求分析,建立了分行操作数据存储模型。将分行操作数据存储模型作为数据中心为各应用系统提供数据共享服务,并在此模型的基础上实现了各种应用。为分行以后开发管理分析类应用奠定了良好的基础。
Financial products have now become richer with the rapid development and reform of the financial system. Besides, more relevant business systems which are independent or overlapped have run into operation. So data sources are increased largely and it's also complicated for system management. To solve the isolated island of data among different systems, narrow the differences of data forms and ease the complex interface, united data models were established by bank of headquarters.
In this thesis, data models are analyzed, including foundation data model, aggregation data model, and market data model. Combining with the practice, Operational Data Storage of Branch was built in accordance with the demand analysis of every business department. AS the main data source and a data share platform, ODSB provides most service. Besides, many kinds of applications are deployed, which lay good foundation for the branch to develop new applications of management and analysis.
本文所描述的内容,主要对总行数据模型进行分析,包括基础数据层、汇总数据层和数据集市层,充分研究其设计思路。结合分行实际,对各业务部门进行需求分析,建立了分行操作数据存储模型。将分行操作数据存储模型作为数据中心为各应用系统提供数据共享服务,并在此模型的基础上实现了各种应用。为分行以后开发管理分析类应用奠定了良好的基础。
Financial products have now become richer with the rapid development and reform of the financial system. Besides, more relevant business systems which are independent or overlapped have run into operation. So data sources are increased largely and it's also complicated for system management. To solve the isolated island of data among different systems, narrow the differences of data forms and ease the complex interface, united data models were established by bank of headquarters.
In this thesis, data models are analyzed, including foundation data model, aggregation data model, and market data model. Combining with the practice, Operational Data Storage of Branch was built in accordance with the demand analysis of every business department. AS the main data source and a data share platform, ODSB provides most service. Besides, many kinds of applications are deployed, which lay good foundation for the branch to develop new applications of management and analysis.
引文
[1]王珊等 数据仓库技术与联机分析处理科学出版社1998.6
[2]W.H.Inmon/王志海等译Building the Data Warehouse机械工业出版社2000.5
[3]黄宏涛,陈阳;数据挖掘在客户关系管理中的应用[J];中国西部科技;2005年07期;40-41
[4]项军,雷英杰;数据仓库技术与应用[J];计算机与现代化;2004年11期
[5]Jiawei Han等著范明等译:数据挖掘概念与技术机械工业出版社,2004
[6]Alex Berson等著贺奇等译:构建面向CRM的数据挖掘应用人们邮电出版社,2001
[7]苏新宁杨建林邓三鸿等数据挖掘理论与技术[M]北京科学技术文献出版社,2003
[8]Tom Soukup,Ian Davidson著,朱建秋,蔡伟杰译.可视化数据挖掘[M].北京:电子工业出版社,2004
[9]张宁,贾自艳,史忠植。数据仓库中ETL技术的研究。计算机工程与应用,2002(24)
[10]阳富民 刘军平:统一认证技术研究与实现.计算机工程与科学2007(2)
[11]胡胜丰 蒋平:基于LDAP的企业统一资源管理研究.微计算机应用2008(3)
[12]李建中,王珊.《数据库系统原理(第2版)》电子工业出版社,2004.9
[13]MichaelCorey MichaelAbbey/希望图书创作室译SQL Server 7 Data Warehousing北京希望电子出版社2000.1
[14][美]Matthew Hart Scott Jesse著 刘永健 也令梅 译Oracle Database 10g高可用性实现方案 清华大学出版社2005.5
[15][美]Stephen G.Kochan著张小潘译C语言编程电子工业出版社2007.3
[16][美]John Resig著 陈贤安 江疆译Pro JavaScript Techniques精通JavaScript人民邮电出版社2008.4
[17]善鹏杨波:基于Linux的LDAP应用环境研究与目录服务实现信息技术与信息化2006(5)
[18]廖卫东,等编著.Java程序设计实用指南.北京:机械工业出版社,1996;(10)
[19]美Jamie Jaworski著.曹康,等译.Java开发指南.北京:中国水利水电出版社,1996
[20]施伯乐,丁宝康,汪卫,数据库系统教程[M],高等教育出版社,2005 7第二版。
[2]W.H.Inmon/王志海等译Building the Data Warehouse机械工业出版社2000.5
[3]黄宏涛,陈阳;数据挖掘在客户关系管理中的应用[J];中国西部科技;2005年07期;40-41
[4]项军,雷英杰;数据仓库技术与应用[J];计算机与现代化;2004年11期
[5]Jiawei Han等著范明等译:数据挖掘概念与技术机械工业出版社,2004
[6]Alex Berson等著贺奇等译:构建面向CRM的数据挖掘应用人们邮电出版社,2001
[7]苏新宁杨建林邓三鸿等数据挖掘理论与技术[M]北京科学技术文献出版社,2003
[8]Tom Soukup,Ian Davidson著,朱建秋,蔡伟杰译.可视化数据挖掘[M].北京:电子工业出版社,2004
[9]张宁,贾自艳,史忠植。数据仓库中ETL技术的研究。计算机工程与应用,2002(24)
[10]阳富民 刘军平:统一认证技术研究与实现.计算机工程与科学2007(2)
[11]胡胜丰 蒋平:基于LDAP的企业统一资源管理研究.微计算机应用2008(3)
[12]李建中,王珊.《数据库系统原理(第2版)》电子工业出版社,2004.9
[13]MichaelCorey MichaelAbbey/希望图书创作室译SQL Server 7 Data Warehousing北京希望电子出版社2000.1
[14][美]Matthew Hart Scott Jesse著 刘永健 也令梅 译Oracle Database 10g高可用性实现方案 清华大学出版社2005.5
[15][美]Stephen G.Kochan著张小潘译C语言编程电子工业出版社2007.3
[16][美]John Resig著 陈贤安 江疆译Pro JavaScript Techniques精通JavaScript人民邮电出版社2008.4
[17]善鹏杨波:基于Linux的LDAP应用环境研究与目录服务实现信息技术与信息化2006(5)
[18]廖卫东,等编著.Java程序设计实用指南.北京:机械工业出版社,1996;(10)
[19]美Jamie Jaworski著.曹康,等译.Java开发指南.北京:中国水利水电出版社,1996
[20]施伯乐,丁宝康,汪卫,数据库系统教程[M],高等教育出版社,2005 7第二版。