United States Naval Academy

Computer Science Department

IT462: Advanced Database Systems (2-2-3) – Fall 2011





Dr. Adina Crainiceanu, Phone 3-6822, MI362, adina@usna.edu



Course Description:

This course will discuss advanced issues in database systems such as data warehousing, data mining, parallel and distributed databases, cloud computing and XML.


Learning Objectives: 

Upon completing this course, students should be able to

  1. Apply data warehousing technologies to decision support.
  2. Apply data mining technologies to decision support.
  3. Write simple programs using the Map-Reduce framework to analyze data.
  4. Illustrate and explain the use of client-server architecture for distributed database systems.
  5. Analyze ethical and legal issues related to peer-to-peer systems.


ABET Program Outcomes:

e. An understanding of legal issues and responsibilities; (Supported by Learning Objective 5)

g. An ability to analyze the local and global impact of computing on organizations; (Supported by Learning Objective 5)



Recommended: Database Management Systems, 3rd Edition, R Ramakrishnan and J Gehrke, McGraw Hill, 2003

Recommended: Hadoop The Definitive Guide, 2nd Edition, Tom White, O’Reilly, 2010 - Safari Books Online – Nimitz Library



IT360 Applied Database Systems or SI440 Database Systems


Extra Instruction (EI):

EI is available and encouraged. Since this course continually builds upon material previously presented, it is crucial that you seek EI as soon as you have problems understanding the material. However, you must come prepared with specific questions or areas to be discussed (i.e. have read the assigned readings). If you have missed class, get the notes from a classmate. Do not ask or expect to receive EI on material that you have slept through.







Exam 1




Exam 2








Topic presentation/project




Final Exam





For the “topic presentation”, teams of students will independently investigate an approved topic, then have responsibility for one class period during which the topic shall be presented. Grades shall be based on content, preparation (including timely submission of lesson plans to the instructor), presentation quality, engagement of the audience (exercises and/or activities to promote learning are encouraged), and peer evaluation by the audience.  Team members might not receive the same grade.



The 6 and 12-week exams will primarily focus on the recent material. The final exam will be comprehensive. If for some reason a make-up exam will be required, inform the instructor at least 1 week in advance.

All exams will be closed books. You can use your own written notes during the exams.

Use of any electronic devices is not permitted during the exam.



Expect frequent quizzes. Quizzes may be open or closed book/notes, as announced. No makeup quizzes will be given.


Late Assignments:

Unless otherwise specified, all assignments are due before the beginning of class on the due date. If there is no class on the due day, the assignments are due at 0800, under the instructor’s office door. The assignments will normally be given on Thursday and due the following Thursday.


Late penalty: 10 % - if up to one day late, 25% - if up to two days late; assignments not accepted if more than two days late.

Re-grade requests have to be submitted to the instructor at most 7 days after the assignment was graded.



You are expected to follow the guidance given in:

  • Honor Concept of the Brigade of Midshipmen, USNAINST 1610.3F
  • Policies Concerning Graded Academic Work, USNAINST 1531.53
  • Policy Concerning Graded Academic Work, COMPSCIDEPTINST 1531.1C


These references can be found at http://www.usna.edu/cs/documents/honor.htm.


In particular:

1. You may collaborate on laboratory assignments to the following extent:  collaborative conversations with regard to syntax, strategies and methods for accomplishing the goal of the labs are encouraged, however design and implementation must be the work of the individual student handing in the final product. Sharing or copying of any submitted work is never permitted. We reserve the right to divide the grade between any students who violate this policy. In addition, you must identify all those that you collaborate with on your assignment cover sheet.  Consult your instructor if you need further clarification.

2. All work on exams/quizzes must be your own.


Classroom Decorum:

1.      No food is permitted in the classroom or in the labs. Drinks with closeable caps are permitted.

2.      Sleeping is not allowed in class. If you feel you may fall asleep at your desk, stand in the back of the room.

3.      No use of computer equipment for any purpose other than as outlined in the class activity will be tolerated, i.e. reading e-mail, playing games, or IMing classmates.  These actions will subject the abuser to immediate dismissal from class to report to their Company Officer.



1.      Reading assignments are expected to be completed prior to class for which it is assigned.  Practical exercises will expand on concepts introduced in these readings. 

2.      Please inform the instructor in advance if you will miss class (for instance, due to a movement order).


Submitted by:                                                                                                              Approved by:


__________________                                                                                               __________________                                                 

Dr. Adina Crainiceanu                                                                                               Prof. Steve Miner             

Assistant Professor,                                                                                                    Chair,

Computer Science Department                                                                                 Computer Science Department