Edinburgh Research Archive logo

Edinburgh Research Archive

University of Edinburgh homecrest
View Item 
  •   ERA Home
  • Geosciences, School of
  • GeoSciences MSc thesis collection
  • View Item
  •   ERA Home
  • Geosciences, School of
  • GeoSciences MSc thesis collection
  • View Item
  • Login
JavaScript is disabled for your browser. Some features of this site may not work without it.

Evaluation of spatial database management systems: A performance-based comparison

View/Open
ArbesserRastburgTG_MSc_GIS_DissertationResearchPaper.doc (1.462Mb)
ArbesserRastburgTG_MSc_GIS_DissertationTechnicalDoc.doc (12.09Mb)
Date
26/11/2009
Item status
Restricted Access
Author
Arbesser-Rastburg, Thomas
Metadata
Show full item record
Abstract
This analytical research paper investigates the question which of three Spatial Database Management Systems (Oracle 11g, PostgreSQL 8.3 with PostGIS 1.2 and MySQL 5) installed on a Linux platform performs best in queries used in typical GIS applications. It assesses the components responsible for performance and identifies a suitable methodology for a comprehensible comparison of database management systems. An application is developed to precisely measure the response from the database systems, performing various queries on the geometry data. The result showed that while for lightweight operations, MySQL 5 is performing very well, the other two database systems are by far superior, and with not too much difference, the Oracle 11g DBMS performs best overall in performance critical queries. Recommendations are made with suggestions for case-specific performance measurement.
URI
http://hdl.handle.net/1842/3085
Collections
  • GeoSciences MSc thesis collection

Library & University Collections HomeUniversity of Edinburgh Information Services Home
Privacy & Cookies | Takedown Policy | Accessibility | Contact
Privacy & Cookies
Takedown Policy
Accessibility
Contact
feed RSS Feeds

RSS Feed not available for this page

 

 

All of ERACommunities & CollectionsBy Issue DateAuthorsTitlesSubjectsPublication TypeSponsorSupervisorsThis CollectionBy Issue DateAuthorsTitlesSubjectsPublication TypeSponsorSupervisors
LoginRegister

Library & University Collections HomeUniversity of Edinburgh Information Services Home
Privacy & Cookies | Takedown Policy | Accessibility | Contact
Privacy & Cookies
Takedown Policy
Accessibility
Contact
feed RSS Feeds

RSS Feed not available for this page