DATABASE TECHNOLOGY

Course Information
TitleΤΕΧΝΟΛΟΓΙΑ ΒΑΣΕΩΝ ΔΕΔΟΜΕΝΩΝ / DATABASE TECHNOLOGY
CodeNIS-06-04
FacultySciences
SchoolInformatics
Cycle / Level1st / Undergraduate
Teaching PeriodSpring
CoordinatorApostolos Papadopoulos
CommonNo
StatusActive
Course ID40002957

Programme of Study: PPS-Tmīma Plīroforikīs (2019-sīmera)

Registered students: 12
OrientationAttendance TypeSemesterYearECTS
GENIKĪ KATEUTHYNSĪYPOCΗREŌTIKO KATA EPILOGĪ635
Class Information
Academic Year2017 – 2018
Class PeriodSpring
Faculty Instructors
Weekly Hours4
Class ID
600104751
Course Type 2016-2020
  • Scientific Area
  • Skills Development
Course Type 2011-2015
Specific Foundation / Core
Mode of Delivery
  • Face to face
Digital Course Content
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
ActivitiesWorkloadECTSIndividualTeamworkErasmus
Lectures52✓✓
Reading Assigment30✓✓
Project60✓✓
Written assigments8✓✓
Total150
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