【作者】 孙士卫；

【导师】 张继福； 罗阿理；

【作者基本信息】 太原科技大学 ， 计算机应用技术， 2007， 硕士

【摘要】 数据仓库是一种有效的数据存储工具,OLAP是面向数据仓库的数据分析和知识提取的有效工具。本文以国家重大科学工程为背景,对LAMOST的天体光谱数据仓库系统进行了研究,对提高天文数据的利用效率、发现天文数据隐藏的知识具有重要实际意义。主要研究工作如下:1、对面向LAMOST的天体光谱数据仓库系统进行了需求分析,给出了系统业务流程图、数据流图和小字典。2、LAMOST天体光谱数据仓库系统的总体设计,给出了系统的实现目标、软件的处理流程、软件的流程图、软件的体系结构、功能模块图,并且将各个模块的具体功能进行了规划。3、天体光谱数据仓库系统的数据结构设计,给出了数据仓库结构的概念模型和物理模型,以及对星表的设计、星表之间的关系,以及数据仓库的多维立方体,包括Star多维立方体和Galaxy多维立方体。4、天体光谱数据仓库系统的主要功能详细设计,包括系统运行设计、模块函数等功能模块,以及在函数中采用各种算法、系统出错时的处理手段。5、天体光谱数据仓库系统的实现。采用SQL Server2000、Analysis services和VB6.0作为开发工具,构建了天体光谱数据仓库系统和多维立方体(Star,Galaxy),实现了天体光谱的显示与OLAP操作。运行与测试结果表明,系统是稳定的、高效的和可行的。更多还原

【Abstract】 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.更多还原