155-0909/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	Czech
Year of introduction	2013/2014	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

Understanding of 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 database modeling and more advanced database technologies in the ORACLE environment, such as distributed database systems and data warehouses for decision support applications. Its aim is to understand these technologies, their theoretical principles, application possibilities, design and implementation.

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. KVET, M., MATIAŠKO, K. Efficiency of the relational database tuple access. Proceedings of 2019 IEEE 15th International Scientific Conference on Informatics, Informatics 2019, pp. 222-227, ISBN: 978-1-7281-3178-8. 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. ELVIS C. FOSTER, SHRIPAD GODBOLE. Database Systems. APress 2016, ISBN: 1484211928.

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. LAKSHMAN, B. Oracle and Java Development. Sams Publishing, 2002. ISBN 0-672-32117-3. ELVIS C. FOSTER, SHRIPAD GODBOLE. Database Systems. APress 2016, ISBN: 1484211928. PLUNKETT, T. Oracle Big Data Handbook (Oracle Press) (DATABASE & ERP - OMG). OraclePress, 2013, ISBN: 978-0-07-1827726-3.

Way of continuous check of knowledge in the course of semester

Exam fom 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: 2013/2014 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
2023/2024	(P6209) Systems Engineering and Informatics	(6209V025) System Engineering and Informatics	P	Czech	Ostrava	Choice-compulsory	study plan
2023/2024	(P6209) Systems Engineering and Informatics	(6209V025) System Engineering and Informatics	K	Czech	Ostrava	Choice-compulsory	study plan
2022/2023	(P6209) Systems Engineering and Informatics	(6209V025) System Engineering and Informatics	P	Czech	Ostrava	Choice-compulsory	study plan
2022/2023	(P6209) Systems Engineering and Informatics	(6209V025) System Engineering and Informatics	K	Czech	Ostrava	Choice-compulsory	study plan
2021/2022	(P6209) Systems Engineering and Informatics	(6209V025) System Engineering and Informatics	P	Czech	Ostrava	Choice-compulsory	study plan
2021/2022	(P6209) Systems Engineering and Informatics	(6209V025) System Engineering and Informatics	K	Czech	Ostrava	Choice-compulsory	study plan
2020/2021	(P6209) Systems Engineering and Informatics	(6209V025) System Engineering and Informatics	P	Czech	Ostrava	Choice-compulsory	study plan
2020/2021	(P6209) Systems Engineering and Informatics	(6209V025) System Engineering and Informatics	K	Czech	Ostrava	Choice-compulsory	study plan
2019/2020	(P6209) Systems Engineering and Informatics	(6209V025) System Engineering and Informatics	P	Czech	Ostrava	Choice-compulsory	study plan
2019/2020	(P6209) Systems Engineering and Informatics	(6209V025) System Engineering and Informatics	K	Czech	Ostrava	Choice-compulsory	study plan
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 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í.