Datenbanksysteme

Datenbanksysteme

Dozent

Prof. Dr. Marc H. Scholl

Dr. Svetlana Mansmann
Barbara Pampel
Andreas Weiler

Termine (Vorlesung)

Inhalt

Die Veranstaltung vermittelt einen grundlegenden Überblick über Funktionalität, Architektur und Realisierungskonzepte von Datenbanksystemen als Grundlage für computergestützte Informationssysteme. Charakteristisch für Datenbanksysteme ist, dass Informationen gemäß irgendeinem Modell dargestellt, gespeichert und aufbewahrt werden, die mittels Operationen einer geeigneten Sprache abgefragt (wiedergewonnen) und manipuliert werden können.

Weitere Details zum Inhalt auf der Webseite zur Vorlesung.

RSS-Feed

RSS-Feed abonnieren

Episoden

2012/04/16 (Mo) - About the course, What is a Database?, Powerful Abstractions

2012/04/17 (Di) - Powerful Abstractions, DBMSs: Database Systems

2012/04/23 (Mo) - Brief DB History, Sets and Predicates, Relations and Graphs

2012/04/24 (Di) - Information Modelling, Relational Model & SQL, Relational Tables, Simple Constraints

2012/04/30 (Mo) - Tables: Better or worse?, Historical Remarks, The Entity-Relationship Model

2012/05/01 (Di) - Feiertag (Tag der Arbeit)

2012/05/07 (Mo) - Basic ER Constructs, Kinds of Relationships, Keys & Weak Entities, N-Ary Relationships

2012/05/08 (Di) - Translation into the Relational Model, Extended ER Models, Beyond E/R and Relational Modeling, The UML Language

2012/05/14 (Mo) - Post Relational Database Models, Data Modeling, Relational Normal Forms, Functional Dependencies

2012/05/15 (Di) - Functional Dependencies, Anomalies, FD-based Normal Forms

2012/05/21 (Mo) - Anomalies, FD-based Normal Forms, Multi-Valued Dependencies (MVDs) and 4NF

2012/05/22 (Di) - Multi-Valued Dependencies and 4NF, Normal Forms and ER Design, Denormalization

2012/05/28 (Mo) - Feiertag

2012/05/29 (Di) - Database Query Languages, Relational Algebra

2012/06/04 (Mo) - Relational Algebra - The Five Basic Operations, Composite Expressions, Derived Operations

2012/06/05 (Di) - Relational Algebra - Derived Operations, Formalities, Algebraic Equivalencies

2012/06/11 (Mo) - Relational Calculus, SQL Query Syntax

2012/06/12 (Di) - SQL Queries

2012/06/18 (Mo) -  Advanced SQL Query Syntax

2012/06/19 (Di) - OLAP Queries in SQL, SQL: More Than Queries, SQL Data Definitions, Data Manipulation in SQL

2012/06/25 (Mo) - Data Manipulation: Updating Database Contents, Integrity Constraint Checking, Views & View Updates

2012/06/26 (Di) - Views & View Updates,  Access Control, Transaction Processing, Simplified Transaction Model, Currency Controles 

2012/07/02 (Mo) - Currency Control: Serializability, Currency Control Protocols: Locking

2012/07/03 (Di) - Currency Control Protocols: Locking, Transaction in SQL, Recovery

2012/07/09 (Mo) - Currency Control Protocols: Locking, Transaction in SQL, Recovery (2)

2012/07/10 (Di) - Storing Data: Disks and Files

2012/07/16 (Mo) - Disks and Files: Indexes & Overview of Query Processing & Optimization