[Tpc-info] Request for Clarification on TPC-H Version 3.0.0/3.0.1 Data Calculation

[Dhuny, Riyad]

Dear TPC support officer,

I hope you're doing well. Firstly, I would like to express my admiration
for the TPC team for keeping this exceptional benchmark system and tools
continuously operational for over two decades. Your efforts have certainly
not gone unnoticed and are very much appreciated.

I'm just reaching out to ask for clarification on a specific piece of
information found in versions 3.0.0/3.0.1 of the TPC-H. My query pertains
to the Sample Executive Summary of TPC-H, which starts from page 133. On
page 137, there is a table—specifically the first one—which includes
various timing intervals (in seconds) in column Q1.

It appears there may be a discrepancy in the maximum value of this column.
The minimum value is 45.23, which appears to be correct. However, the
Maximum is displayed as 69.14, whereas it should reflect 97.31.
Additionally, the average column shows a value of 485.51, which roughly
equal the sum of the 8 streams.

So, I'm wondering: Are the minimum, maximum, and average values in this
column calculated solely based on the values present in column Q1? If not,
could you please clarify how these values are determined? If these values
are derived from conducted tests, I kindly request further information on
how these tests were carried out.

I'm looking forward to hearing back from you on this.

Kind Regards

Riyad Dhuny
Senior Lecturer, Department of Creative Arts, Film and Media Technologies
(CAFMT)
School of Innovative Technologies and Engineering (SITE)
University of Technology, Mauritius
La Tour Koenig, Pointe-aux-Sables.Tel: (230) 207 52 50.

------------------------------
*DISCLAIMER*: This message contains confidential information and is
intended only for the recipient. If you are not the intended recipient and
you have received the email by mistake, you should not disseminate,
distribute or copy this email. Kindly notify the sender and delete the
email from your system. Unwarranted use of emails will be dealt with as per
current legislation.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.tpc.org/pipermail/tpc-info/attachments/20240603/33028ddb/attachment.html