|Lecturer:||Dr. Lena Wiese|
|ECTS (SWS):||6 ECTS (4 SWS)||Date:||Lecture: Wed. 14-16 c.t. weekly|
Lecture: Thu. 14-15 c.t. weekly
Exercise: Thu. 15-16 s.t. weekly
|Audience||Applied Computer Science MSc|
Applied Computer Science BSc
The relational data model - where data are stored in tables and hence structured according to some fixed set of attributes (that is, table columns) - has been a success for several decades. Furthermore, SQL is a standardized and widely used query and management language for relational databases. A transformation of commonly occurring data into the relational table format is however not always convenient. On the contrary, storing arbitrary documents, objects in programming language, XML data and the like in relational databases imposes a huge overhead. Moreover, relational databases are geared towards frequent queries on a stable set of data with infrequent updates.
Novel requirements for database management systems lead to an emergence of several alternatives to relational systems, so that data can be stored in other structures with a flexible update and query behavior and distributed on multiple servers. Under the slogan NOSQL (in the sense of Not Only SQL) some systems have come up that concentrate on versatile use cases while diverging from the relational data model. This lecture surveys some of these NOSQL technologies that are employed in Cloud Computing or in social networks and hence will become gradually more significant. The course will cover graph databases, object databases, XML databases, key-value stores and column-family stores.
Active participation during the exercises is required.
Every participant has to register in the studIP system and be present at the oral examination.
Individual oral tests (in English or German)
Time slots: end of July 2015 and September 2015
15.04. 14:15 - 15:45 Topics: Introduction
16.04. 14:15 - 15:00 Topics: Relational databases, Weaknesses of RDBMSs
22.04. 14:15 - 15:45 Topics: Graph Databases
23.04. 14:15 - 15:00 Topics: Graph Databases
29.04. 14:15 - 15:45 Topics: XML Databases
30.04. 14:15 - 15:00 Topics: XML Databases
06.05. 14:15 - 15:00 Topics: XML Databases
07.05. 14:15 - 15:00 Topics: XML Databases
13.05. 14:15 - 15:45 Topics: Key-value Stores, Document Databases
20.05. 14:15 - 15:00 Topics: Map-Reduce, Exercise instructions
21.05. 14:15 - 15:45 Topics: Column Stores
03.06. 14:15 - 15:45 Topics: BigTable databases (aka column family databases, wide column stores, extensible record stores)