621.511 (23S) Database technology

Sommersemester 2023

Registration deadline has expired.

First course session
09.03.2023 12:00 - 14:00 S.2.69 - Bitmovin On Campus
... no further dates known

Overview

Lecturer
Course title german Datenbanktechnologie
Type Practical class (continuous assessment course )
Course model Attendance-based course
Hours per Week 2.0
ECTS credits 4.0
Registrations 19 (20 max.)
Organisational unit
Language of instruction English
Course begins on 09.03.2023
eLearning Go to Moodle course

Time and place

List of events is loading...

Course Information

Intended learning outcomes

Students 

  • understand and know advanced database technologies
  • are able to use advance database technologies for the development of information systems and other applications
  • are able to design, operate and maintain large database systems.

Teaching methodology

Lectures with student presentations and associated lab exercises, and group discussions. Active participation is required.

Course content

This course complements course 621.510 taking a practical perspective.

Topics include:                

  • Advanced logical and physical Database design
  • Database evolution and support of agile software development
  • Databases on new hardware
  • Tuning of Database systems
  • Data mining essentials
  • OLAP in Data warehouses
  • Temporal databases
  • Information retrieval and Search engines, PageRank

Prior knowledge expected

A first course in Databases, in particular:

  • Entity-Relationship model and UML class diagrams
  • Relational model
  • Normalization
  • Indexes
  • SQL and Database programming
  • XML, XML-Schema, XQuery
  • Basic transaction models


Examination information

Im Fall von online durchgeführten Prüfungen sind die Standards zu beachten, die die technischen Geräte der Studierenden erfüllen müssen, um an diesen Prüfungen teilnehmen zu können.

Examination methodology

Written exam with closed books.

Examination topic(s)

All course topics.

Assessment criteria / Standards of assessment for examinations

Written exam with closed books.

Grading scheme

Grade / Grade grading scheme

Position in the curriculum

  • Teacher training programme Computer Sciences and Computer Sciences Management (Secondary School Teacher Accreditation) (SKZ: 884, Version: 04W.7)
    • Stage two
      • Subject: Angewandte Informatik (LI 2.3) (Compulsory subject)
        • Datenbanktechnologie ( 2.0h PR / 4.0 ECTS)
          • 621.511 Database technology (2.0h UE / 4.0 ECTS)
  • Bachelor's degree programme Applied Informatics (SKZ: 511, Version: 19W.2)
    • Subject: Vertiefung Informatik (Compulsory elective)
      • 7.2 Datenbanktechnologie ( 2.0h UE / 4.0 ECTS)
        • 621.511 Database technology (2.0h UE / 4.0 ECTS)
          Absolvierung im 4., 5., 6. Semester empfohlen
  • Bachelor's degree programme Applied Informatics (SKZ: 511, Version: 17W.1)
    • Subject: Natural Language Processing (Compulsory elective)
      • 5.1 Datenbanktechnologie ( 2.0h UE / 4.0 ECTS)
        • 621.511 Database technology (2.0h UE / 4.0 ECTS)
  • Bachelor's degree programme Applied Informatics (SKZ: 511, Version: 17W.1)
    • Subject: Software Development (Compulsory elective)
      • 6.1 Datenbanktechnologie ( 2.0h UE / 4.0 ECTS)
        • 621.511 Database technology (2.0h UE / 4.0 ECTS)
  • Bachelor's degree programme Applied Informatics (SKZ: 511, Version: 17W.1)
    • Subject: Business Informatics (Compulsory elective)
      • 7.1 Datenbanktechnologie ( 2.0h UE / 4.0 ECTS)
        • 621.511 Database technology (2.0h UE / 4.0 ECTS)
  • Bachelor's degree programme Applied Informatics (SKZ: 511, Version: 12W.1)
    • Subject: Natural Language Processing (Compulsory elective)
      • Datenbanktechnologie ( 2.0h UE / 4.0 ECTS)
        • 621.511 Database technology (2.0h UE / 4.0 ECTS)
  • Bachelor's degree programme Applied Informatics (SKZ: 511, Version: 12W.1)
    • Subject: Software Development (Compulsory elective)
      • Datenbanktechnologie ( 2.0h UE / 4.0 ECTS)
        • 621.511 Database technology (2.0h UE / 4.0 ECTS)
  • Bachelor's degree programme Applied Informatics (SKZ: 511, Version: 12W.1)
    • Subject: Business Informatics (Compulsory elective)
      • Datenbanktechnologie ( 2.0h UE / 4.0 ECTS)
        • 621.511 Database technology (2.0h UE / 4.0 ECTS)
  • Master's degree programme Applied Informatics (SKZ: 911, Version: 13W.1)
    • Subject: Vertiefung Informatik (Compulsory subject)
      • Datenbanktechnologie ( 2.0h UE / 4.0 ECTS)
        • 621.511 Database technology (2.0h UE / 4.0 ECTS)
  • Bachelor's degree programme Management Information Systems (SKZ: 522, Version: 20W.2)
    • Subject: Spezialisierung Angewandte Informatik (Compulsory elective)
      • 9.2 Datenbanktechnologie ( 0.0h UE / 4.0 ECTS)
        • 621.511 Database technology (2.0h UE / 4.0 ECTS)
          Absolvierung im 5. Semester empfohlen
  • Bachelor's degree programme Management Information Systems (SKZ: 522, Version: 20W.2)
    • Subject: Vertiefung Angewandte Informatik (Compulsory elective)
      • 11.7 Vertiefung Angewandte Informatik ( 0.0h VO, VC, UE / 8.0 ECTS)
        • 621.511 Database technology (2.0h UE / 4.0 ECTS)
          Absolvierung im 5., 6. Semester empfohlen
  • Master's degree programme Information Management (SKZ: 922, Version: 13W.2)
    • Subject: Informatik (Compulsory subject)
      • 1.2 Datenbanktechnologie ( 2.0h KS / 4.0 ECTS)
        • 621.511 Database technology (2.0h UE / 4.0 ECTS)
  • Masterstudium Mathematics (SKZ: 401, Version: 18W.1)
    • Subject: Informatics (Compulsory elective)
      • 8.8 Datenbanktechnologien ( 2.0h UE / 4.0 ECTS)
        • 621.511 Database technology (2.0h UE / 4.0 ECTS)

Equivalent courses for counting the examination attempts

Sommersemester 2024
  • 621.511 UE Datenbanktechnologie (2.0h / 4.0ECTS)
  • 621.512 UE Datenbanktechnologie (2.0h / 4.0ECTS)
Sommersemester 2022
  • 621.511 UE Datenbanktechnologie (2.0h / 4.0ECTS)
  • 621.512 UE Datenbanktechnologie (2.0h / 4.0ECTS)
Sommersemester 2021
  • 621.511 UE Datenbanktechnologie (2.0h / 4.0ECTS)
  • 621.512 UE Datenbanktechnologie (2.0h / 4.0ECTS)
Sommersemester 2020
  • 621.511 UE Datenbanktechnologie (2.0h / 4.0ECTS)
Sommersemester 2019
  • 621.511 UE Datenbanktechnologie (2.0h / 4.0ECTS)
  • 621.512 UE Datenbanktechnologie (2.0h / 4.0ECTS)
Sommersemester 2018
  • 621.511 UE Datenbanktechnologie (2.0h / 4.0ECTS)
  • 621.512 UE Datenbanktechnologie (2.0h / 4.0ECTS)
Sommersemester 2017
  • 621.511 UE Datenbanktechnologie (2.0h / 4.0ECTS)
  • 621.512 UE Datenbanktechnologie (2.0h / 4.0ECTS)
Sommersemester 2016
  • 621.511 UE Datenbanktechnologie (2.0h / 4.0ECTS)
  • 621.512 UE Datenbanktechnologie (2.0h / 4.0ECTS)
Sommersemester 2015
  • 621.511 UE Datenbanktechnologie (2.0h / 4.0ECTS)
  • 621.512 UE Datenbanktechnologie (2.0h / 4.0ECTS)
Sommersemester 2014
  • 621.511 UE Datenbanktechnologie (2.0h / 4.0ECTS)
  • 621.512 UE Datenbanktechnologie (2.0h / 4.0ECTS)
Sommersemester 2013
  • 621.511 PR Datenbanktechnologie (2.0h / 4.0ECTS)
  • 621.512 PR Datenbanktechnologie (2.0h / 4.0ECTS)
Sommersemester 2012
  • 621.511 PR Datenbanktechnologie (2.0h / 4.0ECTS)
  • 621.512 PR Datenbanktechnologie (2.0h / 4.0ECTS)
Sommersemester 2011
  • 621.511 PR Datenbanktechnologie (2.0h / 4.0ECTS)
  • 621.512 PR Datenbanktechnologie (2.0h / 4.0ECTS)
Sommersemester 2010
  • 621.511 PR Datenbanktechnologie (2.0h / 4.0ECTS)
  • 621.512 PR Datenbanktechnologie (2.0h / 4.0ECTS)
Sommersemester 2009
  • 621.511 PR Datenbanktechnologie (2.0h / 4.0ECTS)
  • 621.512 PR Datenbanktechnologie (2.0h / 4.0ECTS)
  • 621.513 PR Datenbanktechnologie (2.0h / 4.0ECTS)