4208151: C15 Data Management

back to overview
Semester:WS 16/17
Type:Module
Language:English
ECTS-Credits:6.0
Scheduled in semester:3
Semester Hours per Week / Contact Hours:52.0 L / 39.0 h
Self-directed study time:141.0 h

Module coordination/Lecturers

Curricula

Master's degree programme in Information Systems (01.09.2015)

Description

Short description
The course covers the complete modern data management cycle, with a focus on collecting data from diverse sources and preparing it to enable data-driven applications. Students will learn how to handle various data formats, assess and eventually improve data quality, and store as well as process data using SQL, NoSQL, and Hadoop technologies. The course will also look into the basics of mining (big) data sets.

Topics

  • Modern data management requirements
  • Database system architecture
  • Diagnosing and handling data quality problems
  • Relational databases (SQL)
  • Hands-on labs with MySQL
  • Concurrency control techniques
  • NoSQL databases (e.g., MongoDB)
  • Apache Hadoop (HDFS, MapReduce)

Learning objectives
  • Students will acquire and understand foundational concepts and methods of modern data management
  • Students will collect and prepare data in order enable data-driven applications
  • Students will select and apply appropriate technologies for building data-driven applications

Methods
  • The module integrates theoretical knowledge and practical skills in an interactive lecture.
  • The e-learning platform Moodle will be used throughout the course for the dissemination of course material and discussions.

Recommended previous knowledge
  • Module “Process and Data Management”

Compulsory reading
  • 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

Qualifications