Database Design and Implementation

Design and implement data models for different database types (SQL, NoSQL)

Data science applications usually require a lot of data. In general, this data is stored in databases so that it can later be efficiently searched according to certain search criteria. The efficiency of the queries plays a central role. Database design and implementation shows the way from the problem (or file) to the database and how it can be implemented efficiently. Through database design and implementation students become database developer respectively a data engineer.

Selection procedure and criteria: Based on a problem, students can create selection criteria for a relational or non-relational database system, weigh them against each other and select a suitable database. Thus, they know the typical application areas of relational and non-relational databases. They understand which database model (among others relational, key-value, document/JSON, column-store and graph databases) is suitable for which type of data. Furthermore, they know the advantages and disadvantages of the different consistency models (e.g. ACID vs. BASE) and their implications.

Relational databases (SQL): Students can define a relational data model from a problem and implement it in a relational database. They can add data, change data and delete entries in this database. They can create indexes. They can export and re-import data. They know how the data model can be adapted and deleted depending on the requirement.

Non-relational databases (NoSQL): Students can define a non-relational data model from a problem and create it in a non-relational database. They can add data, modify data and delete entries in this database. They can export and re-import data. They know how the data model can be adapted and deleted depending on the requirement.

Distributed databases: Students have a basic understanding of the concept of distributed databases, specifically data distribution, data replication, resiliency, and time to live (TTL).