460-2059/01 – Database systems II (DS II)
Gurantor department | Department of Computer Science | Credits | 6 |
Subject guarantor | prof. Ing. Michal Krátký, Ph.D. | Subject version guarantor | prof. Ing. Michal Krátký, Ph.D. |
Study level | undergraduate or graduate | Requirement | Compulsory |
Year | 2 | Semester | summer |
| | Study language | Czech |
Year of introduction | 2019/2020 | Year of cancellation | |
Intended for the faculties | FEI | Intended for study types | Bachelor |
Subject aims expressed by acquired skills and competences
The goal of this course is to provide extended information to bachelor students about the database technology with respect to the information system creation. Student will be able to implement an information system with complicated data layer using capabilities of modern RDBMS.
Teaching methods
Lectures
Tutorials
Experimental work in labs
Project work
Summary
The main topics of this course are as follows: multi-user access to a DBMS (transactions, locking, transactions in SQL and a host language environment), physical implementation of a DBMS (data structures and algorithms applied in a DBMS) and query evaluation (query evaluation plans, optimization of the query evaluation). These topics will be presented for a DBMS like Oracle and SQL Server. The goal of this course is to provide extended informations about query evaluation. A student will use this knowledge during an implementation of a real information system.
Compulsory literature:
Garcia-Molina, J.D. Ullman, J.D. Widom. Database Systems: The Complete Book. Prentice Hall, 2001.
S.S. Lightstone, T.J. Teorey, T. Nadeau: Physical Database Design: the database professional's guide to exploiting indexes, views, storage, and more. Morgan Kaufmann, 2007.
Recommended literature:
S.S. Lightstone, T.J. Teorey, T. Nadeau: Physical Database Design: the database professional's guide to exploiting indexes, views, storage, and more. Morgan Kaufmann, 2007.
Way of continuous check of knowledge in the course of semester
The first part of this course is finished with a test on a procedural extension of SQL, PL/SQL. In the second part, students implement an information system.
E-learning
Other requirements
There are no additional requirements.
Prerequisities
Co-requisities
Subject has no co-requisities.
Subject syllabus:
Syllabus of lectures:
- Procedural extensions of SQL: PL/SQL, T-SQL, stored procedures, triggers (5 lectures).
- Functional analysis of an information system, design of forms of the user interface (1 lecture).
- Transactions, ACID, log (1 lecture).
- Transactions, concurrency control (2 lectures): locking, versioning, transaction isolation levels.
- Data layer of an information system, object-relational mapping (ORM) (1 lecture): JDBC, ADO.NET.
- Integration of ORM and forms of an application (1 lecture).
- Physical implementation of database systems (1 lecture): query evaluation plan, heap table, index.
- Object-relational data model (1 lecture).
Syllabus of computer exercises:
- Procedural extensions of SQL: PL/SQL, T-SQL (5 exercises).
- Test on procedural extensions of SQL (2 exercises).
- Functional analysis of an information system, design of forms of the user interface (1 exercise).
- Description of nontrivial functions (transactions) using minispecifications (1 exercise).
- Implementation of object-relational mapping (1 exercise).
- Implementation of transactions (1 exercise).
- Integration of ORM and forms of an application (1 exercise).
- Transaction isolation levels (1 exercise).
Project:
- Functional analysis of an information system, design of forms of the user interface.
- Implementation of object-relational mapping.
- Implementation of transactions.
- Integration of ORM and forms of an application.
Conditions for subject completion
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction