Zhongshang Supermarket Based On OLAP Technology Management System Research And Implementation

Development of information technology promotes the progress of the retail chain,and the degree of application of information technology directly affects the earnings ofretail business. Therefore focusing on daily business support systems can not fully meetthe needs of modern enterprises.OLAP technology is a kind of solution to the aboveproblems arising from. Decision makers will focus on the data processing businessprocess from the traditional extended to the online analytical processing up. Using thistechnology, enterprise decision-makers can grasp useful information, to grasp markettrends, to make correct and effective judgement.In this thesis, the basic theoretical knowledge of related concepts of OLAP,multidimensional analysis and data cube storage structure was studied. Based on thecurrent OLAP solution after the Analysis and comparison, a OLAP Analysis servicesbased system solution was put forward. On the in-depth understanding of the businessprocess and information flow of Zhongshang parity supermarket chain sales system, thisthesis finished zhongshang parity supermarket data warehouse of design andimplementation. Proposed based on data warehouse and OLAP technology solutions,this thesis established he commodity sale data warehouse, using OLAP fast datastatistics for commercial enterprises provide decision support. Proposed OLAPimplementation of the system of zhongshang parity supermarket chain a concretesystem implementation.Proposed OLAP system implementation, the parity in thebusiness for a specificsupermarket chain system implementation. Using self-developedfront-end display tools, analysis and inquiry of the business of daily production in theparity chain of sales data can be realized. Users can easily access different size flexible,different angles of the sales data to meet the business needs of parity chain, which hascertain practical value.