157-0909/02 – Integrated Software Systems in the Conditions of Heterogeneous Networks (ORACLE) (ISS)

Gurantor departmentDepartment of Systems EngineeringCredits10
Subject guarantorprof. Ing. Dušan Marček, CSc.Subject version guarantorprof. Ing. Jindřich Kaluža, CSc.
Study levelpostgraduateRequirementChoice-compulsory
YearSemesterwinter + summer
Study languageCzech
Year of introduction2012/2013Year of cancellation2012/2013
Intended for the facultiesEKFIntended for study typesDoctoral
Instruction secured by
LoginNameTuitorTeacher giving lectures
KAL65 prof. Ing. Jindřich Kaluža, CSc.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Credit and Examination 30+0
Part-time Credit and Examination 30+0

Subject aims expressed by acquired skills and competences

To apply independently, to absorb the world scientific knowledge, and to develop theoretically the issues in the area of distributed databases of relational and distributed data warehouse.

Teaching methods

Individual consultations


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.

Compulsory literature:

BULUSHU LAKSHMAN: 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. JOHNSTON, T., WEIS, R. Managing Time in Relational Databases. Morgan Kafmann, 2010.

Recommended literature:

INMON, W.H. Building the data warehouse. NY: Wiley, 2005. ASHDOWN, L., KYTE, T. Oracle database concepts. Oracle Press ,2015.

Way of continuous check of knowledge in the course of semester


Other requirements



Subject has no prerequisities.


Subject has no co-requisities.

Subject syllabus:


Conditions for subject completion

Conditions for completion are defined only for particular subject version and form of study

Occurrence in study plans

Academic yearProgrammeField of studySpec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2012/2013 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics K Czech Ostrava Choice-compulsory study plan
2012/2013 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics P Czech Ostrava Choice-compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner