Transaction Processing over XML (TPoX) is acomputing benchmark forXML database systems. As abenchmark, TPoX is used for theperformance testing ofdatabase management systems that are capable of storing, searching, modifying 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 andlogging, andconcurrency control. TPoX includes XML update tests based on theXQuery Update Facility.

The TPoX benchmark exercises the processing ofdata-centric XML, in contrast to content- ordocument-centric XML.

TPoX was originally developed and tested byIBM andIntel, but became an open source project onSourceForge in January 2007. TPoX 1.1 was released in June 2007. TPoX 2.0 was released in July 2009.

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 asFIXML to model real-world applications.
• Workloads which are executed on the generated data. A workload is a set of transactions. Atransaction can be a query inXQuery orSQL/XML notation or an insert, update or delete operation.
• AJava 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.

The TPoX workload consists of seven XML queries, two inserts, two deletes, and sixXML update operations. The primary performance metric of the benchmark is TTPS (TPoX Transactions Per Second) which is the throughput of the multi-user read/write workload at a givenscale factor. The smallest TPoX scale factor uses 10GB of raw XML documents, the largest uses1PB of raw XML documents.

• Ron Bourret'slist of XML database benchmarks
• An XML transaction processing benchmark, Proceedings of the 2007ACMSIGMOD International Conference on Management of Data
• TheCEO of Marklogic describes TPoX as a data-centric as opposed to content-centric XML scenario.
• TPoX is included in thelist of XML Benchmarks in theEncyclopedia of Database Systems.
• TPoX is used in section 7.2 of anarticle fromOracle Corporation.
• TPoX is used in aresearch study from theUniversity of Kaiserslautern, Germany.
• TPoX has been used in aresearch project to evaluate the efficiency ofsolid state disks.
• DB2 9.5 pureXML Performance Trends on the Next Generation Quad-Core Intel Xeon Processor
• DB2 9 pureXML Scalability on Intel Xeon MP Platforms Using IBM N Series Storage
• Taming a Terabyte of XML Data

• Transaction Processing over XML (TPoX)
  • TPoX 1.1
  • TPoX 1.2
  • TPoX 1.3
  • TPoX 2.0
• TPoX Benchmark Results

• Benchmarks (computing)

• Articles with short description
• Short description matches Wikidata