Databases II

Course Code: Ν2-4050
Weekly Duty: 4 (2Th + 2L)
ECTS: 5
Typical Semester: 4th
Course Category: Special Infrastructure Course
Prerequisites: Databases I

Learning Outcomes

Upon successful completion of the course students should have acquired:

  • knowledge of the database technologies, and the Database Management Products
  • understanding of matters arising during the design and implementation of integrated database systems
  • skills of designing and implementing integrated database systems using various database technologies
  • ability to evaluate database systems design, and implement integrated database systems in various environments

Course Content
  1. Database design and functional dependencies
  2. Enhanced Entity Relationship model, Object-Relational Database model
  3. Oracle PL/SQL technology (triggers, stored procedures, cursors, etc.)
  4. Open source Database Management Products
  5. Transaction processing and Database Management Products
  6. Database Administration and Database Management Products
  7. Back up, database recovery
  8. Concurrency
  9. Query optimization
  10. Distributed databases
  11. Technological evolution of Databases – multimedia databases, web based database systems, database security, information and knowledge management, XML, OLAP, Data Warehouse, business intelligence
  12. Case Study

Literature
  1. Elmasri R., Navathe S.B., Θεμελιώδεις Αρχές Συστημάτων Βάσεων Δεδομένων, Τόμος Β’, (μετάφραση Μ. Χατζόπουλου), Εκδόσεις Δίαυλος
  2. Silberschatz A., Korth H.F., Sudarshan S., Συστήματα βάσεων δεδομένων – Η πλήρης θεωρία των βάσεων δεδομένων, (μετάφραση Μ. Γκλαβά), Εκδόσεις Γκιούρδα
  3. Ramakrishnan R., Gehrke J., Συστήματα διαχείρισης βάσεων δεδομένων, τόμος Β, (μετάφραση Δ. Δέρβου, Α. Ευαγγελίδη), Eκδόσεις Τζιόλα
  4. Ullman J.D., Widom J., A first course in database systems, Prentice-Hall
  5. Γ. Βασιλακόπουλος, Σχεδιασμός Βάσεων Δεδομένων
  6. Χ. Σκουρλάς, Υλοποίηση εφαρμογών με γλώσσα SQL – χρήση τεχνολογίας Oracle, Νέες Τεχνολογίες.
  7. Βασιλειάδης Π., Σελλής Τ., Αντικειμενοστρεφή συστήματα διαχείρισης βάσεων δεδομένων, Εκδόσεις Παπασωτηρίου
  8. Subrahmanian V.S., Principles of Multimedia Database Systems, Morgan Kaufmann
  9. Gray J., Reuter A., Transaction Processing: Concepts and Techniques, Morgan Kaufmann
  10. Connolly T., Begg C., Database solutions. A step-by-step guide to building databases, Addison-Wesley
  11. Theriault M., Henney W., Oracle security, O’Reilly
  12. Hipsley P., Developing client/server systems with Oracle developer /2000, SAMS
  13. Gennick J., Teach yourself Oracle PL/SQL in 21 days, SAMS Publishing
  14. Lulushi A., Developer/2000 forms. The practitioner’s guide, Prentice-Hall
  15. Billings C., BillingsM., Tower J., Rapid Application Development with Oracle designer / 2000, Addison-Wesley
  16. O’Neil B. (Ed.), Oracle data warehousing unleashed, SAMS
  17. Dorsey P., Hudicka J., Oracle design using UML & object modeling, Oracle Press
  18. AbramsonI., Abbey M., Corey M., Oracle Database 10g: A beginner’s guide, Oracle Press, McGraw-Hill
  19. Meloni J., Teach Yourself PHP, MySQL and Apache, SAMS
  20. Davies A., Fisk H., MySQL Clustering, MySQL Press
  21. Bell C.A., Expert MySQL, Apress

Internationalisation I18n