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 条
  • [41] Matrix-Query: A Distributed SQL-Like Query Processing Model for Large Database Clusters
    Liu, Qiao
    Ji, Ping
    Zuo, Yuan
    2013 INTERNATIONAL CONFERENCE ON CYBER-ENABLED DISTRIBUTED COMPUTING AND KNOWLEDGE DISCOVERY (CYBERC), 2013, : 179 - 185
  • [42] Query rewriting for semantic query optimization in spatial databases
    Eduardo Mella
    M. Andrea Rodríguez
    Loreto Bravo
    Diego Gatica
    GeoInformatica, 2019, 23 : 79 - 104
  • [43] Query rewriting for semantic query optimization in spatial databases
    Mella, Eduardo
    Andrea Rodriguez, M.
    Bravo, Loreto
    Gatica, Diego
    GEOINFORMATICA, 2019, 23 (01) : 79 - 104
  • [44] Default logic as a query language
    Cadoli, M
    Eiter, T
    Gottlob, G
    IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 1997, 9 (03) : 448 - 463
  • [45] Applications of a Web query language
    Arocena, GO
    Mendelzon, AO
    Mihaila, GA
    COMPUTER NETWORKS AND ISDN SYSTEMS, 1997, 29 (8-13): : 1305 - 1316
  • [46] A coherent query language for XML
    Thirunarayan, Krishnaprasad
    Immaneni, Trivikram
    JOURNAL OF INTELLIGENT INFORMATION SYSTEMS, 2009, 32 (02) : 139 - 162
  • [47] PQL: Protein Query Language
    Elfayoumy, Sherif
    Bathen, Paul
    2012 11TH INTERNATIONAL CONFERENCE ON MACHINE LEARNING AND APPLICATIONS (ICMLA 2012), VOL 2, 2012, : 127 - 132
  • [48] A coherent query language for XML
    Krishnaprasad Thirunarayan
    Trivikram Immaneni
    Journal of Intelligent Information Systems, 2009, 32 : 139 - 162
  • [49] Enhancing Faculty Grading Productivity Using Robotic Process Automation (RPA): The Development of a Structured Query Language (SQL) Automated Grading Tool
    Coyne, Joshua G.
    Summers, Scott L.
    Wood, David A.
    ISSUES IN ACCOUNTING EDUCATION, 2024, 39 (04): : 55 - 68
  • [50] A Query Language for Workflow Logs
    Tang, Yan
    Cui, Weilong
    Su, Jianwen
    ACM TRANSACTIONS ON MANAGEMENT INFORMATION SYSTEMS, 2022, 13 (02)