FI:PV003 RDBS Architecture - Course Information
PV003 Relational Database System Architecture
Faculty of InformaticsSpring 2011
- 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).
- Teacher(s)
- RNDr. Milan Drášil, CSc. (lecturer)
doc. RNDr. Vlastislav Dohnal, Ph.D. (seminar tutor) - Guaranteed by
- prof. RNDr. Václav Matyáš, M.Sc., Ph.D.
Department of Computer Systems and Communications – Faculty of Informatics
Contact Person: RNDr. Milan Drášil, CSc. - Timetable
- Mon 18:00–19:50 D2
- Timetable of Seminar Groups:
PV003/02: Mon 17:00–17:50 B311, V. Dohnal
PV003/03: Wed 10:00–10:50 B311, V. Dohnal
PV003/04: Wed 11:00–11:50 B311, V. Dohnal - 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
- there are 43 fields of study the course is directly associated with, display
- Course objectives
- The course is focused to architecture of relational database engines and the query language SQL.
- 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, seminary
- Assessment methods
- Attendance in seminary is optional, credit is acquired after simple project presentation and succesful written credit exam (select statement). 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 2011, recent)
- Permalink: https://is.muni.cz/course/fi/spring2011/PV003