Database Transparencies for CIS 671
Introduction and Review of CIS 670
- Introduction
Postscript
PDF
- Relational Databases
- Relational Database Query Language Review
Postscript
PDF
- SQL Table Expressions in SQL-92 (SQL 2)
Postscript
PDF
- SQL Inner Join vs. Cartesian Product Join [** NEW **]
Postscript
PDF
- SQL Recursive Closure in SQL:1999 (SQL 3)
Postscript
PDF
- Report Writing
Postscript
PDF
- Query-By-Example (QBE) MS Access Version
Postscript
PDF
- Entity-Relationship (ER) and Enhanced ER (EER) Models
Postscript
PDF
Object-Oriented and Extended Relational Database Technology
- Universal Modeling Language (UML) [** REVISED **]
Postscript
PDF
- Object-Oriented Databases
- Object-Oriented-1: Overview
Postscript
PDF
- Object-Oriented-2: Object-Oriented Database Systems
(Missing slide added 1/30)
Postscript
PDF
- Missing slide
Postscript
PDF
- Object-Oriented-3: OQL
Postscript
PDF
- Object-Oriented-4: OQL - Exer. 7.18 in OQL
Company DB in UML (Fig. 4.11)
Postscript
PDF
Company DB in ODL
Postscript
PDF
- Queries
Postscript
PDF
- Interfacing SQL to programming Languages: Embedded SQL
Postscript
PDF
- Object-Oriented-4: Object-Relational Database Systems
Postscript
PDF
Decision Support: Data Warehousing and Data Mining
- Data Warehouses
- Transaction Processing to Support for Decision Making
Postscript
PDF
- Data Warehouses-1
Postscript
PDF
- Data Warehouses: On-Line Analytical Processing (OLAP)
Postscript
PDF
- On-Line Analytical Processing (OLAP): Data Explosion; SQL Server
Postscript
PDF
- On-Line Analytical Processing (OLAP): Example
Postscript
PDF
- Data Mining
Postscript
PDF
Other Topics
- Active Databases
Postscript
PDF
- Introduction to Query Processing
- Introduction
Postscript
PDF
- Disks, Files and B-trees. Figures in text and class handout.