![[USC / University of Southern California]](L-1-BW-mod.gif)
CSCI585:
Database SystemsCSCI585:
Database SystemsOffice: PHE 410 Phone: (213) 740-8162 Email: shahabi@rcf.usc.edu Office Hours: T 1-2 pm, Th 2-3 pm or By appointment
Priyatham PamuOffice: SAL 229 Phone: (213) 740-4521 Email: shanbhag@usc.edu Office Hours: W 10.30 - 12.30 pm
Office: SAL 337 Phone: (213) 740-6506 Email: pamu@usc.edu Office Hours: T 3.30-5.30 pm
Snehal ThakkarEmail: kaghazia@usc.edu
Amol GhotingEmail: snehalth@usc.edu
Email: ghoting@usc.edu
This Course involves challenging programming assignments and projects
for which understanding of and programming ability in Java is required.
Knowledge in JDBC is a plus.
Back to top
Additional readings (A.R.):
The material covered in lectures should be considered the main definition
of the scope of the course. However, the text and readings are important
to supplement lecture material. Assignments and exams will be based on
the topics presented in lecture, and may also involve issues addressed
in the textbook and readings.
Back to top
| SCHEDULE OF CLASSES | |||||||
| Date | Topic | Handouts | |||||
|---|---|---|---|---|---|---|---|
| 01/09/2001 | Introduction and overview (A.R. 1) | ||||||
| 01/11/2001 | Introduction and overview | PDF , PS download | |||||
| 01/16/2001 | ER data model (review) | PDF , PS download | |||||
| 01/18/2001 | Relational data model (review) | PDF , PS download | |||||
| 01/23/2001 | Extended ER | PDF , PS download | |||||
| 01/25/2001 | Extended ER | PDF , PS download Homework #1 PDF, PS |
|||||
| 01/30/2001 | SQL (review) | PDF , PS download | |||||
| 02/01/2001 | SQL (advanced) | PDF , PS download | |||||
| 02/06/2001 | OODB (A.R. 3) | PDF , PS download | |||||
| 02/08/2001 | OO & OR-DBMS (A.R. 2, 13) | PDF , PS download | |||||
| 02/13/2001 | OR-DBMS & SQL 3 (A.R. 4) | Lecture - PDF , PS Informix Slides - PDF , PS download |
|||||
| 02/15/2001 | Database Connectivity | PDF , PS JDBC Example 1 , 2 , 3 , 4 , 5 |
|||||
| 02/20/2001 | Spatial Databases (A.R. 6) | PDF , PS | |||||
| 02/22/2001 | Spatial Databases | PDF , PS Homework #1 due | |||||
| 02/27/2001 | RIMS | Lecture PDF , PS GPL sample program Homework #2 PDF , PS, Info Data - stations , railroads, Satellite image Download RIMS version 3 |
|||||
| 03/01/2001 | Spatial Index structures (A.R. 7, 17 , 18) | PDF , PS download | |||||
| 03/06/2001 | Exam 1 review | ||||||
| 03/08/2001 | Exam 1 | ||||||
| 03/13/2001 | No class--Spring Break | ||||||
| 03/15/2001 | No class--Spring Break | ||||||
| 03/20/2001 | XML (A.R. 19,21) | ||||||
| 03/22/2001 | XML (A.R. 5, 20 ) | ||||||
| 03/23/2001 | Homework #2 due on March 26th | ||||||
| 03/27/2001 | XML | Homework #3 PDF, PS , Download XML-QL, Online demo of XML-QL |
|||||
| 03/29/2001 | Information Integration (A.R. 15) | PDF , PS download | |||||
| 04/03/2001 | Temporal Databases (A.R. 8) | PDF , PS download | |||||
| 04/05/2001 | Temporal Databases (A.R. 8) | ||||||
| 04/10/2001 | Multimedia Databases (A.R. 12) | part 1. PDF , PS part 2. PDF , PS part 3. PDF , PS download |
|||||
| 04/12/2001 | Multimedia Databases | ||||||
| 04/17/2001 | Multimedia Databases (A.R. 16) | PDF , PS download | |||||
| 04/19/2001 | Advanced Database Concepts (Data Mining, Data Warehousing, OLAP) | Homework #3 due | |||||
| 04/24/2001 | Exam 2 review | ||||||
| 04/26/2001 | Exam 2 | ||||||
| GRADING POLICY | |||||||
| EXAM | WEIGHT | ||||||
|---|---|---|---|---|---|---|---|
| HOMEWORK 1 PDF, PS, solution 1, 2 | 10% | ||||||
| HOMEWORK 2 PDF , PS Data - stations , railroads , Satellite image Download RIMS version 3 |
15% | ||||||
| HOMEWORK 3 PDF, PS | 15% | ||||||
| Sample question paper - solution EXAM 1 | 30% | ||||||
| EXAM 2 | 30% | ||||||
Grader: Leila Kaghazian
Use the Extended ER and Object Relational concepts to create a conceptual schema for a provided example application. Use your schema to build a sample database in Informix. Write the given queries in SQL3 and execute them on your database.
Electronic Submission
First decide on the files that are to be submitted and it is advised to have file names which are related to the file content.
Submit your homework in the following manner.
submit -user csci585 -tag hw1 file_name
The submit command will immediately respond with a SUCCEEDED if your submission of file "file_name" was successful. That will be your means to know that your homework has reached the right place. Your submissions will be time stamped, so we will know the exact time when you made the submission. Submit by the deadline.
Make sure you use the right numbers for your home works and the corresponding tags. This is very important because if you submit with the wrong numbers you may overwrite some other homework of yours. Resubmitting the same file will lead to overwriting the previous file.
Homework 2
Due on March 26th
Grader: Snehal Thakkar
Extend your schema of Homework 1 to support spatial datatypes. Use the
new schema to build a database in Informix. Write a GUI program that supports
Graphical Query Language (GQL). The program must allow the users to select
spatial attributes for spatial queries (e.g. selection from a map). The
GQL must then parse these into SQL queries, which will be passed to your
database. Use RIMS v3.0 to connect
to the database and display the results of the queries graphically.
Homework 3
Grader: Amol Ghoting
Extend the schema from Homework 1 to XML. Create a DTD specification
for the same. Write a custom XSL stylesheet (details will be provided).
Write an XML parser module that reads the XML data and automatically populates
your database (a sort of XML->SQL conversion). Write Perl scripts to query
the XML data using XML::Parser module of Perl.
Back to top
In this course we encourage students to study together. This includes discussing general strategies to be used on individual assignments. However, all work submitted for the class is to be done individually.
Some examples of what is not allowed by the conduct code: copying all or part of someone else's work (by hand or by looking at others' files, either secretly or if shown), and submitting it as your own; giving another student in the class a copy of your assignment solution; consulting with another student during an exam. If you have questions about what is allowed, please discuss it with the instructor.
Students who violate University standards of academic integrity are subject to disciplinary sanctions, including failure in the course and suspension from the University. Since dishonesty in any form harms the individual, other students, and the University, policies on academic integrity will be strictly enforced. We expect you to familiarize yourself with the Academic Integrity guidelines found in the current SCampus.
Violations of the Student Conduct Code will be filed with the Office
of Student Conduct, and appropriate
sanctions will be given.
Back to top
