• DocumentCode
    1038763
  • Title

    Spatial SQL: a query and presentation language

  • Author

    Egenhofer, Max J.

  • Author_Institution
    Nat. Center for Geogr. Inf. & Anal., Maine Univ., Orono, ME, USA
  • Volume
    6
  • Issue
    1
  • fYear
    1994
  • fDate
    2/1/1994 12:00:00 AM
  • Firstpage
    86
  • Lastpage
    95
  • Abstract
    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: the preservation of SQL concepts; the high-level treatment of spatial objects; and 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
  • Keywords
    query languages; query processing; spatial data structures; visual databases; Graphical Presentation Language; SQL extensions; Spatial SQL; database query languages; graphical presentation; high-level treatment; nonspatial data; presentation language; query and presentation language; spatial data handling; spatial databases; spatial objects; spatial query language; spatially related data; standard SQL queries; CADCAM; Computer aided manufacturing; Data handling; Database languages; Design automation; Displays; Geographic Information Systems; Information retrieval; Spatial databases; Very large scale integration;
  • fLanguage
    English
  • Journal_Title
    Knowledge and Data Engineering, IEEE Transactions on
  • Publisher
    ieee
  • ISSN
    1041-4347
  • Type

    jour

  • DOI
    10.1109/69.273029
  • Filename
    273029