Database Design and Distributed Databases

ΕΠ03 - Database Design and Distributed Databases

General Information

School: Digital Technology

Department: Informatics and Telematics

Level: Undergraduate

Course Title: Database Design and Distributed Databases

Course id: ΕΠ03

Type: Core Course 

Semester: 

Teaching and Examination Language: Greek

Is the course offered in Erasmus: Yes

Course web-page: https://eclass.hua.gr/courses/DIT128/

Activities

Lectures (Theory): 3,0

Lab lectures: 0,0

ECTS credits: 5,0

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.

General Skills

- Independent work
- Team work
- Adaptation in new conditions

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 and Teaching Methods - Evaluation

Teaching methods: - Face-to-face (lectures
 & lab)
- Hands-on exercises
- Assignments

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

Course Organization

 

Activity

Semester work load

Lectures

30,0

Lab exercises

9,0

Individual of group projects

20,0

Lab report preparation

20,0

Thesis 

  

Independent Study

46,0

Total

125

Assessment



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.

Literature



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

Conferences
- ACM SIGMOD
- ACM VLDB
- IEEE ICDE
- EDBT/ICDT
- ACM PODS