Lecture Notes: ICS 321 Course Organization

What you will learn in this course

How to

• think about data management problems

• use a DBMS to manage data

• query data using SQL

• model data

• program database-backed applications

Why are these skills important ?

• Database-related jobs pay well!
  • Database Administrator Salaries

• All IT-related jobs will most likely require some data management skills

• Database technology is behind almost all internet technology/applications.

Rhythm of the Course

• Read the assigned readings BEFORE each class

• Take the quiz before every class on Laulima.

• Attend and participate in class:
  • Summary lecture with Q & A (20mins).
  • In-class exercise (55mins). Sometimes group-based. Sometimes on the computer.
• Start early and do the homework assignments:
  • Java programming assignment
  • SQL Queries
  • Data modeling using Entity-Relationship models
  • Simple database-backed web application

• Start early and work on the project.

• Take the Exams: mid-term & final. (Not cumulative).

• Take charge of the learning process
  • Try out the commands on the DBMS
  • Practice on the exercises in the textbook
• Focus on understanding the material to the point where you can apply it in different contexts.

Prerequisite Equipment, Skills & Knowledge

• Set Theory (ICS141)

• Propositional logic (ICS141, ICS111)

• Be able to write a Java program (ICS111, ICS211)

  • Use an editor or IDE to edit java code
  • Compile and run java programs

• Basic Unix Shell commands

• Have access to a computer

• Internet access

Software Setup

• Java JDK 8

• Netbeans IDE (Java EE)

• Oracle DBMS. Details in the Experience Installing DBMS

Assignment 1: Querying Large Files

Input

A CSV data file

1|3691|O|194029.55|1996-01-02|5-LOW|Clerk#000000951|0|  
2|7801|O|60951.63|1996-12-01|1-URGENT|Clerk#000000880|0|    
3|12332|F|247296.05|1993-10-14|5-LOW|Clerk#000000955|0|  
4|13678|O|53829.87|1995-10-11|5-LOW|Clerk#000000124|0|

AND a list of queries

Load order.csv   
SearchEq 3  F  
SearchGtr   4  200000   

Output

Prints the rows that matches the queries

Constraint

Data is too big to fit into memory.