Testing current DBMS products with real spatial data
Peter J. M. van Oosterom, C.W. Quak, T.P.M. Tijssen · Research Repository (Delft University of Technology) · 2002
T his paper analyses three commercially available geo-DBMSs, several different recent versions of Oracle, Informix and Ingres, with respect to their offered functionality and their performance (and correctness of the results).T he functionality analysis is based on the manuals of the different systems and comparing this to the OpenGIS Simple Feature Specifications for SQL.In addition this paper touches on the topics, which are currently outside the scope of this specification: 3D data, raster (geo-image) data, topology structures, spatial indexing and clustering.T he performance of the three different systems is evaluated by loading two large cadastral data sets (one with 21 million spatial records and one with 122 million spatial records) and firing a set of representative queries on these data sets in order to compare the results and test the scalability.It is very difficult to draw overall conclusions but it is clear that Ingres has the least richness with respect to the functionality, that Informix is the only one compliant to the OpenGIS specifications and that Oracle does not always have the best performance, but it is the richest with respect to the functionality.