首页   按字顺浏览 期刊浏览 卷期浏览 Restructuring the SQL Framework for Spatial Queries
Restructuring the SQL Framework for Spatial Queries

 

作者: Bo Huang,   Hui Lin,  

 

期刊: Geographic Information Sciences  (Taylor Available online 1997)
卷期: Volume 3, issue 1-2  

页码: 42-50

 

ISSN:1082-4006

 

年代: 1997

 

DOI:10.1080/10824009709480492

 

出版商: Taylor & Francis Group

 

数据来源: Taylor

 

摘要:

This paper presents an approach to designing a spatial query language, called GeoSQL, in terms of the conventional spatial query and implementation process. A critical factor to the design is how to accommodate spatial operators in an appropriate form, while being compatible with the Structured Query Language (SQL) standard. To achieve this, the FROM clause of SQL is restructured to contain spatial operators via a subquery so that the results of spatial operations can be easily fed into both the SELECT and WHERE clauses. The subquery in the FROM clause creates an intermediate relation, on which the selection in terms of certain criteria is conducted. This is a distinct characteristic of GeoSQL. The syntax and semantics of GeoSQL are described, and a set of examples for testing the expressiveness of the language is given. The interface of the language is also designed with the introduction of visual constructs (e.g., icons and ListBoxes) to aid the entry of query text. This distinguishes GeoSQL's interface from the previous extended SQLs, which only employ pure text for constructing a query. After this, an implementation of GeoSQL is discussed. This paper finally suggests further extending GeoSQL for temporal and fuzzy queries.

 

点击下载:  PDF (1447KB)



返 回