A Method of Designing a Reliable and Safe Distributed Meteorological Database System

In the process of constructing an actual meteorological database system, it is a complicated and important task to design a reliable, safe, flexible and expandable meteorological database system which based on the characteristic of actual meteorological data and combined with some current advanced computer and software developing technology. Combined with the actual circumstances of one department's meteorological database system construction, an applied method of establishing a reliable and safe meteorological database system based on the distributed database technology is introduced. In the logical design for database, all meteorological data are divided into relation data and non-relation data. The relation data are directly stored in Microsoft SQL Server 2000, but the non-relation data are stored according to the different file index structure of Windows operating system. The technology of Microsoft cluster server (MSCS) and the redundant array of inexpensive disks (RAID) are used in the reliability design for database, the system's fault-tolerant is realized on the database server and storage device. The fault-tolerant and failover capability of the history meteorological database system are improved by using this technology. For the first time, the safe component conception and the models to design a safe database is proposed. Applying this conception to the database management module, the unsafe problems in database systems can be resolved. The Browse/Server (B/S) structure and multi-tier Client/Server (C/S) structure are used in the software architecture design of the meteorological database. The multi-tier C/S structure is used in meteorological database management software and the querying and displaying system of the meteorological graph data. The B/S structure is used in the meteorological Web applications based on the internet network. An integrated meteorological data query and display system based on the Web is developed, and a series of server-side COM component to display different kinds of meteorological data on the Web are designed, in which the COM technology and Browser/Server structure are used. Meteorological data dynamic real-time publishing and retrieving on the Web can be achieved by using this system. Since the database system is done and applied in the actual meteorological operation, it has been working well, with excellent stabilization, reliability, and quick data storage/reading speed. In the process of developing software for meteorological database, the computer technologies such as the safe component models, the COM component of server side, the structure of Browser/Server are applied very well, which is proved to be a good method for solving hidden safe trouble in the original protocol of computer network and database system, and an effect method for expanding applied field of distributed database system.