CSE 5330/7330 Fall 2009
FILE ORGANIZATION AND DATABASE MANAGEMENT

Course Syllabus

Book:

Database Management Systems by Raghu Ramakrishnan and Johannes Gehrke Book Web Page

Class Material

• Database Introduction Slides
• Book Slides
• B+ tree and Hashing by Pinar Karagoz Senkul
• I/O and File Systems
• Relational Database Design Slides from Database System Concepts Fifth Edition by Avi Silberschatz, Henry F. Korth, and S. Sudarshan

• HW 1
• HW 2
• HW 3
• HW 4
• EC 2
• HW 5

Project

• PROJECT 1
• PROJ1B for GRADUATE STUDENTS ONLY

Supplementary Material

• RELATIONAL MODEL
  • "A Relational Model of Data for Large Shared Data Banks," by E.F. Codd
  • Using Oracle at SMU/LYLE
• SQL/ORACLE
  • Oracle/SQL Tutorial by Michael Gertz
  • SQL*Plus Command Reference
  • Notes on the Oracle DBMS
  • ORACLE/SQLPLUS EXAMPLES:
    • Examples based on relations found in Database Systems Concepts by Avi Silberschatz, Henry F. Korth, and S. Sudarshan
    • Create Relations
    • Populate Relations
    • Describe Relations
    • List Relations
    • Alter Relations
    • Update Examples
    • Dual Relation
    • Select Examples
    • Union Examples
    • Intersect Examples
    • Minus Examples
    • In Examples
    • Aggregate Examples
  • SQL NULLS
    • "Nulls: Nothing to Worry About
    • "The NULL comparison trap: Escape with NVL(Oracle) and Nz(Access)

Additional Topics

• Student Presentations
  • Non-Relational Databases by Jeff Allen
  • SQL Injection by Timothy Boyd
  • Hibernate by Robert Greiner
  • Database Security Overview by Blake Middleton
  • Data Warehouse Architecture by Harrison Reid
  • Spatial Databases by Tyler Reainthong
  • BtrFS by Kyle Turney
• Recent File Systems (9/3)
  • StorageReview.com
  • ZFS The Last Word in File Systems by Jeff Bonwick and Bill Moore
  • ZFS Nuts and Bolts
  • ext3 at Wikipedia
  • The new ext4 filesystm: current status and future plans, by Avantika Mathur, Mingming Cao, Suparna Bhattacharya, and Andreas Dilger
  • BTRFS
    • BTRFS wiki
    • BTRFS at Wikipedia
  • The Hammer Filesystem by Matthew Dillon
  • Comparison of File Systems at Wikipedia
• Entity-Relationship Model
  • The Entity-Relationship Model-Toward a Unified View of Data by Peter Chen
  • ER Conference