| Title | ΤΕΧΝΟΛΟΓΙΑ ΒΑΣΕΩΝ ΔΕΔΟΜΕΝΩΝ / DATABASE TECHNOLOGY |
| Code | NIS-06-04 |
| Faculty | Sciences |
| School | Informatics |
| Cycle / Level | 1st / Undergraduate, 2nd / Postgraduate |
| Teaching Period | Spring |
| Coordinator | Anastasios Gounaris |
| Common | No |
| Status | Active |
| Course ID | 40002957 |
Programme of Study: PPS-Tmīma Plīroforikīs (2019-sīmera)
Registered students: 12
| Orientation | Attendance Type | Semester | Year | ECTS |
|---|---|---|---|---|
| GENIKĪ KATEUTHYNSĪ | YPOCΗREŌTIKO KATA EPILOGĪ | 6 | 3 | 5 |
| Academic Year | 2017 – 2018 |
| Class Period | Spring |
| Faculty Instructors |
|
| Weekly Hours | 4 |
| Class ID | 600104751
|
Class Schedule
| Building | Βιολογίας |
| Floor | Ισόγειο |
| Hall | ΑΙΘΟΥΣΑ Α (211) |
| Calendar | Δευτέρα 16:00 έως 18:00 |
| Building | Βιολογίας |
| Floor | Ισόγειο |
| Hall | ΑΙΘΟΥΣΑ Β (210) |
| Calendar | Τετάρτη 16:00 έως 18:00 |
Course Type 2016-2020
- Scientific Area
- Skills Development
Course Type 2011-2015
Specific Foundation / Core
Mode of Delivery
- Face to face
Digital Course Content
- e-Study Guide https://qa.auth.gr/en/class/1/600104751
- At the Website of the School: http://delab.csd.auth.gr/courses/c_dbt/index.html
Erasmus
The course is also offered to exchange programme students.
Language of Instruction
- Greek (Instruction, Examination)
Learning Outcomes
Knowledge: Training on implementation and advanced database technology topics. Acquisition of practical and theoretical knowledge of database implementation techniques and of advanced database topics.
Skills: Application of advanced data management techniques in modern problems, implementation of efficient data management techniques and experimental evaluation.
General Competences
- Apply knowledge in practice
- Retrieve, analyse and synthesise data and information, with the use of necessary technologies
- Adapt to new situations
- Make decisions
- Work autonomously
- Work in teams
- Design and manage projects
- Advance free, creative and causative thinking
Course Content (Syllabus)
Review of relational database systems. Physical issues in DBMSs. Storage media. File organization and indexing schemes. Tree-structured indexes (B-trees, B+-trees, B*-trees). Hashing techniques (dynamic, extendible, exponential, linear). External sorting. Buffer management. Review of relational operators. Query processing and optimization. Transaction management and concurrency control. Recovery techniques. Security issues. Object-oriented and object-relational systems. Semi-structured data. Parallel and distributed DBMSs. Advanced topics.
Keywords
databases, indices, query optimization, query processing, parallel data processing
Educational Material Types
- Slide presentations
- Book
Use of Information and Communication Technologies
Use of ICT
- Use of ICT in Course Teaching
- Use of ICT in Laboratory Teaching
- Use of ICT in Communication with Students
Course Organization
| Activities | Workload | ECTS | Individual | Teamwork | Erasmus |
|---|---|---|---|---|---|
| Lectures | 52 | ✓ | ✓ | ||
| Reading Assigment | 30 | ✓ | ✓ | ||
| Project | 60 | ✓ | ✓ | ||
| Written assigments | 8 | ✓ | ✓ | ||
| Total | 150 |
Student Assessment
Description
Written exams (total weight 40%), project (60%)
Student Assessment methods
- Written Exam with Short Answer Questions (Formative, Summative)
- Oral Exams (Formative, Summative)
- Written Exam with Problem Solving (Formative, Summative)
- Report (Formative, Summative)
- Labortatory Assignment (Formative, Summative)
- written examination (Formative, Summative)
Bibliography
Course Bibliography (Eudoxus)
H. Garcia-Molina, J.D. Ullman, J.D. Widom ΣΥΣΤΗΜΑΤΑ ΒΑΣΕΩΝ ΔΕΔΟΜΕΝΩΝ
Additional bibliography for study
- Βάσεις Δεδομένων: Θεωρία και Πρακτική Εφαρμογή"
- R. Ramakrishnan, J. Gehrke, "Database Management Systems", McGraw-Hill, 2002.
- C.J. Date, Introduction to Database Systems, Addison Wesley, 2003.
- R. Elmasri, S.B. Navathe, "Fundamentals of Database Systems,", Addison Wesley, 2006.
- A. Silberschatz, H.F. Korth, S. Sudarshan, "Database System Concepts", McGraw-Hill, 2005.
Last Update
03-12-2020