Module: Worlds of Database Systems

Introduction to database systems.

Prerequisite Modules

Data Representations

Binary representation of data.

Learning Outcomes

Understand what is a database system

You understand what is a DBMS and what it provides
You know when to use files and when to use a DBMS
You understand how data can be encoded and stored in files.
You can write a program to query large CSV files

Readings

Chapter 1: Worlds of Database systems

Data vs. Database vs. DBMS

10 pages

Introduction to database systems

Data vs. Database vs. DBMS

Lecture Notes

Experiential Learning

Exercise 1

Reverse engineer an application

HW1: Querying Large Files

Write a Java program to query large CSV files

Assignment 1