Evaluating query performance on object-relational spatial databases

Zhonghai Zhou, Bin Zhou, WenWen Li, Brian Griglak, Carmen Caiseda, Qunying Huang

Research output: Chapter in Book/Report/Conference proceedingConference contribution

6 Citations (Scopus)

Abstract

The great popularity of geospatial data and increasing use in commercial as well as scientific applications is a significant event of our times. The overwhelming flow of data has made Database management systems (DBMS) a ubiquitous component for scientific research. However, although many database management systems have been built, there have been very few systematic comparisons of performance and functionalities especially few benchmark standards. In this paper, we aim to perform a performance evaluation for vector spatial databases and shows how the evaluation has been implemented in four spatial database systems, including object-relational database IBM DB2 Spatial Extender, Oracle Spatial, PostgreSQL and MySQL spatial. We expect this work to provide a standard benchmark in evaluating facilities and the efficiencies of various spatial database managers as well as guidance on selection for scientific application of spatial database.

Original languageEnglish (US)
Title of host publicationProceedings - 2009 2nd IEEE International Conference on Computer Science and Information Technology, ICCSIT 2009
Pages489-492
Number of pages4
DOIs
StatePublished - 2009
Externally publishedYes
Event2009 2nd IEEE International Conference on Computer Science and Information Technology, ICCSIT 2009 - Beijing, China
Duration: Aug 8 2009Aug 11 2009

Other

Other2009 2nd IEEE International Conference on Computer Science and Information Technology, ICCSIT 2009
CountryChina
CityBeijing
Period8/8/098/11/09

Fingerprint

Managers

Keywords

  • Benchmark
  • DBMS
  • Spatial analysis
  • Spatial database

ASJC Scopus subject areas

  • Computer Science Applications
  • Information Systems
  • Software

Cite this

Zhou, Z., Zhou, B., Li, W., Griglak, B., Caiseda, C., & Huang, Q. (2009). Evaluating query performance on object-relational spatial databases. In Proceedings - 2009 2nd IEEE International Conference on Computer Science and Information Technology, ICCSIT 2009 (pp. 489-492). [5234509] https://doi.org/10.1109/ICCSIT.2009.5234509

Evaluating query performance on object-relational spatial databases. / Zhou, Zhonghai; Zhou, Bin; Li, WenWen; Griglak, Brian; Caiseda, Carmen; Huang, Qunying.

Proceedings - 2009 2nd IEEE International Conference on Computer Science and Information Technology, ICCSIT 2009. 2009. p. 489-492 5234509.

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Zhou, Z, Zhou, B, Li, W, Griglak, B, Caiseda, C & Huang, Q 2009, Evaluating query performance on object-relational spatial databases. in Proceedings - 2009 2nd IEEE International Conference on Computer Science and Information Technology, ICCSIT 2009., 5234509, pp. 489-492, 2009 2nd IEEE International Conference on Computer Science and Information Technology, ICCSIT 2009, Beijing, China, 8/8/09. https://doi.org/10.1109/ICCSIT.2009.5234509
Zhou Z, Zhou B, Li W, Griglak B, Caiseda C, Huang Q. Evaluating query performance on object-relational spatial databases. In Proceedings - 2009 2nd IEEE International Conference on Computer Science and Information Technology, ICCSIT 2009. 2009. p. 489-492. 5234509 https://doi.org/10.1109/ICCSIT.2009.5234509
Zhou, Zhonghai ; Zhou, Bin ; Li, WenWen ; Griglak, Brian ; Caiseda, Carmen ; Huang, Qunying. / Evaluating query performance on object-relational spatial databases. Proceedings - 2009 2nd IEEE International Conference on Computer Science and Information Technology, ICCSIT 2009. 2009. pp. 489-492
@inproceedings{8ebe7849b2034e4eafa94c93a868036d,
title = "Evaluating query performance on object-relational spatial databases",
abstract = "The great popularity of geospatial data and increasing use in commercial as well as scientific applications is a significant event of our times. The overwhelming flow of data has made Database management systems (DBMS) a ubiquitous component for scientific research. However, although many database management systems have been built, there have been very few systematic comparisons of performance and functionalities especially few benchmark standards. In this paper, we aim to perform a performance evaluation for vector spatial databases and shows how the evaluation has been implemented in four spatial database systems, including object-relational database IBM DB2 Spatial Extender, Oracle Spatial, PostgreSQL and MySQL spatial. We expect this work to provide a standard benchmark in evaluating facilities and the efficiencies of various spatial database managers as well as guidance on selection for scientific application of spatial database.",
keywords = "Benchmark, DBMS, Spatial analysis, Spatial database",
author = "Zhonghai Zhou and Bin Zhou and WenWen Li and Brian Griglak and Carmen Caiseda and Qunying Huang",
year = "2009",
doi = "10.1109/ICCSIT.2009.5234509",
language = "English (US)",
isbn = "9781424445196",
pages = "489--492",
booktitle = "Proceedings - 2009 2nd IEEE International Conference on Computer Science and Information Technology, ICCSIT 2009",

}

TY - GEN

T1 - Evaluating query performance on object-relational spatial databases

AU - Zhou, Zhonghai

AU - Zhou, Bin

AU - Li, WenWen

AU - Griglak, Brian

AU - Caiseda, Carmen

AU - Huang, Qunying

PY - 2009

Y1 - 2009

N2 - The great popularity of geospatial data and increasing use in commercial as well as scientific applications is a significant event of our times. The overwhelming flow of data has made Database management systems (DBMS) a ubiquitous component for scientific research. However, although many database management systems have been built, there have been very few systematic comparisons of performance and functionalities especially few benchmark standards. In this paper, we aim to perform a performance evaluation for vector spatial databases and shows how the evaluation has been implemented in four spatial database systems, including object-relational database IBM DB2 Spatial Extender, Oracle Spatial, PostgreSQL and MySQL spatial. We expect this work to provide a standard benchmark in evaluating facilities and the efficiencies of various spatial database managers as well as guidance on selection for scientific application of spatial database.

AB - The great popularity of geospatial data and increasing use in commercial as well as scientific applications is a significant event of our times. The overwhelming flow of data has made Database management systems (DBMS) a ubiquitous component for scientific research. However, although many database management systems have been built, there have been very few systematic comparisons of performance and functionalities especially few benchmark standards. In this paper, we aim to perform a performance evaluation for vector spatial databases and shows how the evaluation has been implemented in four spatial database systems, including object-relational database IBM DB2 Spatial Extender, Oracle Spatial, PostgreSQL and MySQL spatial. We expect this work to provide a standard benchmark in evaluating facilities and the efficiencies of various spatial database managers as well as guidance on selection for scientific application of spatial database.

KW - Benchmark

KW - DBMS

KW - Spatial analysis

KW - Spatial database

UR - http://www.scopus.com/inward/record.url?scp=70449096244&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=70449096244&partnerID=8YFLogxK

U2 - 10.1109/ICCSIT.2009.5234509

DO - 10.1109/ICCSIT.2009.5234509

M3 - Conference contribution

AN - SCOPUS:70449096244

SN - 9781424445196

SP - 489

EP - 492

BT - Proceedings - 2009 2nd IEEE International Conference on Computer Science and Information Technology, ICCSIT 2009

ER -