HammerDB

HammerDB
Developer(s)Steve Shaw
Stable release
4.4
Repositorygithub.com/TPC-Council/HammerDB
Available inEnglish
TypeLoad testing
LicenseGPLv3
Websitewww.hammerdb.com

HammerDB is an open source database benchmarking application developed by Steve Shaw. HammerDB supports databases such as Oracle, SQL Server, Db2, MySQL and MariaDB. HammerDB is written in TCL and C, and is licensed under the GPL v3.[1]

Features

HammerDB is a database load testing and benchmarking tool. HammerDB is used to create a test schema, load it with data and simulate the workload of multiple virtual users against the database for both transactional and analytic scenarios. HammerDB makes it possible to run derived workloads of the industry standard TPROC-C & TPROC-H (known by trademarks TPC-C and TPC-H respectively) so they can compare and contrast systems, databases and database cloud services.[1][2]

HammerDB supports Oracle Database, Microsoft SQL Server, IBM Db2, TimesTen, MySQL, MariaDB, PostgreSQL, Greenplum, Postgres Plus Advanced Server, Amazon Aurora and Amazon Redshift. HammerDB also includes deprecated workloads for Redis and Apache Trafodion.[1][2][3][4][5][6]

HammerDB is developed in the languages TCL and C - this is to avoid a common 'feature' of Python called the Global Interpreter Lock or GIL.[1][7]

HammerDB is hosted on GitHub by TPC-Council.[8] The Transaction Processing Performance Council (TPC) is described as "a worldwide consortium that establishes standards intended to promote the fast, efficient and reliable execution of e-commerce and database transactions".[9][10]

See also

References

  1. ^ a b c d "HammerDB". www.hammerdb.com. Retrieved 2022-04-27.
  2. ^ a b "How to benchmark performance of Citus and Postgres with HammerDB on Azure". www.citusdata.com. Retrieved 2022-04-27.
  3. ^ "HammerDB". www.hammerdb.com. Retrieved 2022-04-27.
  4. ^ "Benchmark Amazon RDS SQL Server performance using HammerDB". Amazon Web Services. 2021-11-17. Retrieved 2022-04-27.
  5. ^ "MySQL vs MariaDB vs Aurora performance and cost comparison". SQLPipe. 2022-01-17. Retrieved 2022-04-27.
  6. ^ "Accelerate Oracle Database with the Next-Gen FlashArray//X". Pure Storage Blog. 2020-03-18. Retrieved 2022-04-27.
  7. ^ "HammerDB Concepts and Architecture – HammerDB Blog". 30 November 2018. Retrieved 2022-04-27.
  8. ^ "TPC - Transaction Processing Performance Council". GitHub. Retrieved 2022-04-27.
  9. ^ "What is Transaction Processing Performance Council (TPC)? - Definition from WhatIs.com". SearchAppArchitecture. Retrieved 2022-04-27.
  10. ^ "Twitter @Daniel_Bowers regarding TCP and HammerDB". Twitter. Retrieved 2022-04-27.