Spatial SQL: a query and presentation language
- 1 January 1994
- journal article
- Published by Institute of Electrical and Electronics Engineers (IEEE) in IEEE Transactions on Knowledge and Data Engineering
- Vol. 6 (1) , 86-95
- https://doi.org/10.1109/69.273029
Abstract
Recently, attention has been focused on spatial databases, which combine conventional and spatially related data, such as geographic information systems, CAD/CAM, or VLSI. A language has been developed to query such spatial databases. It recognizes the significantly different requirements of spatial data handling and overcomes the inherent problems of the application of conventional database query languages. The spatial query language has been designed as a minimal extension to the interrogative part of SQL and distinguishes from previously designed SQL extensions by: the preservation of SQL concepts; the high-level treatment of spatial objects; and the incorporation of spatial operations and relationships. It consists of two components, a query language to describe what information to retrieve and a presentation language to specify how to display query results. Users can ask standard SQL queries to retrieve nonspatial data based on nonspatial constraints, use Spatial SQL commands to inquire about situations involving spatial data, and give instructions in the Graphical Presentation Language, GPL to manipulate or examine the graphical presentation.Keywords
This publication has 30 references indexed in Scilit:
- Research issues in spatial databasesACM SIGMOD Record, 1990
- The implementation of area and membership retrievals in point geography using SQLPublished by Springer Nature ,1990
- Geo-relational algebra: A model and query language for geometric database systemsPublished by Springer Nature ,1988
- ON THE PROBLEM OF PLACING NAMES IN A GEOGRAPHIC MAPInternational Journal of Pattern Recognition and Artificial Intelligence, 1987
- Computer Assisted Cartography: Graphics or Geometry?Journal of Surveying Engineering, 1984
- MAPQUERYACM SIGGRAPH Computer Graphics, 1982
- Context-sensitive, graphic presentation of informationACM SIGGRAPH Computer Graphics, 1982
- Spatial management of dataACM Transactions on Database Systems, 1980
- Query-by-Example: A data base languageIBM Systems Journal, 1977
- The design and implementation of INGRESACM Transactions on Database Systems, 1976