作者投稿和查稿 主编审稿 专家审稿 编委审稿 远程编辑

计算机工程 ›› 2007, Vol. 33 ›› Issue (14): 66-68,8. doi: 10.3969/j.issn.1000-3428.2007.14.023

• 软件技术与数据库 • 上一篇    下一篇

基于DW+OLAP+DM的超市销售决策支持系统

薛 红,王 敏   

  1. (北京工商大学信息工程学院,北京 100037)
  • 收稿日期:1900-01-01 修回日期:1900-01-01 出版日期:2007-07-20 发布日期:2007-07-20

Supermarket Sale DSS Based on DW+OLAP+DM

XUE Hong, WANG Min   

  1. (College of Information Engineering, Beijing Technology and Business University, Beijing 100037)
  • Received:1900-01-01 Revised:1900-01-01 Online:2007-07-20 Published:2007-07-20

摘要: 结合超市的销售信息设计和开发了C/S结构的基于数据仓库、联机分析和数据挖掘技术的超市销售决策支持系统,从应用的角度介绍了数据仓库的构建过程、联机分析处理技术的实现。数据挖掘模块通过分析商品销售记录,寻求最佳的货架摆放布局。通过对会员资料的分析,帮助制定会员卡服务策略和促销方案,更好地适应顾客,留住固定的消费群。

关键词: 数据仓库, OLAP, 数据挖掘, 决策支持系统

Abstract: With supermarket sale data, the supermarket sale DSS of C/S framework is designed and developed based on data warehouse, OLAP and data mining technologies. This paper introduces the established process of data warehouse and realization of online analytical processing technology from application requirement. The data mining function module seeks the optimal putting layout of goods shelves by analyzing the sale record of merchandise. The module can help managers set down member card serving strategy and sales promotion project according to the analysis of member information to adapt well to consumers and keep steady consumption group.

Key words: data warehouse, OLAP, data mining, decision support system

中图分类号: