Relation - Database Benchmark

1 - Tpc

1.1 - Model

Type of TPC benchmarks model:

  • the operational aspect of the business environment where transactions are executed on a real time basis.
  • the simpler, more static model of decision support.

editing the SQL is not allowed

1.1.1 - TPC-DS

TPC-DS does not benchmark the operational systems.

The TPC-DS benchmark, models the challenges of business intelligence systems where operational data is used both:

  • to support the making of business decisions in near real time
  • and to direct long-range planning and exploration.

Big data - TPC-DS is well-known in the industry as the right benchmark for data warehousing workloads because it uses larger tables and more complex queries representative of real analytics use cases. TPC-DS consisting of 99 queries.

1.1.2 - TPC-H

TPC - TPC-H Decision Support Benchmark Sample Schema: Measures performance against 22 different queries and is typically used to evaluate data warehouses and other decision support systems.

1.2 - Single node

1.3 - Distributed

2 - Software

http://www.hammerdb.com/ for execution, installation and more. (Code)

data/type/relation/benchmark/benchmark.txt ยท Last modified: 2018/07/08 20:50 by gerardnico