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

Gurantor departmentDepartment of Systems EngineeringCredits0
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 introduction2006/2007Year 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

Lectures
Individual consultations

Summary

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

Exam from selected topics

E-learning

Other requirements

No another 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: 1960/1961 Summer semester, validity until: 2012/2013 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Exercises evaluation and Examination Credit and Examination 100 (145) 51
        Examination Examination 100  0
        Exercises evaluation Credit 45  0
Mandatory attendence parzicipation:

Show history

Occurrence in study plans

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

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner