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

Gurantor departmentDepartment of Computer ScienceCredits4
Subject guarantorprof. Ing. Michal Krátký, Ph.D.Subject version guarantorprof. Ing. Michal Krátký, Ph.D.
Study levelundergraduate or graduateRequirementChoice-compulsory
Year1Semesterwinter
Study languageEnglish
Year of introduction2015/2016Year of cancellation2022/2023
Intended for the facultiesFEIIntended for study typesFollow-up Master
Instruction secured by
LoginNameTuitorTeacher giving lectures
KRA28 prof. Ing. Michal Krátký, Ph.D.
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 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

Other requirements

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: 2017/2018 Winter semester, validity until: 2022/2023 Summer 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  23
        Examination Examination 55  28 3
Mandatory attendence participation:

Show history

Conditions for subject completion and attendance at the exercises within ISP:

Show history

Occurrence in study plans

Academic yearProgrammeBranch/spec.Spec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2021/2022 (N0688A140015) Industry 4.0 P English Ostrava 1 Optional study plan
2021/2022 (N2647) Information and Communication Technology (2612T025) Computer Science and Technology P English Ostrava 1 Choice-compulsory study plan
2020/2021 (N0688A140015) Industry 4.0 P English Ostrava 1 Optional study plan
2020/2021 (N2647) Information and Communication Technology (2612T025) Computer Science and Technology P English Ostrava 1 Choice-compulsory study plan
2019/2020 (N2647) Information and Communication Technology (2612T025) Computer Science and Technology P English Ostrava 1 Choice-compulsory study plan
2019/2020 (N2647) Information and Communication Technology (2612T025) Computer Science and Technology K English Ostrava 1 Choice-compulsory study plan
2018/2019 (N2647) Information and Communication Technology (2612T025) Computer Science and Technology P English Ostrava 1 Choice-compulsory study plan
2018/2019 (N2647) Information and Communication Technology (2612T025) Computer Science and Technology K English Ostrava 1 Choice-compulsory study plan
2017/2018 (N2647) Information and Communication Technology (2612T025) Computer Science and Technology P English Ostrava 1 Choice-compulsory study plan
2017/2018 (N2647) Information and Communication Technology (2612T025) Computer Science and Technology K English Ostrava 1 Choice-compulsory study plan
2016/2017 (N2647) Information and Communication Technology (2612T025) Computer Science and Technology P English Ostrava 1 Choice-compulsory study plan
2016/2017 (N2647) Information and Communication Technology (2612T025) Computer Science and Technology K English Ostrava 1 Choice-compulsory study plan
2015/2016 (N2647) Information and Communication Technology (2612T025) Computer Science and Technology P English Ostrava 1 Choice-compulsory study plan
2015/2016 (N2647) Information and Communication Technology (2612T025) Computer Science and Technology K English Ostrava 1 Choice-compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner

Assessment of instruction

Předmět neobsahuje žádné hodnocení.