155-9509/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 languageEnglish
Year of introduction2014/2015Year 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

Undestanding 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 modeling database and advanced database technology in Oracle environments, such as distributed database systems and data warehouses for decision support applications. Its aim is to understand these technologies, its theoretical principles, application possibilities, design and deployment in practice.

Compulsory literature:

ASHDOWN, L., KYTE, T. Oracle database concepts. 0racle Press, 2015. 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. LAKSHMAN, B. Oracle and Java Development. Sams Publishing, 2002. ISBN 0-672-32117-3. 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. KOCH, G., LONEY, K. Oracle 8i, The Complete Reference. Osborne: Oracle Press Ed., 1999.

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. KOCH, G., LONEY, K. Oracle 8i, The Complete Reference. Osborne: Oracle Press Ed., 1999. LAKSHMAN, Bulushu. Oracle and Java Development. Sams Publishing, 2002. ISBN 0-672-32117-3

Way of continuous check of knowledge in the course of semester

Exam from 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: 2014/2015 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
2020/2021 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics P English Ostrava Choice-compulsory study plan
2020/2021 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics K English Ostrava Choice-compulsory study plan
2019/2020 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics P English Ostrava Choice-compulsory study plan
2019/2020 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics K English Ostrava Choice-compulsory study plan
2018/2019 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics P English Ostrava Choice-compulsory study plan
2018/2019 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics K English Ostrava Choice-compulsory study plan
2017/2018 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics P English Ostrava Choice-compulsory study plan
2017/2018 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics K English Ostrava Choice-compulsory study plan
2016/2017 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics P English Ostrava Choice-compulsory study plan
2016/2017 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics K English Ostrava Choice-compulsory study plan
2015/2016 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics P English Ostrava Choice-compulsory study plan
2015/2016 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics K English 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

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner