| 决策支持系统中OLAP的设计与实现 |
| |
| 引用本文： | 李雅莉. 决策支持系统中OLAP的设计与实现[J]. 宝鸡文理学院学报(自然科学版), 2009, 29(2): 67-71 |
| |
| 作者姓名： | 李雅莉 |
| |
| 作者单位： | 宝鸡文理学院,电子电气工程系,陕西,宝鸡,721007 |
| |
| 摘 要： | 目的设计和实现对数据仓库中的信息进行决策分析的OLAP。方法以零售企业销售预测为切入点,研究决策支持系统中OLAP的设计。结果建立了用来进行OLAP分析的多维数据集,并对多维数据集中的数据用切片、切块、钻取和旋转等方式进行分析,用MDX多维查询语言对多维数据集中的数据进行复杂查询,提出了对OLAP分析数据展现的3种解决方案。结论在研究决策支持系统中OLAP的基础上,建立和实现了对数据仓库进行决策分析的OLAP。
|
| 关 键 词： | OLAP 多维数据集 MDX |
OLAP design and realization in decision support system |
| |
| LI Yali. OLAP design and realization in decision support system[J]. Journal of Baoji College of Arts and Science(Natural Science Edition), 2009, 29(2): 67-71 |
| |
| Authors: | LI Yali |
| |
| Affiliation: | Dept.Electronics.& Elect.Engn.;Baoji Univ.Arts & Sci.;Baoji 721007;Shaanxi;China |
| |
| Abstract: | Aim The purpose of the article is to design and realize OLAP which can analyze the information in data warehouse for decision.Methods Taking the retail enterprise sales forecasting as starting point,OLAP projects in decision support system are planned.Results The multi-dimensional data set for OLAP analysis is built.After researching it by slice,dice,drill and rotation enquiring it in multi-dimensional query language MDX,the three solutions which can unfold OLAP analysis data are put forward.Conclusion OLAP... |
| |
| Keywords: | OLAP multi-dimensional data set MDX |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
