Department of Information & Communication Systems Engineering
University of the Aegean
SCHOOL OF ENGINEERING

Department of Information
& Communication Systems Engineering

Information & Communication Systems Security
Information Systems
Artificial Intelligence
Computer & Communication Systems
Geometry, Dynamical Systems & Cosmology
 
Databases II

Title: Databases II
Lesson Code: 321-3703
Semester: 5
ECTS: 5
Theory Hours: 3
Lab Hours: 2
Faculty: Tzouramanis Theodoros
 
Content outline

 Transactions and Concurrency

Database Recovery

Query Planning and Optimization

Paraller and Disctributed Databases

 
Learning outcomes

Students will gain understanding and practice in the development of a Database Management System. The intent is to train students to perform data analysis, modeling and application development using an appropriate Database Management System. The course focuses on the methodology for good database design practices and gives a practical dimension to the issue. Students will acquire the ability to perceive advanced issues in a Database Management System such as transaction management, synchronization, query optimization, Object-Oriented Databases, and participate in project management teams dealing with databases, creating applications for small and medium-sized businesses. At the end of the course, students are expected to:

  1. be able to interpret concepts of database technologies, their importance and their role in an Information System,
  2. Understand the basic principles of designing and developing systems using databases,
  3. manage advanced issues of a Database Management System such as transactions, synchronization, recovery from hardware or software failure, optimization, etc.
     
 
Prerequisites

Not required.

 
Basic Textbooks

 1. Elmasri R. and Navathe S.B.: "Θεμελιώδεις Αρχές Συστημάτων Βάσεων Δεδομένων", 6η Έκδοση, 2012. Μετάφραση από τις Εκδόσεις Δίαυλος.
2. Μανωλόπουλος Ι. και Παπαδόπουλος Α.: "Συστήματα Βάσεων Δεδομένων", Εκδόσεις Νέων Τεχνολογιών, 2006.
3. Ramakrishnan R., Gehrke J.: "Συστήματα Διαχείρισης Βάσεων Δεδομένων", 3η Έκδοση, 2012.

 
Additional References

 1. A.Silberschatz, H.F. Korth and S. Sudarshan: "Database System Concepts", Sixth Edition, McGraw-Hill, 2010.
2. Garcia-Molina H., Ullman J. and Widom J.: "Database Systems: The Complete Book", Prentice Hall Inc., 2002.
3. Date C.J.: "An Introduction to Database Systems", 8th Edition, Addison Wesley-Pearson Education Inc., 2004.

 
Learning Activities and Teaching Methods

 Work in classroom. Final exams.

 
Assessment/Grading Methods

 

Activity Semester workload
Lectures 39 hours


Personal study 83 hours
 
Final exams 3 hours
Course total 125 hours (5 ECTS)

 

 
Language of Instruction
Greek, English (for Erasmus students)
 
Μode of delivery

 Face-to-face



Home | Contact

University Of The Aegean

SCHOOL OF ENGINEERING
Department of Information & & Communications Systems Engineering

© Copyright ICSD :: 2008 - 2017