Simon Fraser University
Engaging the World

Course Outlines

Spring 2018 - CMPT 843 G100

Database and Knowledge-base Systems (3)

Class Number: 10849

Delivery Method: In Person

Overview

  • Course Times + Location:

    Jan 3 – Apr 10, 2018: Wed, Fri, 9:30–10:50 a.m.
    Burnaby

Description

CALENDAR DESCRIPTION:

An advanced course on database systems which focuses on data mining and data warehousing, including their principles, designs, implementations, and applications. It may cover some additional topics on advanced database system concepts, including deductive and object-oriented database systems, spatial and multimedia databases, and database-oriented Web technology.

COURSE DETAILS:

The Big Data movement is attracting an increasing number of new researchers to work on data processing related research. On the other hand, the database community has been thinking about how to address data-processing challenges for over 40 years. Numerous elegant ideas were proposed in the past and many of them are being widely applied in industry. Therefore, there is a high need to educate the new researchers to learn classical database knowledge and make sure they can stand on the shoulders of giants rather than reinvent the wheel. Because of this purpose, the course will be divided into two parts. The first part will guide students to read classical database papers that were published before 2000 on the topics including relational model, parallel database systems, transaction processing, query optimization, and materialized views. The second part will mostly about the papers published in the recent ten years on the topics including MapReduce, Spark, Columnar Store, and Key-Value Store. Through this traditional vs. modern view of data processing, the students should have a much deeper understanding of the Big Data movement and form their own opinion on what's novel about Big Data systems.

opics

  • Data Model
  • Parallel Database Systems
  • Transaction
  • Query Optimization
  • MapReduce and Spark
  • NoSQL
  • NewSQL
  • Columnar Store
  • Key-Value Store

Grading

NOTES:

Paper Presentation: 25% Questions: 10% Paper Review: 20% Blog Post: 10% Final Project: 35%

Materials

RECOMMENDED READING:

Readings in Database Systems, 4th Edition,
Peter Bailis, Joseph M. Hellerstein, Michael Stonebraker

http://www.redbook.io/
ISBN: 9780262693141

Graduate Studies Notes:

Important dates and deadlines for graduate students are found here: http://www.sfu.ca/dean-gradstudies/current/important_dates/guidelines.html. The deadline to drop a course with a 100% refund is the end of week 2. The deadline to drop with no notation on your transcript is the end of week 3.

Registrar Notes:

SFU’s Academic Integrity web site http://students.sfu.ca/academicintegrity.html is filled with information on what is meant by academic dishonesty, where you can find resources to help with your studies and the consequences of cheating.  Check out the site for more information and videos that help explain the issues in plain English.

Each student is responsible for his or her conduct as it affects the University community.  Academic dishonesty, in whatever form, is ultimately destructive of the values of the University. Furthermore, it is unfair and discouraging to the majority of students who pursue their studies honestly. Scholarly integrity is required of all members of the University. http://www.sfu.ca/policies/gazette/student/s10-01.html

ACADEMIC INTEGRITY: YOUR WORK, YOUR SUCCESS