Announcements
Tue, April 28, 2009 -- Final is posted!
See the file posted in course schedule and Blackboard. Due: 11:55pm, May 3, 2009 (Sunday). No late submissions will be accepted. Only submissions via Blackboard will be accepted.
Tue, Mar 03, 2009 -- Midterm and project 3
Midterm grades are available from Blackboard. Project 3 has also
been posted. I will return the midterm paper on Wednesday and go
over the problems if needed.
Tue, Feb 17, 2009 -- Homework 2 is posted!
Due: 11:55pm, Feb. 28, 2009 (Saturday).
People
Instructor : Dr. Yicheng Tu
Office : ENB 340 Phone : 4-2114 Email : ytu@cse.usf.edu
Office hours : 2:30pm-4 :30pm, Wednesday, and other times by appointment
URL: www.cse.usf.edu/~ytu
Teaching Assistant: Ravikiran Krishnan
Email: rkrishn2@mail.usf.edu
Office : ENB 221 Phone : 646-257-0368
Office hours: 1:00pm - 2:00pm, Monday
Course Overview
This course covers the principles and practice of database systems, with a focus on the fundamentals of modern database management systems. Specifically, the following topics will be discussed:
I. Database systems concepts:
Relational and object-oriented data models
Database languages: relational algebra and calculus, SQL
II. Core functionalities of database management systems
Buffer management
Data storage and file organization, space-filing curves, and partitioning
Indexing: tree-based, hash-based, and bitmap indices, indexes for spatiotemporal data
Query processing and optimization
Concurrency control and system recovery
III. Advanced topics:
Database architecture: parallel and distributed databases
Specialized databases: deductive, biological, stream, and multimedia databases
Data warehousing and online analytical processing (OLAP)