Based On Financial Analysis Of Medium And Small Trade Enterprises Of The Data Warehouse Model Design And Implementation

In 90's of last century, the concept of data warehouse was proposed for the first time. And since then data warehouse has been establishing in the financial, telecommunications, insurance, and other large industries that major in traditional data-processing-intensive business. In recent years, data warehouse and OLAP technology has also been widely used in our large enterprises and institutions. However, more and more medium and small trade enterprises have implemented the ERP, and running smoothly, so there are mature online transaction processing systems and a lot of historical data, which provide the necessary objective conditions for the data warehouse; for the trade enterprises, the financial situation directly impacts on their ability to survive, which provides the external forces to establish a financial data warehouse.This paper is divided into four parts to illustrate the financial data warehouse construction of medium and small trade enterprises. In the first part, the research background and significance of this paper are described, as well as the domestic and international research status of the data warehouse, and then the content and innovation of this paper are put forward. The theory of financial analysis commonly used and important technology of data warehouse and OLAP are reviewed in the second part. In the third part, the design and creation of financial data warehouse for small and medium trade enterprise are realized. The third chapter discusses the design of the financial data warehouse, which guides the design of the themes, dimensions, granularities and analysis indicators, as well as proposed architecture design and data storage design-BKR architecture and dimension reduction technology; in the fourth chapter the model and applications of the financial data warehouse are established and in the fifth chapter the ETL work during the process of establishing the data warehouse is described. And finally, the demonstrations of one application are given in the fourth part.