数据库访问代理在ERP开发中的研究及应用

【作者】 孙闵；

【导师】 丁秋林；

【作者基本信息】 南京航空航天大学 ， 计算机应用技术， 2002， 硕士

【摘要】 论文结合ERP系统的设计与开发，提出用数据库访问代理解决ERP系统发展将要面临的信息安全性和数据库服务器流量控制问题。论文主要研究了数据库访问代理的系统结构、关键技术及实现方法，其中重点研究了数据库访问代理设计与实现中数据库服务器流量控制、数据库加密设计和网络传输加密等内容。数据库访问代理采用Visual C++6.0在Windows NT、Windows98平台实现。 论文首先探讨了数据库访问代理的体系结构，然后重点研究了基于组件的数据库访问代理设计、网络通信平台、代理服务端及代理客户端的设计和实现，最后给出了具体的应用实例。 基于组件的数据库访问代理设计介绍了组件开发技术、数据库访问代理的组件标准选择及数据库访问代理的组件框架设计；网络通信平台设计和实现研究了网络通信平台的工作原理、实现过程中使用的基本技术，论述了网络加密传输关键技术，设计了网络通信平台的程序结构；代理服务端设计和实现研究了代理服务端的工作原理，论述了数据库流量控制和访问优先级调度、数据缓冲及安全数据库支持等关键技术，设计了代理服务端的程序结构；代理客户端设计和实现研究了代理客户端的工作原理，设计了代理客户端的程序结构和组件接口。更多还原

【Abstract】 We have proposed a solution which makes use of the database access agent to resolve the problems of information security and database flux control that will be encountered in the design and development of ERP system. Therefore, this thesis studies on the architecture, key technologies and methods for the implementation of the database access agent. Furthermore, the emphasis of this thesis is focused on the database flux control, database encryption techniques, and encrypted network transmission. The agent has been implemented using Visual C++ 6.0 on Windows NT or Windows 98.In this thesis, the architecture of the database access agent is firstly introduced, then the component based database access agent design is discussed, and the design and implementation of the network communication platform, the server and the client of the agent are studied in detail. At the end of the thesis, an example is presented to explain how to use the agent.In the chapter of Component Based Database Access Agent, the component criterion for the agent is selected and the component frame of the agent is designed based on the discussion for the component development technology. In the chapter of The Platform of Network Communication, its operational principle is discussed at first, then the program structure of the platform and the key technology of encrypted network transmission is focused. In the chapter of The Design and Implementation of the Server of the Agent, the operational principle is researched, the program structure is designed, and the key technologies of database flux control, data buffer, and database security are studied. In the chapter of The Design and Implementation of the Client of the Agent, the operational principle of the client of the agent is first researched, and the program structure of the platform and the component interface are studied.更多还原