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 条
  • [1] A SPATIAL QUERY LANGUAGE FOR PRESENTATION-ORIENTED DOCUMENTS
    Oro, Ermelinda
    Riccetti, Francesco
    Ruffolo, Massimo
    [J]. ICAART 2011: PROCEEDINGS OF THE 3RD INTERNATIONAL CONFERENCE ON AGENTS AND ARTIFICIAL INTELLIGENCE, VOL 1, 2011, : 306 - 312
  • [2] Multi-dimensional qualitative spatial query language MQS-SQL
    Wang, Sheng-Sheng
    Liu, Da-You
    Yang, Bo
    [J]. Tien Tzu Hsueh Pao/Acta Electronica Sinica, 2002, 30 (SUPPL.): : 1995 - 1999
  • [3] ViQueL: A Spatial Query Language for Presentation-Oriented Documents
    Oro, Ermelinda
    Riccetti, Francesco
    Ruffolo, Massimo
    [J]. 22ND INTERNATIONAL CONFERENCE ON TOOLS WITH ARTIFICIAL INTELLIGENCE (ICTAI 2010), PROCEEDINGS, VOL 2, 2010, : 345 - +
  • [4] Use of Visual Query System in teaching database query language SQL
    Chen, PK
    Sheen, CY
    Chen, GD
    [J]. ADVANCED RESEARCH IN COMPUTERS AND COMMUNICATIONS IN EDUCATION, VOL 1: NEW HUMAN ABILITIES FOR THE NETWORKED SOCIETY, 1999, 55 : 800 - 807
  • [5] EXTENSIONS TO THE SQL QUERY LANGUAGE TO SUPPORT SPATIAL-ANALYSIS IN A TOPOLOGICAL DATA-BASE
    HERRING, JR
    LARSEN, RC
    SHIVAKUMAR, J
    [J]. GIS/LIS 88 PROCEEDINGS : ACCESSING THE WORLD, VOL 2, 1988, : 741 - 750
  • [6] XML-SQL: An XML query language based on SQL and path tables
    Pankowski, T
    [J]. XML-BASED DATA MANAGEMENT AND MULTIMEDIA ENGINEERING-EDBT 2002 WORKSHOPS, 2002, 2490 : 184 - 209
  • [7] MSQL - the language of extended multimedia query based on SQL
    [J]. Xiaoxing Weixing Jisuanji Xitong, 8 (33-38):
  • [8] FTS-SQL: A Query Language for Fuzzy Multidatabases
    Sharma, Awadhesh Kumar
    Goswami, A.
    Gupta, D. K.
    [J]. WORLD CONGRESS ON ENGINEERING 2009, VOLS I AND II, 2009, : 69 - +
  • [9] SQL/SDA: A query language for supporting spatial data analysis and its Web-based implementation
    Lin, H
    Huang, B
    [J]. IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 2001, 13 (04) : 671 - 682
  • [10] Translating Controlled Natural Language Query into SQL Query using Pattern Matching Technique
    Kumar, Rajender
    Dua, Mohit
    [J]. 2014 INTERNATIONAL CONFERENCE FOR CONVERGENCE OF TECHNOLOGY (I2CT), 2014,