| 基于数据仓库和OLAP技术的证券交易系统的实现方案研究 |
| |
| 引用本文： | 谷岩.基于数据仓库和OLAP技术的证券交易系统的实现方案研究[J].计算机工程与应用,2004,40(31):215-217. |
| |
| 作者姓名： | 谷岩 |
| |
| 作者单位： | 广州大学,广州,510091 |
| |
| 摘 要： | 数据仓库和联机分析处理(OLAP)技术是信息技术领域的新兴技术,而如何应用到证券交易中是证券业面临的问题。建立证券交易数据仓库并使用OLAP技术,可以将大量源数据有效地转化为有用的知识信息,并服务于决策过程。基于数据仓库的证券交易系统就是在面向信息处理的联机事务处理(OLTP)系统的基础上并引入数据仓库和OLAP技术而发展起来的。论文结合证券交易业务提出了系统实现的解决方案,并给出了基于证券交易业务的数据仓库的体系结构、逻辑模型、粒度模型,以及基于证券交易业务的联机分析处理(OLAP)系统的实现方法。
|
| 关 键 词： | 证券交易 数据仓库 联机分析处理 粒度模型 |
| 文章编号： | 1002-8331-(2004)31-0215-03 |
The Research of Implement Solution of Stock Exchange System Based on Data Warehouse and OLAP |
| |
| Gu,Yan.The Research of Implement Solution of Stock Exchange System Based on Data Warehouse and OLAP[J].Computer Engineering and Applications,2004,40(31):215-217. |
| |
| Authors: | Gu Yan |
| |
| Abstract: | 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. |
| |
| Keywords: | stock exchange data warehouse OLAP granularity model |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
