Data Analysis, Exhibition And Prediction Based On Data Warehouse, OLAP And Data Mining Technologies

With the development and wide applications of Data Base technology, more and more inner history data taking on some characters such as separating-storage, disunity in data structure, data redundancy, data un-integration and so on, which makes data integration more difficult. The large numbers of multifarious data reduces the accessing performance of traditional system, and large of data doesn't be used sufficiently and then can't turn into useful information to direct decisions. Therefore, data integration and analysis becomes a wide-attentioned hot spot. The development and maturity of Data Warehouse technology, OLAP technology and Data Mining technology has established the theoretical foundationes for this task.In this paper, the author focuses on the study, realization and application of some core technologies relating to this subject, the primary work includes: (1) Applying theories relating to Data Warehouse, author sets up a weather data warehouse based on the weather history data to test the performance of the back work. (2)Author emphatically studies the key technology ETL for building data warehouse. Author composes some sql scripts and realizes a simple ETL process, and a data cleaning arithmetic"approximately duplicated records examining". (3)Applying OLAP technology, author realizes the multidimensional analysis and exhibition to the precipitation theme data of the weather data warehouse. (4) Author emphatically studies the time series analysis arithmetic, which is used for a data mining outside arithmetic to realize data analysis and forecast.