CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • harvard1
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Other style
More styles
Language
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf
Database Performance for GIS: A Comparison of Database Schemas for Measurements with Spatial Attributes
KTH, School of Electrical Engineering and Computer Science (EECS).
2019 (English)Independent thesis Advanced level (degree of Master (Two Years)), 20 credits / 30 HE creditsStudent thesis
Abstract [en]

Spatial databases are becoming more and more important. One type of spatial database is a database of measurements, which combine positions with alphanumerical attributes. While these databases are important, little research has been done on them. There is therefore need for research on how to store this type of data most effectively.In this thesis a read performance benchmark and an execution plan analysis of three different database schemas using two different datasets of different size are presented. The three schemas investigated are the existing schema of the dataset, a schema where the spatial data have been split into a separate table, and a star schema. Additionally, these benchmarks were performed in two database management systems, Oracle Spatial and PostGIS.The results show that the choice of database schema has a real impact on performance, but none of the designs performs best in all cases. Star schema seems promising and may perform better than the existing schema in some cases, but more research is required to investigate further the specific cases where one schema outperforms the other. Finally, the results also show that PostGIS might perform better than Oracle Spatial for this type of data.

Abstract [sv]

Spatiala databaser blir mer och mer populära. En typ av spatial databas är en databas med mätningar som kombinerar positioner med alfanumeriska attribut. Även om dessa databaser är viktiga, så har det skett ytterst lite forskning om dessa databaser. Därför finns det behov av mer forskning om hur man lagrar denna typ av data mest effektivt.I denna examensrapport presenteras en prestandamätning av läsprestanda och en exekveringsplansanalys för tre olika databasscheman på två olika datamängder av olika storlek. De tre scheman som undersöks är det existerande schemat för datamängden, ett schema där spatialdata har delats upp i en separat tabell, samt ett stjärnschema. Dessa prestandamätningar utfördes dessutom i två databashanteringssystem, Oracle Spatial och PostGIS.Resultaten visar att valet av schema påverkar prestandan, men inget schema presterar bäst i samtliga fall. Stjärnschema verkar lovande och kan i vissa fall prestera bättre än det befintliga schemat, men mer forskning krävs för att ytterligare undersöka de specifika fallen där så sker. Slutligen visar resultaten också att PostGIS kan fungera bättre än Oracle Spatial för denna typ av data.

Place, publisher, year, edition, pages
2019. , p. 69
Series
TRITA-EECS-EX ; 2019:492
National Category
Computer and Information Sciences
Identifiers
URN: urn:nbn:se:kth:diva-255022OAI: oai:DiVA.org:kth-255022DiVA, id: diva2:1337271
Examiners
Available from: 2019-07-12 Created: 2019-07-12 Last updated: 2019-07-12Bibliographically approved

Open Access in DiVA

fulltext(12372 kB)9 downloads
File information
File name FULLTEXT01.pdfFile size 12372 kBChecksum SHA-512
7445b8805d24dab5c8ec26fc81e5aad10e9f64c72f52e83698cbf9bbe275a33d82e59a65061ae508bebd50169148b5779f1e759295e91cfd922b98359b55b9cb
Type fulltextMimetype application/pdf

By organisation
School of Electrical Engineering and Computer Science (EECS)
Computer and Information Sciences

Search outside of DiVA

GoogleGoogle Scholar
Total: 9 downloads
The number of downloads is the sum of all downloads of full texts. It may include eg previous versions that are now no longer available

urn-nbn

Altmetric score

urn-nbn
Total: 28 hits
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • harvard1
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Other style
More styles
Language
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf