transaction processing Transaction processing is information processing in computer science that is divided into individual, indivisible operations called ''transactions''. Each transaction must succeed or fail as a complete unit; it can never be only partially comple ...

, the Telecommunication Application Transaction Processing Benchmark (TATP) is a

benchmark Benchmark may refer to: Business and economics * Benchmarking, evaluating performance within organizations * Benchmark price * Benchmark (crude oil), oil-specific practices Science and technology * Benchmark (surveying), a point of known elevatio ...

designed to measure the performance of

in-memory database An in-memory database (IMDB, or main memory database system (MMDB) or memory resident database) is a database management system that primarily relies on main memory for computer data storage. It is contrasted with database management systems that e ...

transaction systems.

Benchmark

As database and microprocessor architectures change, so must the benchmarks that are employed to measure the combined performance of these critical components. While other

industry standard ''Industry Standard'' is the sixth studio album by the Dixie Dregs, released in 1982. This was the second of two albums released under the moniker The Dregs, and is their only album featuring vocals (by Alex Ligertwood of Santana and Patrick Sim ...

throughput workloads already exist, none was designed specifically to exercise the relationship between in-memory

database software In computing, a database is an organized collection of data stored and accessed electronically. Small databases can be stored on a file system, while large databases are hosted on computer clusters or cloud storage. The design of databases span ...

and the memory processing subsystem in which it transacts. The TATP is a new

open source Open source is source code that is made freely available for possible modification and redistribution. Products include permission to use the source code, design documents, or content of the product. The open-source model is a decentralized sof ...

workload designed specifically for high-throughout applications, well suited for in-memory database performance analysis and system comparison. The TATP benchmark simulates a typical

home location register Network switching subsystem (NSS) (or GSM core network) is the component of a GSM system that carries out call out and mobility management functions for mobile phones roaming on the network of base stations. It is owned and deployed by mobile ...

(HLR) database used by a mobile carrier. The HLR is an application

mobile network A cellular network or mobile network is a communication network where the link to and from end nodes is wireless. The network is distributed over land areas called "cells", each served by at least one fixed-location transceiver (typically thre ...

operators use to store all relevant information about valid subscribers, including the mobile

phone number A telephone number is a sequence of digits assigned to a landline telephone subscriber station connected to a telephone line or to a wireless electronic telephony device, such as a radio telephone or a mobile telephone, or to other devices f ...

, the services to which they have subscribed, access privileges, and the current location of the subscriber's handset. Every call to and from a mobile phone involves lookups against the HLRs of both parties, making it is a perfect example of a demanding, high-throughput environment where the workloads are pertinent to all applications requiring extreme speed: telecommunications,

financial services Financial services are the Service (economics), economic services provided by the finance industry, which encompasses a broad range of businesses that manage money, including credit unions, banks, credit-card companies, insurance companies, acco ...

, gaming, event processing and alerting, reservation systems,

software as a service Software as a service (SaaS ) is a software licensing and delivery model in which software is licensed on a subscription basis and is centrally hosted. SaaS is also known as "on-demand software" and Web-based/Web-hosted software. SaaS is con ...

(SaaS), and so on. The benchmark generates a flooding load on a

database server A database server is a server which uses a database application that provides database services to other computer programs or to computers, as defined by the client–server model. Database management systems (DBMSs) frequently provide database- ...

. This means that the load is generated up to the maximum throughput point that the server can sustain. The load is generated by issuing pre-defined transactions run against a specified target database. The target

database schema The database schema is the structure of a database described in a formal language supported by the database management system (DBMS). The term "schema" refers to the organization of data as a blueprint of how the database is constructed (divide ...

is made to resemble a typical HLR database in a

mobile phone network A cellular network or mobile network is a communication network where the link to and from end nodes is wireless. The network is distributed over land areas called "cells", each served by at least one fixed-location transceiver (typically thre ...

. The algorithm of what is known as the TATP Benchmark was originally published in a Master's Thesis. The benchmark was modeled after a real test program that was used by a telecom equipment manufacturer to evaluate the applicability of various

relational database A relational database is a (most commonly digital) database based on the relational model of data, as proposed by E. F. Codd in 1970. A system used to maintain relational databases is a relational database management system (RDBMS). Many relatio ...

systems to service control programming in mobile networks. Another derivative of the original test is the Network Database Benchmark. TATP executes seven pre-defined transactions that insert, update, delete and query the data in the database. The TATP results show the Mean Qualified Throughput (MQTh) of the target database system, and the

response time Response time may refer to: *The time lag between an electronic input and the output signal which depends upon the value of passive components used. * Responsiveness, how quickly an interactive system responds to user input * Response time (biolog ...

distributions per transaction type for all seven types of transactions. The TATP benchmark has been used in industry and research.Kevin P. Gaffney, Martin Prammer, Larry Brasfield, D. Richard Hipp, Dan Kennedy, and Jignesh M. Patel. 2022. SQLite: past, present, and future. Proc. VLDB Endow. 15, 12 (August 2022), 3535–3547. https://doi.org/10.14778/3554821.3554842

References

{{reflist

External links

* SourceForge.net
Telecommunication Application Transaction Processing (TATP) Benchmark
* Antoni Wolski and Vilho Raatikka:
Performance Measurement and Tuning of Hot-Standby Databases
, Third International Service Availability Symposium (ISAS 2006), May 15–16, 2006, Helsinki, Finland. * Github.com
Implementation of TATP for Volt
Transaction processing