Research And Implementation Of Patch Management System Database

Abstract:With the rapid development of computer technology, computer operating systems and application softwares appear to endlessly, more and more application softwares and high integration computer operating systems have appeared and provided people with convenience and shortcut, but also with huge security problem yet. Leaks will appear during the development stage of all softwares, even operating systems can not be avoided. If these leaks are used by the outlaws, there will be serious threats for the safety of user’s computer. In order to repair leaks in time, users should install the corresponding patch for guaranteeing computer security.This study realizes research of patch data source, database structure design and implementation and three kinds of database key technologies, based on the research and development project of enterprise Windows operating system patch management system of local area network.In paper I give a detailed analysis of WSUS and the architecture, table structure and patch data screening process of SUSDB, which is the database of WSUS, and also point out the shortcomings of WSUS. And then according to the needs of our project, I obtain accurate patch data of Windows operating system and Microsoft application software from SUSDB.Then I make detailed design of database schema, table structure and system management module, achieve database security, disaster recovery and real-time database concurrency scheduling.At the next stage I test project database from the database functionality and stress.Finally, according to the actual situation of the database exists in this article, I put forward the future growth prospects.