基于ORACLE的长三角自动站数据库系统

Design and Implementation of Oracle-Based AWS Database System for Yangtze River Delta Region

在气象部门自动站资料存储实现中,大型数据库系统如ORACLE、SQL SERVER等已经得到了初步的应用,不过目前存储的自动站数量都较少,数据库性能容易保持。在区域级或者省级气象业务中,自动站的数据量非常大,且数据量不断快速增长,需要对自动站数据的存储进行重点设计。2009年,为服务上海世博会等大型活动,设计实现了基于ORACLE 10G的长三角自动站数据库系统,系统实时处理长三角地区的自动站资料并入库,极大地扩展了资料的共享度。重点介绍了数据库系统的设计实施方案,主要包括事件驱动入库处理、自动站核心大表设计、索引实现,以及SQL语句的查询优化原则等。

At present, database systems such as Oracle and SQL Server are a preliminary application in automatic weather station data storage. The database performance is easy to maintain with a small number of AWS＇ s, but at the regional level or provincial level meteorological service, because of the large amount of AWS＇s and the growing amount of data, the design and implementation of data storage is need to be paid great attention. In 2009, based on the Oracle 10 G database system, the Yangtze River Delta region AWS Database System was developed and established. The system carries out the processing and storing of AWS＇s data in real-time. The design of the massive database implementation, including event-driven storage processing, large table partition, index, and SQL statement query optimization principles in the massive database, is discussed.