CSE 8330 Spring 1999
Distributed Databases

Principles of Distributed Database Systems, Second Edition by T. Tamer Ozsu and Patrick Valduriez

The objective of this course is to study various implementation issues related to the use of database systems in a distributed environment. Completion of CSE7330 or introductory database course is a prerequisite. Material will be drawn from the text as well as published literature in the area.

• CSE8330 Course Outline
  

• The course notes for this course are those found at the home page for the book. The following are postscript files for the class notes:
  • Introduction
  • Architecture
  • Design
  • Query
  • Transaction (pdf format)
  • Databases and Mobile Computing(ppt format)
  
  

• There are two projects required for this course.
  • Project 1 Requirments
  • There is a choice of requirements for the second project:
    • Option 1
    • Option 2
    • Option 3
    • JDBC How To

• Homework Assignment:
  • HW 1
  • HW 2
  • HW 3
  • HW 4
  • HW 5

• Related Links:
  • Sun JDBC Documentation
  • Sun JDBC Tutorials
  • Oracle8 is available for your project, please contact merlin@seas.smu.edu account and password. You may instead use any relational DBMS which has SQL. An ORACLE HOWTO is available to help you get started. In addition, here are some sample SQL files:
    Create tables: Customer , Borrow , Branch , Deposit .
    Insert into tables: Customer , Borrow , Branch , Deposit .
    Various select examples: Sel1 , Sel2 , Sel3 , Sel4 , Sel5 , Sel6 , Sel7 , Sel8 , Sel9 .