DM-05 - Extensions of the relational model

- 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
DM-67 - NoSQL Databases
NoSQL databases are open-source, schema-less, horizontally scalable and high-performance databases. These characteristics make them very different from relational databases, the traditional choice for spatial data. The four types of data stores in NoSQL databases (key-value store, document store, column store, and graph store) contribute to significant flexibility for a range of applications. NoSQL databases are well suited to handle typical challenges of big data, including volume, variety, and velocity. For these reasons, they are increasingly adopted by private industries and used in research. They have gained tremendous popularity in the last decade due to their ability to manage unstructured data (e.g. social media data).