Database Design and Distributed Databases
General
Code: ΕΠ03
Language: Greek
Delivery: Face-to-face
Prerequisites:
Workload
- Lectures: 39.0 hours
- Lab: 0.0 hours
- Study: 46.0 hours
- Project: 20.0 hours
Course Content
Introduction to Database Design. Criteria for the quality of DB design. Functional Dependencies. Schema Normalization. Physical design. Storage and Indexing Structures. Query Processing and optimization. Transaction Processing, time-scheduling and serialization. Concurrency Control. Database recovery techniques. Distributed Databases and Databases on the Web. Object-oriented and Object-relational databases. Semi-structured data. Data warehouses and data mining.
Learning Outcomes
The course aims to familiarize students with issues concerning the operation of databases and their efficient design. Such issues comprise: data redundancy, data integrity, query processing, security, recovery and concurrency control of transactions.
At the same time the objective is to improve the students skills in programming languages for databases and teach them the basic concepts of data management and information mining from databases.
At the end of the course the students must be able to:
- Know the basic principles of database systems, the design process of a database.
- Engage in the collaborative design of a database that optimizes query execution
- Activate and manipulate the appropriate access control mechanisms, transaction management etc.
Skills
- Independent work
- Team work
- Adaptation in new conditions