263-3845-00L  Data Management Systems

SemesterAutumn Semester 2021
LecturersG. Alonso
Periodicityyearly recurring course
Language of instructionEnglish



Courses

NumberTitleHoursLecturers
263-3845-00 VData Management Systems3 hrs
Wed10:15-12:00CAB G 61 »
Fri08:15-09:00HG G 3 »
G. Alonso
263-3845-00 UData Management Systems1 hrs
Fri09:15-10:00HG D 5.1 »
09:15-10:00HG E 21 »
09:15-10:00HG G 26.1 »
G. Alonso
263-3845-00 AData Management Systems3 hrsG. Alonso

Catalogue data

AbstractThe course will cover the implementation aspects of data management systems using relational database engines as a starting point to cover the basic concepts of efficient data processing and then expanding those concepts to modern implementations in data centers and the cloud.
ObjectiveThe goal of the course is to convey the fundamental aspects of efficient data management from a systems implementation perspective: storage, access, organization, indexing, consistency, concurrency, transactions, distribution, query compilation vs interpretation, data representations, etc. Using conventional relational engines as a starting point, the course will aim at providing an in depth coverage of the latest technologies used in data centers and the cloud to implement large scale data processing in various forms.
ContentThe course will first cover fundamental concepts in data management: storage, locality, query optimization, declarative interfaces, concurrency control and recovery, buffer managers, management of the memory hierarchy, presenting them in a system independent manner. The course will place an special emphasis on understating these basic principles as they are key to understanding what problems existing systems try to address. It will then proceed to explore their implementation in modern relational engines supporting SQL to then expand the range of systems used in the cloud: key value stores, geo-replication, query as a service, serverless, large scale analytics engines, etc.
LiteratureThe main source of information for the course will be articles and research papers describing the architecture of the systems discussed. The list of papers will be provided at the beginning of the course.
Prerequisites / NoticeThe course requires to have completed the Data Modeling and Data Bases course at the Bachelor level as it assumes knowledge of databases and SQL.
CompetenciesCompetencies
Subject-specific CompetenciesConcepts and Theoriesassessed
Techniques and Technologiesassessed

Performance assessment

Performance assessment information (valid until the course unit is held again)
Performance assessment as a semester course
ECTS credits8 credits
ExaminersG. Alonso
Typesession examination
Language of examinationEnglish
RepetitionThe performance assessment is offered every session. Repetition possible without re-enrolling for the course unit.
Mode of examinationwritten 180 minutes
Written aidsNo supporting materials will be allowed.
Online examinationThe examination may take place on the computer.
This information can be updated until the beginning of the semester; information on the examination timetable is binding.

Learning materials

 
Main linkInformation
Only public learning materials are listed.

Groups

No information on groups available.

Restrictions

There are no additional restrictions for the registration.

Offered in

ProgrammeSectionType
CAS in Computer ScienceFocus Courses and ElectivesWInformation
Cyber Security MasterCore CoursesWInformation
Data Science MasterData ManagementWInformation
Computer Science MasterCore Focus Courses General StudiesWInformation
Computer Science MasterFocus Core Courses Distributed SystemsWInformation
Computer Science MasterCore CoursesWInformation
Computer Science MasterMinor in Data ManagementWInformation
Computer Science MasterMinor in Systems SoftwareWInformation
Science, Technology, and Policy MasterData and Computer ScienceWInformation