【作者】 夏军；

【导师】 宋福根；

【作者基本信息】 东华大学 ， 管理科学与工程， 2007， 硕士

【摘要】 在服装行业日益激烈的竞争过程中，我国的服装企业面临着如何有效地整合产业链上的各类信息，将业务流程电子化，以实现供应链的快速反应的问题。随着企业规模的不断扩大，市场竞争的不断加剧，企业的运营层如何把正确的信息、在正确的时机、提供给相应的决策层，以及决策层如何及时准确地获得必要的决策参考信息等问题将成为一个紧迫而复杂的课题。随着信息技术的高速发展和企业界需求的多样化、复杂化，数据仓库技术应运而生。数据仓库提供了一个数据平台，在此基础上可以进行强有力的数据分析、数据挖掘和报表处理，以支持管理决策。虽然很多公司相继推出了数据仓库产品，但对数据仓库技术的研究仍然方兴未艾。数据仓库的建设不是一个简单的技术问题，而是一项复杂的系统工程。联机分析处理是数据仓库的一个最典型的应用。它能将数据仓库中的数据按照不同的粒度进行聚合和预计算，从而在用户面前展现多维数据视图。同时，联机分析处理还提供了较直观的多维分析操作，包括切片、切块、上卷、下钻和旋转等，使用户能多角度、多层次地观察数据仓库中的数据。首先，本文利用实际研究与理论归纳相结合的手段，对论文的研究背景进行阐述，总结了国内外的研究现状，探讨了研究的目的和实际意义。之后，通过综合国内外学者的研究成果，对数据仓库和OLAP技术的理论原理进行全面地分析，并研究了数据仓库、OLAP和数据挖掘三者之间的关系。进而在理论研究的基础之上，结合服装行业的背景和我国某服装企业销售业务的具体需求分析，提出了基于联机分析处理技术的销售管理系统的总体解决方案，该解决方案分为两大主要部分，一部分是销售管理系统(OLTP系统)，另一部分是在此系统基础之上，运用数据仓库技术将数据库中的数据通过转换、加载与清洗到销售OLAP分析数据仓库中，而开发的销售OLAP分析系统。并构建了解决方案的总体结构以保证系统的设计方案具备较高的实用价值和技术可行性。然后，通过对销售管理系统的功能结构和数据库的分析与设计，利用Visual Basic.Net与SQL Server2000开发实现所有功能模块。并在所开发的销售管理系统的基础上设计和建立了数据仓库和OLAP模型。最后，通过对OLAP前端应用程序开发方法的研究，用ASP结合MDX和ADO MD开发并实现了基于Web的销售OLAP分析系统，结合该系统运行效果的分析说明了系统的有效性和现实意义。本论文的主要贡献在于结合我国服装行业某龙头企业销售业务的具体需求，研究了数据仓库和联机分析处理技术在销售管理系统中的应用原理；建立了数据仓库三级模型和四个主题的多维分析模型；提出了基于联机分析处理技术的销售管理系统整体解决方案；最后开发实现了相应的原型系统。为企业进行销售与营销决策提供了支持，辅助决策者快速制定正确的销售策略，尤其是全面提高了服装企业销售与营销的决策水平和市场竞争能力。本研究成果对在我国服装行业乃至其他行业中实施数据仓库的解决方案有一定的实际参考价值，可显著地提高企业的经济效益和科学决策水平。更多还原

【Abstract】 The competition becomes more and more drastic in rag trade. The domestic enterprises faced to many problems such as how to integrate various informations in industry chain effectively. As the scale of enterprises become larger. The problem that how the operator provide the right information at the right time to the decision-makers in the enterprise and how the decision-makers get the right information exactly will become more urgent and complicated.As the rapid development of information technology and the demand of enterprises become more diverse and complicated. The technology of data warehouse is presented. Data warehouse provides a data platform. We can do data analysis, data mining and report processing to support the decision-making based on this platform. Although many enterprises provide solutions of data warehouse, the research of this technology is still going on. OLAP is the typical application of data warehouse. It can process the data in the data warehouse to show the multimensional data view to users. At the same time, OLAP provides the more convenient operation including slice, dice, drill and so on. The users can observe the data from different levels.First, this papar set forth the background of research and summarize the current research, discuss the target and meaning of this research. Then, through integrating the achievement of many scholars’ research. The author analyzes the theory of data warehouse and OLAP as well as the relationship among data warehouse, OLAP and data mining. Based on this research and coinbine the background of rag trade and demand of a certain company, the author bring forward a whole solution of the sales management system based on OLAP. This solution contain two parts: one is sales management system (OLTP) another is sales OLAP analysis system based on WEB. I constructed the whole structure to ensure the practicality and technic feasibitiy of this system. After that, the author use Visual Basic.Net and SQL Server 2000 develop and realize all function modules. Based on this system, the author use ASP, MDX and ADO MD develop and realize the sales OLAP system. Finally, the author analyzes the effect of system application.The main contribution of this papar is researching the application principle of data warehouse and OLAP in the sales management system based on the demand of a certain company in rag trade in our country, setting up a data warehouse’s 3 level models and 4 topics of dimensional analysis models, providing a whole solution of sales management system based on OLAP and finally developing and realizing the system. The achievement of this research supports the decision-making in sales and marketing, assists the decision-maker establishes the right strategy. Especially, it improved the decision level and marketing competitive capacity of the companies’ sales and marketing business. The achievement of this research has a certain reference value of implementing the data warehouse solution in rag trade or other industries.更多还原