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: Undergradute Studies - School of Informatics (2015-today)

Registered students: 72
OrientationAttendance TypeSemesterYearECTS
Information SystemsElected Compulsory Directional635
Digital MediaElective Courses635
Communication, Networks And Systems ArchitectureElective Courses635
Information And Communication Technologies In EducationElective Courses635
General Common DirectionElective Courses635

Class Information
Academic Year2015 – 2016
Class PeriodSpring
Faculty Instructors
Weekly Hours4
Class ID
600004995
Type of the Course
  • Scientific Area
  • Skills Development
Course Category
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
Training on implementation and advanced database technology topics. Acquisition of practical and theoretical knowledge of database implementation techniques and of advanced database topics.
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
Lectures521.7
Reading Assigment301
Project602
Written assigments80.3
Total1505
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
08-06-2016