Database II

Curriculum guideline

Effective Date:
Return to Course
Print Guideline
Course
CSIS 3300
Discontinued
No
Course code
CSIS 3300
Descriptive
Database II
Department
Computing Studies & Information Systems
Faculty
Commerce & Business Administration
Credits
3.00
Start date
End term
201820
PLAR
No
Semester length
15 Weeks
Max class size
35
Contact hours
Lecture: 2 Hours per week Seminar: 2 Hours per week Total: 4 Hours per week
Method(s) of instruction
Lecture
Seminar
Learning activities

Lecture, seminar and hands-on exercises in the lab.

Course description
This course will continue on from CSIS 2300 exploring advanced features of database systems. Topics covered will include indexing; query processing and optimization; transaction processing; denormalization; star schema; DW/OLAP cubes; security. NoSQL and MapReduce will also be covered.
Course content
  1. Course overview and review of database fundamentals;
  2. Working with DB indexes;
  3. Introduction to query processing and optimization;
  4. Query optimization case studies;
  5. Working with DB transactions;
  6. Denormalizing a DB - why, when, and how;
  7. Introduction to dimensional modeling;
  8. Designing a star schema;
  9. Working with DW/OLAP cube;
  10. Introduction to noSQL databases;
  11. CRUD operations in noSQL;
  12. Analytics in noSQL (MapReduce);
  13. Securing a database system.
Learning outcomes

The student will be able to:

  1. Explain the purpose of indexing;
  2. List different types of indexes;
  3. Evaluate and explain when to use an index on a column;
  4. Describe how a SQL query is processed by the DB engine;
  5. Generate a more efficient query which reduces resource consumption but provides same data results;
  6. Explain situations when DB transactions should be used;
  7. Plan a set of queries which could be executed as part of a transaction - including both the success and failure scenarios;
  8. Describe why and when denormalization is beneficial for a DB system;
  9. Execute the denormalization process;
  10. Design a star schema;
  11. Use a DW/OLAP cube to extract information from data;
  12. Use a noSQL DB to perform CRUD (Create, Retrieve, Update, Delete) operations;
  13. Demonstrate application of MapReduce functions;
  14. Describe common DB security issues and their solutions.
Means of assessment
Assignments/Projects (Minimum: 3)     25% - 45%
Participation 0% - 5%
Tests/Quizzes (Minimum: 2) 10% - 40%
Final Examination 25% - 30%
Total 100%
Textbook materials

Raghu Ramakrishnan and Johannes Gehrke. Database Management Systems, 3rd Edition,
McGraw-Hill, current version

and

Instructor compiled materials (if applicable)

or

other textbooks as approved by the department

Prerequisites

CSIS 2300 or CISY 2300