Abstract
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.
The work of the author is supported by the PWAB Project of Baden-Württemberg under grant no. PW 87 045
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
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–24
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–352
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-Madison
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–79
Shashi K. Gadia: "A Homogeneous Relational Model and Query Language for Temporal Databases"; in: ACM ToDS, Vol. 13, No. 4, Dec. 1988, pp. 418–448
Oliver Günther: "Efficient Structures for Geometric Data Management"; Lecture Notes in Computer Science, No. 337, Springer Verlag, Berlin 1988
John Guttag: "Abstract Data Types and the Development of Data Structures"; in: CACM, Vol. 20, No. 6, June 1977, pp. 396–404
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–F16
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–116
Bruce Lindsay, John McPherson, Hamid Pirahesh: "A Data Management Extension Architecture"; in: ACM SIGMOD Record, Vol. 16, No. 3, Dec 1987, pp. 220–226
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–124
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–160
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–75
T. S. E. Maibaum: "Database Instances, Abstract Data Types, and Database Specification"; in: The Computer Journal, Vol. 28, No. 2, 1985, pp. 154–161
Jack A. Orenstein: "Spatial Query Processing in an Object-Oriented Database System"; in: ACM SIGMOD Record, Vol. 15, No. 2, June 1986, pp. 326–336
Relational Technology Inc.: "INGRES/SQL Reference Manual"; Release 5.0, UNIX, 1986
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–92
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–288
Timos K. Sellis: "Efficiently Supporting Procedures in Relational Database Systems"; in SIGMOD Record, Vol. 16, No. 3, Dec. 1987, pp. 220–226
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–246
Michael Stonebraker, Jeff Anton, Eric Hanson: "Extending a Database System with Procedures"; in: ACM ToDS, Vol. 12, No. 3, September 1987, pp. 350–376
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–113
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–355
G. Teutsch et.al.: "The Experimental Field Site ‘Horkheimer Insel': Research Program, Instrumentation and First Results"; submitted to: IAHR Journal of Hydrolic Research, 1989
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–192
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1990 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Neugebauer, L. (1990). Extending a database to support the handling of environmental measurement data. In: Buchmann, A.P., Günther, O., Smith, T.R., Wang, YF. (eds) Design and Implementation of Large Spatial Databases. SSD 1989. Lecture Notes in Computer Science, vol 409. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-52208-5_26
Download citation
DOI: https://doi.org/10.1007/3-540-52208-5_26
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-52208-9
Online ISBN: 978-3-540-46924-7
eBook Packages: Springer Book Archive