Extension Of Database Decision Support Testing System And Analysis Of InnoDB Storage Management

This paper consists of two parts: the first part introduces the extension ofdatabase decision support testing system;the second part introduces theanalysis results of storage management system of InnoDB that is a engine inthe open source database MySQL .The first part introduces the extension of database decision support testingsystem.General database decision support testing system is one of databaseperformance test system RedPTS(RedBase performance testing system) thatconsists of three testing systems.It is used to evaluate database ability in theaspect of processing complex queries.The design of database decisionsupport testing system is mainly based on TPC-H specification,and the maintechnologies derive from the test tool DBT3 that is opensource anddeveloped by the Open Source Development Lab in America.TPC-H is one of several specifications about transaction processing anddatabase benchmark that is defined by TPC(Transaction ProcessingCouncil).TPC is a non -profit organization located in SanFransisco ,California state.TPC was sponsored by Omri Serlin and foundedby 8 companies that supply software and hardware system or relativesolution in August 10,1988.The number of current members exceeds fiftythat include the main database companies and server hardware supplies,suchas IBM,NCR,HP,Oracle,Microsoft. TPC has defined serials ofbenchmarks that include TPC-A,TPC-B,TPC-C,TPC-D ,TPC-R/ TPC-H,TPC-W. The main aim of TPC is to specify some specifications aboutperformance test for some specific fields,for example, on-line transactionprocessing system,data warehouse or decision support system,electroniccommerce solution and so on. Besides,TPC alse defined the method ofcomputing system cost and the method of reporting performanceresults,which supplies the reference standards for users who want to selectplatforms for relative solutions.TPC-H is named as decision support benchmark, and is used to testdatabase ability in processing complex queries.TPC-H models complexbusiness analysis applications that refined data to support the making ofsound business decisions.The simulated business model is of a wholesalesupplier.TPC-H has twenty-two decision support queries.While emphasizingon information analysis,TPC-H defines two refresh functions (insert anddelete) to satisfy the need to periodically update the database.The databasesize is defined by a scale factor(SF).For example, a SFof 1 represents aTPC-H database sized at about 1GB.A complete test run consists of one loadtest and two run of performance test.Each performance test consists of apower test and a throughput test.Power test simulates single user state andthroughput test simulates several users who execute queries in parallel.Thetest results from the slowest performance run are used to compute themetric.The performance metric that needs to be reported is QphH@Size thatis the number of complex queries processed by database in an hour if SF=1. TPC organization supplies only the TPC-H specification but not the testtool to evaluate TPC-H performance.Currently OSDL DBT3 is a free testprograms to test TPC-H performance.DBT3, written by c language, is basedon TPC-H specification version 1.5.0.It applies to Linux platform and canonly test database SAPDB and PostgreSQL.DBT3 is designed to run underthe host-based configuration that put DBT3 and the database on the samesystem. Jilin university base technology group of data processing has realizedthree benchmarks to several open source database and one domesticdatabase.The tests have been finished by the research group include:TPC-Ctest on database MySQL5.0,PostgreSQL7.5,Oracle9i,and a domesticdatabase;TPC-W test on database MySQL5.0,PostgreSQL7.5,Oracle9i ,and adomestic database;TPC-H test on database Oracle9i and Maxdb. The first part in this paper introduces the method of adding databaseOracle into DBT3 test tool,which include in details the extension of querytemplates,refresh functions and test scripts.Besides,this paper introduces thegeneral method of adding any database into DBT3 test tool.In the last ,thispaper introduces the steps to test Oracle9i under c/s model,then it offer thetest results to reader.This paper also includes the analysis of test results fromthe angles:the design of queries,system cpu,system memory and system diski/o ability.These will affect the results when running the test. The second part introduces the analysis results of InnoDB storagemanagement system. Currently there are many research results about the database principles,butthere are less research results about the database implementation...