ΕΠ03 - Database Design and Distributed Databases
School: Digital Technology
Department: Informatics and Telematics
Course Title: Database Design and Distributed Databases
Course id: ΕΠ03
Type: Core Course
Teaching and Examination Language: Greek
Is the course offered in Erasmus: Yes
Course web-page: https://eclass.hua.gr/courses/DIT128/
Lectures (Theory): 3,0
Lab lectures: 0,0
ECTS credits: 5,0
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.
- Independent work
- Team work
- Adaptation in new conditions
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 and Teaching Methods - Evaluation
Teaching methods: - Face-to-face (lectures
- Hands-on exercises
Use of ICT:
- Specific software for query execution optimization
- Specific software for database programming
- Dissemination and organization of course material using OpenClass
- Communication via OpenClass and emails
The course grade takes into account
- the final exam grade (60%), which comprises
- Multiple choice questions
- Problem solving
- Critical evaluation of theoretical knowledge
- two or three compulsory assignments (40%), which are group and/or individual.
- 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.
- VLDB Journal, ACM
- Transactions on Database Systems (TODS), ACM
- Transactions on Knowledge and Data Enginering (TKDE), ACM
- Data and Knowledge Engineering Journal (DKE), Elsevier.
- International Journal of Big Data Intelligence, Inderscience.
- ACM SIGMOD
- ACM VLDB
- IEEE ICDE
- ACM PODS