Efficient access to a very large spatial database

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

Efficient access to a very large spatial database

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

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution › Academic › peer-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 language	English
Title of host publication	Proceedings of the 2nd European conference on Geographic Information Systems
Number of pages	10
Publication status	Published - 1996
Event	2nd European conference on Geographic Information Systems - Barcelona Duration: 27 Mar 1996 → 29 Mar 1996

Conference

Conference	2nd European conference on Geographic Information Systems
Abbreviated title	JEC96
City	Barcelona
Period	27/03/96 → 29/03/96

Keywords

PGM
ADLIB-ART-612

Access to Document

jec96

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

Cite this

@inproceedings{7a5e2d73298e4e5e986890838ee83111,

title = "Efficient access to a very large spatial database",

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.",

keywords = "PGM, ADLIB-ART-612",

author = "{van Oosterom}, P.J.M. and C. Lemmen",

note = "In: Proceedings of the 2nd European conference on Geographic Information Systems, Barcelona, 1996. Vol. 2. pp. 814-823; 2nd European conference on Geographic Information Systems, JEC96 ; Conference date: 27-03-1996 Through 29-03-1996",

year = "1996",

language = "English",

booktitle = "Proceedings of the 2nd European conference on Geographic Information Systems",

}

TY - GEN

T1 - Efficient access to a very large spatial database

AU - van Oosterom, P.J.M.

AU - Lemmen, C.

N1 - In: Proceedings of the 2nd European conference on Geographic Information Systems, Barcelona, 1996. Vol. 2. pp. 814-823

PY - 1996

Y1 - 1996

N2 - 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.

AB - 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.

KW - PGM

KW - ADLIB-ART-612

M3 - Conference contribution

BT - Proceedings of the 2nd European conference on Geographic Information Systems

T2 - 2nd European conference on Geographic Information Systems

Y2 - 27 March 1996 through 29 March 1996

ER -