Object-oriented and extended relational database systems; data warehousing; active databases; GUI interface to a relational database system; introduction to data and file storage.
Weeks Topics Readings 1 SQL Review including ANSI Joins EN: 7-8 1 Review of Relational Database Design EN: 3-4, 14-15 1 GUI Interface to a Relational Database System See Tutorials 3 Object-Oriented and Extended Relational Database Technology
Object-Oriented Databases
Object-Relational Databases
SQL3
EN: 11-12
EN: 13
D: Appendix F2 Data Warehousing
Online Analytical Processing (OLAP)
Data Mining
Association Rules
EN: 26.1, C, CD, P
EN: 26.21 Active Databases EN: 23.1 1 Introduction to Query Processing
Introduction
Disks
Basic Files
Index Structures for Files
Indexing
B-Trees
Hashing (If time allows.)
EN: 5.1-5.2, particularly 5.2.1 See Disks
EN: 5.5-5.8
EN: 6.1
EN: 6.3
EN: 5.9
Homework. Late homeworks will not be accepted. 20% Midterm Exam: Wednesday, February 13. 35% Final Exam: 7:30 - 9:18 AM, Wednesday, March 20.
(Early Senior Final Exam: Tuesday, March 12 (Corrected), 2:30-4:30, Caldwell 183)45%