Universität Wien
Warning! The directory is not yet complete and will be amended until the beginning of the term.

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

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