Why not SQL!
- 1 March 1992
- journal article
- research article
- Published by Taylor & Francis in International Journal of Geographical Information Science
- Vol. 6 (2) , 71-85
- https://doi.org/10.1080/02693799208901897
Abstract
The application of traditional database query languages, primarily the Structured Query Language SQL, for geographical information systems (GIS) and other non–standard database applications has been tried unsuccessfully; therefore, several extensions to the relational database query language SQL have been proposed to serve as a spatial query language. It is argued that the SQL framework is inappropriate for an interactive query language for a GIS and an extended SQL is at best a short term solution. Any spatial SQL dialect has a number of serious deficiencies, particularly the patches to incorporate the necessary spatial concepts into SQL.Keywords
This publication has 39 references indexed in Scilit:
- Point-set topological spatial relationsInternational Journal of Geographical Information Science, 1991
- Research issues in spatial databasesACM SIGMOD Record, 1990
- Third-generation database system manifestoACM SIGMOD Record, 1990
- Extensions to SQL for historical databasesIEEE Transactions on Knowledge and Data Engineering, 1990
- The development of a historical digital cadastral database†International Journal of Geographical Information Science, 1990
- A review of temporal database research and its use in GIS applicationsInternational Journal of Geographical Information Science, 1989
- The GEO VIEW design A relational data base approach to geographical data handlingInternational Journal of Geographical Information Science, 1987
- An algorithm to determine the directional relationship between arbitrarily-shaped polygons in the planePattern Recognition, 1987
- A temporally oriented data modelACM Transactions on Database Systems, 1986
- Human Factors Studies of Database Query Languages: A Survey and AssessmentACM Computing Surveys, 1981