基于数据仓库的电子订货系统设计及仿真

摘要

Research the electronic order problem. The pater proposed an improved electronic order system based on data warehouse. First, supermarket sales data were analysed, and order database module was built according to the relationship of stocks and sales. Then, distribution process and demand were analysed to establish the distribution -oriented information packets an guarantee the low cost of distribution. Finally, the MDX query language was used to make the distribution decisions, build data warehouse queries module, and ensure the order efficiency. The experi-ment results show that the improved electronic order system can achieve satisfactory results.%研究电子订货问题,针对连锁超市订货频繁、订货依据的数据冗杂等特点,传统的电子订货方式存在订货效率低,配货成本高的问题.为了解决上述问题,提出了一种改进的基于数据仓库的电子订货系统.通过三部分完成数据仓库的创建,首先分析超市销售数据,按照销售量及库存量的关系构建订货数据库模块,然后分析配送流程及需求分析,建立面向配送的信息包,保证配货的低成本,最后利用MDX查询语言制定配送决策,构建数据仓库的查询模块,保证订货效率.实验研究表明,改进的基于数据仓库的电子订货系统能够有效解决传统方法订货效率低、配送成本高的难题,取得了满意的结果.