Show simple item record

dc.contributor.advisorGittings, Bruce
dc.contributor.authorArbesser-Rastburg, Thomas
dc.date.accessioned2009-10-01T10:39:14Z
dc.date.available2009-10-01T10:39:14Z
dc.date.issued26/11/2009
dc.identifier.urihttp://hdl.handle.net/1842/3085
dc.description.abstractThis 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.en
dc.format.extent12683778 bytes
dc.format.extent1533952 bytes
dc.format.mimetypeapplication/msword
dc.format.mimetypeapplication/msword
dc.language.isoenen
dc.subjectSpatial Databases, DBMS, Performance, Oracle, PostgreSQL, PostGIS, MySQL, Spatial data, OpenStreetMapen
dc.subjectMSc Geographical Information Scienceen
dc.subjectGISen
dc.titleEvaluation of spatial database management systems: A performance-based comparisonen
dc.typeThesis or Dissertationen
dc.type.qualificationlevelMastersen
dc.type.qualificationnameMSc Master of Scienceen
dcterms.accessRightsRestricted Accessen_US


Files in this item

This item appears in the following Collection(s)

Show simple item record