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

Gurantor department	Department of Applied Informatics	Credits	10
Subject guarantor	prof. Ing. Dušan Marček, CSc.	Subject version guarantor	prof. Ing. Dušan Marček, CSc.
Study level	postgraduate	Requirement	Choice-compulsory
Year		Semester	winter + summer
		Study language	English
Year of introduction	2014/2015	Year of cancellation
Intended for the faculties	EKF	Intended for study types	Doctoral

Instruction secured by
Login	Name	Tuitor	Teacher giving lectures
MAR0011	prof. Ing. Dušan Marček, CSc.

Extent of instruction for forms of study
Form of study	Way of compl.	Extent
Full-time	Examination	30+0
Part-time	Examination	30+0

Subject aims expressed by acquired skills and competences

Undertanding 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
Individual consultations

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. ELVIS C. FOSTER, SHRIPAD GODBOLE. Database Systems. APress 2016, ISBN: 1484211928 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

Part-time form (validity from: 2014/2015 Winter semester)

Task name	Type of task	Max. number of points (act. for subtasks)	Min. number of points	Max. počet pokusů
Examination	Examination			3

Mandatory attendence participation:

Show history

Conditions for subject completion and attendance at the exercises within ISP:

Show history

Occurrence in study plans

Academic year	Programme	Branch/spec.	Form	Study language	Tut. centre	Type of duty
2022/2023	(P6209) Systems Engineering and Informatics	(6209V025) System Engineering and Informatics	P	English	Ostrava	Choice-compulsory	study plan
2022/2023	(P6209) Systems Engineering and Informatics	(6209V025) System Engineering and Informatics	K	English	Ostrava	Choice-compulsory	study plan
2021/2022	(P6209) Systems Engineering and Informatics	(6209V025) System Engineering and Informatics	P	English	Ostrava	Choice-compulsory	study plan
2021/2022	(P6209) Systems Engineering and Informatics	(6209V025) System Engineering and Informatics	K	English	Ostrava	Choice-compulsory	study plan
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 name	Academic year	Form of study	Study language	Year	W	S	Type of block	Block owner

Assessment of instruction

Předmět neobsahuje žádné hodnocení.