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 条
  • [21] Natural Language Query to SQL conversion using Machine Learning Approach
    Arefin, Minhazul
    Hossen, Kazi Mojammel
    Uddin, Mohammed Nasir
    2021 3RD INTERNATIONAL CONFERENCE ON SUSTAINABLE TECHNOLOGIES FOR INDUSTRY 4.0 (STI), 2021,
  • [22] ISQNL: Interpretable SQL Query Synthesizer from Natural Language Input
    Phal, Shubham Milind
    Yatish, H. R.
    Hukkeri, Tanmay Sanjay
    Natarajan, Abhiram
    Gonchigar, Prathika
    Deepamala, N.
    PROCEEDINGS OF THE 1ST INTERNATIONAL CONFERENCE ON ADVANCED INFORMATION SCIENCE AND SYSTEM, AISS 2019, 2019,
  • [23] Blended Learning for Improving Flexibility of Learning Structure Query Language (SQL)
    Lertnattee, Verayuth
    Pamonsinlapatham, Perayot
    BLENDED LEARNING: NEW CHALLENGES AND INNOVATIVE PRACTICES, ICBL 2017, 2017, 10309 : 343 - 353
  • [24] Grid global structure query language G2SQL
    Xie, Z.
    Chen, Z. L.
    Wu, L.
    Tian, G.
    2008 PROCEEDINGS OF INFORMATION TECHNOLOGY AND ENVIRONMENTAL SYSTEM SCIENCES: ITESS 2008, VOL 2, 2008, : 847 - 852
  • [25] PSS-SQL: Protein Secondary Structure - Structured Query Language
    Mrozek, Dariusz
    Wieczorek, Dominika
    Malysiak-Mrozek, Bozena
    Kozielski, Stanislaw
    2010 ANNUAL INTERNATIONAL CONFERENCE OF THE IEEE ENGINEERING IN MEDICINE AND BIOLOGY SOCIETY (EMBC), 2010, : 1073 - 1076
  • [26] Organization and Query of Point Clouds Data Based on SQL Server Spatial
    Chen, Yijin
    Zhang, Huixia
    Fu, Xiaoxue
    PROCEEDINGS OF 2010 3RD IEEE INTERNATIONAL CONFERENCE ON COMPUTER SCIENCE AND INFORMATION TECHNOLOGY (ICCSIT 2010), VOL 7, 2010, : 178 - 181
  • [27] SQL Query optimalization
    Cerna, Eva
    Herold, Petr
    Tyrychtr, Jan
    AGRARIAN PERSPECTIVES XVIII, VOL 3, 2009, : 71 - 74
  • [28] SQL Query optimalization
    Cerna, Eva
    Herold, Petr
    Tyrychtr, Jan
    AGRARIAN PERSPECTIVES XVIII, VOLS 1 AND 2, 2009,
  • [29] Enhancing Natural Language Query to SQL Query Generation Through Classification-Based Table Selection
    Chopra, Ankush
    Azam, Rauful
    ENGINEERING APPLICATIONS OF NEURAL NETWORKS, EANN 2024, 2024, 2141 : 152 - 165
  • [30] Auto-Query - A simple natural language to SQL query generator for an e-learning platform
    Parikh, Parth
    Chatterjee, Oishik
    Jain, Muskan
    Harsh, Aman
    Shahani, Gaurav
    Biswas, Rathin
    Arya, Kavi
    PROCEEDINGS OF THE 2022 IEEE GLOBAL ENGINEERING EDUCATION CONFERENCE (EDUCON 2022), 2022, : 936 - 940