Databases, Spatial Computing, SQL, Maps and GPS
Link to
Databases class files
The Databases course introduced the various database technologies with an assignment to do with each:
- SQL
- NoSQL
- JSON
- XML
- XSLT
- Xquery and Xpath
- Relational Algebra
- DTDs
- BCNF
- MVDs4NF
- Normal Form
- UML
- Relations
- Modeling
- Views
- Recursion
- Non Linear Mutual Recursion
- Referential Integrity
- Constraints
- Indexes
- Triggers
- Transactions
- Isolation Levels
- Functional Dependencies
- OLAP
- Authorization
- Also discussed but did not do projects in MySQL
Link to
Google Maps, Spatial Computing and SQL and GPS class files
From GPS and Google Maps To Spatial Computing Course
Description (concepts, not programming course for me):
DESCRIPTION:From Google Maps to consumer
global positioning system (GPS) devices, spatial technology
shapes many lives in both ordinary and extraordinary ways.
Thanks to spatial computing, a hiker in Yellowstone and a
taxi driver in Manhattan can know precisely where they are,
discover nearby points of interest and learn how to reach
their destinations. Spatial computing technology is what
powers the Foursquare check in, the maps app on your
smartphone, the devices used by scientists to track
endangered species, the routing directions that help you get
from point A to point B, the precision agriculture
technology that is revolutionizing farming, and the
augmented reality devices like Google Glass that may soon
mediate our interaction with the real world.
This course introduces the fundamental ideas underlying
spatial computing services, systems, and sciences
Subject Areas covered:
- The nature of geospatial information
- Proper statistical frameworks for working with
geospatial data
- Key algorithms and data structures
- Spatial data mining
- Cartography/geovisualization
- Addressed applied topics such as:
- Where to find spatial data
- How to use powerful open source software to analyze
and map spatial data
- Frameworks for building location-based
services.
Topics Covered
- Defining spatial computing
- Spatial query languages
- Spatial networks: motivation, society uses
- Conceptual and mathematical models
- Need for SQL extensions
- CONNECT and RECURSIVE statements
- Storage and data structures
- Algorithms for connectivity query
- Algorithms for shortest path
- Spatial data mining
- Volunteered geographic information
- Positioning
- Cartography
- Future direction topics in these areas.
