Type of TPC benchmarks model:
editing the SQL is not allowed
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:
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.
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.
http://www.hammerdb.com/ for execution, installation and more. (Code)