DM2-4 - Extensions of the relational model

You are currently viewing an archived version of Topic . If updates or revisions have been published you can find them at .

Author and Citation Info: 

DiBiase, D., DeMers, M., Johnson, A., Kemp, K., Luck, A. T., Plewe, B., and Wentz, E. (2006). Extensions of the relational model. The Geographic Information Science & Technology Body of Knowledge. Washington, DC: Association of American Geographers. (2nd Quarter 2016, first digital).

Learning Objectives: 
  • Explain why early attempts to store geographic data in standard relational tables failed
  • Evaluate the adequacy of contemporary proprietary database schemes to manage geospatial data
  • Describe standards efforts relating to relational extensions, such as SQL:1999 and SQL-MM
  • Evaluate the degree to which an available object-relational database management system approximates a true object-oriented paradigm
  • Describe extensions of the relational model designed to represent geospatial and other semistructured data, such as stored procedures, Binary Large Objects (BLOBs), nested tables, abstract data types, and spatial data types