460-2059/01 – Database systems II (DS II)

Gurantor departmentDepartment of Computer ScienceCredits6
Subject guarantorprof. Ing. Michal Krátký, Ph.D.Subject version guarantorprof. Ing. Michal Krátký, Ph.D.
Study levelundergraduate or graduateRequirementCompulsory
Year2Semestersummer
Study languageCzech
Year of introduction2019/2020Year of cancellation
Intended for the facultiesFEIIntended for study typesBachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
CHO247 Ing. Peter Chovanec, Ph.D.
JAW254 Ing. Jan Janoušek
KRA28 prof. Ing. Michal Krátký, Ph.D.
LUK194 Ing. Petr Lukáš, Ph.D.
MOR0179 Ing. Lukáš Moravec
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Credit and Examination 2+2
Part-time Credit and Examination 10+0

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

Subject codeAbbreviationTitleRequirement
460-2056 DS I Database Systems I Recommended

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

Full-time form (validity from: 2019/2020 Winter semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of pointsMax. počet pokusů
Credit and Examination Credit and Examination 100 (100) 51
        Credit Credit 45 (45) 23
                Test Laboratory work 15  8 2
                Projekt Semestral project 30  16
        Examination Examination 55  28 3
Mandatory attendence participation: Participation is mandatory on practices with tests and individual parts of the project.

Show history

Conditions for subject completion and attendance at the exercises within ISP: Completion of all mandatory tasks within individually agreed deadlines.

Show history

Occurrence in study plans

Academic yearProgrammeBranch/spec.Spec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2024/2025 (B0613A140014) Computer Science INF P Czech Ostrava 2 Compulsory study plan
2024/2025 (B0613A140014) Computer Science INF K Czech Ostrava 2 Compulsory study plan
2023/2024 (B0613A140014) Computer Science INF K Czech Ostrava 2 Compulsory study plan
2023/2024 (B0613A140014) Computer Science INF P Czech Ostrava 2 Compulsory study plan
2022/2023 (B0613A140014) Computer Science INF K Czech Ostrava 2 Compulsory study plan
2022/2023 (B0613A140014) Computer Science INF P Czech Ostrava 2 Compulsory study plan
2021/2022 (B0613A140014) Computer Science INF P Czech Ostrava 2 Compulsory study plan
2021/2022 (B0613A140014) Computer Science INF K Czech Ostrava 2 Compulsory study plan
2021/2022 (B2647) Information and Communication Technology (2601R013) Telecommunication Technology P Czech Ostrava 2 Optional study plan
2021/2022 (B2647) Information and Communication Technology (2601R013) Telecommunication Technology K Czech Ostrava 2 Optional study plan
2021/2022 (B2647) Information and Communication Technology (2612R059) Mobile Technology P Czech Ostrava 2 Optional study plan
2021/2022 (B2647) Information and Communication Technology (2612R059) Mobile Technology K Czech Ostrava 2 Optional study plan
2020/2021 (B0613A140014) Computer Science INF K Czech Ostrava 2 Compulsory study plan
2020/2021 (B0613A140014) Computer Science INF P Czech Ostrava 2 Compulsory study plan
2020/2021 (B2647) Information and Communication Technology (2601R013) Telecommunication Technology P Czech Ostrava 2 Optional study plan
2020/2021 (B2647) Information and Communication Technology (2612R059) Mobile Technology P Czech Ostrava 2 Optional study plan
2020/2021 (B2647) Information and Communication Technology (2601R013) Telecommunication Technology K Czech Ostrava 2 Optional study plan
2020/2021 (B2647) Information and Communication Technology (2612R059) Mobile Technology K Czech Ostrava 2 Optional study plan
2019/2020 (B0613A140014) Computer Science INF P Czech Ostrava 2 Compulsory study plan
2019/2020 (B0613A140014) Computer Science INF K Czech Ostrava 2 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner

Assessment of instruction



2022/2023 Summer
2021/2022 Summer
2020/2021 Summer