File Download
There are no files associated with this item.
Links for fulltext
(May Require Subscription)
- Publisher Website: 10.1080/10824009709480492
- Scopus: eid_2-s2.0-0003711775
- Find via
Supplementary
-
Citations:
- Scopus: 0
- Appears in Collections:
Article: Restructuring the sql framework for spatial queries
Title | Restructuring the sql framework for spatial queries |
---|---|
Authors | |
Issue Date | 1997 |
Citation | Geographic Information Sciences, 1997, v. 3, n. 1-2, p. 42-50 How to Cite? |
Abstract | 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. © 1997 Taylor & Francis Group, LLC. |
Persistent Identifier | http://hdl.handle.net/10722/329818 |
ISSN |
DC Field | Value | Language |
---|---|---|
dc.contributor.author | Huang, Bo | - |
dc.contributor.author | Lin, Hui | - |
dc.date.accessioned | 2023-08-09T03:35:33Z | - |
dc.date.available | 2023-08-09T03:35:33Z | - |
dc.date.issued | 1997 | - |
dc.identifier.citation | Geographic Information Sciences, 1997, v. 3, n. 1-2, p. 42-50 | - |
dc.identifier.issn | 1082-4006 | - |
dc.identifier.uri | http://hdl.handle.net/10722/329818 | - |
dc.description.abstract | 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. © 1997 Taylor & Francis Group, LLC. | - |
dc.language | eng | - |
dc.relation.ispartof | Geographic Information Sciences | - |
dc.title | Restructuring the sql framework for spatial queries | - |
dc.type | Article | - |
dc.description.nature | link_to_subscribed_fulltext | - |
dc.identifier.doi | 10.1080/10824009709480492 | - |
dc.identifier.scopus | eid_2-s2.0-0003711775 | - |
dc.identifier.volume | 3 | - |
dc.identifier.issue | 1-2 | - |
dc.identifier.spage | 42 | - |
dc.identifier.epage | 50 | - |