水利数据中心通用数据库维护系统设计与实现

摘要

针对水利数据中心水文、水质等异构专题数据库统一维护管理的问题,提出一种基于元数据的通用机制,实现水利数据中心通用的数据库维护系统.系统以元数据库为中介,通过使用对象/关系映射技术的通用机制,实现数据库注册、数据导航定位和数据查询展示等通用服务.在此基础上支持数据编辑控制、数据质量校验、数据导入导出等个性维护功能.通用机制的应用使得系统能够自适应表结构的变化,实现水利数据中心数据资源集成维护.结合J2EE多层软件架构技术,显著提高系统的可扩展性及组件的可复用性.%In light of the uniform maintenance and management of the heterogeneous thematic databases for hydrology and water quality in water conservancy data centre,we propose a metadatabase-based general mechanism to realise the general database maintenance system for the centre.With the metadatabase as the medium,the system realises the general services including database register,data navigator localisation,and data query and display by using a general mechanism of object/relation mapping technology.Based on which,the system supports the personalised maintenance functions such as data edit and control,data quality verification and check,data import and export,etc.The use of general mechanism makes the system self-adapt to the changes of the structure of the tables and realises the maintenance of data resources integration in water conservancy data centre.The database maintenance system,which combining the technology of J2EE n-tiers software architecture,markedly improves the scalability of the system and the reusability of the components.