157-0911/01 – Database systems (DS)

Gurantor department	Department of Systems Engineering	Credits	0
Subject guarantor	prof. Ing. Dušan Marček, CSc.	Subject version guarantor	doc. Ing. Ludmila Kalužová, CSc.
Study level	postgraduate	Requirement	Choice-compulsory
Year		Semester	winter + summer
		Study language	Czech
Year of introduction	2010/2011	Year of cancellation	2011/2012
Intended for the faculties	EKF	Intended for study types	Doctoral

Instruction secured by
Login	Name	Tuitor	Teacher giving lectures
KAL70	doc. Ing. Ludmila Kalužová, CSc.

Extent of instruction for forms of study
Form of study	Way 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

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

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:

Conditions for subject completion

Full-time form (validity from: 2010/2011 Summer semester, validity until: 2012/2013 Summer semester)

Task name	Type of task	Max. number of points (act. for subtasks)	Min. number of points	Max. počet pokusů
Exercises evaluation and Examination	Credit and Examination	100	51
Exercises evaluation	Credit
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
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

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