PV003 Relational Database System Architecture

Faculty of Informatics
Spring 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.
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2010, 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.

PV003 Relational Database System Architecture

Faculty of Informatics
Spring 2024
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 14:00–15:50 D2
  • Timetable of Seminar Groups:
PV003/01: Tue 17:00–17:50 A215, M. Batko
PV003/02: Tue 16:00–16:50 A215, M. Batko
PV003/03: Tue 9:00–9:50 B311, M. Batko
PV003/04: Tue 8:00–8:50 B311, M. Batko
PV003/05: Mon 13:00–13:50 B311, M. Batko
PV003/06: Mon 12:00–12:50 B311, 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: 132/100, only registered: 2/100, only registered with preference (fields directly associated with the programme): 2/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.
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2010, 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 2025.

PV003 Relational Database System Architecture

Faculty of Informatics
Spring 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/01: Mon 13. 2. to Mon 15. 5. Mon 12:00–12:50 A215, M. Batko
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: 78/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.
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2010, 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 2024, Spring 2025.

PV003 Relational Database System Architecture

Faculty of Informatics
Spring 2022
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 14. 2. to Mon 9. 5. Mon 14:00–15:50 D2
  • Timetable of Seminar Groups:
PV003/01: Tue 15. 2. to Tue 10. 5. Tue 9:00–9:50 B311, M. Batko
PV003/02: Tue 15. 2. to Tue 10. 5. Tue 8:00–8:50 B311, M. Batko
PV003/03: Mon 14. 2. to Mon 9. 5. Mon 9:00–9:50 A215, M. Batko
PV003/04: Mon 14. 2. to Mon 9. 5. Mon 8:00–8:50 A215, M. Batko
PV003/05: Wed 16. 2. to Wed 11. 5. Wed 14:00–14:50 A215, M. Batko
PV003/06: Wed 16. 2. to Wed 11. 5. Wed 15:00–15: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.
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.
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2010, Spring 2011, Spring 2012, Spring 2013, Spring 2014, Spring 2015, Spring 2016, Spring 2017, Spring 2018, Spring 2019, Spring 2020, Spring 2021, Spring 2023, Spring 2024, Spring 2025.

PV003 Relational Database System Architecture

Faculty of Informatics
Spring 2021
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 16:00–17:50 Virtuální místnost
  • Timetable of Seminar Groups:
PV003/01: Wed 15:00–15:50 Virtuální místnost, M. Batko
PV003/02: Wed 16:00–16:50 Virtuální místnost, 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 / plans the course is directly associated with
there are 74 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.
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2010, Spring 2011, Spring 2012, Spring 2013, Spring 2014, Spring 2015, Spring 2016, Spring 2017, Spring 2018, Spring 2019, Spring 2020, Spring 2022, Spring 2023, Spring 2024, Spring 2025.

PV003 Relational Database System Architecture

Faculty of Informatics
Spring 2020
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 17. 2. to Fri 15. 5. Mon 16:00–17:50 B410
  • Timetable of Seminar Groups:
PV003/01: Mon 17. 2. to Fri 15. 5. Fri 11:00–11:50 A215, M. Batko
PV003/02: Mon 17. 2. to Fri 15. 5. Fri 10:00–10: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.
fields of study / plans the course is directly associated with
there are 74 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.
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2010, Spring 2011, Spring 2012, Spring 2013, Spring 2014, Spring 2015, Spring 2016, Spring 2017, Spring 2018, Spring 2019, Spring 2021, Spring 2022, Spring 2023, Spring 2024, Spring 2025.

PV003 Relational Database System Architecture

Faculty of Informatics
Spring 2019
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)
RNDr. Michal Batko, Ph.D. (seminar tutor)
doc. RNDr. Vlastislav Dohnal, Ph.D. (seminar tutor)
RNDr. Jakub Valčík, Ph.D. (seminar tutor)
Mgr. 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
Timetable
Mon 16:00–17:50 D2
  • Timetable of Seminar Groups:
PV003/01: Wed 9:00–9:50 A215, M. Batko
PV003/02: Wed 10:00–10: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.
fields of study / plans 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.
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.
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2010, Spring 2011, Spring 2012, Spring 2013, Spring 2014, Spring 2015, Spring 2016, Spring 2017, Spring 2018, Spring 2020, Spring 2021, Spring 2022, Spring 2023, Spring 2024, Spring 2025.

PV003 Relational Database System Architecture

Faculty of Informatics
Spring 2018
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)
RNDr. Michal Batko, Ph.D. (seminar tutor)
doc. RNDr. Vlastislav Dohnal, Ph.D. (seminar tutor)
RNDr. Jakub Valčík, Ph.D. (seminar tutor)
Mgr. 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
Timetable
Mon 16:00–17:50 A217
  • Timetable of Seminar Groups:
PV003/01: Thu 12:00–12:50 A215, M. Batko
PV003/02: Thu 11:00–11:50 A215, M. Batko
PV003/03: Wed 9:00–9:50 A215, M. Batko
PV003/04: Wed 8:00–8: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.
fields of study / plans 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.
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.
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2010, Spring 2011, Spring 2012, Spring 2013, Spring 2014, Spring 2015, Spring 2016, Spring 2017, Spring 2019, Spring 2020, Spring 2021, Spring 2022, Spring 2023, Spring 2024, Spring 2025.

PV003 Relational Database System Architecture

Faculty of Informatics
Spring 2017
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)
RNDr. Michal Batko, Ph.D. (seminar tutor)
doc. RNDr. Vlastislav Dohnal, Ph.D. (seminar tutor)
RNDr. Jakub Valčík, Ph.D. (seminar tutor)
Mgr. 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
Timetable
Mon 16:00–17:50 A318
  • Timetable of Seminar Groups:
PV003/01: Mon 14:00–14:50 B116, M. Batko
PV003/02: Mon 15:00–15:50 B116, M. Batko
PV003/03: Mon 9:00–9:50 B117, M. Batko
PV003/04: Mon 8:00–8:50 B117, 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 / plans 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.
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.
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2010, Spring 2011, Spring 2012, Spring 2013, Spring 2014, Spring 2015, Spring 2016, Spring 2018, Spring 2019, Spring 2020, Spring 2021, Spring 2022, Spring 2023, Spring 2024, Spring 2025.

PV003 Relational Database System Architecture

Faculty of Informatics
Spring 2016
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)
RNDr. Michal Batko, Ph.D. (seminar tutor)
doc. RNDr. Vlastislav Dohnal, Ph.D. (seminar tutor)
RNDr. Jakub Valčík, Ph.D. (seminar tutor)
Mgr. 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
Timetable
Mon 16:00–17:50 D1
  • Timetable of Seminar Groups:
PV003/01: Wed 9:00–9:50 B117, M. Batko
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 / plans 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.
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.
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2010, Spring 2011, Spring 2012, Spring 2013, Spring 2014, Spring 2015, Spring 2017, Spring 2018, Spring 2019, Spring 2020, Spring 2021, Spring 2022, Spring 2023, Spring 2024, Spring 2025.

PV003 Relational Database System Architecture

Faculty of Informatics
Spring 2015
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)
RNDr. Michal Batko, Ph.D. (seminar tutor)
doc. RNDr. Vlastislav Dohnal, Ph.D. (seminar tutor)
RNDr. Jakub Valčík, Ph.D. (seminar tutor)
Mgr. 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
Timetable
Mon 16:00–17:50 D3
  • Timetable of Seminar Groups:
PV003/T01: Mon 16. 2. to Fri 15. 5. Mon 13:00–14:35 108, J. Valčík, Nepřihlašuje se. Určeno pro studenty se zdravotním postižením.
PV003/01: Tue 8:00–8:50 A215, M. Batko
PV003/02: Tue 9:00–9:50 A215, M. Batko
PV003/03: Thu 8:00–8:50 A219, M. Batko
PV003/04: Thu 9:00–9:50 A219, 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 / plans the course is directly associated with
there are 36 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.
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.
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2010, Spring 2011, Spring 2012, Spring 2013, Spring 2014, Spring 2016, Spring 2017, Spring 2018, Spring 2019, Spring 2020, Spring 2021, Spring 2022, Spring 2023, Spring 2024, Spring 2025.

PV003 Relational Database System Architecture

Faculty of Informatics
Spring 2014
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)
RNDr. Michal Batko, Ph.D. (seminar tutor)
doc. RNDr. Vlastislav Dohnal, Ph.D. (seminar tutor)
RNDr. Jakub Valčík, Ph.D. (seminar tutor)
Guaranteed by
doc. RNDr. Vlastislav Dohnal, 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 16:00–17:50 D3
  • Timetable of Seminar Groups:
PV003/T01: Thu 20. 2. to Sat 31. 5. Thu 12:40–14:25 Učebna S9 (55), J. Valčík, Nepřihlašuje se. Určeno pro studenty se zdravotním postižením.
PV003/01: Thu 8:00–8:50 B116, M. Batko
PV003/02: Thu 9:00–9:50 B116, M. Batko
PV003/03: Thu 10:00–10:50 B116, M. Batko
PV003/04: Wed 14:00–14:50 B116, M. Batko
PV003/05: Wed 15:00–15: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 / plans the course is directly associated with
there are 36 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.
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.
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2010, Spring 2011, Spring 2012, Spring 2013, Spring 2015, Spring 2016, Spring 2017, Spring 2018, Spring 2019, Spring 2020, Spring 2021, Spring 2022, Spring 2023, Spring 2024, Spring 2025.

PV003 Relational Database System Architecture

Faculty of Informatics
Spring 2013
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)
RNDr. Michal Batko, Ph.D. (seminar tutor)
doc. RNDr. Vlastislav Dohnal, Ph.D. (seminar tutor)
RNDr. Jakub Valčík, Ph.D. (seminar tutor)
Mgr. Jan Fikejs (assistant)
Guaranteed by
doc. RNDr. Vlastislav Dohnal, 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 16:00–17:50 G101
  • Timetable of Seminar Groups:
PV003/01: Wed 8:00–8:50 B204, V. Dohnal
PV003/02: Wed 9:00–9:50 B204, V. Dohnal
PV003/03: Wed 14:00–14:50 B204, J. Valčík
PV003/04: Wed 15:00–15:50 B204, J. Valčík
PV003/05: Wed 9:00–9: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 / plans the course is directly associated with
there are 36 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.
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.
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2010, Spring 2011, Spring 2012, Spring 2014, Spring 2015, Spring 2016, Spring 2017, Spring 2018, Spring 2019, Spring 2020, Spring 2021, Spring 2022, Spring 2023, Spring 2024, Spring 2025.

PV003 Relational Database System Architecture

Faculty of Informatics
Spring 2012
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. Luděk Matyska, CSc.
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 18:00–19:50 D2
  • Timetable of Seminar Groups:
PV003/01: Tue 10:00–10:50 A104, V. Dohnal
PV003/02: Tue 11:00–11:50 A104, V. Dohnal
PV003/03: Wed 12:00–12:50 A104, V. Dohnal
PV003/04: Wed 13:00–13:50 A104, 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 44 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.
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.
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2010, Spring 2011, Spring 2013, Spring 2014, Spring 2015, Spring 2016, Spring 2017, Spring 2018, Spring 2019, Spring 2020, Spring 2021, Spring 2022, Spring 2023, Spring 2024, Spring 2025.

PV003 Relational Database System Architecture

Faculty of Informatics
Spring 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/01: Mon 16:00–16:50 B311, V. Dohnal
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.
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2010, 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, Spring 2025.

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
there are 41 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.
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, Spring 2025.

PV003 Relational Database System Architecture

Faculty of Informatics
Spring 2009
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: Tue 8:00–8:50 B311, V. Dohnal
PV003/02: Tue 9:00–9:50 B311, V. Dohnal
PV003/03: Wed 9:00–9:50 B311, V. Dohnal
PV003/04: Wed 14:00–14:50 B311, V. Dohnal
PV003/05: Wed 15:00–15: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 38 fields of study the course is directly associated with, display
Course objectives
Basic course to relational datadase communication language SQL.
Syllabus
  • 1. DDL - Data Definition Language SQL - standard and user data types - table definition - integrity constraints (primary, references, check) - sequential generators - synonyms - views - indexes 2. Security - basic rules - roles - user's rights 3. DML - Data Manipulation Language SQL - INSERT, UPDATE, DELETE, TRUNCATE - projection in SQL - selection in SQL - product in SQL - indexes - query execution plans - query optimalization 4. Server procedures - functions - procedures - procedure packages - triggers - events 5. Development Techniques for client applications - PRO*C
Literature
  • Definition of SQL, technical manuals
Assessment methods
Simple project, practical test (select command ..), final test from SQL language principles.
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 2010, 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, Spring 2025.

PV003 Relational Database System Architecture

Faculty of Informatics
Spring 2008
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 A107
  • Timetable of Seminar Groups:
PV003/01: Tue 10:00–10:50 B311, V. Dohnal
PV003/02: Tue 11:00–11:50 B311, V. Dohnal
PV003/03: Tue 12:00–12:50 B311, V. Dohnal
PV003/04: Wed 8:00–8:50 B311, V. Dohnal
PV003/05: Wed 9:00–9: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 38 fields of study the course is directly associated with, display
Course objectives (in Czech)
Výklad je zaměřen na relační DB systémy a dotazovací jazyk SQL.
Syllabus
  • 1. DDL - Data Definition Language SQL - standard and user data types - table definition - integrity constraints (primary, references, check) - sequential generators - synonyms - views - indexes 2. Security - basic rules - roles - user's rights 3. DML - Data Manipulation Language SQL - INSERT, UPDATE, DELETE, TRUNCATE - projection in SQL - selection in SQL - product in SQL - indexes - query execution plans - query optimalization 4. Server procedures - functions - procedures - procedure packages - triggers - events 5. Development Techniques for client applications - PRO*C
Literature
  • Definice jazyka SQL, firemní dokumentace
Assessment methods (in Czech)
Ucast na cviceni neni povinna. Pro ziskani zapoctu je treba prezentovat jednoduchy projekt a napsat pisemnou zapoctovou zkousku (prikaz select). Pro ziskani zkousky je treba navic uspesne absolvovat pisemku - test z princiou SQL, PL/SQL,PRO*C.
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 2009, Spring 2010, 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, Spring 2025.

PV003 Relational Database System Architecture

Faculty of Informatics
Spring 2007
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: Wed 12:00–12:50 B311, V. Dohnal
PV003/02: Wed 13:00–13:50 B311, V. Dohnal
PV003/03: Thu 14:00–14:50 B116, V. Dohnal
PV003/04: Thu 15:00–15:50 B116, V. Dohnal
PV003/05: Thu 16:00–16:50 B311, V. Dohnal
Prerequisites (in Czech)
! P003 RDBS Architecture
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 18 fields of study the course is directly associated with, display
Course objectives (in Czech)
Výklad je zaměřen na relační DB systémy a dotazovací jazyk SQL.
Syllabus
  • 1. DDL - Data Definition Language SQL - standard and user data types - table definition - integrity constraints (primary, references, check) - sequential generators - synonyms - views - indexes 2. Security - basic rules - roles - user's rights 3. DML - Data Manipulation Language SQL - INSERT, UPDATE, DELETE, TRUNCATE - projection in SQL - selection in SQL - product in SQL - indexes - query execution plans - query optimalization 4. Server procedures - functions - procedures - procedure packages - triggers - events 5. Development Techniques for client applications - PRO*C
Literature
  • Definice jazyka SQL, firemní dokumentace
Assessment methods (in Czech)
Ucast na cviceni neni povinna. Pro ziskani zapoctu je treba prezentovat jednoduchy projekt a napsat pisemnou zapoctovou zkousku (prikaz select). Pro ziskani zkousky je treba navic uspesne absolvovat pisemku - test z princiou SQL, PL/SQL,PRO*C.
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 2008, Spring 2009, Spring 2010, 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, Spring 2025.

PV003 Relational Database System Architecture

Faculty of Informatics
Spring 2006
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: No timetable has been entered into IS. V. Dohnal
PV003/02: Tue 9:00–9:50 B311, V. Dohnal
PV003/03: No timetable has been entered into IS. V. Dohnal
PV003/04: Tue 10:00–10:50 B311, V. Dohnal
PV003/05: No timetable has been entered into IS. V. Dohnal
PV003/06: Tue 11:00–11:50 B311, V. Dohnal
PV003/07: Tue 15:00–15:50 B311, V. Dohnal
PV003/08: Tue 8:00–8:50 B311, V. Dohnal
Prerequisites (in Czech)
! P003 RDBS Architecture
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 18 fields of study the course is directly associated with, display
Course objectives (in Czech)
Výklad je zaměřen na relační DB systémy a dotazovací jazyk SQL.
Syllabus
  • 1. DDL - Data Definition Language SQL - standard and user data types - table definition - integrity constraints (primary, references, check) - sequential generators - synonyms - views - indexes 2. Security - basic rules - roles - user's rights 3. DML - Data Manipulation Language SQL - INSERT, UPDATE, DELETE, TRUNCATE - projection in SQL - selection in SQL - product in SQL - indexes - query execution plans - query optimalization 4. Server procedures - functions - procedures - procedure packages - triggers - events 5. Development Techniques for client applications - PRO*C
Literature
  • Definice jazyka SQL, firemní dokumentace
Assessment methods (in Czech)
Ucast na cviceni neni povinna. Pro ziskani zapoctu je treba prezentovat jednoduchy projekt a napsat pisemnou zapoctovou zkousku (prikaz select). Pro ziskani zkousky je treba navic uspesne absolvovat pisemku - test z princiou SQL, PL/SQL,PRO*C.
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 2007, Spring 2008, Spring 2009, Spring 2010, 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, Spring 2025.

PV003 Relational Database System Architecture

Faculty of Informatics
Spring 2005
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)
RNDr. Jiří Hroza (seminar tutor)
doc. RNDr. Petr Švenda, Ph.D. (seminar tutor)
Guaranteed by
prof. Ing. Pavel Zezula, CSc.
Department of Machine Learning and Data Processing – Faculty of Informatics
Contact Person: RNDr. Milan Drášil, CSc.
Timetable
Mon 16:00–17:50 D2
  • Timetable of Seminar Groups:
PV003/01: Tue 12:00–12:50 B311, P. Švenda
PV003/02: Tue 13:00–13:50 B311, P. Švenda
PV003/03: Thu 18:00–18:50 B311, P. Švenda
PV003/04: Thu 19:00–19:50 B311, P. Švenda
PV003/05: Wed 12:00–12:50 B311, J. Hroza
PV003/06: Wed 13:00–13:50 B311, J. Hroza
PV003/07: Thu 12:00–12:50 B311, J. Hroza
Prerequisites (in Czech)
! P003 RDBS Architecture
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 18 fields of study the course is directly associated with, display
Course objectives (in Czech)
Výklad je zaměřen na relační DB systémy a dotazovací jazyk SQL.
Syllabus
  • 1. DDL - Data Definition Language SQL - standard and user data types - table definition - integrity constraints (primary, references, check) - sequential generators - synonyms - views - indexes 2. Security - basic rules - roles - user's rights 3. DML - Data Manipulation Language SQL - INSERT, UPDATE, DELETE, TRUNCATE - projection in SQL - selection in SQL - product in SQL - indexes - query execution plans - query optimalization 4. Server procedures - functions - procedures - procedure packages - triggers - events 5. Development Techniques for client applications - PRO*C
Literature
  • Definice jazyka SQL, firemní dokumentace
Assessment methods (in Czech)
Ucast na cviceni neni povinna. Pro ziskani zapoctu je treba prezentovat jednoduchy projekt a napsat pisemnou zapoctovou zkousku (prikaz select). Pro ziskani zkousky je treba navic uspesne absolvovat pisemku - test z princiou SQL, PL/SQL,PRO*C.
Language of instruction
Czech
Further Comments
The course is taught annually.
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2010, 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, Spring 2025.

PV003 Relational Database System Architecture

Faculty of Informatics
Spring 2004
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)
Mgr. Michal Merta (seminar tutor)
Ing. Mgr. et Mgr. Zdeněk Říha, Ph.D. (seminar tutor)
Guaranteed by
prof. Ing. Pavel Zezula, CSc.
Department of Machine Learning and Data Processing – Faculty of Informatics
Contact Person: RNDr. Milan Drášil, CSc.
Timetable
Mon 16:00–17:50 D2
  • Timetable of Seminar Groups:
PV003/01: Thu 9:00–9:50 B117, Z. Říha
PV003/02: Thu 10:00–10:50 B117, Z. Říha
PV003/03: Thu 11:00–11:50 B117, Z. Říha
PV003/04: Mon 13:00–13:50 B116, M. Merta
PV003/05: Mon 14:00–14:50 B116, M. Merta
PV003/06: Mon 15:00–15:50 B116, M. Merta
Prerequisites (in Czech)
! P003 RDBS Architecture
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 6 fields of study the course is directly associated with, display
Course objectives (in Czech)
Výklad je zaměřen na relační DB systémy a dotazovací jazyk SQL.
Syllabus
  • 1. DDL - Data Definition Language SQL - standard and user data types - table definition - integrity constraints (primary, references, check) - sequential generators - synonyms - views - indexes 2. Security - basic rules - roles - user's rights 3. DML - Data Manipulation Language SQL - INSERT, UPDATE, DELETE, TRUNCATE - projection in SQL - selection in SQL - product in SQL - indexes - query execution plans - query optimalization 4. Server procedures - functions - procedures - procedure packages - triggers - events 5. Development Techniques for client applications - PRO*C
Literature
  • Definice jazyka SQL, firemní dokumentace
Assessment methods (in Czech)
Ucast na cviceni neni povinna. Pro ziskani zapoctu je treba prezentovat jednoduchy projekt a napsat pisemnou zapoctovou zkousku (prikaz select). Pro ziskani zkousky je treba navic uspesne absolvovat pisemku - test z princiou SQL, PL/SQL,PRO*C.
Language of instruction
Czech
Further Comments
The course is taught annually.
The course is also listed under the following terms Spring 2003, Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2010, 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, Spring 2025.

PV003 Relational Database System Architecture

Faculty of Informatics
Spring 2003
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)
Ing. Mgr. et Mgr. Zdeněk Říha, Ph.D. (seminar tutor)
Mgr. Petr Švéda (seminar tutor)
Guaranteed by
prof. Ing. Pavel Zezula, CSc.
Department of Machine Learning and Data Processing – Faculty of Informatics
Contact Person: RNDr. Milan Drášil, CSc.
Timetable
Mon 16:00–17:50 D1
  • Timetable of Seminar Groups:
PV003/01: Tue 17:00–17:50 B116, P. Švéda
PV003/02: Tue 18:00–18:50 B116, P. Švéda
PV003/03: Tue 19:00–19:50 B116, P. Švéda
PV003/04: Tue 17:00–17:50 A104, Z. Říha
PV003/05: Tue 18:00–18:50 A104, Z. Říha
PV003/06: Tue 19:00–19:50 A104, Z. Říha
PV003/07: Mon 14:00–14:50 A104, Z. Říha
PV003/08: Mon 15:00–15:50 A104, Z. Říha
Prerequisites (in Czech)
! P003 RDBS Architecture
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 6 fields of study the course is directly associated with, display
Course objectives (in Czech)
Výklad je zaměřen na relační DB systémy a dotazovací jazyk SQL.
Syllabus
  • 1. DDL - Data Definition Language SQL - standard and user data types - table definition - integrity constraints (primary, references, check) - sequential generators - synonyms - views - indexes 2. Security - basic rules - roles - user's rights 3. DML - Data Manipulation Language SQL - INSERT, UPDATE, DELETE, TRUNCATE - projection in SQL - selection in SQL - product in SQL - indexes - query execution plans - query optimalization 4. Server procedures - functions - procedures - procedure packages - triggers - events 5. Development Techniques for client applications - PRO*C
Literature
  • Definice jazyka SQL, firemní dokumentace
Language of instruction
Czech
Further Comments
The course is taught annually.
The course is also listed under the following terms Spring 2004, Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2010, 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, Spring 2025.