| 基于ORACLE的陇东南区域自动气象站数据库设计及应用 |
| |
| 引用本文： | 袁佰顺,朱拥军,李晓鹤,汪鸿滨,陈薇.基于ORACLE的陇东南区域自动气象站数据库设计及应用[J].甘肃气象,2014(3):475-480. |
| |
| 作者姓名： | 袁佰顺 朱拥军 李晓鹤 汪鸿滨 陈薇 |
| |
| 作者单位： | [1]甘肃省天水市气象局,甘肃天水741000 [2]甘肃省天水市人工影响天气办公室,甘肃天水741000 |
| |
| 基金项目： | 甘肃省气象局科研项目“甘肃省短临监测诊断预警预报平台”（2012-02）、“市州气象频道气象信息服务平台建设”（2012-20）共同资助 |
| |
| 摘 要： | 区域气象自动站的建立,提高了防灾减灾及突发灾害性天气的监测预警能力。随着站点建设规模的快速扩展,数据处理量成倍增多,对数据库系统的存储处理提出了更高的要求。ORACLE数据库在处理海量数据方面,性能优异、可伸缩性强。以ORACLE 10G作为核心数据库,设计、建立了基于ORACLE的陇东南区域自动气象站数据库与应用系统。经过试用表明,该数据库能够很好地满足区域自动气象站数据实时访问和检索需求,提高了数据应用效率,实现了陇东南和周边部分地区近千个站点的资料自动入库、存储和查询检索。本文对数据库设计、SQL语句查询优化原则、ORACLE数据服务器和客户端的连接配置等方面做了重点介绍。
|
| 关 键 词： | 区域自动气象站 实时资料 ORACLE 系统应用 |
Design and Application of Regional Automatic Meteorological Station Database in Southeast of Gansu Based on ORACLE |
| |
| YUAN Baishun,ZHU Yongjun,LI Xiaohe,WANG Hongbin,CHEN Wei.Design and Application of Regional Automatic Meteorological Station Database in Southeast of Gansu Based on ORACLE[J].Gansu Meteorology,2014(3):475-480. |
| |
| Authors: | YUAN Baishun ZHU Yongjun LI Xiaohe WANG Hongbin CHEN Wei |
| |
| Institution: | 1. Tianshui Meteorological Bureau of C.ansu Praviace, Tianshui 741000, China; 2. Tianshui Weather Modification Office, Tianshui 741000, China) |
| |
| Abstract: | 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 database has so many advantages in dealing with massive amounts of data,such as excellent performance and strong scalability. The regional automatic meteorological station database application system in southeast Gansu was designed and established based on ORACLE10G. 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. |
| |
| Keywords: | regional automatic meteorological station real-time data ORACLE system application |
| 本文献已被 CNKI 维普 等数据库收录！ |
|
