direkt zum Inhalt springen

direkt zum Hauptnavigationsmenü

Sie sind hier

TU Berlin

Inhalt des Dokuments

Lupe

DIMA Courses / Modules

DIMA offers courses for various Bachelor's study programs, e.g.  Computer Science (Informatik), Business Informatics (Wirtschaftsinformatik), Computer Engineering (Techn. Informatik), or Industrial Engineering (Wirtschaftsingenieurwesen).

Our graduate courses provide an ideal foundation for software engineering oriented students. They enable to understand the background and theory of database systems and information management, and, finally, to design and implement database applications and complex information management solutions.

You find the detailed, current descrictions of our courses in the MOSES Moduldatenbank, as well as the course lists (Modullisten)  of your study programme with mandatory modules, mandatory electives and optional modules.

Here you find a short description of our modules of Bachelor offers with focus on Database Systems and Information Management.

Basic Bachelor Course

ISDA

Information Systems & Data Analysis

VL+UE, 6 ECTS, 2 SWS
Course Language: German

Upon completion of this course, students will have: (i) mastered basic concepts in information management and relational database management systems (RDBMS), (ii) learned how to develop information models, and (iii) grasped how to formulate queries in relational algebra and express these in SQL. They will be able to describe a data warehouse, compare it to transaction systems, and decide which requirements are essential for a given application profile. Furthermore, they will learn about data analytics using classification & clustering algorithms and apply them to a database using SQL and Java

MOSES Course Description (SS 2017)

Lab Courses & Seminars

DBPRA

Datenbankpraktikum

PRA, 6 ECTS, 4 SWS
Course Language: German

Goal of this module is the practical application of the theoretical content of the database lecture "Information Systems and Data Analytics". The practical applications include use of SQL as data definition, data manipulation, and authorization language, and the embedding of SQL into another programming language. Furthermore, the process architecture of database systems and the basics of database administration (e.g. building indexes or materialized views, analysis of query plans and query optimization based on statistics) are taught. For the lab work, a commercial object-relational database system is used. As programming language we use Java and JDBC to communicate with the database system.

MOSES Course Description (SS 2017)

DBSEM

Datenbankseminar - Foundations of Database Systems

SEM, 3 ECTS, 2 SWS
Course Language: English

During the initial phase of this class, students will hear presentations on how to read scientific papers, how to give a good presentation, and how to write high-quality scientific/technical reports. Additionally, all participants will receive one or more top-ranked scientific articles, from the literature in the classical database area. E.g. paper from the Red Book, the Great Papers in Computer Science, VLDB 10-Year Best Paper Awards, or SIGMOD Test of Time Awards. Task of the students is to study the literature deeply, to structure own presentations, and to reflect the main challenges addressed in the presentations and in a written summary. The contributions of the other students shall be critically reflected by the audience - like own contribution.

MOSES Course Description (SS 2017)

DBPRO

Database Project

PJ, 6 ECTS, 4 SWS
Course Language: German, English

At the beginning of the course you will receive a project task description from which you first create an overall system specification. Then, you design, specify (detailed), and finally implement the components of the system. Finally, you integrate and test the system and present your work as part of a system demonstration. The technologies used depend on the project. Usually, Java, relational and NoSQL database systems, indexing, and visualization software are used. For the implementation of the project you are advised to use computerized tools for effective management and implementation of the project, particularly for efficient co-operation, source code management, automated testing and generation of documentation. At the end of the project, the approach, results and tests have to be documented in form of a project report. The project will be completed by the system demonstration and an oral exam.

MOSES Course Description (SS 2017)

Advanced Bachelor Courses

INFMOD II

Advanced Information Modelling

IV, 6 ECTS, 4 SWS
Course Language: English

This module offers an advanced course in “Information Modeling” and “Modeling Methodology”. Participants will achieve detailed competences in modeling as well classical databases and information systems as well as highly heterogeneous distributed information systems. They will be enabled to integrate static (structure) and dynamic (processes and behavior) modeling approaches for these classes of information systems. The competence of critically choosing (or even developing) an appropriate set of modeling techniques and the modeling methodology for complex information modeling tasks by understanding the foundations of modeling languages (semantics and metamodelling approaches) is the main qualification objective. Participants are enabled to use and modify advanced modeling constructs, applying (meta-)modeling methodology to model-based integration of software and data components

MOSES Course Description (SS 2017)

DW

Data Warehousing and Business Intelligence

IV, 6 ECTS, 4 SWS
Course Language: English

Data Warehouses (DWH) store big amounts of data in databases designed with a focus in data analysis. Business Intelligence is the process of extracting information from DWH with the purpose of enabling decision support. The lecture introduce these topics with an emphasis in data analysis. In particular DWH architectures and components, differences between "normal" databases and DWH, integration of data in a DWH, the multidimensional data model as well as selected methods for analysis in relational DWH. The previous topics will be put in practice with the help of relational database management system (DBMS) (for example IBM DB2 or Business Objects XI 3.0).

The comprehensive thematic of this course is organized in three blocks. In the first block the development and management methods for DWH in relational databases are presented (architectures, ETL-process, OLAP operations, Bitmap-index). In the second block complex topics in relation to data analysis and exploration are examined in more detail (multidimensional data model, logic modeling, view materialization, etc.). In the last block, current research questions (Cloud, TextAnalytics) and practical experience (invited expert in the field) are addressed

MOSES Course Description (SS 2017)

Bachelor's Thesis Opportunities

DIMA thesis opportunities provide students with challenging research problems and enable them to collaborate with national and international research partners. DIMA regularly offers numerous Bachelor‘s thesis opportunities, often tied to ongoing research projects from various fields.

More informations here.

 

 

Zusatzinformationen / Extras

Quick Access:

Schnellnavigation zur Seite über Nummerneingabe

Auxiliary Functions

Student Advisory Service

Dr. Ralf Kutsche
consultation-hour:
Tuesday 12 - 13
(by appointment)
Phone: +49 30 31423555