地面沉降数据库规划与结构设计研究

发布时间：2018-03-12 21:29

本文选题：地面沉降　切入点：数据字典　出处：《长安大学》2014年硕士论文　论文类型：学位论文

【摘要】：近几十年来，政府相关部门投入了大量的人力物力及财力，加强对地面沉降的监测，包括精密水准测量、地下水动态监测、GPS实时观测、分层标自动监测等，积累了大量的数据和资料，如何合理有效的管理、分析及利用这些数据，从中提取地面沉降相关信息，使其得到更好的应用，是摆在地面沉降控制与防治工作者面前的重要课题。本研究依托《全国地面沉降监测与防治综合研究与信息系统建设》项目，根据已有的地面沉降资料、地面沉降观测设施和动态监测数据相关资料，利用GIS技术和数据库管理系统，对地面沉降监测数据进行科学规范的管理，建立动态的地面沉降数据库，为地面沉降灾害管理信息系统提供数据支撑，并为城市规划、建设及地面沉降的防治工作等提供及时准确的信息。论文取得以下研究成果： 1）对多源数据进行分类。论文根据应用需求及数据信息的不同，对所采集的信息进行归类，对数据库进行规划。地面沉降数据按照工作进程划分为调查、钻探和槽探、监测三类数据。 2）建立统一编码体系。在分析地面沉降多源数据特点及实际应用需求的基础上，建立了统一的编码体系对数据进行管理，确保各类监测点、调查点的唯一性，避免数据冗余，以便于统一协调管理和查询。 3）完成数据字典设计。地面沉降数据采集系统属性数据库基于数据字典生成，数据字典的设计使属性数据库生成更加灵活，增强了地面沉降采集系统实现的灵活性和高效性。数据字典包含属性数据库中所有属性表及各属性表的数据项，保证各属性表中相同数据项及数据项代码的唯一性，消除数据冗余；同时数据字典的设计减少了系统开发的工作量，系统设计与开发不会受制于数据库，亦无需因数据库设计的改变而重新设计与开发。
[Abstract]:In recent decades, the relevant government departments have invested a great deal of manpower, material and financial resources to strengthen the monitoring of land subsidence, including precision leveling, dynamic monitoring of groundwater and GPS real-time observation, automatic monitoring of stratified marks, etc. Accumulated a lot of data and data, how to reasonably and effectively manage, analyze and use these data, extract the relevant information of land subsidence, so that it can be applied better. It is an important subject in front of land subsidence control and prevention workers. This research relies on the project "Comprehensive Research and Information system Construction of National Land subsidence Monitoring and Prevention", according to the existing land subsidence data, land subsidence observation facilities and dynamic monitoring data related data, By using GIS technology and database management system, land subsidence monitoring data are managed scientifically and normatively, and dynamic land subsidence database is established to provide data support for land subsidence disaster management information system and urban planning. Provide timely and accurate information for construction and prevention of land subsidence. The research results are as follows:. 1) classifying the multi-source data. According to the application requirements and different data information, the paper classifies the collected information and plans the database. The land subsidence data is divided into investigation, drilling and grooving according to the working process. Monitor three types of data. 2) establishing a unified coding system. On the basis of analyzing the characteristics of land subsidence multi-source data and practical application requirements, a unified coding system is established to manage the data, to ensure the uniqueness of various monitoring points and survey points, and to avoid data redundancy. To facilitate the coordination of management and query. 3) complete the design of data dictionary. The attribute database of land subsidence data acquisition system is based on data dictionary, and the design of data dictionary makes attribute database more flexible. The data dictionary includes all the attribute tables and the data items of each attribute table in the attribute database to ensure the uniqueness of the same data items and the code of the data items in each attribute table. At the same time, the design of data dictionary reduces the workload of system development, and the system design and development will not be restricted by database, nor need to be redesigned and developed because of the change of database design.
【学位授予单位】：长安大学
【学位级别】：硕士
【学位授予年份】：2014
【分类号】：P208;TP311.12

【参考文献】