Sample Query Definition (cont.)
2.8.4 Query ValidationFor validation against the qualification database the query must be executed using the following values for the substitution parameters and must produce the following output:Values for substitution parameters:1. DATE = 1994-01-012. DISCOUNT = 0.063. QUANTITY = 24Query validation output data:1 row returned| REVENUE || 11450588.04 |
Query validation demonstrates the integrity of an implementation
- Query phrasings are run against 100MB data set
- Data set must mimic the design of the test data base
- Answers sets must match those in the specification almost exactly
If the answer sets donít match, the benchmark is invalid!