Com S 561 Syllabus
Fall 2011
|
Date |
Topic |
Source* |
|
Aug 22 |
Why
databases, data models, relational model |
[1,2,5],lecture |
|
Aug 24 |
Relational
query languages(Relational Algebra, Relational Calculus) |
[6],lecture |
|
Aug 26 |
SQL and MySQL(http://www.mysql.com) |
[8],lecture |
|
|
|
|
|
Aug 29 |
Design–ER
Model |
[3],lecture |
|
Aug 31 |
Design–Normal
Forms -- functional dependencies |
[10,11],lecture |
|
Sept 2 |
Design –
normal forms and multi-valued dependencies |
[11],lecture |
|
|
|
|
|
Sept 5 |
Labor Day
Holiday |
|
|
Sept 7 |
Design: Lossless
Join and Join Dependencies |
[9]lecture |
|
Sept 9 |
Program
Access - Embedded SQL and Java SQLJ |
[9],lecture |
|
|
|
|
|
Sept 12 |
Program
Access - SQL and JDBC |
[9],lecture |
|
Sept 14 |
Web access -
Tomcat Server http://www.iastate.edu/~lmiller/cs561/webAccessRefs.htm |
lecture |
|
Sept 16 |
Web access -
Tomcat Server, Servlets and JSP http://www.iastate.edu/~lmiller/cs561/webAccessRefs.htm |
lecture |
|
|
|
|
|
Sept 19 |
Web access -
Tomcat Server and Struts http://www.iastate.edu/~lmiller/cs561/webAccessRefs.htm |
lecture |
|
Sept 21 |
Web access -
Struts |
lecture |
|
Sept 23 |
Web access - Struts
http://www.iastate.edu/~lmiller/cs561/webAccessRefs.htm |
lecture |
|
|
|
|
|
Sept 26 |
OO model |
[20,21],lecture |
|
Sept 28 |
OR – Mixing
Objects and Relations |
[22],lecture |
|
Sept 30 |
Interesting
tools—e.g., Hibernate http://www.hibernate.org/80.html |
lecture |
|
Oct 3 |
Hibernate |
lecture |
|
Oct 5 |
Java Data
Objects (JDO) http://www.jdocentral.com/JDO_Links_Body.html |
Lecture |
|
Oct 7 |
Semi-structured
data model/XML |
[27],lecture |
|
Oct 10 |
Semi-structured
data model/XML |
[27],lecture |
|
Oct 12 |
Concurrency
and Recovery |
[18,19],lecture |
|
Oct
14 |
Exam 1 |
|
|
Oct 17 |
Managing
Transactions |
[17],lecture |
|
Oct 19 |
Managing
Transactions |
[17],lecture |
|
Oct 21 |
Managing
Transactions |
[17],lecture |
|
Oct 24 |
Data Mining – Instance
based learning and Weka |
lecture |
|
Oct 26 |
Data Mining –
association rules |
[28],lecture |
|
Oct 28 |
Data Mining –
association rules |
[28],lecture |
|
Oct 31 |
Data Mining –
Distance |
[28],lecture |
|
Nov 2 |
Data Mining –
Nearest neighbor |
[28],lecture |
|
Nov 4 |
Data Mining –
Decision Trees |
[28],lecture |
|
Nov 7 |
Data Mining –
Decision Trees |
[28],lecture |
|
Nov 9 |
Data Mining –
Rule based |
[28],lecture |
|
Nov 11 |
Data Mining –
Rule based |
[28],lecture |
|
|
|
|
|
Nov 14 |
Data Mining –
Clustering |
[28],lecture |
|
Nov 16 |
Data Mining –
Recap |
[28],lecture |
|
Nov 18 |
Data Warehouses |
[29],lecture |
|
|
|
|
|
Nov 21 |
Thanksgiving |
|
|
Nov 23 |
Thanksgiving |
|
|
Nov 25 |
Thanksgiving |
|
|
Nov 28 |
OLAP and Data Warehouses |
[29],lecture |
|
Nov 30 |
Distributed Databases |
[25],lecture |
|
Dec 2 |
Designing Distributed
Databases |
[25],lecture |
|
Dec 5 |
Transactions in
Distributed Databases |
[25],lecture |
|
Dec 7 |
Data
Integration |
lecture |
|
Dec 9 |
Data
Integration |
lecture |
Final Exam Friday.,
Dec. 16 9:45-11:45.
*-[number] indicates a chapter or section in the textbook:
Elmasri and Navathe, Fundametals of Database Systems, 5th Edition, 2006, Addison Wesley.