Principles of Database Management Systems (COP-5725)
Fall 2008
Announcements
· Instructions to connect to mysql from tomcat.
· The version of MySQL at the lab does not support triggers, assertions and check, so for Deliverable F of the project you don’t need to add the constraints to the database, but just write the SQL commands in your project paper. The same holds for the “create view” statements of Deliverable D, which are not supported by the installed MySQL version, so you just need to write the SQL commands in your project paper, and execute the corresponding queries in MySQL to make sure that they are correct and there is no syntax errors.
· Create all your tables with the option TYPE=INNODB. For example, create table test (id integer) TYPE=INNODB. The reason is that in MySQL foreign key constraints are only enforced when you create the table with this option, so use this option always since it does not harm you.
·
MySQL tips: To start MySQL, first ssh to connect
to margay.cs.fiu.edu and then type
mysql -u username -D databasename -h margay.cs.fiu.edu –p.
Then, to see tables in the db, type: show
tables; To see schema of a table, type: describe
tablename;
·
MySQL accounts are ready. For each student:
Server: margay.cs.fiu.edu
Username: fall08_username
Database name: fall08_username
Password: Panther ID
· Your UNIX login is your regular FIU username, and <first initial><pantherid><last initial> for your password, if you haven't used it yet. You can log into margay from outside of campus, but you must use ssh.
· When building the E-R diagram for the project, don’t use the E-R package of Visio since it uses different notation.
· Midterm and final have closed books. A single-sheet cheat sheet is allowed.
· Welcome to the COP-5725 web page!
General Info
Instructor: Vagelis Hristidis
Lecture time: Tuesdays 6:25 pm-9:05 pm
Location: ECS 145
Office hours: Tuesdays 4 pm-5 pm
Grading
30% midterm
40% final
30% project
Course Description
This is a graduate level course that introduces the principles of database management systems. After the students successfully finish this course, they should have a better understanding on different aspects of a database management system. They should also be familiar with relational model, SQL, storage and indexing, query evaluation, transaction management, and some selected topics.
The first part of the class will quickly go through the undergraduate databases material and the second part will discuss new material like indexing, query optimization and XML.
The class involves a project of accessing a database through a web application. In particular, the technologies that we will use are:
- JSP to write dynamic web
pages
- JDBC to connect to the
database system
- MySQL as the database
system
Prior
knowledge of these technologies is not required as learning materials will be
provided. Students can work in groups of two, but in the end they should report
on the primary responsibilities of each partner.
Some of the topics presented will be:
- Database Design with ER model
- Relational Model
- Relational Algebra and Calculus
- SQL
- Indexing
- Transaction Processing (briefly)
- Query Optimization
- XML
Project
Description
Tentative
Lectures’ Schedule
(for chapter slides you can go to http://www.cs.wisc.edu/~dbbook/)
|
Date |
Topic |
Book Chapters or Other Material |
|
8/26/2008 |
Overview of DBMSs |
1 |
|
9/2/2008 |
Database Design |
2 (except 2.7) |
|
9/9/2008 |
Relational Model |
3 (except 3.6) |
|
9/16/2008 |
Relational Algebra and Calculus |
4 |
|
9/23/2008 |
Normal Forms |
19.1-19.6, 19.8.1 |
|
9/30/2008 |
SQL |
5.1-5.5, 3.6 |
|
10/7/2008 |
SQL, Constraints, Views |
5.6, 5.7, 3.6 |
|
10/14/2008 |
Review Session |
|
|
10/21/2008 |
MIDTERM |
material covered up to midterm date |
|
10/28/2008 |
JDBC, Stored Procedures Web Applications, JSP+MySQL |
6.2, 6.3, 6.5.1, 6.5.2, 6.6 7.5, JSP tutorial (slides: JDBC-JSP), |
|
11/04/2008 |
Indexing |
8.1-8.3, 8.5, 10.1, 10.3, 10.4 |
|
11/18/2008 |
Indexing (cont’d), Query Evaluation I |
12 |
|
11/25/2008 |
XML |
7.4, 27.7, XQuery tutorial (slides: XML, XQuery) |
|
12/2/2008 |
Review Session |
|
|
TBA |
FINAL |
material covered after midterm |
Other Resources
http://dev.mysql.com/doc/mysql/en/index.html
http://jakarta.apache.org/tomcat/
Textbook
Database Management Systems
by Raghu Ramakrishnan, Johannes Gehrke
Third Edition
ISBN: 0072465638
http://www.cs.wisc.edu/~dbbook/
Policies
Code of Academic Integrity:
http://www.fiu.edu/~oabp/misconductweb/2codeofacainteg.htm
University Policies: academic misconduct, sexual harassment, religious holydays, and information on services for students with disabilities.