Skip to main content
SpringerLink
Log in
Book cover

International Conference on Flexible Query Answering Systems

FQAS 2004: Flexible Query Answering Systems pp 307–319Cite as

Fuzzy-Spatial SQL

  • Conference paper

Part of the book series: Lecture Notes in Computer Science ((LNAI,volume 3055))

Abstract

Current Geographic Information Systems (GISs) are inadequate for performing spatial analysis, since they force users to formulate their often vague requests by means of crisp selection conditions on spatial data. In fact, SQL extended to support spatial analysis is becoming the de facto standard for GISs; however, it does not allow the formulation of flexible queries. Based on these considerations, we propose the extension of SQL/Spatial in order to make it flexible. Flexibility is obtained by allowing the expression of linguistic predicates defining soft spatial and non-spatial selection conditions admitting degrees of satisfaction. Specifically, this paper proposes an extension of the basic SQL SELECT operator; proposes the definition of some spatial functions to compute gradual topological, distance, and directional properties of spatial objects; introduces a new operator for defining linguistic predicates over spatial properties, and reports the related formal semantics.

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

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   54.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

Learn about institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Bertino, E., Vantini, G.: Advanced Database Systems and Geographical Information Systems. In: Proc. of the II Workshop on AITSES, pp. 1–10 (1996)

    Google Scholar 

  2. Burrough, P.A., Frank, A.U. (eds.): Objects with Indeterminate Boundaries. GISDATA series. Taylor & Francis, Abington (1996)

    Google Scholar 

  3. Petry, F.E.: Fuzzy Databases. Kluwer Academic Pub., Dordrecht (1996)

    MATH  Google Scholar 

  4. Zadeh, L.A.: The concept of a linguistic variable and its application to approximate reasoning, parts I, II. Information Science 8, 199–249, 301–357 (1997)

    Google Scholar 

  5. Zadeh, L.A.: Fuzzy Sets as a Basis for a Theory of Possibility. Fuzzy Sets and Systems 1, 3–28 (1978)

    Article  MATH  MathSciNet  Google Scholar 

  6. Bosc, P., Prade, H.: An Introduction to the Fuzzy Set and Possibility Theory-based Treatment of Flexible Queries and Uncertain and Imprecise Databases. In: Motro, A., Smets, P. (eds.) Uncertainty Management in Information Systems: from Needs to Solutions, pp. 285–324. Kluwer Academic Pub, Dordrecht

    Google Scholar 

  7. Bosc, P., Buckles, B., Petry, F.E., Pivert, O.: Fuzzy Databases. In: Bezdek, J.C., Dubois, D., Prade, H. (eds.) Fuzzy sets in Approximate reasoning and information systems: the handbook of fuzzy set series, pp. 404–468. Kluwer Ac. Pub, Dordrecht (1999)

    Google Scholar 

  8. Bosc, P., Pivert, O.: SQLf: a relational database language for fuzzy querying. IEEE Trans. on Fuzzy Systems 3, 1–17 (1995)

    Article  Google Scholar 

  9. Kacprzyk, J., Zadrosny, S.: FQUERY for ACCESS: fuzzy querying for Windows-based DBMS. In: Bosc, P., Kacprzyk, J. (eds.) Fuzziness in database management systems, pp. 415–433. Physica verlag (1995)

    Google Scholar 

  10. Egenhofer, J.: Spatial SQL: A Query and Presentation Language. IEEE Trans. on Knowledge and Data Engineering 6(1), 86–95 (1994)

    Article  Google Scholar 

  11. Cary, N., Mak, M.: A survey on Query Languages for Content-based retrieval, ???

    Google Scholar 

  12. Huang, B., Lin, H.: Design of a Query Language for Accessing Spatial Analysis in Web Environment. Geoinformatica (2000)

    Google Scholar 

  13. OGC.OpenGIS-Simple Features Specification for SQL, http://www.opengis.org/techno/specs.htm (1998)

  14. ArcView GIS, Using ArcView GIS, ESRI inc. (1999)

    Google Scholar 

  15. Cood, E.: A Relational Model for Large Shared Data Banks. Communications of the ACM 13, 377–387 (1970)

    Article  Google Scholar 

  16. Erwig, M., Guting, R.H., Schneider, M., Vazirgiannis, M.: Spatio-Temporal Data Types: An approach to Modeling and Querying Moving Objects. Geoinformatica 3(3), 269–296 (1999)

    Article  Google Scholar 

  17. Bordogna, G., Chiesa, S.: A Fuzzy Object-Based Data Model for Imperfect Spatial Information Integrating Exact Objects and Fields. Int. Journal of Uncertainty, Fuzziness and Knowledge- Based Systems 11(1), 23–41 (2003)

    Article  MATH  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. CNR Istituto per la Dinamica dei Processi Ambientali Sez. di Milano, Lab. di Georisorse, via Pasubio 3/5, 24044, Dalmine, (BG), Italy

    Gloria Bordogna

  2. Dip. Ing. Gestionale e dell’Informazione, Università di Bergamo, Viale Marconi 5, 24044, Dalmine, (BG), Italy

    Giuseppe Psaila

Authors
  1. Gloria Bordogna
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Giuseppe Psaila
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Research group PLIS: Programming, Logic and Intelligent Systems, Department of Communication, Business and Information Technologies, Roskilde University, P.O. Box 260, DK-4000, Roskilde, Denmark

    Henning Christiansen

  2. LIRIS - UFR d’Informatique, Université Claude Bernard Lyon 1, 43, boulevard du 11 novembre 1918,, 69622, Villeurbanne, France

    Mohand-Saïd Hacid

  3. Department of Computer Science, Roskilde University, P.O. Box 260, DK-4000, Roskilde, Denmark

    Troels Andreasen

  4. Department of Computer Science and Engineering, Aalborg University Esbjerg, Niels Bohrs Vej 8Niels Bohrs Vej 8, 6700, Esbjerg, Denmark

    Henrik Legind Larsen

Rights and permissions

Reprints and permissions

Copyright information

© 2004 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Bordogna, G., Psaila, G. (2004). Fuzzy-Spatial SQL. In: Christiansen, H., Hacid, MS., Andreasen, T., Larsen, H.L. (eds) Flexible Query Answering Systems. FQAS 2004. Lecture Notes in Computer Science(), vol 3055. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-25957-2_25

Download citation

  • DOI: https://doi.org/10.1007/978-3-540-25957-2_25

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-22160-9

  • Online ISBN: 978-3-540-25957-2

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation