ΕΠ03 - Database Design and Distributed Databases

Information

Code : ΕΠ03

Type : Elective

Semester : 5

ECTS credits: 5

Course URL: https://eclass.hua.gr/courses/DIT128/

Expected 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.

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.

Evaluation Means

I. Written final exam 60% which includes:
-Multiple choice questions
-Problem solving
-Comparative evaluation of theory elements
II. Individual or Group Assignments 40%

Bibliοgraphy

- Fundamentals of Database Systems 5th Edition, R. Elmasri S.B. Navathe, Pearson Higher Education, 2007
- Database Management System, R. Ramakrishnan/ J. Gehrke.. McGraw Hill. 2007
- Database System Concepts Fifth Edition, A. Silberschatz, H.F. Korth, και S. Sudarshan. McGraw-Hill, 2005.

Journals
- ACM Transactions on Database Systems (TODS)
- IEEE Transactions on Knowledge and Data Engineering (TKDE)
- VLDB Journal (Very Large Data Bases Journal)
- Information Systems Journal
- Data and Knowledge Engineering
- Journal of Database Management (JDM)
- International Journal of Information Management (IJIM)
Conferences
- PVLDB Endowment
- ACM SIGMOD-SIGACT-SIGART Symposium on Principles of Database Systems
- International Conference on Database Theory
- International Conference on Database Systems for Advanced Applications
- Advances in Databases and Information Systems (ADBIS)
- Statistical and Scientific Database Management (SSDBM)