Is there a datawarehousing benchmark available?
In the latest 2.3 build of swingbench (December 2009) there is a new wizard “shwizard” that builds a sales history schema. It is currently under test but it can be used to build a sizeable test database. Swingbench also includes a config (shconfig under the $SWINGHOME/bin/sample directory) with and a number of queries to stress the resultant schema. I’ll be producing a web page shortly to describe its setup and configuration.
