Online Sales Of Tobacco Logistics Analysis Technology In The Application Of OLAP

As development of information technology,the informative demands on tobacco enterprises are continually growing.During production process with years,it accumulates numerous data of users,sales and inventory,thus enterprises begin to utilize database system to charge these data with a better practice.However,most enterprises have just made sample and cosmetic inquiries on those existing data and could not offer in-depth analyses as a result.That is how existing data has not been used effectively to make correlation analyses and get the valuable conclusion for organization's better improvement.Online Analytical Process(OLAP)served as a technical system with features to excavate data character effectively and management sorts of enterprise data adequately.,Apart from this,it can also offer enterprises managers valuable decision services by excavating,analyzing and predicting the trend of existing data.Currently,for enterprise leader,OLAP technology has become an increasingly important reference during their decision-making management.This essay based on OLAP technical theoretical analyses,through extensive literature reviews,summarizing both current OLAP development status and its features at home and abroad,analyzing several technical methods related to OLAP such as Data warehouse,Multidimensional analysis theory etc at the same time.Following this methodology,this essay has taken the detailed marketing situation of some tobacco enterprise as a research objective,analyzing its marketing management process.Guided by design specification of SELMAS and technical requirement of OLAP,it developed the layout of distribution logistic online system to set up better practices with which combined business style and data character.This essay firstly focused on detailed marketing status to develop a demand analysis and design an OLAP framework of enterprise distribution logistic with concrete demand analysis.Subsequently it gave an all-around introduction from SQL,OLAP design,data warehouse model design,data analysis model and data type analysis model.On a concrete design basis,this paper finished design works of every functional module by adopting fore-end OLAP technologies such as drill-up,drill-down,rotation,section and so on,doing a great job in complex icon functions with a multidimensional analysis as a result.After testing,the system has been officially entering an operation stage of which result shows new system can meet specific demands for multi-lever users,in addition,it can handle different sorts of data in tobacco business to do related selection and analysis at the same time and give the corresponding report in accordance with different kinds of demands.The system appeared on this essay has been playing a significant role in effectively utilizing the existing data of the company,reasonably making the analysis and report to enterprise sales business and logistic development.As organization data availability has been increasingly improved,it eventually contributes the most to enterprise sales business with a wonderful performance.