Universität Wien

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