155-0909/01 – Integrated software systems in a heterogeneous network environments (Oracle) (ISSPHS)

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
Part-time Examination 30+0

Subject aims expressed by acquired skills and competences

Understanding of relational concept of ORACLE database system. Basics in programming in DB ORACLE system. SQL programming language, Developer 2000. Designing methodology in Designer 2000. Distributed processing and databases. Data storage, decision-making support, multi-dimensional database. Alternative knowledge of another comparable database system.

Teaching methods

Lectures

Summary

The course focuses on conceptual database modeling and more advanced database technologies in the ORACLE environment, such as distributed database systems and data warehouses for decision support applications. Its aim is to understand these technologies, their theoretical principles, application possibilities, design and implementation.

Compulsory literature:

ELMASRI, R. AND NAVATHE, S.B. Fundamentals ff Database Systems. Addison Wesley, N.Y., 2003. ROB, P. CORONEL C. and CROCKETT, K. Database systems: Implementation and Management. London: Cengage Learning, 2008. ISBN 978-1-84480-732-1. KVET, M., MATIAŠKO, K. Efficiency of the relational database tuple access. Proceedings of 2019 IEEE 15th International Scientific Conference on Informatics, Informatics 2019, pp. 222-227, ISBN: 978-1-7281-3178-8. CONNOLLY, T., BEGG, C., STRACHAN, A. Database Systems, A Practical Approach to Desing, Implementation and Management. 3rd ed, Addison-Wesley Publ. Comp., 2002. ISBN 0-201-70857-4 DATE, C. J. An Introduction to Database Systems. 7th ed. Reading, Addison-Wesley, 2000. ISBN 0-201-68419-5. ELVIS C. FOSTER, SHRIPAD GODBOLE. Database Systems. APress 2016, ISBN: 1484211928.

Recommended literature:

CONNOLLY, T., BEGG, C., STRACHAN, A. Database Systems, A Practical Approach to Desing, Implementation and Management. 3rd ed, Addison-Wesley Publ. Comp., 2002. ISBN 0-201-70857-4 DATE, C. J. An Introduction to Database Systems. 7th ed. Reading, Addison-Wesley, 2000. ISBN 0-201-68419-5. ELMASRI, R., NAVATHE, S. B. Fundamentals of Database Systems. 3rd ed. Addison-Wesley, 2000. LAKSHMAN, B. Oracle and Java Development. Sams Publishing, 2002. ISBN 0-672-32117-3. ELVIS C. FOSTER, SHRIPAD GODBOLE. Database Systems. APress 2016, ISBN: 1484211928. PLUNKETT, T. Oracle Big Data Handbook (Oracle Press) (DATABASE & ERP - OMG). OraclePress, 2013, ISBN: 978-0-07-1827726-3.

Way of continuous check of knowledge in the course of semester

Exam fom selected topics

E-learning

Other requirements

no further requirements

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

Relational concept of ORACLE database system. Basics in programming in DB ORACLE system. SQL programming language, Developer 2000. Designing methodology in Designer 2000. Distributed processing and databases. Data storage, decision-making support, multi-dimensional database. Alternative knowledge of another comparable database system.

Conditions for subject completion

Full-time 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.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2022/2023 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics P Czech Ostrava Choice-compulsory study plan
2022/2023 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics K Czech Ostrava Choice-compulsory study plan
2021/2022 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics P Czech Ostrava Choice-compulsory study plan
2021/2022 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics K Czech Ostrava Choice-compulsory study plan
2020/2021 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics P Czech Ostrava Choice-compulsory study plan
2020/2021 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics K Czech Ostrava Choice-compulsory study plan
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