Kursusbasen

Kursusoversigt

Kursusbeskrivelse

Kursusnavn (dansk):	Data Management
Kursusnavn (engelsk):	Data Management
Semester:	Efterår 2018
Udbydes under:	Bachelor i datavidenskab (b-ds)
Omfang i ECTS:	7,50
Kursussprog:	Engelsk
Kursushjemmeside:	https://learnit.itu.dk
Min. antal deltagere:	40
Forventet antal deltagere:	0
Maks. antal deltagere:	60
Formelle forudsætninger:	The course is only open to BSc DS third semester. The course assumes that the students have some prior knowledge on data structures (e.g., took an Algorithms and Data Structures course). Moreover the student must always meet the admission requirements of the IT University.
Læringsmål:	After the course the students should be able to: 1) Select an appropriate data management system (or set of systems), access methods, and data layout given a data science use case. 2) Describe the pros and cons of different (classes of) data management systems for modern analytics and data science. 3) Reflect upon the landscape of data management applications/workloads and their impact on data management system design. 4) Reflect upon the evolution of the hardware and storage hierarchy and its impact on data management system design. 5) Explain the internals of a traditional database system. 6) Query and modify data using SQL. 7) Design a database using the relational model and normal form theory.
Fagligt indhold:	Today, a large variety of data management systems are available to help us store, modify, and analyze data. None of these systems, however, are the best for every type of application and data processing. Knowing the foundations of database systems is therefore crucial to understand how we traditionally reason about data and data management, and how and why that reasoning has changed over time. This course gives an introduction to the evolution of the data management landscape during the past 4-5 decades, with particular emphasis on relational databases and recent hardware trends. More specifically, the topics that will be covered are • The role of data management systems in modern analytics, brief history of relational databases • E-R model, relational model, schema design, normal forms, SQL • Trends in hardware and storage • Database internals and data layouts • Access methods / indexes • Query operators, optimization, and compilation • Transactions, concurrency control, and recovery • Case studies and examples from today’s data management landscape: main-memory databases, key-value stores, parallel and distributed databases, streaming, etc.
Læringsaktiviteter:	12 forelæsninger og 12 øvelsesgange There will be 2 hour lectures a week covering the topics above, and 2 hour exercises a week covering SQL examples and activities that would guide students in their assignments and exam. Students will work on assignments throughout the semester. More details regarding the assignments will be posted on LearnIT.
Obligatoriske aktivititer:	None
Eksamensform og -beskrivelse:	D22: Aflevering med mundtlig eksamen suppleret af aflevering., (7-scale, external exam) The assignments described under learning activities as a whole will be the hand-in for the final exam. Duration of oral exam: 20 Minutes