HammerDB

Last updated

HammerDB
Developer(s) Steve Shaw
Stable release
4.4
Repository github.com/TPC-Council/HammerDB
Available inEnglish
Type Load testing
License GPLv3
Website www.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]

Contents

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