基于ORACLE的陇东南区域自动气象站数据库设计及应用

摘要

Because of regional automatic meteorological stations,the ability of monitoring and early warning of disaster prevention and mitigation of severe weather emergencies has been promoted.But with the rapid expansion of the automatic weather stations,the data processing increases exponentially,so the higher requirements for storage processing of database system are put forward.ORACLE da-tabase has so many advantages in dealing with massive amounts of data,such as excellent performance and strong scalability.The re-gional automatic meteorological station database application system in southeast Gansu was designed and established based on ORACLE 10G.The tryout showed that this system could satisfy the requirement of visiting and searching real-time data of regional automatic meteorological stations,the application efficiency has been improved,and the data from thousands of regional automatic meteorological stations which located in southeast Gansu and surrounding areas could realize automatically warehousing,store,search and retrieve.In this essay,the design,optimization principles of statement query,connection configuration of ORACLE data server with client of the database have been introduced.%区域气象自动站的建立，提高了防灾减灾及突发灾害性天气的监测预警能力。随着站点建设规模的快速扩展，数据处理量成倍增多，对数据库系统的存储处理提出了更高的要求。ORACLE数据库在处理海量数据方面，性能优异、可伸缩性强。以ORACLE 10G作为核心数据库，设计、建立了基于ORACLE的陇东南区域自动气象站数据库与应用系统。经过试用表明，该数据库能够很好地满足区域自动气象站数据实时访问和检索需求，提高了数据应用效率，实现了陇东南和周边部分地区近千个站点的资料自动入库、存储和查询检索。本文对数据库设计、SQL语句查询优化原则、ORACLE 数据服务器和客户端的连接配置等方面做了重点介绍。