摘要
数据仓库和联机分析处理(OLAP)技术是信息技术领域的新兴技术,而如何应用到证券交易中是证券业面临的问题。建立证券交易数据仓库并使用OLAP技术,可以将大量源数据有效地转化为有用的知识信息,并服务于决策过程。基于数据仓库的证券交易系统就是在面向信息处理的联机事务处理(OLTP)系统的基础上并引入数据仓库和OLAP技术而发展起来的。论文结合证券交易业务提出了系统实现的解决方案,并给出了基于证券交易业务的数据仓库的体系结构、逻辑模型、粒度模型,以及基于证券交易业务的联机分析处理(OLAP)系统的实现方法。
Data Warehouse and Online Analytical Processing(OLAP)are new technology in information technology.It is a problem to be faced that how to use these technology to stock exchange system.If data warehouse and OLAP are used in stock exchange system,a lot of source data can be transformed to useful information and the information can be used in the decision process.Stock exchange system based on data warehouse is developed on the basis of Online Transaction Processing(OLTP)and by importing Data Warehouse and OLAP.The paper presents the implement solution of stock exchange system,the structure,logic model and granularity model of data warehouse.Also the implement method of OLAP based on stock exchange is discussed.
出处
《计算机工程与应用》
CSCD
北大核心
2004年第31期215-217,共3页
Computer Engineering and Applications
