Skip to main content

Web-Enabling Geographic Data with Object-Relational Databases

  • Conference paper
Datenbanksysteme in Büro, Technik und Wissenschaft

Part of the book series: Informatik aktuell ((INFORMAT))

  • 196 Accesses

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 54.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 69.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. S. Abiteboul, P. Buneman, D. Suciu: Data on the Web: From Relations to Semistructured Data and XML. Morgan Kaufmann Publishers, San Francisco, 2000.

    Google Scholar 

  2. 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.

    Google Scholar 

  3. 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.

    Google Scholar 

  4. D. Florescu, D. Kossmann: Storing and Querying XML Data using an RDMBS. Data Engineering. 22:3 (1999), 27–34.

    Google Scholar 

  5. 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.

    Google Scholar 

  6. 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.

    Google Scholar 

  7. 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.

    Google Scholar 

  8. K. Neumann, H. Koch: Ein experimentelles Informationssystem für ATKIS-Daten. Nachrichten aus dem Karten-und Vermessungswesen. 113:1 (1995), 179–190.

    Google Scholar 

  9. 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.

    Google Scholar 

  10. S. St. Laurent, R. Biggar: Inside XML DTDs: Scientific and Technical. McGraw-Hill, New York, 1999.

    Google Scholar 

  11. J. Widom: Data Management for XML: Research Directions. Data Engineering. 22:3 (1999) 44–53.

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints 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

Publish with us

Policies and ethics