460-4068/01 – Database and Information Systems II (DAIS II)

Gurantor departmentDepartment of Computer ScienceCredits4
Subject guarantordoc. Ing. Michal Krátký, Ph.D.Subject version guarantordoc. Ing. Michal Krátký, Ph.D.
Study levelundergraduate or graduate
Study languageCzech
Year of introduction2015/2016Year of cancellation
Intended for the facultiesFEIIntended for study typesFollow-up Master
Instruction secured by
LoginNameTuitorTeacher giving lectures
KRA28 doc. Ing. Michal Krátký, Ph.D.
ZAT0056 Ing. Lukáš Zátopek
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Credit and Examination 2+2
Combined Credit and Examination 14+0

Subject aims expressed by acquired skills and competences

A student knows current methodologies, methods, and tools for the database design and information system development, especially the physical database design and testing of the data layer, and student is able to apply these knowledges during a real design and implementation of information systems. Moreover, student can describe some extended database technologies such as spatial DBMS, full-text options of DBMS, XML, distributed, and NoSQL DBMS.

Teaching methods

Lectures
Tutorials

Summary

The content of the first part connects on topics of the bachelor course Database and Information Systems. The content of this course includes the physical database design, a design and implementation of the information system's data layer, and benchmarking of the data layer. In practices, students implements individual tasks related to the following topics: data and functional analysis, physical database design, and the implementation and benchmarking of information system's data layer. In the second part of a semester, there are some extended database technologies such as spatial DBMS, full-text options of DBMS, XML, distributed, and NoSQL DBMS. In practices, students implement individual tasks related to these topics.

Compulsory literature:

H. Garcia-Molina, J. D. Ullman, J. Widom: Database Systems: The Complete Book (2nd Edition). Prentice Hall; 2 edition (June 15, 2008).

Recommended literature:

S. S. Lightstone, T. J. Teorey (Author), T. Nadeau: Physical Database Design, 1st Edition. Morgan Kaufmann; 4th edition (April 4, 2007).

Way of continuous check of knowledge in the course of semester

Partial tasks to topics of lectures are checked in practices.

E-learning

Další požadavky na studenta

We require the following knowledges: conceptual modelling, functional analysis, SQL, relational data model, procedural extensions of SQL, transaction processing, design and implementation of the information system's data layer.

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

Lectures: 1. Introduction, data storages, RAID 2. Data modelling and functional analysis 3. Physical database design I 4. Physical database design II 5. Physical database design III 6. Compression in DBMS 7. Data Layer of IS - ORM, implementation, and benchmarking 8. Spatial data and Spatial extensions of DBMS 9. Distributed and NoSQL DBMS 10. NoSQL, BigData storages 11. Distributed transactions, eventual consistency 12. Data integration, ERP systems 13. Native XML databases Practices include samples and tasks related to the topics of lectures.

Conditions for subject completion

Full-time form (validity from: 2015/2016 Winter semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Credit and Examination Credit and Examination 100 (100) 51
        Credit Credit 45  20
        Examination Examination 55  6
Mandatory attendence parzicipation:

Show history
Combined form (validity from: 2015/2016 Winter semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Credit and Examination Credit and Examination 100 (100) 51
        Credit Credit 45  20
        Examination Examination 55  6
Mandatory attendence parzicipation:

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
2019/2020 (N2647) Information and Communication Technology (2612T025) Computer Science and Technology P Czech Ostrava 1 Choice-compulsory study plan
2019/2020 (N2647) Information and Communication Technology (2612T025) Computer Science and Technology K Czech Ostrava 1 Choice-compulsory study plan
2018/2019 (N2647) Information and Communication Technology (2612T025) Computer Science and Technology P Czech Ostrava 1 Choice-compulsory study plan
2018/2019 (N2647) Information and Communication Technology (2612T025) Computer Science and Technology K Czech Ostrava 1 Choice-compulsory study plan
2017/2018 (N2647) Information and Communication Technology (2612T025) Computer Science and Technology P Czech Ostrava 1 Choice-compulsory study plan
2017/2018 (N2647) Information and Communication Technology (2612T025) Computer Science and Technology K Czech Ostrava 1 Choice-compulsory study plan
2016/2017 (N2647) Information and Communication Technology (2612T025) Computer Science and Technology P Czech Ostrava 1 Choice-compulsory study plan
2016/2017 (N2647) Information and Communication Technology (2612T025) Computer Science and Technology K Czech Ostrava 1 Choice-compulsory study plan
2015/2016 (N2647) Information and Communication Technology (2612T025) Computer Science and Technology P Czech Ostrava 1 Choice-compulsory study plan
2015/2016 (N2647) Information and Communication Technology (2612T025) Computer Science and Technology K Czech Ostrava 1 Choice-compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner