FI:PV003 RDBS Architecture - Course Information
PV003 Relational Database System Architecture
Faculty of InformaticsSpring 2025
- 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).
In-person direct teaching - 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 - Course Enrolment Limitations
- The course is also offered to the students of the fields other than those the course is directly associated with.
The capacity limit for the course is 100 student(s).
Current registration and enrolment status: enrolled: 0/100, only registered: 0/100, only registered with preference (fields directly associated with the programme): 0/100 - fields of study / plans the course is directly associated with
- there are 39 fields of study the course is directly associated with, display
- 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
- The course is taught annually.
The course is taught: every week.
- Enrolment Statistics (Spring 2025, recent)
- Permalink: https://is.muni.cz/course/fi/spring2025/PV003