COP 4751: Advanced Database Management; Section U01B

Professor Nagarajan Prabakar
prabakar@cis.fiu.edu
305.348-2033
CASE-345
Office Hours: Mon/Wed/Fri: 4:00pm – 4:45pm, 7:30pm – 8:30pm, or by appointment

Catalog Description

Design & management of enterprise systems; query optimization, transaction processing; concurrency techniques; web queries; XML interchanges; data warehousing, datamining; OLAP; NOSQL and bigdata.

Prerequisite

This course has a prerequisite: COP4703 or COP4710

Detailed Syllabus (pdf file)

Course Outcomes

• Be exposed to enterprise database system
• Master query optimization
• Master transaction processing and concurrency techniques
• Be familiar with web queries
• Be familiar with XML and XQueries
• Be familiar with data mining, data warehouse and OLAP
• Be familiar with information retrieval
• Be familiar with NOSQL and big data

Course Modules

1. Foundations of database systems
2. Query processing and query optimization
3. Transaction processing
4. Concurrency control
5. Internet database and web queries
6. XML database and XQueries
7. Data mining and data warehouse
8. Information retrieval and bigdata

Textbook

Fundamentals of Database Systems
Elmasri and Navathe
Addison Wesley; 7th Edition; 2016
ISBN-10: 0-13-397077-9
ISBN-13: 9780133970777

Grading

25% assignments

20% quizzes (in-person)

25% midterm exam (in-person: Fri, July 9th 5:00pm-7:00pm)

25% final exam (in-person: Fri, July 30th 5:00pm-7:00pm)

5% class (poll) participation

Other Issues

I expect you to maintain a high level of academic integrity in this course.
Please read FIU's Code of Academic Integrity.
You are allowed to consult other books in solving assignment problems, or to discuss the problems with other students, but you must do the assignments on your own.

For each assignment, you must upload the soft copy of the assignment through Canvas before the deadline and submit a printed copy of the assignment along with the signed originality declaration, in class on the due date.

I will grant incomplete only in extreme circumstances, such as medical emergencies with proper documentation.

I expect you to attend class regularly and promptly, and to participate in discussions. Feel free to ask questions -- if something is unclear to you, it is probably unclear to others as well.

System

John C. Comfort Lab (CASE-241)

PC workstations

For additional course information, please visit FIU Canvas Support

Discussion Forums

Keep in mind that your discussion forum postings will be seen by other members of the course. Care should be taken when determining what to post.

Important Information

Before starting this course, please review the following pages:

• Accessibility and Accommodation
• Academic Misconduct Statement

*The professor reserves the right to change or modify the syllabus at any time during the semester.