Research Of Data Storage And Data Organization Based On Data Warehouse

With the rapid development of Mobile Communication Service, Guizhou Mobile has already set up information system for many purposes to improve the management skills and complement of enterprise. With the development of Information System, many problems have arisen, such as the accumulation of a large amount of the data and only a hand of the data being utilized in effect, the enterprise is being under the disadvantage circumstance, such as "Data rich" and "Information poor". It is impossible to found the Integrated Marketing Analysis System, which can supply all-grade managers and promotion workers with data processing and related analysis in order to solve the problem and improve the market promotion and service management to a better degree. The Integrated Marketing Analysis System using the modern data warehouse technology will be used in the related information systems to sample, process, store, and analyze. The system will be used conveniently by using the friendly interface.An excellent data organization and storage scheme play an important role in the data warehouse application. Combined with the construction of Marketing Analysis System in Guizhou Mobile, this paper mainly focuses on the data storage and data organization in the data warehouse application.The paper has discussed the following questions about data storage:1. The storage of active data in the OLAP (On Line Analytical Process);2. Page storage strategy in multi-granularity3. An improved multidimensional storage structure;4. Image storage in data warehouse;5. Selective storage;Question 2 and 3 are keystones in this paper.The paper discusses the correlated concept and expatiates the related knowledge about the data organization, which includes:1. The granularity and partition of data;2. Invalidate data and aging data;3. The data organization of OLAP;4. The key technology of data organization;5. The realization methods of data organization;The key technology and realization methods of data organization are keystones in this chapter.At the end of the paper, a regulation-based data warehouse thesis analysis system has been designed and used in the Marketing Analysis System Project in Guizhou Mobile. A better data storage and organization strategy has been designed.Thorough analysis and excavation are not only the demanding of fine management but also the key way of development for enterprises. The foundation is the data warehouse, which set up on high efficient and reliable data management. With intense competition between enterprises and increase of technology, more and more enterprises will adopt data warehouse and related technology.