Com S 561 Syllabus

                                                                 Spring 2008

 

Date

Topic

Source*

Jan 14

Why databases, data models, relational model

[1,2,5],lecture

Jan 16

Relational query languages(Relational Algebra, SQL)

[6,8],lecture

 

 

 

Jan 21

University Holiday

 

Jan 23

Design–functional and multi-valued dependencies

[10,11],lecture

 

 

 

Jan 28

Design – normal forms/good design issues/ER Model

[3,4,11],lecture

Jan 30

Lossless Join and Join Dependencies

[11],lecture

 

 

 

Feb 4

Program Access/ Embedded SQL/SQL and Java

[9]lecture

Feb 6

SQL and Java /SQLJ and JDBC

[9],lecture

 

 

 

Feb 11

Program Access/JDBC&MySQL(http://www.mysql.com)

[9],lecture

Feb 13

Web access, Tomcat Server, Servlets, JSP, PHP

http://www.iastate.edu/~lmiller/cs561/webAccessRefs.htm

lecture

 

 

 

Feb 18

Web access, Tomcat Server, Struts

http://www.iastate.edu/~lmiller/cs561/webAccessRefs.htm

lecture

Feb 20

OO model

[20,21],lecture

Feb 25

Interesting tools—e.g., Hibernate  http://www.hibernate.org/80.html

lecture

Feb 27

Java Data Objects (JDO)

http://www.jdocentral.com/JDO_Links_Body.html

lecture

Mar 3

OO and web databases

Lecture

Mar 5

OR – Mixing Objects and Relations

[22],lecture

Mar 10

Semi-structured data model/XML

[27],lecture

Mar 12

Exam 1

Mar 17

Spring Break

Mar 19

Spring Break

Mar 24

Concurrency and Recovery

[18,19],lecture

Mar 26

Managing Transactions

[17],lecture

Mar 31

Transactions

[17],lecture

Apr 2

Transactions

[17],lecture

 

 

 

Apr  7

Data Mining – association rules

[26],lecture

Apr  9

Data Mining – association rules/machine learning

[26],lecture

Apr  14

Data Mining – machine learning

[26],lecture

Apr  16

OLAP and Data Warehouses

[29],lecture

Apr  21

Designing Distributed Databases

[25],lecture

Apr  23

Transactions in Distributed Databases

[25],lecture

Apr  28

Data Integration

lecture

Apr  30

Data Integration

lecture

      Final Exam Monday May 7th, 7:30-9:30 am.

        *-[number] indicates a chapter or section in the textbook: 
            Elmasri and Navathe, Fundametals of Database Systems, 5th Edition, 2006, Addison Wesley.