Apr 8, 2020   2:55 p.m. Albert
Academic information system

Course syllabus PDT_I - Advanced Database Technologies (FIIT - WS 2019/2020)


     Information sheet          ECTS          Syllabus          


     Slovak          English          


University: Slovak University of Technology in Bratislava
Faculty: Faculty of Informatics and Information Technologies
Course unit title: Advanced Database Technologies
Course unit code: PDT_I
Mode of completion and Number of ECTS credits: Exam (6 credits)
 
Name of lecturer: Ing. Tomáš Kramár, PhD. (lecturer, person responsible for course) - slovak
Samuel Pecár (instructor) - slovak
Ing. Miroslav Rác (instructor) - slovak
 
Learning outcomes of the course unit:
Student understands principles of SQL query processing in a relational database, understands how the query planner turns SQL query into a query plan and understands individual query plan steps, their limitations and trade-offs. Student understands indexing, various index types, and can select appropriate index for a particular situation. Student can use advanced features of relational databases: geographical data processing, XML and JSON data types and can write a complex recursive SQL query. Student can implement effective full-text search in a relational database and in a specialized database (Elasticsearch). Student understands NoSQL database concepts, their advantages and limitations and can choose appropriate database for a particular use-case.
 
Prerequisites and co-requisites: none
 
Course contents:
- How SQL is executed - query plans, anatomy of an index, single-column indices
- Multi-column indices, joins, indexing group by
- Recursion in SQL
- Advanced data structures: arrays, JSON, XML
- GIS/PostGIS
- Fulltext search in SQL.
- SQL/NoSQL trade-offs
- Elasticsearch: concepts, text analysis
- Elasticsearch: advanced queries, facets
- Elasticsearch: distributed search, cluster
- In-memory databases, Redis
- Combining databases, Case-study
 
Recommended or required reading:
Basic:
ZANIOLO, C. -- CERI, S. -- FALOUTSOS, C. -- SNODGRASS, R T. -- SUBRAHMANIAN, V. -- ZICARI, R. Advanced database systems. San Francisco : Morgan Kaufmann Publishers, 1997. 574 p. ISBN 1-55860-443-X.
MATIAŠKO, K. -- VAJSOVÁ, M. -- ZÁBOVSKÝ, M. -- CHOCHLÍK, M. Databázové systémy a technológie. STU v Bratislave FIIT, 2009. 693 p. ISBN 978-80-227-3035-8.

Recommended:
Radu Gheorghe, Matthew Lee Hinman, and Roy Russo. 2015. Elasticsearch in Action (1st ed.). Manning Publications Co., Greenwich, CT, USA.
Winand, Markus. 2012. SQL Performance Explained.

 
Planned learning activities and teaching methods: -- item not defined --
 
Assesment methods and criteria: Written exam.
 
Language of instruction: Slovak
 
Work placement(s): There is no compulsory work placement in the course unit.


Last modification made by RNDr. Marta Gnipová on 09/20/2019.

Type of output: