Design And Implementation Of Data Warehouse System For LAMOST Spectra

Data Warehouse is an effective tool for storage of data, and OLAP is an tool for data analysis and knowledge extraction. These techniques had be successfully applied in many areas ,such as information indexing and knowledge discovery et al. The topic of this thesis aims at establishing the Data Warehouse system for LAMOST project. The system will be used to improve the efficiency of the data usage, discover knowledge hidden in astronomical data. The main work includes as follows:First, demand analysis for LAMOST Spectra Data Warehouse System is gived. Business flow chart,data flow chart and dictionary are given.Second, general design for LAMOST Spectra Data Warehouse System is gived, which includes the implementation aim of the system, software processing flow, software architecture, functional block diagram. Detailed function of each modular is defined. Third, data structure of the system is designed. Concept and physical model of the data warehouse structure,star catalogue and the relationship of catalogues are given. The multi-dimension cube of the data warehouse,including Star multi-dimension cube and Galaxy multi-dimension cube, is also gived too.Fourth, main functions of the system are designed, including system running, modular function,different algorithm in each function , error and accident process et al.Fifth, by using SQL Server2000, Analysis services and VB6.0 as the development tools, the LAMOST spectra data warehouse system and multi-dimension cub for stars and galaxies are constructed, and spectral display and OLAP operation are implemented. The running and testing results show the system is robust, high efficient and feasible.