Understanding TPC-H and TPC-E Performance Benchmarks

In order to understand how the performances of databases can be bench marked it helps to understand how they can be organized for the purposes of classification. In terms of their structure, databases can be considered to be able to run two broad types of queries, namely,

  1. Online Transaction Processing (OLTP) queries — These are typically the queries that are run day in, day out in businesses such as Customer Relationship Management (CRM) and Enterprise Resource Planning (ERP) systems where for example invoice values are inserted, updated or…