DM-03 - Relational DBMS

- Explain the advantage of the relational model over earlier database structures including spreadsheets
- Define the basic terms used in relational database management systems (e.g., tuple, relation, foreign key, SQL, relational join)
- Discuss the efficiency and costs of normalization
- Describe the entity-relationship diagram approach to data modeling
- Explain how entity-relationship diagrams are translated into relational tables
- Create an SQL query that extracts data from related tables
- Describe the problems associated with failure to follow the first and second normal forms (including data confusion, redundancy, and retrieval difficulties)
- Demonstrate how search and relational join operations provide results for a typical GIS query and other simple operations using the relational DBMS within a GIS software application
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).