| 餐饮决策支持系统中OLAP数据仓库的设计与实现 |
| |
| 引用本文： | 林璇,冯健文,陈启买.餐饮决策支持系统中OLAP数据仓库的设计与实现[J].计算机工程与设计,2006,27(21):4142-4144,4156. |
| |
| 作者姓名： | 林璇 冯健文 陈启买 |
| |
| 作者单位： | 1. 韩山师范学院,数学与信息技术学院,广东,潮州,521041
2. 华南师范大学,计算机学院,广东,广州,510631 |
| |
| 摘 要： | 餐饮联机事务处理系统（OLTP）能规范企业业务流程和提高业务运转效率，但对企业决策的支持能力差，因此建立基于餐饮企业业务数据集的后台决策支持系统（DSS）是有必要的。提出了采用数据仓库，OLAP和数据挖掘技术建立餐饮决策支持系统的思路，重点讨论系统的体系结构设计，基于原型法，从开始的数据仓库模型设计，数据的抽取、转换和加载及多维数据集的设计，到最后的OLAP分析，对系统的实施进行了探讨。
|
| 关 键 词： | 数据仓库 决策支持系统 多维数据集 餐饮业 |
| 文章编号： | 1000-7024（2006）21-4142-03 |
| 收稿时间： | 2005-09-29 |
| 修稿时间： | 2005-09-29 |
Design and implementation of OLAP data warehouse in catering decision support system |
| |
| LIN Xuan,FENG Jian-wen,CHEN Qi-mai.Design and implementation of OLAP data warehouse in catering decision support system[J].Computer Engineering and Design,2006,27(21):4142-4144,4156. |
| |
| Authors: | LIN Xuan FENG Jian-wen CHEN Qi-mai |
| |
| Affiliation: | 1, College of Math and Information Technology, Hanshan Normal University, Chaozhou 521041, China; 2. College of Computer Science, South China Normal University, Guangzhou 510631, China |
| |
| Abstract: | Catering on-line transaction processing system(OLTP) help catering enterprises manager business operations and improve efficiency,but support enterprise decision is of bad.Therefore it is necessary to establish the decision support system(DSS) based on catering operationdataset.It is putforward firstlythat DSS is established by data warehouse(DW),on-line analysis processing(OLAP) and data mining(DM).Then the design of system architecture is mainly discussed.Lastly,how the catering DSS implements from initial design of DW models,to data ETL,design of multidimensional datasets and OLAP based on prototype method is discussed. |
| |
| Keywords: | OLAP |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
