157-0328/04 – Database Systems (DBS)

Gurantor departmentDepartment of Systems EngineeringCredits5
Subject guarantordoc. Ing. Ludmila Kalužová, CSc.Subject version guarantordoc. Ing. Ludmila Kalužová, CSc.
Study levelundergraduate or graduateRequirementChoice-compulsory
Year1Semesterwinter
Study languageCzech
Year of introduction2010/2011Year of cancellation2012/2013
Intended for the facultiesEKFIntended for study typesFollow-up Master
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 2+2

Subject aims expressed by acquired skills and competences

- To design the data structures in SQL and Oracle system environment - To create SQL and PL/SQL language application - To outline physical data structures - To compare the object relational databases and object databases - To apply triggers for creating the applications in Oracle Forms Developer product

Teaching methods

Lectures
Tutorials
Project work

Summary

The course is a continuation of Fundamentals of Database Systems course. It extends the SQL language. Practical application will be demonstrated through the Oracle system. The course specifies the features of object and object- relational database systems. It also involves the physical data structures explanation; e. g. the B trees indexes and the bitmap ones.

Compulsory literature:

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

Další požadavky na studenta

Další požadavky na studenta

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

Subject syllabus: 1.Subject introduction -Subject relations, exam requirements, literature 2.System ORACLE. -Oracle10g database product fami - Allocating and managing space for the objects -Block, extent, segment, tablespace as elements of memory organisation 3.SQL Plus. -Formatting and editing reports, Column statement, Ttitle, Btitle statement -Calculating Summary lines, Break statement, Compute statement 4.Introduction to PL/SQL language -The Declaration section, Executable commands section 5.Oracle database security. -Database system privileges-Create user, Alter user, Drop use statement -Roles and privileges, standard roles, Grant statement, Revoke statement -Database object privileges – Grant statement, revoke statement 6.Transaction Processing -Basic features, a multiversion consistency model in Oracle, Set transaction command 7.Connection to remote database, DML lock, materialized view -Sharing data, statement Lock -Creating and using database link 8.Database management system -Third generation database systems, features of the object-relational databases 9.Object features implemented in Oracle -Object data type,methods, varying arrays, nested tables 10.Object features implemented in Oracle -object tables, references, inheritance and a type hierarchy 11.Object oriented databases -ODMG object model, ODL Language 12.Physical data organisation -Types, sequential structure, indexes, pointer chain structure, hashing 13.Physical data organisation -Bitmap indexes, B-trees indexes, examples and implementation in DBMS

Conditions for subject completion

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

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
2012/2013 (N6209) Systems Engineering and Informatics (1802T001) Applied Informatics P Czech Ostrava 1 Choice-compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner