【作者】 荣秋生；

【导师】 肖德宝；

【作者基本信息】 华中师范大学 ， 计算机应用技术， 2001， 硕士

【摘要】 网络管理系统中数据库的设计与实现是指当网络管理系统第一次运行时，系统初始化过程遍历整个园区网并建立被管理设备的对象，将一些较固定的信息存入数据库。系统在以后运行时，系统初始化过程就不用遍历整个园区网，直接从数据库中读信息来生成被管对象，以加快运行速度。同时网络管理系统自身的安全可靠性对网络的正常运行至关重要，而计算机网络的开放性和数据库中信息安全性之间的矛盾又要求在网络管理系统的建设中强调安全性。它是目前网络管理领域内研究热点，对计算机网络的正常运行具有重要的现实意义。 本文的研究是以华中师范大学网络与通信研究所自主研制的基于Web的园区网络管理系统为背景展开的。作者负责其中数据库的设计与实现及其安全机制的研究。 本文系统介绍了网络数据库的概念、体系结构和数据库的设计。讨论了目前网络数据库的产品，然后根据实际需要，确定了本系统的数据库选型方案（Microsoft SQL Server），并详细描述了系统中数据库的构造。 本文分析了数据库与应用程序的接口层，对数据库进行了初始化和详细的定义及其实现，还进一步介绍了SQL Server7.0中触发机制的原理以及存储过程的应用。 本文还从保护数据的安全性方面着手，介绍了数据库的复制，包括复制结构、复制代理、复制类型。详细介绍了数据库的备份以及恢复。 在此基础上，本文提出了怎样构建安全的网络数据库应用系统，把复杂的网络管理一点点分散到系统的建设中去。最后在实现网络数据库的安全机制时，一步步分析怎样使系统达到真正的安全性。 本文以华中师范大学网络与通信研究所自主研制的基于Web的园区网络管理系统为例，描述了作者提出的为实现系统的兼容性，用SQL语句来定义数据库，并介绍了基于Web的园区网络管理系统中数据库的设计方案和数据库安全机制的具体实现。更多还原

【Abstract】 The Design and Implementation of Database Based on Network Management System is refer to the search of initial process in whole Campus Network, the establishment of managed object and the storage in database of stationary information. As the system run later, the process needn抰 search the whole network, it can become the managed object from the informations, which can make the system faster. At the same time, it抯 important to the running of net by the security of NMS. But the contradiction between the opening of network and the security of database is embodied, which emphasizes the security of the NMS. Being present research focus, it is an object which has great realistic significance and extensive practical foreground in network management area. This article is based on the research of Web Based on Campus Network Management System,which is independently made by Institute of Communication and Computer Network of CCNU. The author is in charge of design and implementation of database and research of security based on Network Management System. The article introduces the concept, the architecture and the design of database on network. It introduces the production. And then, with the actuality requirement, we confirm the project of database(Microsoft SQL Server).It also depicts the constitution of the database on network. The article analyses the layer between database and applied program. It initiates and delimits the database. Further more, it introduces the principles of touching mechanism and the application of storaging course in SQL Server7.O. The article falls to protecting the data, also introduces the replication of database, which includes the structure, the agency and the type of replication. And it introduces the backup and restoration of database. On the basis of all above, the article expounds how to establish the application system on network securely, it distracts the involved management to the establishment of system. At last, it analyses how to achieve the truthful security in research of security based on NMS. On the basis of the research on design and implementation of database and research of security based on NMS, taking the Web Based on CNMS as a example,which is independently made by Institute of Communication and Computer Network of CCNU. The article not only depicts that the author delimits database with the SQL for the compatibility, but also introduces the design of database and research of security based the Web Based on CNMS.更多还原