航空伽玛能谱数据库的设计和实现

【作者】 肖刚毅；

【导师】 赖万昌； 熊盛青； 葛良全；

【作者基本信息】 成都理工大学 ， 核技术及应用， 2004， 硕士

【摘要】 本文介绍航空伽玛能谱数据库的数据库结构设计及应用程序开发，本项研究源自中国地质调查局下达的科研项目“航空物探、遥感数据库”。论文在系统分析了航空伽玛能谱测量内在特点的基础上，提取了航空伽玛能谱数据库的数据源，初步完成了航空伽玛能谱数据库的设计。取得的主要成果如下： 1．建立航空伽玛能谱数据库 以SQL Server 2000数据库管理系统为开发平台，设计了航空伽玛能谱数据库的实体—关系模型，采用两级存储结构来存储航空伽玛能谱测量数据，最大限度地降低了数据冗余度。两级存储结构为测区基本信息表和测点数据表，通过测区编号建立对应关系。从实际运用的角度出发，确定了两表的结构和字段的属性。 2．优化航空伽玛能谱数据库 由于航空伽玛能谱测量数据量大，保证查询测点数据具有较好的响应速度是航空伽玛能谱数据库设计的重点。使用水平分区的技术和建立聚集索引的技术取得了较好的效果，在本机测试环境中，从测点数据表近2800万条记录中输出匹配量为18422条记录的时间约为8秒。同时应用数据库系统的查询分析器来指导优化的过程。 3．客户端程序的设计和实现 为了便于用户使用航空伽玛能谱数据库，开发了客户端程序：航空伽玛能谱数据库管理系统。客户端程序包括登录模块、系统管理模块、数据管理模块、数据查询模块和系统帮助模块。通过先进的数据访问技术ADO．NET驱动各个功能模块调用库的数据表，实现了用户管理、数据整理、录入或导入、更新和输出以及数据查询等功能。客户端程序采用Visual Basic．NET编程语言实现，运行在．NET框架下，具有较好的移植性。 航空伽玛能谱数据库的建设，使新中国30多年来航放数据获得了新生，本项研究成果具有较高的经济效益和社会效益。更多还原

【Abstract】 This thesis introduces the design of application database structure and development of client application, which is rising from the scientific project of aerial geophysical survey and remote sensing database of China Geological Survey. The thesis brings forward the datasource of the aerial gamma-ray spectrometric database, and completes elementarily the design of the aerial gamma-ray spectrometric database on the base of the analysis of internal characteristic of the aerial gamma-ray spectrometry. The primary acquired harvests are below.1. Building aerial gamma-ray spectrometric databaseDeveloped with SQL Server 2000 database management system, the entity-relation model of aerial gamma-ray spectrometric database is designed. A two-level storage structure is adopted to store aerial gamma-ray spectrometric survey data so as to shorten data rebundancy maxmimumly. The two-level storage structure consists of basic information table of survey area and data table of survey spot, both of which is related by serial number of survey area. The structure and field properties of two tables are retablished from the point of practical application.2. Optimizing aerial gamma-ray spectrometric databaseBecause large datas exist in the aerial gamma-ray spectrometric survey, an emphase of designing aerial gamma-ray spectrometric database is that a better response speed of querying spot data is acquired surely. A good effect is made by using the technology of horizontal subarea and building clustered index. In the testing environment on local machine, the response time of outputting 18,422 pieces of records from the spot data table induing about 28 million pieces of records is about 8 second. At the same time query optimizer of database management system is used to guide the optimize process.3. Design and development of client applicationIn view of users’ conveniences of using the application database, the client application of aerial gamma-ray spectrometric database management system is developed. The client application includes entry model, system management model, data management model, data querying model and system help model. Each function model is drived to load the related table of databse using the advaced data access technique of ADO.NET object, so that these functions including manageing user, cleaning up data, inputing or importing data, updating data, exporting data and querying data and so on come true. The client application is developed with visual basic .NET programming language, running in the .NET framework and possessing good transplant.更多还原