157-0911/01 – Database systems (DS)

Gurantor departmentDepartment of Systems EngineeringCredits0
Subject guarantorprof. Ing. Dušan Marček, CSc.Subject version guarantordoc. Ing. Ludmila Kalužová, CSc.
Study levelpostgraduateRequirementChoice-compulsory
YearSemesterwinter + summer
Study languageCzech
Year of introduction2010/2011Year of cancellation2011/2012
Intended for the facultiesEKFIntended for study typesDoctoral
Instruction secured by
LoginNameTuitorTeacher giving lectures
KAL70 doc. Ing. Ludmila Kalužová, CSc.
Extent of instruction for forms of study
Form of studyWay 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:

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.

Conditions for subject completion

Full-time form (validity from: 2010/2011 Summer semester, validity until: 2012/2013 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Exercises evaluation and Examination Credit and Examination 100  51
        Exercises evaluation Credit  
        Examination Examination  
Mandatory attendence parzicipation:

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.ZaměřeníFormStudy language Tut. centreYearWSType 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 nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner