Build Optimization And Research Of Meteorological And Atmospheric Pollution Database System

In the 21st century meteorological and atmospheric pollution database system is a new generation of meteorological information storage management system, can greatly improve the existing huge amounts of meteorological and air pollution data’s management and access efficiency, and can improve service level of People’s Daily life as well as support for meteorological operations and scientific research. Meteorological and atmospheric pollution database system is based on B/S architecture system, using OpenLayer as front-end WebGIS framework. Database side is supported by powerful RDBMS ORACLE database.Optimization of the database and SQL statements development mostly use database optimization technology and SQL development technology. Simple ETL process is implemented by PL/SQL and Java language. Simple business logic is implemented by Java language, Based on this meteorological and atmospheric pollution database system is built. This system’s focus and highlight is the construction of meteorological database, database entity design, metadata design, database partition technology and optimization of the database. However, because the work of the application layer and presentation layer have no support, it is relatively weak. On this basis, this article’s work is as follows:(1)the construction of meteorological and atmospheric pollution databaseSystem uses the ORACLE database 11 g database as its nuclear database. It is used to carry a large number of meteorological and pollution data. The database is designed for OLAP database, to support the complex analytical queries, at the same time, the paper gives some database entity’s data structure and relationship of the entity. The primary key and the foreign key between entities are designed reasonablely. View technologies is used to protect user data reasonablely.Temporary data is stored in the temporary table.(2) database physical design and the design of metadataAccording to the meteorological data entity design code and database three paradigm, we combine with the system requirements, the characteristics of meteorological data and meteorological service to design the structured data and unstructured data of meteorological data. Specifically we show the regular weather bulletin entity design scheme, the application center entity design scheme, conventional ground meteorological elements design scheme, geopotential height standard meteorological elements numerical physical design scheme, surface-based observing station entity scheme, data forecast products entity design scheme, design of user information entity design scheme and pollution data entity design scheme, etc.Metadata design section describes the types of meteorological and pollution database’s metadata and the role of metadata in creating database entities and the role of metadata in the data retrieval process.(3)partition storageAlthough the amount of data is limited in the experimental environment, but considering the largeamount of data in the practical production, the performance of the single table will encounter bottlenecks, so we use partition storage solution. We use the database partition technology to make appropriate partition of data table, and the conventional ground element data provide five kinds of storage structure and passing the test. According to different data types, we formulate the reasonable partition scheme.(4)the database optimizationThe database optimization of this system work in parallel and OLAP system, direct load, partitioning index, the optimization of SQL and stored procedures optimization, and cooperate with the related commands and the SQL statement to explain.(5)the application layer and presentation layerThe two part of this system is relative weak, the workload and the development and design are not as good as the database of this system. Specifically, as follows: through several relatively simple ETL process to achieve a variety of different kinds of weather in pollution data into database, use Java language to achieve a simple business logic and the integration of the three frameworks, front end using OpenLayer technology has realized the basic WebGIS interface display.