Principles of database and knowledge-base systems, Vol. I
Principles of database and knowledge-base systems, Vol. I
SSD '90 Proceedings of the first symposium on Design and implementation of large spatial databases
Efficient query processing in geographic information systems
Efficient query processing in geographic information systems
ELFS: English language from SQL
ACM Transactions on Database Systems (TODS)
Environmental Information Systems
Environmental Information Systems
An Introduction to Database Systems
An Introduction to Database Systems
Artificial Intelligence in Geography
Artificial Intelligence in Geography
Realm-based spatial data types: the ROSE algebra
The VLDB Journal — The International Journal on Very Large Data Bases
Spatial SQL: A Query and Presentation Language
IEEE Transactions on Knowledge and Data Engineering
An Efficient Pictorial Database System for PSQL
IEEE Transactions on Software Engineering
Geo-Relational Algebra: A Model and Query Language for Geometric Database Systems
EDBT '88 Proceedings of the International Conference on Extending Database Technology: Advances in Database Technology
Geo-SAL: A Query Language for Spatial Data Analysis
SSD '91 Proceedings of the Second International Symposium on Advances in Spatial Databases
Extending a DBMS with Spatial Operations
SSD '91 Proceedings of the Second International Symposium on Advances in Spatial Databases
A Small Set of Formal Topological Relationships Suitable for End-User Interaction
SSD '93 Proceedings of the Third International Symposium on Advances in Spatial Databases
Spatial Internet Marketplaces: A Grand Challenge?
SSD '97 Proceedings of the 5th International Symposium on Advances in Spatial Databases
SIGGRAPH '82 Proceedings of the 9th annual conference on Computer graphics and interactive techniques
Dealing with geographic continuous fields: the way to a visual GIS environment
Proceedings of the working conference on Advanced visual interfaces
An open source and web based framework for geographic and multidimensional processing
Proceedings of the 2006 ACM symposium on Applied computing
SVG-Based Spatial Information Representation and Analysis
W2GIS '08 Proceedings of the 8th International Symposium on Web and Wireless Geographical Information Systems
Phenomena - A visual environment for querying heterogenous spatial data
Journal of Visual Languages and Computing
Design and implementation of flood disaster prevention decision support system
CCDC'09 Proceedings of the 21st annual international conference on Chinese control and decision conference
Modelling and querying geographical data warehouses
Information Systems
Quantum logic based MPEG query format algebra
AMR'10 Proceedings of the 8th international conference on Adaptive Multimedia Retrieval: context, exploration, and fusion
| Hi-index | 0.00 |
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 advantage 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 databases 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.