Application Of Data Warehouse In The Supermarket Distribution Decision Support

The chain supermarket develops rapidly at present, have already become the most vibrant cause of commercial field, especially the data amount that large-scale chain supermarket needs dealing with every day is very huge. In order to adapt to the fierce market competition day by day, we need the aid of the data warehouse, fully utilize data resources of existing magnanimity inside enterprises, excavate out valuable knowledge and law from it, support enterprises to make policy, combine objective and full and accurate data experience and policymaker's own valuable experience effectively together, improve the market competitiveness of enterprises.This thesis regards the supermarket distribution decision support system as background, it describe in detail the model-building methods and steps that orient the data warehouse in the supermarket distribution. Combining the concrete business of enterprises of chain supermarket, the thesis puts forward a scheme that solves the data warehouse in the chain supermarket distribution decision support, utilize DTS by using ETL to structure the data warehouse of the system.The thesis utilizes OLAP technology to structure the multidimensional dataset of sales, using multidimensional inquire language MDX goes on querying dataset in order that policymaker analyze amount of sale ,stock and make correct delivery decision. Finally utilize Delphi to develop a simple foreground application so as to make the decision data that the advanced administrator needed show with obvious data or figure.