Extending a database to support the handling of environmental measurement data

  • Leonore Neugebauer
Geographic Applications
Part of the Lecture Notes in Computer Science book series (LNCS, volume 409)


This paper presents an approach to handle environmental measurement data within a relational database. The approach has been developed within a cooperative environmental research project exploring the contamination of groundwater and soil. Considering the special properties of measurement data we suggest an extension to data retrieval that allows the user to query measurement attributes without knowing the exact spatial and temporal measurement points. Further on, the interaction of this extension with the relational operations is outlined and a system design for an implementation is sketched.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. [AMKP85]
    Hamideh Afsarmanesh, Dennis McLeod, David Knapp, Alice Parker: "An Extensible Object-Oriented Approach to Databases for VLSI/CAD"; in: Proc. of the 11th Conf. on VLDB, Stockholm, Sweden 1985, pp. 13–24Google Scholar
  2. [CaDe85]
    Michael J. Carey, David J. DeWitt: "Extensible Database Systems"; in: Proc. of the Islamorada Workshop on Large Scale Knowledge Bases and Reasoning Systems, Feb., 1985, Islamorada, Florida, pp. 335–352Google Scholar
  3. [CDFG86]
    Michael J. Carey, David J. DeWitt, Daniel Frank, Goetz Graefe, Joel E. Richardson, Eugenie J. Shekita, M. Muralikrishna: "The Architecture of the EXODUS Extensible DBMS: A Preliminary Report"; Computer Science Technical Report #644, May 1986, University of Wisconsin-MadisonGoogle Scholar
  4. [EgFr89]
    Max J. Egenhofer, Andrew U. Frank: "PANDA: An Extensible DBMS Supporting Object-Oriented Software Techniques"; in: Datenbanksysteme in Büro, Technik und Wissenschaft, Proc. BTW'89; GI/SI-Fachtagung, Zürich, March 1989, pp. 74–79Google Scholar
  5. [Gadi88]
    Shashi K. Gadia: "A Homogeneous Relational Model and Query Language for Temporal Databases"; in: ACM ToDS, Vol. 13, No. 4, Dec. 1988, pp. 418–448CrossRefGoogle Scholar
  6. [Guen88]
    Oliver Günther: "Efficient Structures for Geometric Data Management"; Lecture Notes in Computer Science, No. 337, Springer Verlag, Berlin 1988Google Scholar
  7. [Gutt77]
    John Guttag: "Abstract Data Types and the Development of Data Structures"; in: CACM, Vol. 20, No. 6, June 1977, pp. 396–404Google Scholar
  8. [JaMa86]
    Donald A. Jardine, Aviram Matzov: "Ontology and Properties of Time in Information Systems"; in: Proc. IFIP Working Conf. Knowledge & Data (DS-2), Algarve, Portugal 1986, pp. F1–F16Google Scholar
  9. [Kobu88]
    H. Kobus: "Das PWAB-Testfeld Wasser und Boden" ("The PWAB Experimental Field Site ‘Water and Soil'"); in: Bericht über das 1. Statuskolloquium, February 23, Karlsruhe, Projekt Wasser-Abfall-Boden (Project Water-Waste-Soil), KfK-PWAB 1, 1988, pp. 96–116Google Scholar
  10. [LiMP87]
    Bruce Lindsay, John McPherson, Hamid Pirahesh: "A Data Management Extension Architecture"; in: ACM SIGMOD Record, Vol. 16, No. 3, Dec 1987, pp. 220–226Google Scholar
  11. [LiNe86]
    Udo W. Lipeck, Karl Neumann: "Modelling and Manipulating Objects in Geoscientific Databases"; in: Proc. of 5th Int. Conf. on ER-Approach, Dijon, France, 1986, pp. 105–124Google Scholar
  12. [LSBM83]
    Guy M. Lohmann, Joseph C. Stoltzfus, Anita N. Benson, Michael D. Martin, Alfonso F. Cardenas: "Remotely-Sensed Geophysical Databases: Experience and Implications for Generalized DBMS"; in: ACM Sigmod'83 Proceedings of Annual Meeting, San Jose, 1983 (SIGMOD Record Vol. 13, No. 4), pp. 146–160CrossRefGoogle Scholar
  13. [LMWW79]
    Peter C. Lockemann, Heinrich C. Mayr, Wolfgang H. Weil, Wolfgang H. Wohllieber: "Data Abstractions for Database Systems"; in: ACM ToDS, Vol. 4, No. 1, March 1979, pp. 60–75CrossRefGoogle Scholar
  14. [Maib85]
    T. S. E. Maibaum: "Database Instances, Abstract Data Types, and Database Specification"; in: The Computer Journal, Vol. 28, No. 2, 1985, pp. 154–161CrossRefGoogle Scholar
  15. [Oren86]
    Jack A. Orenstein: "Spatial Query Processing in an Object-Oriented Database System"; in: ACM SIGMOD Record, Vol. 15, No. 2, June 1986, pp. 326–336Google Scholar
  16. [RTI86]
    Relational Technology Inc.: "INGRES/SQL Reference Manual"; Release 5.0, UNIX, 1986Google Scholar
  17. [SCFL86]
    P. Schwarz, W. Chang, J. C. Freytag, G. Lohman, J. McPherson, C. Mohan, H. Pirahesh: "Extensibility in the Starburst Database System"; in: Proc. of 1986 Int. Workshop on Object-Oriented Database Systems, Asilomar, Pacific Glore, Cal., pp. 85–92Google Scholar
  18. [ScWa86]
    H.-J. Schek, W. Waterfeld: "A Database Kernel System for Geoscientific Applications"; in: Proc. of the 2nd Int. Symp. on Spatial Data Handling, Seattle, Washington, July 1986, pp. 273–288Google Scholar
  19. [Sell87]
    Timos K. Sellis: "Efficiently Supporting Procedures in Relational Database Systems"; in SIGMOD Record, Vol. 16, No. 3, Dec. 1987, pp. 220–226Google Scholar
  20. [SnAh85]
    Richard Snodgrass, Ilsoo Ahn: "A Taxonomy of Time in Databases"; in: Proc. of ACM-SIGMOD'85 Int. Conf. on Management of Data, Austin, Texas, 1985, pp. 236–246Google Scholar
  21. [StAH87]
    Michael Stonebraker, Jeff Anton, Eric Hanson: "Extending a Database System with Procedures"; in: ACM ToDS, Vol. 12, No. 3, September 1987, pp. 350–376CrossRefGoogle Scholar
  22. [StRG83]
    Michael Stonebraker, Brad Rubenstein, Antonin Guttman; "Application of Abstract Data Types and Abstract Indices to CAD Data Bases"; in: ACM SIGMOD/SIGDBP Proc. of Annual Meeting, Engineering Design Applications, San Jose, May 1983, pp. 107–113Google Scholar
  23. [StRo86]
    Michael Stonebraker, Lawrence A. Rowe: "The Design of POSTGRES"; in: Proc. of ACM SIGMOD'86 Int. Conf. on Management of Data, Washington D.C., 1986, pp. 340–355Google Scholar
  24. [Teut89]
    G. Teutsch et.al.: "The Experimental Field Site ‘Horkheimer Insel': Research Program, Instrumentation and First Results"; submitted to: IAHR Journal of Hydrolic Research, 1989Google Scholar
  25. [WSSH88]
    P. F. Wilms, P. M. Schwarz, H.-J. Schek, L. M. Haas: "Incorporating Data Types in an Extensible Database Architecture"; in: Proc. of 3rd Int. Conf. on Data and Knowledge Bases, Jerusalem, Israel, June 1988, pp. 180–192Google Scholar

Copyright information

© Springer-Verlag 1990

Authors and Affiliations

  • Leonore Neugebauer
    • 1
  1. 1.IPVR, University of StuttgartGermany

Personalised recommendations