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] Data Agnostic RoBERTa-based Natural Language to SQL Query Generation
    Pal, Debaditya
    Sharma, Harsh
    Chaudhuri, Kaustubh
    2021 6TH INTERNATIONAL CONFERENCE FOR CONVERGENCE IN TECHNOLOGY (I2CT), 2021,
  • [42] 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
  • [43] (ANACON: SQL QUERY ANALYZER)
    Garrido, Piedad
    Martinez, Francisco
    Tramullas, Jesus
    Fuertes, Gabriel
    RIED-REVISTA IBEROAMERICANA DE EDUCACION A DISTANCIA, 2007, 10 (01): : 201 - 215
  • [44] SQL query modification algorithms
    Chou, D.
    Segev, A.
    Proceedings of the Jerusalem Conference on Information Technology, 1990,
  • [45] Mathematical foundation of visual query language on spatial information
    Wang, Jianhua
    Guo, Jingjun
    Yan, Huiwu
    Zhu, Guorui
    Wu, Hehai
    Journal of Systems Engineering and Electronics, 2000, 11 (04) : 66 - 72
  • [46] A visual query language for uncertain spatial and temporal data
    Silvervarg, K
    Jungert, E
    VISUAL INFORMATION AND INFORMATION SYSTEMS, 2006, 3736 : 163 - 176
  • [47] A spatial index and query language based on native XML
    Research Center of Spatial Information and Digital Engineering, International School of Software, Wuhan University, 129 Luoyu Road, Wuhan 430079, China
    Wuhan Daxue Xuebao (Xinxi Kexue Ban), 2006, 10 (936-939):
  • [48] A pocket spatial database prototype and its query language
    Yu, GB
    Liao, HS
    Zheng, YM
    DCABES 2004, Proceedings, Vols, 1 and 2, 2004, : 545 - 548
  • [49] ASPECTS OF THE AUTOMATIC-GENERATION OF SQL STATEMENTS IN A NATURAL-LANGUAGE QUERY INTERFACE
    OTT, N
    INFORMATION SYSTEMS, 1992, 17 (02) : 147 - 159
  • [50] SQL-like query language and referential constraints on tree-structured data
    Afrati, Foto N.
    Damigos, Matthew George
    Stasinopoulos, Nikos
    IDEAS 2021: 25TH INTERNATIONAL DATABASE ENGINEERING & APPLICATIONS SYMPOSIUM, 2021, : 1 - 10