157-0328/04 – Database Systems (DBS)

Gurantor department	Department of Systems Engineering	Credits	5
Subject guarantor	doc. Ing. Ludmila Kalužová, CSc.	Subject version guarantor	doc. Ing. Ludmila Kalužová, CSc.
Study level	undergraduate or graduate	Requirement	Choice-compulsory
Year	1	Semester	winter
		Study language	Czech
Year of introduction	2010/2011	Year of cancellation	2012/2013
Intended for the faculties	EKF	Intended for study types	Follow-up Master

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

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 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 (45)	51
Exercises evaluation	Credit	45	23
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.	Spec.	Zaměření	Form	Study language	Tut. centre	Year	W	S	Type 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 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í.