The Implementation Of ACID Testing Subsystem For Database Electronic Commerce Performance Test And The Analysis Of MySQL & PostgreSQL Query Processing

This paper includes two parts. The first part mainly introducesThe Implementation of ACID Testing Subsystem for DatabaseElectronic Commerce Performance Test. The second part mainlyintroduces the analysis result of query engine of two source opendatabases named MySQL5.0 and PostgreSQL7.3.2.The implementation technology of database managementsystem is as important as os system's. It is a kind of core softwaretechnology, which is one of the core technology of nationalinformation security , key technology of national economyinformationization, and the important stanchion of information industry.Our homemade information industry and development of softwareindustry need the support of database management system withindependent intellectual property. We consider that an intact andapplied general database performance test system is absolutelynecessary for development and popularization of homemade generaldatabase products. At the same time, after researching the sourcecodes of open source database, we can understand and master themethod of design and implementation of database managementsystem, study the newest database implementation technologynowadays, and make the best of the corresponding technology todevelop homemade database.The first part of this paper mainly introduces the acid subsystemimplementation of general database electronic commerceperformance test system. Our general database performance testsystem called RedPTS (RedBase Performance Testing System) iscomposed of three parts. The general database electronic commerceperformance test system is one part of the whole test system, whichis used to test database electronic commerce performance .At thesame time, ACID test is an important function in it. "TPC-W Javaimplementation"is a test software for TPC-W developed by ProfessorMikko Lipasti in Wisconsin-Madison University in the United States.Much function is not realized in this tool. For example, it doesn'tsupport acid test. Based on this tool, the penman rebuilds andimplements an intact ACID test system. At the same time, this paperalso summarizes a suit of effective methods on performancebottleneck analysis and optimization of TPC-W test. After searching on internet and literature, we find that ChinaSoftware Test Center owns an intact general database performancetest system that is mainly used for test projects consigned by thenation. It charges corporations and scientific research organizationsfor test. We think that an intact and applied general databaseperformance test system is absolutely necessary to design, develop,update, modify, test and popularize homemade general databaseproducts. As a matter of fact, all the famous database manufacturerssuch as oracle , sql server and etc. have ever done TPC-W test underdifferent hardware platform. The test result is regarded as animportant estimate warrant. The Transaction Performance Council benchmark is a standardindustry benchmark. It is an popular database performance benchmarkinternationally ,too. TPC-W is one of the transaction processing anddatabase benchmarks defined by TPC, which is used to determinedatabase server performance for an internet commerce. It is abreast ofthe times to design one's own test tool according to TPC benchmarkindustry specification. TPC-W specifies all aspects of the workloadprofile, performance metrics of interest, and required structure of theofficial disclosure report. While it doesn't provide sampleimplementation of the application. At present ,we have found two freesoftware. One is "TPC-W Java implementation"by Wisconsin-Madisonuniversity, the other is dbt1 by osdl(Open Source DevelopmentLab).The first is better. It is written in the Java language, is able to testWIPS and supports multiple platforms. But it dosen't support ACID test,web consistence test, PGE and can not test other databases exceptDB2. According to TPC-W specification, the penman implements anintact ACID test system based on "TPC-W Javaimplementation".Furthermore, the penmen has used this tool to testOracle 9i and RedBase 7.5 for ACID. The test result indicates thatboth Oracle 9i and RedBase 7.5 support intact ACID properties. The second part mainly introduces the analysis result of queryengine of two source-open databases named MySQL5.0 andPostgreSQL7.3.2. MySQL and PostgreSQL are two one-upsource-open databases. A great deal of classical technology andalgorithm such as genetic query optimization algorithm are made useof to implement their query engines. There are also much innovation.With the progress of technology, more function modules areappended. There are mostly five folders(parser,rewrite,optimizer,executor and commands) in PostgreSQL query source codes,andone folder(sql) in MySQL. The penman has written down detaileddocuments for each file, and summed up compositive documents foreach folder. As a kind of core technology,it is very difficult to develop adatabase management system. MySQL and PostgreSQL are twopowerful open source databases. MySQL is an attractive alternativeto higher-cost, more complex database technology. Its award-winningspeed, scalability and reliability make it the right choice for corporateIT departments, Web developers and packaged software vendors.PostgreSQL is an complicated and object-relational databasemanagement system.It has pioneered many concepts that onlybecame available in some commercial database systems muchlater.After researching the source codes of open source database,wecan understand and master the method of design and implementationof database management system,study the newest databaseimplementation technology nowadays,and make the best of thecorresponding technology to develop homemade database. A database management system chiefly consists of storagemanagement system, query processing system and transactionmanagement system. The main function of query processing is asfollows. Given a transmitted query ,parser and optimize it, then createa plantree, then carry out this plan. The implementation method ofquery engine of PostgreSQL is different from MySQL's in manyaspects. And much technology used is classical in schoolbook. Thepenman analyzes them by the numbers and contrasts PostgreSQLwith MySQL detailedly. The paper will introduce PostgreSQL mainly,MySQL secondarily. Because of the limit of knowledge, some detail isnot analyzed well, and dynamic debugging and tracing method islacking. Farther analysis could be done in these aspects later. In conclusion, this paper implements the acid subsystem of...