157-0328/03 – Database Systems (DBS)

Gurantor department	Department of Systems Engineering and Informatics	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	Compulsory
Year	1	Semester	winter
		Study language	Czech
Year of introduction	2007/2008	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

Additional study materials

Study supports in the EduDocs system

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 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 (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 year	Programme	Branch/spec.	Spec.	Form	Study language	Tut. centre	Year	Type 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 name	Academic year	Form of study	Study language	Year	W	S	Type of block	Block owner

Assessment of instruction

2012/2013 Winter

2011/2012 Winter

2009/2010 Winter