query operations, query languages

FC-12 - Structured Query Language (SQL) and attribute queries
  • Define basic terms of query processing (e.g., SQL, primary and foreign keys, table join)
  • Create an SQL query to retrieve elements from a GIS
  • Explain the basic logic of SQL syntax
  • Demonstrate the basic syntactic structure of SQL
FC-13 - Spatial queries
  • Demonstrate the syntactic structure of spatial and temporal operators in SQL
  • State questions that can be solved by selecting features based on location or spatial relationships
  • Construct a query statement to search for a specific spatial or temporal relationship
  • Construct a spatial query to extract all point objects that fall within a polygon
  • Compare and contrast attribute query and spatial query
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).

FC-13 - Spatial queries
  • Demonstrate the syntactic structure of spatial and temporal operators in SQL
  • State questions that can be solved by selecting features based on location or spatial relationships
  • Construct a query statement to search for a specific spatial or temporal relationship
  • Construct a spatial query to extract all point objects that fall within a polygon
  • Compare and contrast attribute query and spatial query
FC-12 - Structured Query Language (SQL) and attribute queries
  • Define basic terms of query processing (e.g., SQL, primary and foreign keys, table join)
  • Create an SQL query to retrieve elements from a GIS
  • Explain the basic logic of SQL syntax
  • Demonstrate the basic syntactic structure of SQL
FC-11 - Set Theory
  • Describe set theory
  • Explain how logic theory relates to set theory
  • Perform a logic (set theoretic) query using GIS software
  • Explain how set theory relates to spatial queries
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).

FC-13 - Spatial queries
  • Demonstrate the syntactic structure of spatial and temporal operators in SQL
  • State questions that can be solved by selecting features based on location or spatial relationships
  • Construct a query statement to search for a specific spatial or temporal relationship
  • Construct a spatial query to extract all point objects that fall within a polygon
  • Compare and contrast attribute query and spatial query
FC-11 - Set Theory
  • Describe set theory
  • Explain how logic theory relates to set theory
  • Perform a logic (set theoretic) query using GIS software
  • Explain how set theory relates to spatial queries
FC-12 - Structured Query Language (SQL) and attribute queries
  • Define basic terms of query processing (e.g., SQL, primary and foreign keys, table join)
  • Create an SQL query to retrieve elements from a GIS
  • Explain the basic logic of SQL syntax
  • Demonstrate the basic syntactic structure of SQL

Pages