Limits database for an environmental information system

A fuzzy set-based querying approach
  • Ralf Kramer
  • Horst Spandl
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 819)


This paper describes the design and implementation of the limits database for the environmental information system of Baden-Württemberg. Environmental legislation in Germany is based on numerous laws, decrees, and other regulations. Regulations of the European Union (EU) have a growing impact. Not surprisingly, terminology differs substantially among different regulations. Even for experts, it is impossible to keep track of all regulations and their specific terminology. Thus, two main problems had to be solved. The first challenge was to develop a conceptual model that captures the semantics of a broad collection of regulations. The second main requirement was to support (possibly non-expert) users in querying the limits database. Both challenges are met by an approach that can be characterized as a. front-end to a conventional, state-of-the-art relational database system that accepts and processes fuzzy queries.


European Union Query Processing Search Module Similarity Query Relational Database System 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Land Baden-Württemberg: Umweltinformationssystem Baden-Württemberg. Reihe Verwaltung 2000, Band 6, Hrsg.: Innen-und Umweltministerium, Innen-und Umweltministerium, Stuttgart, 1991Google Scholar
  2. 2.
    P. Bosc, M. Galibourg, G. Hamon: Fuzzy Querying with SQL: Extensions and Implementation Aspects. Fuzzy Sets and Systems, Vol. 28, 1988, pp. 333–349MathSciNetCrossRefGoogle Scholar
  3. 3.
    P. Bosc, H. Prade: An Introduction to Fuzzy Set and Possibility Theory-based Approaches to the Treatment of Uncertainty and Imprecision in Data Base Management Systems. 2nd UMIS Workshop, Catalina, California, USA, April 1993Google Scholar
  4. 4.
    CCINFOdisc, Canadian Centre for Occupational Health and SafetyGoogle Scholar
  5. 5.
    D. Dörner: Die Logik des Miβlingens — Strategisches Denken in komplexen Situationen. Rowohlt, Reinbek, 1992Google Scholar
  6. 6.
    D. Dubois, H. Prade, R.Y. Yager (Eds.): Readings in Fuzzy Sets for Intelligent Systems. Morgan Kaufmann, San Mateo, California, USA, 1993Google Scholar
  7. 7.
    European Inventory of Existing Chemical Substances (EINECS)Google Scholar
  8. 8.
    N. Fuhr: Anfragefunktionen für Umweltinformationssysteme. in: W. Pillmann, A. Jaeschke (Hrgs.): Informatik für den Umweltschutz. Proceedings 5. Symposium, Wien, Austria, September 1990; Springer, 1990, pp. 27–37CrossRefGoogle Scholar
  9. 9.
    S. Hemmer, R. Kramer: Limits Database for UIS — Users' Guide Query Module (in German). FZI Bericht 20/93, Forschungszentrum Informatik (FZI), 1993Google Scholar
  10. 10.
    R. Kramer: Limits Database for UIS — Project Documentation (in German). Forschungszentrum Informatik (FZI), November 1993Google Scholar
  11. 11.
    R. Kramer, H. Spandl: Limits Database for an Environmental Information System — A Fuzzy Set based Querying Approach. FZI Report 25/93, Forschungszentrum Informatik (FZI), December 1993Google Scholar
  12. 12.
    R. Kruse, J. Gebhardt, F. Klawonn: Fuzzy-Systeme. Teubner, Stuttgart, 1993zbMATHGoogle Scholar
  13. 13.
    Landesanstalt für Immisionsschutz Nordrhein-Westfalen: Organismen-und Stoffliste, Version 3.1. 1993Google Scholar
  14. 14.
    Landesanstalt für Umweltschutz Baden-Württemberg, L. Roth: Grenzwerte — Kennzahlen zur Umweltbelastung in Deutschland und in der EG, Tabellenwerk. Ecomed Fachverlag, Landsberg, 1992Google Scholar
  15. 15.
    R. Mayer-Föll: Zur Rahmenkonzeption des Umweltinformationssystems Baden-Württemberg, in: O. Günther, H. Kuhn, R. Mayer-Föll, F.J. Radermacher (Hrsg.): Konzeption und Einsatz von Umweltinformationssystemen, Proceedings, Informatik Fachberichte 301, Springer-Verlag Berlin Heidelberg, 1991, pp. 3–19Google Scholar
  16. 16.
    J. Melton, A. R. Simon: Understanding the New SQL: A Complete Guide. Morgan Kaufmann Publishers, San Mateo, California, USA, 1993Google Scholar
  17. 17.
    A. Motro: VAGUE: A User Interface to Relational Databases that Permits Vague Queries. ACM Trans. on Office Information Systems, Vol. 6(3), 1988, pp. 187–214CrossRefGoogle Scholar
  18. 18.
    A. Motro: Accomodating Imprecision in Database Systems: Issues and Solutions. ACM SIGMOD Record, Vol. 19(4), December 1990, pp. 69–74CrossRefGoogle Scholar
  19. 19.
    Pest Bank, (CD-ROM) Center for Environmental and Regulatory Information System (CERIS), Environmental Protection Agency (EPA), USAGoogle Scholar
  20. 20.
    M. Zemankova: FIIS: A Fuzzy Intelligent Information System. IEEE Data Engineeering, Special Issue on Imprecisions in Databases, Vol. 12(2), 1989, pp. 11–20MathSciNetGoogle Scholar
  21. 21.
    H. J. Zimmermann: Fuzzy Set Theory and its Applications. Kluwer, Boston, 2nd edition, 1991CrossRefGoogle Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1994

Authors and Affiliations

  • Ralf Kramer
    • 1
  • Horst Spandl
    • 2
  1. 1.Forschungszentrum Informatik (FZI)KarlsruheGermany
  2. 2.Landesanstalt für Umweltschutz (LfU)KarlsruheGermany

Personalised recommendations