269013 VO Databases and Processing of Large Data Sets (2017S)

3.00 ECTS (2.00 SWS), SPL 26 - Physik

URL http://vda.univie.ac.at/Teaching/Large/17s/

Details

Language: German, English

Examination dates

Wednesday 05.07.2017 Wednesday 19.07.2017 Friday 24.11.2017

Lecturers

Classes (iCal) - next class is marked with N

Achtung! abweichende Termine und Räume:

1. Juni 2017: 9.45-11.15, Sensengasse 6, Raum 2.09

20. Juni 2017: 15.00-16.30, Sensengasse 6, Raum 2.09

    
    Tuesday
    07.03.
    11:30 - 13:30
    Seminarraum 11, Währinger Straße 29 2.OG
    
    Tuesday
    14.03.
    11:30 - 13:30
    Seminarraum 11, Währinger Straße 29 2.OG
    
    Tuesday
    21.03.
    11:30 - 13:30
    Seminarraum 11, Währinger Straße 29 2.OG
    
    Tuesday
    28.03.
    11:30 - 13:30
    Seminarraum 11, Währinger Straße 29 2.OG
    
    Tuesday
    04.04.
    11:30 - 13:30
    Seminarraum 11, Währinger Straße 29 2.OG
    
    Tuesday
    25.04.
    11:30 - 13:30
    Seminarraum 11, Währinger Straße 29 2.OG
    
    Tuesday
    02.05.
    11:30 - 13:30
    Seminarraum 11, Währinger Straße 29 2.OG
    
    Thursday
    11.05.
    11:30 - 13:00
    Seminarraum 9, Währinger Straße 29 2.OG
    
    Thursday
    18.05.
    11:30 - 13:00
    Seminarraum 11, Währinger Straße 29 2.OG
    
    Thursday
    01.06.
    11:30 - 13:00
    Seminarraum 11, Währinger Straße 29 2.OG
    
    Tuesday
    20.06.
    11:30 - 13:30
    Seminarraum 11, Währinger Straße 29 2.OG
    
    Thursday
    29.06.
    11:30 - 13:00
    Seminarraum 11, Währinger Straße 29 2.OG

Information

Aims, contents and method of the course

Part Databases
- Introduction to Modelling and ER-Diagrams
- Fundamentals of database management systems (DBMS)
- Relational Model and Algebra
- Query Language SQL
- Conceptual Modelling and DB Programming
- Concepts of heterogeneous, distributed data management and NoSQL DBMS

Visualization:
- Visual design principles and the visualization pipeline
- Data acquisition and representation
- Basic visual mapping concepts
- Human visual perception + Color
- Visual mappings and algorithms for 2D+3D scalar, vector, and tensor fields
- Visual mappings for graphs and trees and high-dimensional data
- Data interaction principles: Focus+Context; Navigation+Zoom
- Design principles for Space+Time as well as Depth/Occlusion

Assessment and permitted materials

Oral exam

Minimum requirements and assessment criteria

Students learn to
- understand the fundamentals of DBMS.
- design and query databases.
- use DBMS from applications and programs.
- know about the theoretical foundations of relational DBMS.
- understand the methods of distributed data management.
- represent and interact with various data visually
- evaluate visual depictions of data and possible find improved presentations
- assist users in visual data analysis
- use different visual analysis tools
- use Tableau / D3 to analyse data

Examination topics

Course lectures

Reading list

Teil Databases:
- A. Kemper, A. Eickler. Datenbanksysteme, 7. Auflage, Oldenbourg Verlag, 2009
- R. Elmasri, S.B. Navathe. Grundlagen von Datenbanksystemen, 3. aktualisierte Auflage, Pearson Studium, Addision Wesley, 2009
- Heuer, G. Saake. Datenbanken, Konzepte und Sprachen, 4. Auflage, mitp-Verlag, Oktober 2010
Teil Visualisierung:
- T. Munzner: Visualization Analysis & Design: Abstractions, Principles, and Methods, CRC Press, 2014

Association in the course directory

CO-INF2

Last modified: Sa 08.07.2023 00:21