Computing Science Course Outlines

Course Outline - CMPT 454 - Database Systems II

Information

Subject

Catalog Number

Section

Semester

Title

Instructor(s)

Campus

CMPT

454

D100

2022 Fall (1227)

Database Systems II

Tianzheng Wang   

Burnaby Mountain Campus

Calendar Objective/Description

Database Systems II

Instructor's Objectives

Did you ever wonder how come Amazon and Alibaba are capable of handling so many online orders for Black Friday, Single's Day? Have you had an unlucky case where your bank charged you an overdraft fee while you think you have money? Are you frustrated when you see "service unavailable due to maintenance" on your favourite website? This is the course for you to know all about it. CMPT 454 is a systems-oriented course on the design and implementation of relational database systems, the backbone of many today's data-intensive applications, like e-commerce, banking, social-network, telecom, etc. This course provides an in-depth coverage of core topics in the making of relational database systems, topics includes data storage, indexing, query optimization and transaction processing. Course website will be available at: https://www.cs.sfu.ca/~tzwang/teaching.html

Prerequisites

see go.sfu.ca

Topics

  • Data storage, indexing
  • Query processing
  • Transaction processing
  • Logging and crash recovery

Grading

To be discussed later when lectures start.

Reference Books

  • Database Systems: The Complete Book, Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom, 9780131873254, 2nd or latest Edition
  • Transaction Processing: Concepts and Techniques, Jim Gray, Andreas Reuter, 9781558601901
  • Database Management Systems, Raghu Ramekrishnan, Johannes Gehrke, McGraw-Hill, 9780072465631, 3rd Edition

Academic Honesty Statement

Academic honesty plays a key role in our efforts to maintain a high standard of academic excellence and integrity. Students are advised that ALL acts of intellectual dishonesty will be handled in accordance with the SFU Academic Honesty and Student Conduct Policies ( http://www.sfu.ca/policies/gazette/student.html ).

Data Last Updated: