地震前兆数据库系统设计

On the Design of Earthquake Precursor Observation Database System

基于应用需要,"十五"项目对前兆数据库系统重新进行了统一规划设计,吸取了此前已有前兆数据库系统的优点,制定了《地震前兆数据库结构规范第一部分:固定台站观测》。本文详细介绍了该规范设计的有关方面,包括对此前已有前兆数据库系统的分析、设计时的考虑因素、包含的内容、规范的主要特点、以及对有关问题的解决,如同一台站多套相同仪器的处理等。本文还简要介绍了库表结构,并与"九五"数据库结构进行了查询速度比较。基于该结构的前兆数据库系统已在前兆台网的各级节点使用。实际应用表明,该数据库结构具有结构稳定、查询速度快、表数量和表大小适中、基础信息全面以及开放性好等优点。

According to needs of projects,in the period of the tenth five-year plan,the structure of the earthquake precursor observation database systems is re-designed.The design of the database structure is on the basis of previous similar systems,and the advantages of such previous database systems are adopted.This paper introduces in detail the aspects of the design,including the investigation and analysis of previous database systems,the factors that we considered,the contents that the database should include,the main characteristics of this database structure,and the solution for some relevant problems,such as the method to distinguish two instruments of the same kind.The paper also compares the speed of a database query based on the new structure with that of the old.