Integration of spatial vector data in enterprise relational database environments [Elektronische Ressource] / von Knut Stolze

Integration of Spatial Vector Datain Enterprise Relational DatabaseEnvironmentsDissertationzur Erlangung des akademischen GradesDoktor-Ingenieur (Dr.-Ing.)vorgelegt dem Rat der Fakult¨at fu¨r Mathematik und Informatikder Friedrich-Schiller-Universit¨atJenaim Juli 2006vonDipl.-Inf. Knut Stolzegeboren am 8. Januar 1975 in Jena, Thu¨ringenGutachter:1. Prof. Dr. Klaus Ku¨spert, Friedrich-Schiller-University Jena2. Prof. Johann-Christoph Freytag, Ph.D., Humboldt-Universit¨at zu Berlin3. Dr. Albert Maier, IBM Deutschland Entwicklung GmbH, B¨oblingenTag der letzten Pr¨ufung des Rigorosums: 7. November 2006Tag der ¨offentlichen Verteidigung: 10. November 2006iiTo My Wife AnnettivAbstractSpatial and geometric data can be found in virtually every relational database. Suchdata is often not explicitly modeled but rather hidden in addresses, for example. Unlessspatialdataistreatedasfirstclasscitizenintherelationaldatabasemanagementsystems(RDBMSs), spatial features cannot be leveraged and exploited by applications to theirfull extent. Several products provide the capabilities to store and query geometric datadirectly inrelationaldatabases. Thoseproducts include dedicated datatypes alongwithassociated spatial functions and indexing mechanisms.The SQL/MM spatial standard exists to ensure that the spatial interface provided byproducts are compatible. The standard covers basic spatial functionality only.