GIS Technology Spatial DBMS testing Summary

This report describes the set up and results of the functionality and performance tests of Oracle 8i spatial DBMS (object model). Two data sets are used. The first data set is geological data delivered by TNO-NITG. The second data set is cadastral (geometric and thematic) data delivered by the Dutch Cadastre. The tests with the cadastral data have also been executed within Ingres II DBMS (with OME/SOL) in order to have some reference figures for the performance tests. Further, this also enables the comparison of query results in the different DBMSs as the answers should be independent on the type of DBMS. It turned out that benchmarking was a very difficult process in which two factors are important. First, on a multi-user machine only the necessary processes should be running and no other large processes (e.g. DBMSs) should be started even if they are not actively running. Second, big differences can exist between ’hot ’ and ’cold ’ situations. In order to obtain repeatable results is was decided to reboot the system and restart the DBMS before every test run. The tests indicate that the functionality of Oracle 8i Spatial is sufficient for both Cadastr