5809651: C19 Data Management (CPE)

Description

• Data Management covers the modern data-management cycle, from the collection of data from diverse sources to the preparation of data for data-driven applications. Students learn how to handle various data formats, how to assess and improve data quality, and how to store and process data using SQL, NoSQL, and Hadoop technologies. The course covers eight primary topics:Modern data-management requirementsDatabase system architectureDiagnosing and handling data quality problemsRelational databases (SQL)Hands-on labs with MySQLConcurrency control techniquesNoSQL databases (e.g., MongoDB)Apache Hadoop (HDFS, MapReduce)

Learning Outcomes

After successful completion of the course, students will

Professional competence

• understand the basic concepts of modern data management
• have gained insights in advanced concepts of modern data management

• be able to apply the data management stack from conceptual database design to data query and manipulation
• be able to collect and prepare data for data-driven applications

• be able to organise learning materials and work in groups
• be able to divide problems into meaningfully tasks, work on them and help each other within the group

• be able to apply the learned theoretical content to real-world scenarios
• have an increased capability of structural thinking

• be familiar with SQL, in particular with MariaDB/MySQL
• be familiar with MongoDB

Lectures Method

• The module involves interactive lectures with exercises to integrate theoretical knowledge with practical design and analysis skills.

Literature

• Elmasri, R., & Navathe, S.B. (2016). Fundamentals of Database Systems, 7th edition. New York: Pearson Education
• Harrison, G. (2015). Next Generation Databases – NoSQL, NewSQL, and Big Data. California: Apress Media