This is an extremely watered down version of the sequioa2000 benchmark. We include all of the source (both c and sql) used to run the queries, but the data (normally very large) has been severely subsetted. We provide little more than we need to generate results when the queries are run. For a description of the benchmark see the paper published in the SIGMOD '93 proceedings. In order to run this example you must have the ability to use the spatial blade. The install process in the makefile will attempt to install it in the specified database. You also need write permission in the ../data directory as it is used to uncompress the raster files. To make everything run "make MI_DATABASE=bench all" README - your roadmap makefile - self evident setup.sql - sql queries to create the benchmark schema index.sql - indices normally useful for the benchmark queries drop.sql - the inverse of the setup.sql script load.sh - shell script to handle data loading query2.sql - query*.sql are the benchmark queries. see SIGMOD '93 query3.sql query4.sql query5.sql query6.sql query7.sql query8.sql query9.sql query10.sql drop_temps.sql - script to drop all temporaries create by the benchmark queries and vacuum the database. raster.c - adt functions implementing the required raster operations geo-decls.h - include file for polyfuncs.c - adt functions beyond what the spatial blade provides gen_querydefs - shell script to generate query_defs.h from the .sql files query_defs.h - generated file specifying the query text for the benchmark mife.c - simplistic front end program used to collect timings for - the benchmark runs.