GEOG 868
Spatial Database Management

Overview

PrintPrint

Overview

Teaching enterprise geodatabase concepts online has historically been a challenge because it's been difficult to provide students with a "playground" to get hands-on experience. Fortunately, today it is much easier to give students hands-on experience with enterprise geodatabases through virtual machines hosted by Amazon. Over the next three weeks, you will use this Amazon cloud-based solution to set up and experiment with your own remote enterprise geodatabase server.

Objectives
At the successful completion of this lesson, students should be able to:

  • set up a cloud-based enterprise geodatabase through Amazon's EC2 service;
  • explain the concept of an Amazon Machine Image (AMI);
  • stop and start their geodatabase instance;
  • enable the transfer of files from their local machine to their geodatabase instance;
  • describe the role of ArcSDE in allowing ArcGIS products to work with data in an RDBMS;
  • list advantages of a multiuser (ArcSDE) geodatabase;
  • connect to a SQL Server-based geodatabase through ArcGIS Desktop;
  • create database login roles and assign data access privileges to those roles.

Questions?

If you have any questions now or at any point during this week, please feel free to post them to the Lesson 6 Discussion Forum.