CSC 7402 ADVANCED DATABASE SYSTEMS
(Subject to
change)
(Even though
official number for this course is “section 2” of 7402, but there is only one
section of 7402 course.)
(Last Updated: 12/8/2010, 12:30PM)
Instructor:
Professor Peter Chen, Office #1 and Research Lab: 140 Coates
Hall, Office #2: 257 Coates Hall
E-mail address:
pchen at lsu.edu
Office Hours:
12Noon – 12:30PM, and 4-5:30PM Fridays (no matter whether you want to see Dr.
Chen during office hours or not, please set up an appointment first via
e-mails.)
Time
& Classroom: Fridays 1:10 -4:00pm, 236 Coates Hall
(Please note that some of the class
meetings may be re-scheduled to another date and time -- most likely to the
weekends. You should take this into
consideration when you decide to take this course for credit. Course announcements will be made via e-mails
and via the course web page at: http://www.csc.lsu.edu/~chen/7402.htm
).
Description:
Database systems are the core of many
information systems. This course will
concentrate on the theory and implementation of advanced database systems. We will concentrate on the Entity-Relationship
(ER) model, and some of the new concepts and developments in database
management such as:
·
Graphical Query
Languages, ERD, & English, 1st Order Logic, translation to SQL
·
Data Dictionary
Systems. ANSI/X3/H4 and ISO Draft
Standards
Please note that we won’t have time to
cover all these topics in depth. We will
only cover some of these topics. Besides the topics listed above, we may add
some other topics later.
Pre-requisites:
CSC 4402
(Introduction to Database Systems) at LSU or the equivalent in another college.
It is not recommended to take both
CSC4402 and CSC7402 in the same semester simultaneously, but if you want to
take both courses the same time, please be prepared to spend sufficient amount
in both courses. It is also NOT
allowed to take these two courses in reverse order.
Syllabus (may be modified
periodically):
1st Week, 8/27
Topic: Administrative Issues
8/28 (Saturday), 1-3PM, 109 Coates Hall
Topics: Administrative Issues; Overview of Database Life Cycle
Software Pioneers Conference, Bonn, Germany, 2001: Chen’s Lecture (Video)
Readings: Teorey's
Book, Chapter 1 (4th edition).
2nd
Week, 9/3
Topics: The Entity-Relationship (ER) Model
Readings: Teorey's
Book, Chapter 2 (4rd edition).
3rd Week,
9/10
Topics:
The Entity-Relationship (ER) Model
Readings: Teorey's Book,
Chapters 3 and Chapter 4 of the 4th edition
Basics
of SQL, Teorey’s Book, Appendix (This SQL Appendix will not be
posted. However, you may get any books
yourself on SQL or read SQL materials available on the Web.).
Homework Assignment #1 (Due date and procedure: E-mail your
answers to Dr. Chen by the deadline – to be specified.)
4th Week, 9/17
Transforming ERD to SQL Constructs
Topics
& Readings: Teorey's
Book, Chapter 5 in 4th edition
Assignment
2: (to be announced)
5th Week,
9/24
Topics:
The Entity-Relationship (ER) Model & Normalization of relations
Readings:
1.
First Normal Form of Relations, Teorey’s
Book, 6.1 (4th edition)
2.
Concepts of Keys, Teorey’s
Book, 6.1.2 (4th edition)
3.
Functional Dependency and other normal forms, Teorey’s Book, 6.2 -6.4 (4th edition)
4.
Other dependencies and high-order normal forms, Teorey’s book, 6.5-6.7 (4th edition)
6th Week, 10/1
Topic: Advanced
topic in ER model and Data Management
Readings: Dr. Chen’s papers on “ERD and English”, “ERD
& Chinese Characters”, and “ERD & Ancient Egyptian Hieroglyphs.”
7th Week, 10/8
Topics:
· Discussions of
the mid-term exam ( Mid-term
exam scopes and rules. )
· Mega
Trends
Handouts:
·
Dr. Chen’s slides on Mega Trends (a keynote speech at CIKM 2003
Conference in New Orleans)
8th Week, 10/15
Topics:
· Active
Conceptual Modeling
Handouts:
·
Dr. Chen’s slides on
Active Conceptual Modeling (a keynote speech at ER 2006 Conference in Tucson).
9th Week, 10/22 (Fall Holiday, but we may have class on this date as a make-up class for
another a missing regular meeting date)
Topics:
· Microsoft
ADO.NET Entity Framework (Lecture
#1 on 10/25, and the beginning part of Lecture
#2)
·
Web Page Design Using ER Model (the 2nd part of Lecture #2)
·
A set of operators for
ERD (based on the “Enterprise View of Data” paper in Chen’s website) (the final
part of Lecture #2)
Handouts:
· Paper
on Hypermedia Design
· Slides
on Microsoft ADO.NET Entity Framework
10th Week, 10/29 (A possible
mid-term exam/1st-Quiz date)
Topics (may be discussed in a
re-scheduled class):
· Discussions
of Student Term Papers/Projects
·
Discussions of the
mid-term exam
· Brief
Discussions of demo programs in ER 2008 Conference (the demo programs can be
found at the ER 2008 website).
·
Variants of the ER model
(based on a paper in Chen’s website.)
· Enterprise
Information Integration.
Handouts: Slides on Enterprise
Information Integration
11th Week, 11/5
Topics:
·
IRDS.
·
Student
presentations of term papers/projects (1st presentation)
12th Week, 11/12 (No meeting in classroom. Will be re-scheduled)
Topics:
· Selected
papers/slides from ACM-L Workshop 2009 by
1. Leah
Wong
2. Jens
Jensen
3. Il-Yeol
Song
4. Sudha
Ram
5.
John
Mylopoulos
·
Student
presentations of term papers/projects (1st presentation)
13th Week, 11/19
Topics:
·
Student
presentations of term papers/projects (2nd presentation)
14th Week, 11/26
(Thanksgivings Holiday).
Topics (may be self-reading):
·
Teorey’s Chapters 8 (Business Intelligence,
part of the Chapter 8) and Chapter 9 CASE Tools).
·
Scope of Teorey’s Chapter 8 and Chapter 9 to be included in the
final quiz.
· Student paper/project presentations (2nd- more
in-depth - presentations than those presentations in the previous weeks)
15th Week, 12/3
Project Presentation (for those who want to
present the projects in person) and the final oral quiz (for those who choose
to have the final oral quiz). The scopes of the final oral quiz will include all the materials covered in
the course, but at least 50% of the questions will be based on the materials
after the mid-term. For those who decide not to come to the
campus, it is possible to present the projects via SKYPE on 12/3 or 12/4.
16th Week, 12/10
12/10 (Friday)
-12/13 (Monday) (Presentation of Final Version of Term Papers/Projects)
Students should be prepared
to present the final version of the term papers/projects via SKYPE with
high-speed Internet connection (no matter where the students will be). Selected students will be chosen to conduct
such presentations. After you submit your final
version and make your final presentation, you may still need to be reachable to
answer questions if the materials submitted by you are not clear or your computer
programs do not work.
Course
Work and Grading Policy:
There will be homework assignments,
a written mid-term exam, a term project, and an oral quiz. Students should
actively participate in class discussions and class presentations. Your final grades will be calculated based on
the following formula:
Homework:
20%
Mid-Term Exam/1st-Quiz: 30%
Term Paper/Project & Presentation: 20%-40%
Final Quiz 0%- 20%
Students
can have three options:
Option
#1: Term project 20%, Final oral quiz
20%
Option
#2: Term project 30%, Final oral quiz
10%
Option
#3: Term project 40%, no final oral quiz
Class Discussions 10%
Textbook
(You may order directly from Amazon.com;
not available in Union Bookstore):
Teorey, T., et.
al. Data
Modeling and Design, Morgan Kaufmann publishers, 4th Edition (or the most
recent edition, if available).
Recommended
Readings (not available in Union
Bookstore):
Chen, Peter and Wong, Leah, (eds.), Active Conceptual Modeling of Learning: Next
Generation Learning-Base System Development, LNCS#4512, Springer, 2007.
Chen, Peter, et.
al. (eds.), Conceptual Modeling: Current
Issues and Future Directions, LNCS#1565, Springer, 1999.
Hughes, John, Object-Oriented Databases, Prentice-Hall, 1991.
Korth
and Silbershaltz, Database
System Concepts, McGraw-Hill, (most recent edition)
Hawryszkiewycz,
I.T., Data Base Design, Science
Research Associates,
Software Pioneers: Their Contributions to Software Engineering,
Springer-Verlag, 2002.