| As the development of information technology in all-round way, the system of database management has become a foundational and key factor in information system. It has become a high and new technique for a country's strategies. The information should bring along the development of industry, improve the ability of innovation and competition of our corporations, protect the security of country information and help to develop our nation's IT industry and software. All above need the support of the homemade database. So, the exploitation and extension of the homemade general database is the established policy for the development of our country's information. The e-business performance testing system of an applied database is a key factor for the development of the homemade database. So we design a e-business performance test system for the general database which is based on the TPC-W. TPC-W is an international general system to test the computer's performance. The level of the homemade database is low. For the development of the homemade database that has the independent property rights, we must have the accumulation of knowledge. It can provide essential support for the homemade database. So we analyze and research the technology of Open Source Database. Two sections decompose this paper. Section 1 introduces the realization of the performance test subsystem for the e-business performance test of the database. Then it gives the test result of Oracle Enterprise 9i and the homemade database RedBase 7.5 which is developed by Genera Data Co.. Section 2 introduces the working principle of the lock system of InnoDB data engine of open source database MySQL 5.0.0 alpha and the work mechanism of the InnoDB lock to index. Author and another member develop the e-business performance testing system. It is used for the test of e-business performance of database. It is based on the TPC-W. The technology comes from open-source test tool OSDL-DBT-1 and TPC-W Java implementation. TPC-W is used to test the management performance on the situation of e-business. This system now supports Oracle Enterprise 9i and RedBase 7.5. It is composed by ACID test and performance test. In this paper, we introduce the realization of performance test. We construct a network book store system. The e-business performance test system test the performance of several databases on e-business by the network alternation transaction number. We use RBE(Remote Browser Emulator)to generate several simulated explorer threads. Then we do random visit to WEB server. The WEB server will communicate to the database and dynamically generate the response page according to the requesting page. We record the WIPS(Web Interaction Per Second)of database and test the e-business performance. The test system is composed by server program, client program and data processor program. It is realized by JAVA. In data processor part, we adopt the data generating rules based on TPC-W, program the data-generating tool and data-importing tool. They are imported in the database by JDBC. The server program realized all 14-visiting pages that the TPC-W norm requested. The application program interface that all use Java Servlet and Servlet provide normal Java database function for accepting and responding HTTP request and maintaining the talking state for every user. For database, we use RedBase7.5 general database management system. It uses JDBC interface communication of Servlet to realize query and update. The primary foundation of client program is to realize remote explorer simulation RBE(Remote Browser Emulator) and the visiting operation. Then collect and analyze the testing result. After we have generated several simulated explorer EB (Emulator Browser) threads by the main program of RBE, each EB began to analyze the accepted page information and get the user ID, dialogue ID or other useful information. Then EB generate random number to decide the URL of the next request page until the testing time terminate. We can control the EB number by RBE and then modify the workload. On the same time,RBE save WIPS performance value, thinking time and WIRT performance value, then write them into a generated .m result file. By analyzing the result by MATLAB, we can get the WIPS value. On the environment of Windows Advance Server 2000 PC, the author apply the testing system to Oracle Enterprise 9i and RedBase 7.5, then get the testing result. The optimized method is used from high to low level. By contrast the result, we found that the e-business performance of RedBase 7.5 is not as good as Oracle 9i. The difference is on the database query optimizing part. Author belongs to Data Process Group of Computer Science and Technology College. This group has made deeply research and analyze on the realization of InnoDB data engine of MySQL. InnoDB data engine is one of the engines of MySQL. It fully support business process, support four business isolation level, realize the row lock,foreign key, provide the multi-versioning concurrency control as the same type as Oracle. The author takes charge of the research of lock system of InnoDB. InnoDB lock system has the traditional two-phase locking policy system and can make row level read-write lock. There are five mode of InnoDB to lock the data: shared lock, exclusive lock, Intention Exclusive lock, Share Intention Exclusive lock and auto-increment lock. From the type of lock we can see that InnoDB realized rowlock and table lock. Besides the function of lock resource, deadlock check and concurrency use, there are some special state of InnoDB lock. Because InnoDB save all data inside B-tree index and data are saved in leaf nodes, the lock of InnoDB is combined used with index. Its record logic lock is on index, not on record. InnoDB also have the precision lock used for index: LOCK_ORDINARY, LOCK_GAP, LOCK_REC_NOT_GAP, LOCK_INSERT_INTENTION. It uses Explicitly lock and Implicitly lock and has the integrated lock operation to index. To prevent phantom problem, InnoDB use Next-key locking technology to the blockage of index record. The e-business performance test system to database is a...
|
PDF Full Text Request