SPATIAL SQL - A QUERY AND PRESENTATION LANGUAGE

被引:161
|
作者
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] Path Expressions in SQL: A User Study on Query Formulation
    Junkkari, Marko
    Vainio, Johanna
    Iltanen, Kati
    Arvola, Paavo
    Kari, Heidi
    Kekalainen, Jaana
    JOURNAL OF DATABASE MANAGEMENT, 2016, 27 (03) : 1 - 22
  • [22] SQL reasoning of GIS Chinese query based on case
    School of Computer Science, Wuhan University, 129 Luoyu Road, Wuhan 430079, China
    不详
    不详
    Geomatics Inf. Sci. Wuhan Univ., 2007, 4 (369-372):
  • [23] SQL QUERY TUNING AND OPTIMIZATION : AN EXAMPLE USING AWS
    Dikovic, Jasmina
    Panev, Ida
    ZBORNIK VELEUCILISTA U RIJECI-JOURNAL OF THE POLYTECHNICS OF RIJEKA, 2023, 11 (01): : 289 - 310
  • [24] SQLVis: Visual Query Representations for Supporting SQL Learners
    Miedema, Daphne
    Fletcher, George
    2021 IEEE SYMPOSIUM ON VISUAL LANGUAGES AND HUMAN-CENTRIC COMPUTING (VL/HCC 2021), 2021,
  • [25] What to Expect and What to Focus on in SQL Query Teaching
    Taipalus, Toni
    Perala, Piia
    SIGCSE '19: PROCEEDINGS OF THE 50TH ACM TECHNICAL SYMPOSIUM ON COMPUTER SCIENCE EDUCATION, 2019, : 198 - 203
  • [26] HoTTSQL: Proving Query Rewrites with Univalent SQL Semantics
    Chu, Shumo
    Weitz, Konstantin
    Cheung, Alvin
    Suciu, Dan
    ACM SIGPLAN NOTICES, 2017, 52 (06) : 510 - 524
  • [27] The use of hints in SQL-nested query optimization
    Taniar, David
    Khaw, Hui Yee
    Tjioe, Haorianto Cokrowijoyo
    Pardede, Eric
    INFORMATION SCIENCES, 2007, 177 (12) : 2493 - 2521
  • [28] SQL Query Optimization on Cross Nodes for Distributed System
    Zhao, Feng
    Sun, Qiao
    Jiao, Yan-bin
    Sun, Jia-song
    2016 INTERNATIONAL CONFERENCE ON POWER, ENERGY ENGINEERING AND MANAGEMENT (PEEM 2016), 2016, : 129 - 133
  • [29] A query language for XML
    Deutsch, A
    Fernandez, M
    Florescu, D
    Levy, A
    Suciu, D
    PROCEEDINGS OF THE EIGHTH INTERNATIONAL WORLD WIDE WEB CONFERENCE, 1999, : 77 - 91
  • [30] Ethereum Query Language
    Bragagnolo, Santiago
    Rocha, Henrique
    Denker, Marcus
    Ducasse, Stephane
    2018 IEEE/ACM 1ST INTERNATIONAL WORKSHOP ON EMERGING TRENDS IN SOFTWARE ENGINEERING FOR BLOCKCHAIN (WETSEB), 2018, : 1 - 8