Sample Queries
In this page, you will find a list of sample queries which we used DBToaster for generating IVM programs in both C++ and Scala.
Note: The generated IVM programs are not meant to be human readable, and are presented for giving you an impression of the kind of IVM programs generated for each query.
1. TPC-H queries
tpch1
tpch2
tpch3
tpch4
tpch5
tpch6
tpch7
tpch8
tpch9
tpch10
tpch11
tpch11a
tpch11c
tpch12
tpch13
tpch14
tpch15
tpch16
tpch17
tpch17a
tpch18
tpch18a
tpch19
tpch20
tpch21
tpch22
tpch22a
2. Finance queries
axfinder
brokerspread
brokervariance
pricespread
vwap
3. Simple queries
inequality_selfjoin
invalid_schema_fn
m3k3unable2escalate
miraculous_minus
miraculous_minus2
r_aggcomparison
r_aggofnested
r_aggofnestedagg
r_agtb
r_agtbexists
r_avg
r_bigsumstar
r_btimesa
r_btimesacorrelated
r_count
r_count_of_one
r_count_of_one_prime
r_deepscoping
r_divb
r_existsnestedagg
r_gbasumb
r_gtealldynamic
r_gtesomedynamic
r_gtsomedynamic
r_impossibleineq
r_indynamic
r_ineqandeq
r_instatic
r_lift_of_count
r_ltallagg
r_ltallavg
r_ltallcorravg
r_ltalldynamic
r_multinest
r_multiors
r_natselfjoin
r_nogroupby
r_nonjoineq
r_possibleineq
r_possibleineqwitheq
r_selectstar
r_simplenest
r_smallstar
r_starofnested
r_starofnestedagg
r_sum_gb_all_out_of_aggregate
r_sum_gb_out_of_aggregate
r_sum_out_of_aggregate
r_sumadivsumb
r_sumdivgrp
r_sumnestedintarget
r_sumnestedintargetwitheq
r_sumoutsideofagg
r_sumstar
r_union
r_unique_counts_by_a
rr_ormyself
rs
rs_cmpnest
rs_column_mapping_1
rs_column_mapping_2
rs_column_mapping_3
rs_eqineq
rs_ineqonnestedagg
rs_inequality
rs_ineqwithnestedagg
rs_joinon
rs_joinwithnestedagg
rs_natjoin
rs_natjoinineq
rs_natjoinpartstar
rs_selectconstcmp
rs_selectpartstar
rs_selectstar
rs_simple
rs_stringjoin
rst
rstar
rtt_or_with_stars
singleton_renaming_conflict
ss_math
t_lifttype
4. Employee queries
query01
query01a
query02
query02a
query03
query03a
query04
query04a
query05
query06
query07
query08
query08a
query09
query09a
query10
query10a
query11b
query12a
query13
query14
query16
query16a
query17a
query22
query23a
query24a
query35c
query36c
query37
query38a
query39
query40
query45
query46
query47
query47a
query48
query49
query50
query51
query52a
query53a
query54
query55
query56a
query57a
query58a
query59
query60
query61
query62a
query63a
query64a
query65a
5. MDDB queries
mddb1
mddb2
6. Zeus queries
11564068
12811747
37494577
39765730
48183500
52548748
59977251
75453299
94384934
95497049
96434723
