Abstract
Spatial database systems have become a popular research area since they find applications in diverse fields where there is the need to manage geometric, geographic or spatial data, which means data related to space such as the physical world (geography, urban planning, astronomy), parts of living organisms (body anatomy), engineering design (VLSI circuits, molecular structures) etc. When the earth surface and subsurface are the space of interest, the systems are called the Geographic Information Systems (GIS). A distinguished feature of spatial database systems is the management of sets of entities with a spatial reference, which means that spatial database systems provide operations to deal with the extent, location, and relationships of the spatial elements. However, it is generally recognized that current spatial database systems are inadequate to support typical applications of GIS and CAD, and also for potential applications such as data warehousing. This is the reason that motivates current research aimed at improving the functionalities and the performance of the available spatial database management systems, including the modelling of continuous fields, the management of large data sets and the design of user interfaces for simplifying the user-system interaction [1; 7; 26; 27]. Specifically, current spatial query languages are inadequate to perform spatial analysis for many reasons [3; 7; 14; 20; 25; 27]: one reason is that they force users to formulate their often vague requests by means of crisp selection conditions on spatial data. For many categories of users, such as planners and resource managers, the possibility to express tolerant conditions on conventional and spatial data, and to retrieve discriminated spatial information in decreasing order of relevance, can greatly simplify their spatial
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
E. Bertino and G. Vantini. Advanced database systems and geographical information systems. In Proc. of the II Workshop on AITSES, pages 1–12, 1996.
G. Bordogna, S. Chiesa, and D. Geneletti. Linguistic modelling of imperfect spatial information as a basis for simplifying spatial analysis. Information Sciences, 176(4):366–389, 2006.
G. Bordogna and G. Psaila. Fuzzy spatial sql. In Proceedings of FQAS04, LNAI 3055, pages 24–26, 2004.
P. Bosc, B. Buckles, F.E. Petry, and O. Pivert. Fuzzy databases. In J. C. Bezdek, D. Dubois, and H. Prade, editors, Fuzzy sets in Approximate reasoning and information systems: the handbook of fuzzy set series, pages 404–468. Kluwer Ac. Pub., 1999.
P. Bosc and O. Pivert. Sqlf: a relational database language for fuzzy querying. Trans. on Fuzzy Systems, 3:1–17, 1995.
P. Bosc and H. Prade. An introduction to the fuzzy set and possibility theory-based treatment of flexible queries and uncertain and imprecise databases. In A. Motro and P. Smets, editors, Uncertainty Management in Information Systems: from Needs to Solutions. Kluwer Academic Pub., 1994.
P.A. Burrough and A.U. Frank. Geographic objects with indeterminate boundaries. In GISDATA series. Taylor & Francis, 1996.
E. Clementini and P. Di Felice. A comparison of methods for representing topological relationships. Information Sciences, 80:1–34, 1994.
E. Clementini and P. Di Felice. An algebraic model for spatial objects with indeterminate boundaries. In P.A. Burrough and A.U. Frank, editors, Geographic Objects with Indeterminate Boundaries, GISDATA. Taylor & Francis, 1996.
E. Clementini and P. Di Felice. A model for representing topological relationships between complex geometric features in spatial databases. Information Sciences, 90(1–4):121–136, 1996.
OGC (Open Geospatial Consortium). Opengis simple features implementation specification for sql, 2005.
H. Couclelis. Towards an operational typology of geographic entities with ill-defined boundaries. In P.A. Burrough and A.U. Frank, editors, Geographic Objects with Indeterminate Boundaries, GISDATA. Taylor & Francis, 1996.
M.J. Egenhofer. A formal definition of binary topological relationships. Lecture Notes in Computer Science, 367:457–472, 1989.
M.J. Egenhofer. Spatial sql: A query and presentation language. IEEE Trans, on Knowledge and Data Engineering, 6(l):86–95, 1994.
M.J. Egenhofer and R.D. Franzosa. Point-set topological spatial relations. International Journal of Geographical Information Systems, 5(2): 161–174, 1991.
M.J. Egenhofer and J. Herring. A mathematical framework for the definition of topological relationships. In 4th Intl. Symposium on Spatial Data Handling, pages 803–813, Zrich, 1990.
M.J. Engenhofer and A.U. Frank. Query languages for geographic information systems. Technical report, NCGIA, 2000.
M. Erwig, R.H. Guting, M. Schneider, and M. Vazirgiannis. Spatio-temporal data types: An approach to modeling and querying moving objects. Geoinformatica, 3(3):269–296, 1999.
ESRI Inc. Using ArcView GIS.
Ralf Hartmut Güting. Special issue on spatial database systems: An introduction to spatial database systems. j-VLDB-J, 3(4):357–399, October 1994.
B. Huang and H. Lin. Design of a query language for accessing spatial analysis in the web environment. Geoinformatica: an International Journal on Advances of Computer Science for Geographic Information Systems, 3(2):165–183, 1999.
J. Kacprzyk and S. Zadrosny. Fquery for access: fuzzy querying for windows-based dbms. In P. Bosc and J. Kacprzyk, editors, Fuzziness in database management systems. Physica verlag, 1995.
OGC (Open Geospatial Consortium). Opengis registered products : Compliant and implementing products. http://www.opengeospatial.org/resources/?page=products.
OGC (Open Geospatial Consortium). Opengis-simple features specification for sql. http://www.opengeospatial.org/specs/?page=specs.
F.E. Petry. Fuzzy Databases. Kluwer Academic Pub., 1996.
F. Rigaux, M. Scholl, and A. Voisard. Spatial Databases with application to GIS. Morgan Kaufmann, 2002.
S. Shekkar, S. Chawla, S. Ravada, A. Fetterer, X. Liu, and C. Lu. Spatial databases - accomplishements and research needs. IEEE Trans. on Knowledge and Data Engineering, ll(l):45–55, 1999.
P. Svensson and Z. Huang. Geo-sal: A query language for spatial data analysis. In Proc. 2nd Intl. Symposium on Large Spatial Databases, pages 119–140, Zrich, 1991.
L. A. Zadeh. The concept of a linguistic variable and its application to approximate reasoning, parts i, ii. Information Science, 8:199–249, 301–357, 1997.
L.A. Zadeh. Fuzzy sets as a basis for a theory of possibility. Fuzzy Sets and Systems, l(3–28):3–28, 1978.
F.B. Zhan. Topological relations between fuzzy regions. In Proceedings of the ACM SAC, pages 192–196, 1997.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2006 Springer
About this chapter
Cite this chapter
Bordogna, G., Pagani, M., Psaila, G. (2006). Spatial SQL with Customizable Soft Selection Conditions. In: Bordogna, G., Psaila, G. (eds) Flexible Databases Supporting Imprecision and Uncertainty. Studies in Fuzziness and Soft Computing, vol 203. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-33289-8_13
Download citation
DOI: https://doi.org/10.1007/3-540-33289-8_13
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-33288-6
Online ISBN: 978-3-540-33289-3
eBook Packages: EngineeringEngineering (R0)