7. 4. 2020  13:32 Zoltán
Akademický informační systém

Sylabus předmětu PDT_I - Advanced Database Technologies (FIIT - WS 2019/2020)


     Informačný list          ECTS          Sylabus          


     Slovenština          Angličtina          


University: Slovak University of Technology in Bratislava
Faculty: Faculty of Informatics and Information Technologies
Course unit code: PDT_I
Course unit title: Advanced Database Technologies
Mode of delivery, planned learning activities and teaching methods:
lecture2 hours weekly (on-site method)
laboratory/construction practice2 hours weekly (on-site method)
project/semestral paper1 hour weekly (on-site method)

 
Credits allocated: 6
 
Recommended semester/trimester: -- item not defined --
Level of study: -- item not defined --
Prerequisites for registration: none
 
Assesment methods:
Active participation on seminars, presenting the assignment milestones according to agreed schedule.

Scoring at least 25 points (out of 50) for assignments.
Scoring at least 56 points for all graded assignments and exam (assignments max. 50 + 10 bonus, exam 50).
 
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.
 
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.

 
Language of instruction: slovak and english
 
Notes:
 
Courses evaluation:
Assessed students in total: 1139

ABCDEFX
15,5 %21,4 %26,9 %19,7 %12,4 %4,1 %
Name of lecturer(s): Ing. Tomáš Kramár, PhD. (lecturer, person responsible for course) - slovak
Samuel Pecár (instructor) - slovak
Ing. Miroslav Rác (instructor) - slovak
 
Last modification: 20. 9. 2019
Supervisor: Ing. Tomáš Kramár, PhD. and programme supervisor


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

Typ výstupu: