Recently, the case has been made for operational or real-time Business Intelligence (BI). As
the traditional separation into OLTP database and OLAP data warehouse obviously incurs
severe latency disadvantages for operational BI, hybrid OLTP&OLAP database systems are
being developed. The advent of the first generation of such hybrid OLTP&OLAP database
systems requires means to characterize their performance. While there are standardized
and widely used benchmarks addressing either OLTP or OLAP workloads, the lack of a …

SELECT n_name, SUM (ol_amount) AS revenue FROM customer," order", orderline, stock,
supplier, nation, region WHERE c_id= o_c_id AND c_w_id= o_w_id AND c_d_id= o_d_id
AND ol_o_id= o_id AND ol_w_id= o_w_id AND ol_d_id= o_d_id AND ol_w_id= s_w_id
AND ol_i_id= s_i_id AND mod ((s_w_id* s_i_id), 10000)= su_suppkey AND ascii
(SUBSTRING (c_state, 1, 1))= su_nationkey AND su_nationkey= n_nationkey AND
n_regionkey= r_regionkey AND r_name='[REGION]'AND o_entry_d>='[DATE]'GROUP BY …