157-0911/02 – Database systems (DS)

Gurantor departmentDepartment of Systems EngineeringCredits10
Subject guarantorprof. Ing. Dušan Marček, CSc.Subject version guarantorprof. Ing. Dušan Marček, CSc.
Study levelpostgraduateRequirementChoice-compulsory
YearSemesterwinter + summer
Study languageCzech
Year of introduction2012/2013Year of cancellation2012/2013
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
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 yearProgrammeField of studySpec.ZaměřeníFormStudy language Tut. centreYearWSType 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 nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner