CAJ | 학술논문

区域气象自动站的建立，提高了防灾减灾及突发灾害性天气的监测预警能力。随着站点建设规模的快速扩展，数据处理量成倍增多，对数据库系统的存储处理提出了更高的要求。ORACLE数据库在处理海量数据方面，性能优异、可伸缩性强。以ORACLE 10G作为核心数据库，设计、建立了基于ORACLE的陇东南区域自动气象站数据库与应用系统。经过试用表明，该数据库能够很好地满足区域自动气象站数据实时访问和检索需求，提高了数据应用效率，实现了陇东南和周边部分地区近千个站点的资料自动入库、存储和查询检索。本文对数据库设计、SQL语句查询优化原则、ORACLE 数据服务器和客户端的连接配置等方面做了重点介绍。
구역기상자동참적건립，제고료방재감재급돌발재해성천기적감측예경능력。수착참점건설규모적쾌속확전，수거처리량성배증다，대수거고계통적존저처리제출료경고적요구。ORACLE수거고재처리해량수거방면，성능우이、가신축성강。이ORACLE 10G작위핵심수거고，설계、건립료기우ORACLE적롱동남구역자동기상참수거고여응용계통。경과시용표명，해수거고능구흔호지만족구역자동기상참수거실시방문화검색수구，제고료수거응용효솔，실현료롱동남화주변부분지구근천개참점적자료자동입고、존저화사순검색。본문대수거고설계、SQL어구사순우화원칙、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.