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

Gurantor departmentDepartment of Computer ScienceCredits10
Subject guarantorprof. Ing. Dušan Marček, CSc.Subject version guarantorprof. Ing. Dušan Marček, CSc.
Study levelpostgraduate
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

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

Předmět se soustřeďuje na konceptuální modelování databáze a pokročilejší databázové technologie v prostředí ORACLE, jako jsou distribuované databázové systémy a datové sklady pro aplikace na podporu rozhodování. Jeho cílem je porozumět těmto technologiím, jejích teoretickým principům, aplikačním možnostem, navrhování a nasazení do praxe.

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. 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

E-learning

Další požadavky na studenta

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
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
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