Databases II

Databases II

Code:
Semester:
Type:
Direction:

P1-4010
4th
Compulsory

Course hours:
Instructors:

Links:

3 Lec – 1 Lab
Christos Skourlas (Faculty), Nikitas Karanikolas (Faculty)

Description

Enhanced Entity Relationship model, Object-Relational Database model. Embedded SQL and JDBC API in database Applications. 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 and Parallel databases. Technological evolution of Databases, object-relational databases, multimedia databases, Active databases, Web based database systems, database security, information and knowledge management, XML, OLAP, Data Warehouse, business intelligence. NoSQL, MongoDB. Case Study.