Databases II

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

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

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