FI:PV003 RDBS Architecture - Course Information
PV003 Relational Database System Architecture
Faculty of InformaticsSpring 2023
- 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 13. 2. to Mon 15. 5. Mon 14:00–15:50 D2
- Timetable of Seminar Groups:
PV003/02: Mon 13. 2. to Mon 15. 5. Mon 13:00–13:50 A215, M. Batko
PV003/03: Thu 16. 2. to Thu 11. 5. Thu 9:00–9:50 A215, M. Batko
PV003/04: Thu 16. 2. to Thu 11. 5. Thu 8:00–8:50 A215, M. Batko
PV003/05: Fri 17. 2. to Fri 12. 5. Fri 10:00–10:50 A215, M. Batko
PV003/06: Fri 17. 2. to Fri 12. 5. Fri 11:00–11: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.
The capacity limit for the course is 100 student(s).
Current registration and enrolment status: enrolled: 79/100, only registered: 1/100, only registered with preference (fields directly associated with the programme): 1/100 - fields of study / plans the course is directly associated with
- there are 76 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
- Study Materials
The course is taught annually.
- Enrolment Statistics (Spring 2023, recent)
- Permalink: https://is.muni.cz/course/fi/spring2023/PV003