Efficient access to a very large spatial database

P.J.M. van Oosterom, C. Lemmen

Research output: Chapter in Book/Report/Conference proceedingConference contributionAcademicpeer-review

Abstract

This paper describes the results of the benchmark of a very large database performed during the months July/August 1995 with the test data set 'Zeeland'. Some important aspects of the tests are using: OME/SOL (Object Management Extension/Spatial Object Library), SLC (Spatial Location Code), and data compression. The results have been compared to the current situation of our main database in Zeeland. In general it can be concluded that the benchmarks requirements are met on the average the check-out times are 10 times faster compared to the current main database partly due to faster hardware, check-in times are speed-up even more. The SLC technique has proven to be a good alternative for spatial indexing within the database, as representative spatial queries are speed up between 100 and 200 times. The SQL (Structured Query Language) queries show the flexibility of a relational database especially valuable are the SQL queries using spatial operators of OME/SOL.
Original languageEnglish
Title of host publicationProceedings of the 2nd European conference on Geographic Information Systems
Number of pages10
Publication statusPublished - 1996
Event 2nd European conference on Geographic Information Systems - Barcelona
Duration: 27 Mar 199629 Mar 1996

Conference

Conference 2nd European conference on Geographic Information Systems
Abbreviated titleJEC96
CityBarcelona
Period27/03/9629/03/96

Keywords

  • PGM
  • ADLIB-ART-612

Fingerprint Dive into the research topics of 'Efficient access to a very large spatial database'. Together they form a unique fingerprint.

Cite this