- Transaction Processing over XML
Transaction Processing over XML (TPoX) is a computing benchmark for
XML database systems. As a benchmark, TPoX is used for the performance testing ofdatabase management system s that are capable of storing, searching and retrievingXML data. The goal of TPoX is to allow database designers, developers and users to evaluate the performance of XML database features, such as the XML query languagesXQuery andSQL/XML , XML storage, XML indexing,XML Schema support, XML updates,transaction processing and logging, andconcurrency control .TPoX was originally developed and tested by
IBM and Intel, but became an open source project onSourceForge in January 2007. TPoX 1.1 was released in June 2007. TPoX also proposes XML update tests based on theXQuery Update Facility .The TPoX benchmark exercises the processing of data-centric XML, in contrast to content- or document-centric XML.
The TPoX benchmark package contains the following:
* XML Schemas that define the XML data used in the benchmark.
* An XML data generation tool to generate an arbitrary number of XML documents with well-defined value distributions andreferential integrity across documents. The XML data is generated conforming to industry schema such as FIXML to model real-world applications.
* Workloads which are executed on the generated data. A workload is a set of transactions. A transaction can be a query inXQuery orSQL/XML notation or an insert, update or delete operation.
* A Java application which acts as a workload driver. It is configurable and can spawn 1 to n parallel threads to simulate concurrent database users. Each user connects to the database and executes a random sequence of transactions defined in the workload. Parameter markers in the transactions are replaced by real values that are drawn from random value distributions. The workload driver collects and reports performance metrics, such as the transaction throughput as well as minimum, maximum and average response times.
* Documentation.References
* Ron Bourret's [http://www.rpbourret.com/xml/XMLDBLinks.htm#Benchmarks list] of XML datrabase benchmarks
* [http://wdm.cpsc.ucalgary.ca/?q=node/93 New XML benchmark based on ToXgene]
* [http://portal.acm.org/citation.cfm?doid=1247480.1247590 An XML transaction processing benchmark] , Proceedings of the 2007 ACMSIGMOD International Conference on Management of Data
* [http://www.ibm.com/developerworks/db2/library/techarticle/dm-0606schiefer/ DB2 9 XML performance characteristics]
* TPoX is referenced as [16] in a [http://wwwiti.cs.uni-magdeburg.de/iti_db/workshops/BTW-07/papers/E00-46636036.pdf research paper] from theUniversity of Kaiserslautern , Germany
* The [http://marklogic.blogspot.com/2007/01/waiting-for-godot-no-more-xquerys-done.html CEO of Marklogic] describes TPoX as a data-centric as opposed to content-centric XML scenario.
* [http://softwarecommunity.intel.com/articles/eng/3796.htm DB2® 9.5 pureXML™* Performance Trends on the Next Generation Quad-Core Intel® Xeon® Processor]
* [http://www.intel.com/performance/server/xeon_mp/application.htm?iid=perf+sv_app XML transaction processing performance on IBM DB2* database]External links
* [http://tpox.sourceforge.net/ Transaction Processing over XML (TPoX)]
** [https://sourceforge.net/forum/forum.php?forum_id=705891 TPoX 1.1]
** [https://sourceforge.net/forum/forum.php?forum_id=835414 TPoX 1.2]
Wikimedia Foundation. 2010.