155-0911/01 – Databese Systems (DS)

Gurantor departmentDepartment of Applied InformaticsCredits10
Subject guarantorprof. Ing. Dušan Marček, CSc.Subject version guarantorprof. Ing. Dušan Marček, CSc.
Study levelpostgraduateRequirementChoice-compulsory
YearSemesterwinter + summer
Study languageCzech
Year of introduction2013/2014Year of cancellation
Intended for the facultiesEKFIntended for study typesDoctoral
Instruction secured by
LoginNameTuitorTeacher giving lectures
MAR0011 prof. Ing. Dušan Marček, CSc.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Examination 30+0
Combined Examination 30+0

Subject aims expressed by acquired skills and competences

1. Understanding DBS technologies 2. Basic knowledge of the DB technology 3. Understand the theoretical principles of database technology 4. Get to know the application possibilities of the DB technology, understand the application possibilities of the DB technology.

Teaching methods

Lectures
Individual consultations

Summary

The main topics of the course are: 1. object and relational databases, use of object-access constructors in data modeling, object-oriented databases; 2. conceptual modeling, characteristics of a well-designed model and its transformation into data models; 3. internal data organization, use of B-trees, bitmap and junction indices, etc.; 4. Distributed DBS. Lectures, individual consultations and written work will be determined according to the student's orientation with regard to the profile of the doctoral student

Compulsory literature:

HOFFER, Jeffrey A., Ramesh VENKATARAMAN a Heikki TOPI. Modern Database Management. 10. vyd. Upper Saddle River: Prentice Hall, 2011. ISBN 978-0-13-608839-4. INMON, W.H. Building the data warehouse. New York: Wiley, 2005. ISBN 978-0764599446. HARRINGTON, Jan L. Object-oriented database design clearly explained / Jan L. Harrington. London : Morgan Kaufmann, 2000, ISBN: 0123264286

Recommended literature:

BEGG, E. Carolyn, CONNOLLY, Thomas a HOLOWCZAK, Richard. Business Database Systems. Boston: Addison-Wesley, 2008, ISBN-13: 978-1405874373. INMON, W.H. Building the data warehouse. New York: Wiley, 2005. ISBN 978-0764599446. HARRINGTON, Jan L. Relational Database Design Clearly Explained. Morgan Kaufmann Publishers, 2002, ISBN-13: 978-1-55860-820-7.

Way of continuous check of knowledge in the course of semester

E-learning

Další požadavky na studenta

no further requirements

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

1. Conceptual database modeling: Entity-Relationship model 2. Conceptual database modeling: semantic models and anchored modeling 3. Distributed database systems: architecture, data replication, data fragmentation, data allocation 4. Classification (levels) of information systems, OLTP and OLAP technology 5. Fundamentals of Data Warehousing (DW) 6. DW Environment, DW Architecture 7. DW: data models, used schema of data types 8. DW: multidimensional views of data, creating and description 9. DW: internal data models 10. Recent developments in data warehouses

Conditions for subject completion

Combined form (validity from: 2013/2014 Winter semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Examination Examination  
Mandatory attendence parzicipation:

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
2019/2020 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics P Czech Ostrava Choice-compulsory study plan
2019/2020 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics K Czech Ostrava Choice-compulsory study plan
2018/2019 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics P Czech Ostrava Choice-compulsory study plan
2018/2019 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics K Czech Ostrava Choice-compulsory study plan
2017/2018 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics P Czech Ostrava Choice-compulsory study plan
2017/2018 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics K Czech Ostrava Choice-compulsory study plan
2016/2017 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics P Czech Ostrava Choice-compulsory study plan
2016/2017 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics K Czech Ostrava Choice-compulsory study plan
2015/2016 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics P Czech Ostrava Choice-compulsory study plan
2015/2016 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics K Czech Ostrava Choice-compulsory study plan
2014/2015 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics P Czech Ostrava Choice-compulsory study plan
2014/2015 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics K Czech Ostrava Choice-compulsory study plan
2013/2014 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics P Czech Ostrava Choice-compulsory study plan
2013/2014 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics K Czech Ostrava Choice-compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner