With the growing popularity of Web Mapping and Location based services, spatial support in major relational databases has become increasingly important. The spatial functionalities across commercial and open-source databases differ widely and there is no standard spatial database benchmark to compare such diverse offerings.
Jackpine is a spatial database benchmark that fills this role. It was developed as part of our ongoing research into system software support for spatial database workloads. The benchmark includes a comprehensive set of queries that exercise spatial features, as well as macrobenchmark workloads that model common real-life usage scenarios. It is also extensible so that new test scenarios can be added.
Trivia: the Jack pine is a species of pine tree. It is also the name of a famous painting by Canadian painter Tom Thomson.