157-0911/02 – Database systems (DS)

Gurantor department	Department of Systems Engineering	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	2012/2013	Year of cancellation	2012/2013
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

1. Understand DB technologies 2. Obtain basic knowledge of DB technology 3. Understand the theoretical principles of DB technology 4. Understand the application possibilities of DB technology, understand the application possibilities of DB technology. 5. The utilization of DBS ORCLE techniques to control databese oprations 6. Comparison of object ralational datadases with object orientier databases

Teaching methods

Lectures
Individual consultations
Project work

Summary

Object relational databases. Using object-oriented constructors in data modeling. Advanced features of data modelling. Object-oriented databases. ODMG standard. Multidimensional view on data and multidimensional modelling. Conceptual models. Organization of data at internal level. Use B-trees, bitmap indexes and their combinations as physical structures to solve star queries in a warehouse environment. Transactional processing in distributed databases. Advanced features of Oracle database. Data protection.

Compulsory literature:

1.Connolly,T., Begg,C., Holowczak,R. (2008) Business Database Systems. Addison Wesley Publ. Comp., ISBN 978-1-4058-7437-3 2.Loney, K. (2009) ORACLE DATABASE 11g: The Complete Reference. Osborne McGraw-Hill Comp., ISBN 978-0-07-159875-0

Recommended literature:

1.Loney,K., Brylan,B. (2007) Oracle Database 11g DBA Handbook Osborne McGraw-Hill Comp., ISBN 978-0071496636 2.Koch, G., Loney, K. (2004): ORACLE DATABASE 10g The Complete Reference. Osborne McGraw-Hill Comp., Emeryville California, ISBN 0-07-225352-5 3. Date, C. J., (2003) An Introduction to Database Systems. 8th edition: Addison-Wesley Publishing Company, ISBN 0-32-119784-4

Way of continuous check of knowledge in the course of semester

E-learning

Other requirements

..................................................

Prerequisities

Subject has no prerequisities.

Co-requisities

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 year	Programme	Branch/spec.	Spec.	Zaměření	Form	Study language	Tut. centre	Year	W	S	Type 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 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í.