Research And Design On Database Access Optimization Of Multi-user And Mass Data Based On B/S

With the advent of information age and the development of internet technology, to B/S mode as the central of management information system has become an important support for the rapid development of the business.The core task of management information system is data management,namely the interaction management of database and system.For a management information system which have complex business structures, a large amount of data and users,how to enhance the database accessing efficiency and eliminate performance bottlenecks has become the key in the management information system development process.In this thesis, combine with the development experience of Baoruiyuan Jewelry Company system,according to the performance drawbacks of the original management information system and the business needs of the new management information system,designed a database access method which make a comprehensive use of stored procedures and database connection pool,and through the clever improvement of program code effectively improve the access speed of the batch operation.The main work includes the following aspects:(1) In-depth analysis of the principles of database access and elaborated the knowledge of system performance optimization,includeing the metrics of performance, the factors of affecting performance and some common methods of performance optimization.(2) Combined with the actual needs and characteristics of Baoruiyuan Jewelry Company’s goods warehousing and sales management information system, analysis of the main factors that influence the performance of the original system, pointed out that the database connection switching operation is a time-consuming and dangerous operation, we should be ensuring the premise of safety to reduce the number of database connections as far as possible in the development process; and also pointed out that we should avoid the inefficient duplication of work in the system development process.(3) Based on the common methods of data optimization and the characteristics of the system itself, gives a set of optimization program which make a comprehensive use of the database connection pool, the system code optimization and the stored procedures.The comprehensive optimization program has passed the performance tests and business acceptance. At present, this method has been applied effectively in Baoruiyuan Jewelry Company’s goods warehousing and sales management information system.