一种安全可靠的分布式气象数据库系统设计
A Method of Designing a Reliable and Safe Distributed Meteorological Database System
-
摘要: 该文论述了在分布式数据库基础上建立安全、可靠气象资料数据库系统的一般方法。在数据库安全设计中首次提出了安全组件概念及模型, 并将其应用到具体的数据库管理模块中, 较好地解决了数据库系统存在的安全性问题。在数据库应用软件设计中, 采用COM技术和B/S结构, 开发了一套气象数据Web综合查询显示系统, 解决了气象数据Web动态实时发布和查询显示问题。Abstract: 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.
-
Key words:
- database design;
- MSCS;
- safe component model;
- software architecture
-
表 1 气象Web应用程序需要开发的服务器端COM组件
-
[1] 邓莉, 王国复, 孙超, 等.基本气象资料共享系统建设.应用气象学报, 2004, 15 (增刊): 34-35. http://www.cnki.com.cn/Article/CJFDTOTAL-YYQX2004S1005.htm [2] Dale Rogerson. COM技术内幕∥杨秀章, 江英译. 北京: 清华大学出版社, 1999: 129-170. [3] Joel Scambray. Windows 2000黑客大曝光∥杨洪涛译. 北京: 清华大学出版社, 2002: 95-129. [4] 张顺谦, 熊志强.三层体系结构方法及其在气象信息处理系统中的应用.应用气象学报, 2003, 14 (1): 109-112. http://qikan.camscma.cn/jams/ch/reader/view_abstract.aspx?file_no=20030113&flag=1 [5] 赵伟, 李五生, 杨银娟.基于Browser/Server结构的气象Web应用程序设计.军事气象, 2004, (4): 46-48.