FI:PV003 RDBS Architecture - Course Information
PV003 Relational Database System ArchitectureFaculty of Informatics
- Extent and Intensity
- 2/1. 3 credit(s) (plus extra credits for completion). Recommended Type of Completion: zk (examination). Other types of completion: k (colloquium), z (credit).
- RNDr. Milan Drášil, CSc. (lecturer)
RNDr. Michal Batko, Ph.D. (seminar tutor)
doc. RNDr. Vlastislav Dohnal, Ph.D. (seminar tutor)
RNDr. Jakub Valčík (seminar tutor)
Bc. et Bc. Jan Fikejs (assistant)
- Guaranteed by
- doc. RNDr. Eva Hladká, 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
- Mon 16:00–17:50 D1
- Timetable of Seminar Groups:
PV003/02: Wed 8:00–8:50 B117, M. Batko
PV003/03: Thu 10:00–10:50 B116, M. Batko
PV003/04: Thu 9:00–9:50 B116, M. Batko
PV003/05: Thu 11:00–11:50 B116, 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 the course is directly associated with
- there are 37 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.
- 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.
- 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
- Further Comments
- Study Materials
The course is taught annually.