Sample Query Definition (cont.)
2.8.4 Query Validation For 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-01 2. DISCOUNT = 0.06 3. QUANTITY = 24 Query 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!