PV003 Relational Database System Architecture

Faculty of Informatics
Spring 2010
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 16:00–17:50 D2
  • Timetable of Seminar Groups:
PV003/01: Thu 10:00–10:50 B311, V. Dohnal
PV003/02: Thu 11:00–11:50 B311, V. Dohnal
PV003/03: Fri 8:00–8:50 B311, V. Dohnal
PV003/04: Fri 9:00–9:50 B311, V. Dohnal
PV003/05: Fri 10:00–10: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
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.
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2011, Spring 2012, Spring 2013, Spring 2014, Spring 2015, Spring 2016, Spring 2017, Spring 2018, Spring 2019, Spring 2020, Spring 2021, Spring 2022, Spring 2023, Spring 2024.
  • Enrolment Statistics (Spring 2010, recent)
  • Permalink: https://is.muni.cz/course/fi/spring2010/PV003