This course is an introduction to database systems and Big Data. Topics will include database and GIS terminology. Database systems will be compared e.g. RDBMS, ODBMS and RDBMS. ESRI’s enterprise geodatabase will be examined. Data modelling: conceptual, logical and physical and data normalization, will be reviewed. SQL and data integrity constraints will be covered. Finally a basic introduction to what big data is, how it can be imported into a geodatabase, and the data visualized with ArcGIS.
**IMPORTANT: The final exam must be written at an approved Exam Centre only. See "How do I write my GIS online final exams?" at https://www.bcit.ca/construction/gisresources/faq/studentspt.shtml. Students should be accepted into the GIS program and completed the prerequisites prior to registration of this course. To receive approval, please email your BCIT Student ID to firstname.lastname@example.org. For more information about online courses at BCIT, please visit: www.bcit.ca/distance/foryou.shtml Students must check your my.bcit.ca e-mail account for start-up instructions sent upon registration of this course. To be successful in our online courses, plan to spend 4-6 hours per course each week on your studies, starting Week 1. Our courses are highly interactive with participation requirements weekly. Most of our online learning courses require a textbook. You can search for your course textbook at : www.bcitbookstore.ca/distance/ If no textbook is listed, course material will be provided via e-mail.
Important course information will be sent to you prior to your course start
date. Check your myBCIT email account to
access this information.
Upon successful completion, the student will be able to:
Distinguish between and give examples of data concepts such as raw data vs metadata, spatial vs attribute, structured vs unstructured vs semi-structured, and big vs little.
Distinguish between and give examples of DBMS models: RDBMS, OODBMS, ORDBMS, GIS, LIS, Spatial DBMS, Graph DBMS.
Distinguish between and give examples of spatial data structures.
Describe the architecture of a modern enterprise spatial DBMS.
Create attribute and spatial queries using spatial enabled SQL.
Implement spatial databases using GIS desktop tools including ArcGIS.
Download and import sample Big Data into a geodatabase from a Big Data database.
Visualize a Big Data derived dataset using ArcGIS.
Effective as of Fall 2016
GIST 7160 is offered as a part of the following programs:
Interested in being notified about future offerings of GIST 7160 - GIS Databases & Big Data?
If so, fill out the information below and we'll notify you by email when courses for each new term are displayed here.