Abstract
We show how geographic data sets that are available in a proprietary file format only, can be web-enabled by using an object-relational database system. In particular we propose a database schema for official cartographic-topographic (ATKIS) base data implemented in Oracle8i to store and manage such data sets in an object-structured way. We have implemented an import routine for such data into the database, and for inspection and selection purposes we have developed a visualization tool for arbitrary spatial data residing in an object-relational database. In order to exchange cartographic-topographic data sets over the internet, we introduce an XML-based document type definition along with some general rules on how to design DTDs for data strongly structured according to a database schema. Finally we describe how to generate files for data exchange according to the DTD. We claim that our techniques can be used as a reference pattern for similar tasks on other data formats or in other domains as well.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
S. Abiteboul, P. Buneman, D. Suciu: Data on the Web: From Relations to Semistructured Data and XML. Morgan Kaufmann Publishers, San Francisco, 2000.
F. Arcieri, C. Cammino, E. Nardelli, M. Talamo, A. Venza: The Italian Cadastral Information System: a Real-Life Spatio-Temporal DBMS (Extended Abstract). In M. Bohlen, C. Jensen, M. Scholl (eds.), Spatio-Temporal Database Management—Int. Workshop STDBM’99, Edinburgh, Sept. 10-11, 1999, LNCS 1678, Springer-Verlag, Berlin, 1999, 79–99.
S. Ceri, P. Fraternali, S. Paraboschi: XML: Current Developments and Future Challenges for the Database Community. In C. Zaniolo, P. C. Lockemann, M. H. Scholl, T. Grust (eds.), Advances in Database Technology-EDBT 2000—7th Int. Conference on Extending Database Technology, Konstanz, March 2000, LNCS 1777, Springer-Verlag, Berlin, 2000.
D. Florescu, D. Kossmann: Storing and Querying XML Data using an RDMBS. Data Engineering. 22:3 (1999), 27–34.
C. Kleiner, S. Falke, U. W. Lipeck: Verwaltung geographischer Basisdaten durch objektrelationale Datenbanken am Beispiel von ATKIS und Oracle8i. Informatik-Berichte DB02/2000, Institut für Informatik, Universität Hannover, Hannover, 2000.
G. Kappel, E. Kapsammer, S. Rausch-Schott, W. Retschitzegger: X-Ray—Towards Integrating XML and Relational Database Systems. In A. Laender, S. Liddle, V. Storey (eds.), Conceptual Modeling-ER 2000—19th Int. Conference on Conceptual Modeling, Salt Lake City, Utah, USA, October 9-12, 2000, LNCS 1920, Springer-Verlag, Berlin, 2000.
E. Kophstahl, H. Selige (eds.): Das Geoinformationssystem ATKIS und seine Nutzung in Wirtschaft und Verwaltung, anlässlich des 2.AdV-Symposiums ATKIS, am 27. und 28. Juni 1995. Kopie, Niedersächsisches Landesverwaltungsamt, Hannover, 1995.
K. Neumann, H. Koch: Ein experimentelles Informationssystem für ATKIS-Daten. Nachrichten aus dem Karten-und Vermessungswesen. 113:1 (1995), 179–190.
M. Stonebraker, R Brown: Object-Relational DBMSs—Tracking the Next Great Wave (Second Edition), 2nd edition. The Morgan Kaufmann Series in Data Management Systems, Morgan Kaufmann Publishers, San Francisco, 1999.
S. St. Laurent, R. Biggar: Inside XML DTDs: Scientific and Technical. McGraw-Hill, New York, 1999.
J. Widom: Data Management for XML: Research Directions. Data Engineering. 22:3 (1999) 44–53.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2001 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Kleiner, C., Lipeck, U.W. (2001). Web-Enabling Geographic Data with Object-Relational Databases. In: Heuer, A., Leymann, F., Priebe, D. (eds) Datenbanksysteme in Büro, Technik und Wissenschaft. Informatik aktuell. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-56687-5_11
Download citation
DOI: https://doi.org/10.1007/978-3-642-56687-5_11
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-41707-1
Online ISBN: 978-3-642-56687-5
eBook Packages: Springer Book Archive