File Download
There are no files associated with this item.
Links for fulltext
(May Require Subscription)
- Publisher Website: 10.1109/69.940739
- Scopus: eid_2-s2.0-0035388002
- WOS: WOS:000170283500010
- Find via
Supplementary
- Citations:
- Appears in Collections:
Article: SQL/SDA: A query language for supporting spatial data analysis and its web-based implementation
Title | SQL/SDA: A query language for supporting spatial data analysis and its web-based implementation |
---|---|
Authors | |
Keywords | Client/server Geographical Information System (GIS) Internet Java Query languages Spatial analysis Spatial database SQL Visual interface |
Issue Date | 2001 |
Citation | IEEE Transactions on Knowledge and Data Engineering, 2001, v. 13, n. 4, p. 671-682 How to Cite? |
Abstract | An important trend of current GIS development is to provide easy and effective access to spatial analysis functionalities for supporting decision making based on geo-referenced data. Within the framework of the ongoing SQL standards for spatial extensions, a spatial query language, called SQL/SDA, has been designed to meet such a requirement. Since the language needs to incorporate the important derivation functions (e.g., map-overlay and feature-fusion) as well as the spatial relationship and metric functions, the functionality of the FROM clause in SQL is developed in addition to the SELECT and WHERE clauses. By restructuring the FROM clause via a subquery, SQL/SDA is well-adapted to the general spatial analysis procedures using current GIS packages. Such an extended SQL, therefore, stretches the capabilities of the previous ones. The implementation of SQL/SDA on the Internet adopts a hybrid model, which takes advantages of the Web GIS design methods in both the client side and server side. The client side of SQL/SDA, programmed in the Java language, provides a query interface by introducing visual constructs such as icons, listboxes, and comboboxes to assist in the composition of queries, thereby enhancing the usability of the language. The server side of SQL/SDA, which is composed of a query processor and Spatial Database Engine (SDE), carries out query processing on spatial database after receiving user requests. It was demonstrated that using the familiar SELECT-FROM-WHERE statement instead of a single ad hoc command or procedural commands like macro language in some GIS packages, SQL/SDA offers users an efficient option to perform complicated multistep spatial data analyses on the Internet. |
Persistent Identifier | http://hdl.handle.net/10722/330035 |
ISSN | 2023 Impact Factor: 8.9 2023 SCImago Journal Rankings: 2.867 |
ISI Accession Number ID |
DC Field | Value | Language |
---|---|---|
dc.contributor.author | Lin, H. | - |
dc.contributor.author | Huang, B. | - |
dc.date.accessioned | 2023-08-09T03:37:20Z | - |
dc.date.available | 2023-08-09T03:37:20Z | - |
dc.date.issued | 2001 | - |
dc.identifier.citation | IEEE Transactions on Knowledge and Data Engineering, 2001, v. 13, n. 4, p. 671-682 | - |
dc.identifier.issn | 1041-4347 | - |
dc.identifier.uri | http://hdl.handle.net/10722/330035 | - |
dc.description.abstract | An important trend of current GIS development is to provide easy and effective access to spatial analysis functionalities for supporting decision making based on geo-referenced data. Within the framework of the ongoing SQL standards for spatial extensions, a spatial query language, called SQL/SDA, has been designed to meet such a requirement. Since the language needs to incorporate the important derivation functions (e.g., map-overlay and feature-fusion) as well as the spatial relationship and metric functions, the functionality of the FROM clause in SQL is developed in addition to the SELECT and WHERE clauses. By restructuring the FROM clause via a subquery, SQL/SDA is well-adapted to the general spatial analysis procedures using current GIS packages. Such an extended SQL, therefore, stretches the capabilities of the previous ones. The implementation of SQL/SDA on the Internet adopts a hybrid model, which takes advantages of the Web GIS design methods in both the client side and server side. The client side of SQL/SDA, programmed in the Java language, provides a query interface by introducing visual constructs such as icons, listboxes, and comboboxes to assist in the composition of queries, thereby enhancing the usability of the language. The server side of SQL/SDA, which is composed of a query processor and Spatial Database Engine (SDE), carries out query processing on spatial database after receiving user requests. It was demonstrated that using the familiar SELECT-FROM-WHERE statement instead of a single ad hoc command or procedural commands like macro language in some GIS packages, SQL/SDA offers users an efficient option to perform complicated multistep spatial data analyses on the Internet. | - |
dc.language | eng | - |
dc.relation.ispartof | IEEE Transactions on Knowledge and Data Engineering | - |
dc.subject | Client/server | - |
dc.subject | Geographical Information System (GIS) | - |
dc.subject | Internet | - |
dc.subject | Java | - |
dc.subject | Query languages | - |
dc.subject | Spatial analysis | - |
dc.subject | Spatial database | - |
dc.subject | SQL | - |
dc.subject | Visual interface | - |
dc.title | SQL/SDA: A query language for supporting spatial data analysis and its web-based implementation | - |
dc.type | Article | - |
dc.description.nature | link_to_subscribed_fulltext | - |
dc.identifier.doi | 10.1109/69.940739 | - |
dc.identifier.scopus | eid_2-s2.0-0035388002 | - |
dc.identifier.volume | 13 | - |
dc.identifier.issue | 4 | - |
dc.identifier.spage | 671 | - |
dc.identifier.epage | 682 | - |
dc.identifier.isi | WOS:000170283500010 | - |