157-0328/03 – 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 graduateRequirementCompulsory
Year1Semesterwinter
Study languageCzech
Year of introduction2007/2008Year 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

Other requirements

************************************************************

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: 1960/1961 Summer semester, validity until: 2011/2012 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of pointsMax. počet pokusů
Exercises evaluation and Examination Credit and Examination 100 (100) 51 3
        Exercises evaluation Credit 45 (45) 0 3
                Project Project 45  0 3
        Examination Examination 55 (55) 0 3
                Oral Oral examination 55  0 3
Mandatory attendence participation:

Show history

Conditions for subject completion and attendance at the exercises within ISP:

Show history

Occurrence in study plans

Academic yearProgrammeBranch/spec.Spec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2012/2013 (N6209) Systems Engineering and Informatics (6209T025) System Engineering and Informatics (00) System Engineering and Informatics P Czech Ostrava 1 Compulsory study plan
2011/2012 (N6209) Systems Engineering and Informatics (6209T025) System Engineering and Informatics (00) System Engineering and Informatics P Czech Ostrava 1 Compulsory study plan
2011/2012 (N6209) Systems Engineering and Informatics (1802T001) Applied Informatics P Czech Ostrava 1 Compulsory study plan
2010/2011 (N6209) Systems Engineering and Informatics (1802T001) Applied Informatics P Czech Ostrava 1 Choice-compulsory study plan
2010/2011 (N6209) Systems Engineering and Informatics (6209T025) System Engineering and Informatics (00) System Engineering and Informatics P Czech Ostrava 1 Compulsory study plan
2009/2010 (N6209) Systems Engineering and Informatics (1802T001) Applied Informatics P Czech Ostrava 1 Choice-compulsory study plan
2009/2010 (N6209) Systems Engineering and Informatics (6209T025) System Engineering and Informatics (00) System Engineering and Informatics P Czech Ostrava 1 Compulsory study plan
2009/2010 (N6209) Systems Engineering and Informatics (6209T025) System Engineering and Informatics P Czech Ostrava 1 Compulsory study plan
2008/2009 (N6209) Systems Engineering and Informatics (6209T025) System Engineering and Informatics P Czech Ostrava 1 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner

Assessment of instruction



2012/2013 Winter
2011/2012 Winter
2009/2010 Winter