PV003 Relational Database System Architecture

Faculty of Informatics
Spring 2020
Extent and Intensity
2/1/0. 3 credit(s) (plus extra credits for completion). Recommended Type of Completion: zk (examination). Other types of completion: k (colloquium), z (credit).
Teacher(s)
RNDr. Milan Drášil, CSc. (lecturer)
RNDr. Michal Batko, Ph.D. (seminar tutor)
Mgr. Jan Fikejs (assistant)
Guaranteed by
RNDr. Michal Batko, Ph.D.
Department of Computer Systems and Communications – Faculty of Informatics
Contact Person: RNDr. Milan Drášil, CSc.
Supplier department: Department of Computer Systems and Communications – Faculty of Informatics
Timetable
Mon 17. 2. to Fri 15. 5. Mon 16:00–17:50 B410
  • Timetable of Seminar Groups:
PV003/01: Mon 17. 2. to Fri 15. 5. Fri 11:00–11:50 A215, M. Batko
PV003/02: Mon 17. 2. to Fri 15. 5. Fri 10:00–10:50 A215, M. Batko
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
fields of study / plans the course is directly associated with
Course objectives
The course is focused on an architecture of relational database engines and the SQL query language.
Learning outcomes
Student will be able to fully comprehend usage of SQL query language.
Syllabus
  • A brief history of relational databases, independent data store, advantages and disadvantages.
  • Relational algebra, requirements to communication and query language.
  • Parts of SQL language (definition, manipulation, transaction), lexical conventions of SQL.
  • Data Definition Language, creation and modification of tables, sequence definition, dropping an object from data scheme.
  • Integrity constraints, definition in SQL.
  • An effective approach to table rows, indexes.
  • Data Manipulation Language, insert, delete, update rows in table, foreign keys context.
  • Join of tables, outer join, processing techniques of join.
  • WHERE clause construction, aggregation functions
  • Hierarchical queries
  • Set operations.
  • VIEWs a MATERIALIZED VIEWs.
  • Object relational database, methods, abstract types, inheritance.
  • XML data interface to objects.
  • Execution plan, query tuning, HINT phrase.
  • Transaction control, isolation levels, SELECT query and transactions, deadlock and its detection.
  • Procedural languages in relational databases, procedures and functions, packages, deterministic functions, triggers.
  • Normal forms and data schemes in relational databases.
Literature
  • Definition of SQL, technical manuals
Teaching methods
Lectures, projects, seminars
Assessment methods
Attendance in seminary is optional, credit is acquired by creating and presenting a simple project. During course, a non-trivial example for PL/SQL will be released. Its elaboration is optional, the result however will be included to final rating. The course is finished with final written exam.
Language of instruction
Czech
Further Comments
Study Materials
The course is taught annually.
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2010, Spring 2011, Spring 2012, Spring 2013, Spring 2014, Spring 2015, Spring 2016, Spring 2017, Spring 2018, Spring 2019, Spring 2021, Spring 2022, Spring 2023, Spring 2024, Spring 2025.
  • Enrolment Statistics (Spring 2020, recent)
  • Permalink: https://is.muni.cz/course/fi/spring2020/PV003