SPATIAL SQL - A QUERY AND PRESENTATION LANGUAGE

被引:160
|
作者
EGENHOFER, MJ [1 ]
机构
[1] UNIV MAINE, DEPT COMP SCI, ORONO, ME 04469 USA
基金
美国国家科学基金会;
关键词
GEOGRAPHIC INFORMATION SYSTEMS; GRAPHICAL PRESENTATION; QUERY LANGUAGES; QUERY RESULT COMBINATIONS; SPATIAL CONTEXT; SPATIAL DATABASES; SQL; TOPOLOGICAL RELATIONSHIPS;
D O I
10.1109/69.273029
中图分类号
TP18 [人工智能理论];
学科分类号
081104 ; 0812 ; 0835 ; 1405 ;
摘要
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 1) the preservation of SQL concepts, 2) the high-level treatment of spatial objects, and 3) 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.
引用
收藏
页码:86 / 95
页数:10
相关论文
共 50 条
  • [31] Spatial data query based on natural language spatial relations
    Du, SH
    Qin, QM
    Chen, DZ
    Wang, L
    IGARSS 2005: IEEE International Geoscience and Remote Sensing Symposium, Vols 1-8, Proceedings, 2005, : 1210 - 1213
  • [32] Speech-to-SQL: toward speech-driven SQL query generation from natural language question
    Song, Yuanfeng
    Wong, Raymond Chi-Wing
    Zhao, Xuefang
    VLDB JOURNAL, 2024, 33 (04): : 1179 - 1201
  • [33] Feature-based spatial query language
    Song, Jingang
    Zhang, Dalu
    Jisuanji Gongcheng/Computer Engineering, 2000, 26 (01): : 49 - 50
  • [34] Visual spatial query language for telecommunication GIS
    Stojanovic, Z
    DjordjevicKajan, S
    Stojanovic, D
    GEOGRAPHICAL INFORMATION '97: FROM RESEARCH TO APPLICATION THROUGH COOPERATION, VOLS 1 AND 2, 1997, : 1259 - 1268
  • [35] A Visual Query Language for Spatial Data Warehouses
    Bimonte, Sandro
    Del Fatto, Vincenzo
    Paolino, Luca
    Sebillo, Monica
    Vitiello, Giuliana
    GEOSPATIAL THINKING, 2010, : 43 - +
  • [36] SQL EER - SYNTAX AND SEMANTICS OF AN ENTITY-RELATIONSHIP-BASED QUERY LANGUAGE
    HOHENSTEIN, U
    ENGELS, G
    INFORMATION SYSTEMS, 1992, 17 (03) : 209 - 242
  • [37] SQL4X: A flexible query language for XML and relational databases
    Cohen, S
    Kanza, Y
    Sagiv, Y
    DATABASE PROGRAMMING LANGUAGES, 2002, 2397 : 263 - 280
  • [38] Bridging the Semantic Gap with SQL Query Logs in Natural Language Interfaces to Databases
    Baik, Christopher
    Jagadish, H. V.
    Li, Yunyao
    2019 IEEE 35TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING (ICDE 2019), 2019, : 374 - 385
  • [39] Converting Complex Natural Language Query to SQL Based on Tree Representation Model
    Zhao M.
    Chen K.
    Shou L.-D.
    Wu S.
    Chen G.
    Ruan Jian Xue Bao/Journal of Software, 2022, 33 (12): : 4727 - 4745
  • [40] Enhancement of Natural Language to SQL Query Conversion using Machine Learning Techniques
    Prasad, Akshar
    Badhya, Sourabh S.
    Yashwanth, Y. S.
    Rohan, Shetty
    Shobha, G.
    Deepamala, N.
    INTERNATIONAL JOURNAL OF ADVANCED COMPUTER SCIENCE AND APPLICATIONS, 2020, 11 (12) : 494 - 503