Database Transparencies for CIS 671

    Introduction and Review of CIS 670

  1. Introduction     Postscript     PDF
  2. Relational Databases
    1. Relational Database Query Language Review     Postscript     PDF
    2. SQL Table Expressions in SQL-92 (SQL 2)     Postscript     PDF
    3. SQL Inner Join vs. Cartesian Product Join [** NEW **]     Postscript     PDF
    4. SQL Recursive Closure in SQL:1999 (SQL 3)     Postscript     PDF
    5. Report Writing     Postscript     PDF
    6. Query-By-Example (QBE) MS Access Version     Postscript     PDF
  3. Entity-Relationship (ER) and Enhanced ER (EER) Models     Postscript     PDF

    Object-Oriented and Extended Relational Database Technology

  4. Universal Modeling Language (UML) [** REVISED **]     Postscript     PDF
  5. Object-Oriented Databases
    1. Object-Oriented-1: Overview     Postscript     PDF
    2. Object-Oriented-2: Object-Oriented Database Systems (Missing slide added 1/30)     Postscript     PDF
    3. Missing slide     Postscript     PDF
    4. Object-Oriented-3: OQL     Postscript     PDF
    5. Object-Oriented-4: OQL - Exer. 7.18 in OQL
      Company DB in UML (Fig. 4.11) Postscript     PDF
      Company DB in ODL Postscript     PDF
    6. Queries Postscript     PDF
    7. Interfacing SQL to programming Languages: Embedded SQL     Postscript     PDF
    8. Object-Oriented-4: Object-Relational Database Systems     Postscript     PDF

    Decision Support: Data Warehousing and Data Mining

  6. Data Warehouses
    1. Transaction Processing to Support for Decision Making     Postscript     PDF
    2. Data Warehouses-1     Postscript     PDF
    3. Data Warehouses: On-Line Analytical Processing (OLAP)     Postscript     PDF
    4. On-Line Analytical Processing (OLAP): Data Explosion; SQL Server     Postscript     PDF
    5. On-Line Analytical Processing (OLAP): Example     Postscript     PDF
    6. Data Mining     Postscript     PDF

    Other Topics

  7. Active Databases     Postscript     PDF
  8. Introduction to Query Processing
    1. Introduction     Postscript     PDF
    2. Disks, Files and B-trees. Figures in text and class handout.