Principles of Database Management Systems (COP-5725)
Fall 2009
Announcements
|
|
Project 1 |
midterm |
Project 2 |
|
Min |
28 |
45 |
|
|
Max |
50 |
100 |
|
|
median |
42 |
78 |
|
· Final will be Sat 12/12/2009 9:45-11:45 am, same room as class.
· Instructions to connect to mysql from tomcat.
· Create all your tables with the option ENGINE=INNODB. For example, create table test (id integer) ENGINE=INNODB. The reason is that in MySQL foreign key constraints are only enforced when you create the table with this option
·
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: fall09_username
Database name: fall09_username
Password: Panther ID
Note that the MySQL accounts are different from your UNIX accounts that you need to connect to the school computers.
· 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: CP 111
Office hours: Tuesdays 5 pm-6:25 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/25/2009 |
No class, instructor out of town,
in conference |
|
|
9/1/2009 |
Overview of DBMSs |
1 |
|
9/8/2009 |
Database Design |
2 (except 2.7) |
|
9/15/2009 |
Relational Model |
3 (except 3.6) |
|
9/22/2009 |
Relational Algebra and Calculus |
4 |
|
9/29/2009 |
Review Session |
|
|
10/6/2009 |
Normal Forms |
19.1-19.6, 19.8.1 |
|
10/13/2009 |
SQL |
5.1-5.5, 3.6 |
|
10/20/2009 |
SQL, Constraints, Views, Review |
5.6, 5.7, 3.6, SQL review, normal forms review |
|
10/27/2009 |
MIDTERM |
material covered up to midterm date |
|
11/03/2009 |
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/10/2009 |
XML |
7.4, 27.7, XQuery tutorial (slides: XML, XQuery) |
|
11/17/2009 |
Indexing |
8.1-8.3, 8.5, 10.1, 10.3, 10.4 |
|
11/24/2009 |
Indexing (cont’d), Query Evaluation I |
12 |
|
12/1/2009 |
Review Session |
|
|
Sat 12/12/2009 9:45-11:45 am, same
room as class |
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.