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
- Database design and functional dependencies
- Enhanced Entity Relationship model, Object-Relational Database model
- Oracle PL/SQL technology (triggers, stored procedures, cursors, etc.)
- Open source Database Management Products
- Transaction processing and Database Management Products
- Database Administration and Database Management Products
- Back up, database recovery
- Concurrency
- Query optimization
- Distributed databases
- Technological evolution of Databases – multimedia databases, web based database systems, database security, information and knowledge management, XML, OLAP, Data Warehouse, business intelligence
- Case Study
Literature
- Elmasri R., Navathe S.B., Θεμελιώδεις Αρχές Συστημάτων Βάσεων Δεδομένων, Τόμος Β’, (μετάφραση Μ. Χατζόπουλου), Εκδόσεις Δίαυλος
- Silberschatz A., Korth H.F., Sudarshan S., Συστήματα βάσεων δεδομένων – Η πλήρης θεωρία των βάσεων δεδομένων, (μετάφραση Μ. Γκλαβά), Εκδόσεις Γκιούρδα
- Ramakrishnan R., Gehrke J., Συστήματα διαχείρισης βάσεων δεδομένων, τόμος Β, (μετάφραση Δ. Δέρβου, Α. Ευαγγελίδη), Eκδόσεις Τζιόλα
- Ullman J.D., Widom J., A first course in database systems, Prentice-Hall
- Γ. Βασιλακόπουλος, Σχεδιασμός Βάσεων Δεδομένων
- Χ. Σκουρλάς, Υλοποίηση εφαρμογών με γλώσσα SQL – χρήση τεχνολογίας Oracle, Νέες Τεχνολογίες.
- Βασιλειάδης Π., Σελλής Τ., Αντικειμενοστρεφή συστήματα διαχείρισης βάσεων δεδομένων, Εκδόσεις Παπασωτηρίου
- Subrahmanian V.S., Principles of Multimedia Database Systems, Morgan Kaufmann
- Gray J., Reuter A., Transaction Processing: Concepts and Techniques, Morgan Kaufmann
- Connolly T., Begg C., Database solutions. A step-by-step guide to building databases, Addison-Wesley
- Theriault M., Henney W., Oracle security, O’Reilly
- Hipsley P., Developing client/server systems with Oracle developer /2000, SAMS
- Gennick J., Teach yourself Oracle PL/SQL in 21 days, SAMS Publishing
- Lulushi A., Developer/2000 forms. The practitioner’s guide, Prentice-Hall
- Billings C., BillingsM., Tower J., Rapid Application Development with Oracle designer / 2000, Addison-Wesley
- O’Neil B. (Ed.), Oracle data warehousing unleashed, SAMS
- Dorsey P., Hudicka J., Oracle design using UML & object modeling, Oracle Press
- AbramsonI., Abbey M., Corey M., Oracle Database 10g: A beginner’s guide, Oracle Press, McGraw-Hill
- Meloni J., Teach Yourself PHP, MySQL and Apache, SAMS
- Davies A., Fisk H., MySQL Clustering, MySQL Press
- Bell C.A., Expert MySQL, Apress
search
Announcements
No posts found.