Optimization Of Database Training System With Caching Technology

As the Internet and Intranet/Extranet grow at a fast rapid, Web has already affected the commerce, industry, bank, finance, education, government, entertainment, our work and lives. Many conventional information and database systems have being transferred to the Internet. WWW becomes one of the most popular application in the Internet. Because of its rapid growing, the network is congested and the server is over loading. Meanwhile the demand of Web's quality of service and accessing speed is increased. Recently, How to improve the Web's performance is becoming a significant research. For the moment, the cache technology is considered as an efficient way to lighten the server's loading, reduce the network congestion and cut down the delay of the user accessing.With the increase of the Web application, there are more and more large-scale applications bases B/S. How to test these Web applications is becoming a instant problem, especially the pressure test to confirm whether the Web application is able to deal with the uncertain requests from the users exactly and safely in the real network environment and checkout the Robustness of the program.This thesis introduce ASP.NET cache which supports the dynamic contents caching in the whole application under the .NET Framework. The project background of the thesis is Database Training System project for Shanghai Labor Bureau which is implemented by author. The thesis introduces the process that using the caching technology of ASP.NET to improve the performance of Database Training System. The project adopts Microsoft.NET as the develop platform, uses ASP.NET as develop tools. This project requires building a series of new teaching resources which include some database operation emulation system and some active courseware for database training. The thesis first introduced the systems analysis and the module, then chose the proper caching solutions to improve the performance of Database Training System according to the characteristic of each parts of the system. Meanwhile how to keep the data consistency is also an important aspect of this thesis.Besides the research in the caching technology, the thesis gives a summarize of the Web test technique, especially the pressure test and the tools for pressure test: Microsoft Corporation has released the test tool Application Center Test(ACT) with the Visual Studio. NET. ACT is a pressure test tool which can produce load on the Web server by software. By examining the performance analysis report and diagnosing the performance problem, the utmost performance of the Web application could be estimated. In this thesis, four group tests will be took based onthe above-mentioned project, using the RPS(Gets the average number of Requests Per Second) and TTLB(Gets the number of milliseconds that passed before the last byte of the response was received) as the indexes of the evaluation for the system's performance. After analyzing the test results, the thesis gets the conclusion: if the cache used properly, the performance of the system will improved a lot.At last, the thesis is on the basis of summarizing full paper, against the studied content, put forward some questions and look into the distance.