Title :
Evaluating query performance on object-relational spatial databases
Author :
Zhou, Zhonghai ; Zhou, Bin ; Li, Wenwen ; Griglak, Brian ; Caise, Carmen ; Huang, Qunying
Author_Institution :
Coll. of Marine Geosci., Sea Instrum. Meas. Appliance Res. Inst. of Shandong province Acad. of Sci., Ocean Univ. of China, Qingdao, China
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 :
query processing; relational databases; visual databases; database management system; geospatial data; object-relational database; query performance evaluation; vector spatial database; Data mining; Data models; Database systems; Educational institutions; Instruments; Oceans; Open source software; Relational databases; Spatial databases; Visual databases; DBMS; benchmark; spatial analysis; spatial database;
Conference_Titel :
Computer Science and Information Technology, 2009. ICCSIT 2009. 2nd IEEE International Conference on
Conference_Location :
Beijing
Print_ISBN :
978-1-4244-4519-6
Electronic_ISBN :
978-1-4244-4520-2
DOI :
10.1109/ICCSIT.2009.5234509
