460-4061/01 – Database and Information Systems II (DAIS II)

Gurantor departmentDepartment of Computer ScienceCredits6
Subject guarantordoc. Ing. Michal Krátký, Ph.D.Subject version guarantordoc. Ing. Michal Krátký, Ph.D.
Study levelundergraduate or graduateRequirementOptional
Year1Semesterwinter
Study languageCzech
Year of introduction2013/2014Year of cancellation2014/2015
Intended for the facultiesFEIIntended for study typesFollow-up Master
Instruction secured by
LoginNameTuitorTeacher giving lectures
BED157 Ing. Pavel Bednář
KRA28 doc. Ing. Michal Krátký, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Credit and Examination 2+2
Combined Credit and Examination 14+0

Subject aims expressed by acquired skills and competences

A student knows up-to-date methodologies, methods, and tools for information system development, especially physical database design and testing of the data layer, and he is able to apply these knowledges during a real implementation of information systems. Moreover, he can describe some extended database technologies such as date warehouses, business intelligence, spatial DBMS, full-text options of DBMS, XML DBMS, and distributed DBMS.

Teaching methods

Lectures
Tutorials
Project work

Summary

The content of the first part includes physical database design, design and implementation of the data layer, and testing of the data layer. During practices, students design and implement a simple information system from the data and functional analysis, implementation of the data layer to testing of the data layer. In the second part of semester, some extended database technologies such as date warehouses, business intelligence, spatial DBMS, full-text options of DBMS, XML DBMS, and distributed DBMS. During practices, student utilize an extended database technology in their project.

Compulsory literature:

H. Garcia-Molina, J. D. Ullman, J. Widom: Database Systems: The Complete Book (2nd Edition). Prentice Hall; 2 edition (June 15, 2008).

Recommended literature:

S. S. Lightstone, T. J. Teorey (Author), T. Nadeau: Physical Database Design, 1st Edition. Morgan Kaufmann; 4th edition (April 4, 2007).

Way of continuous check of knowledge in the course of semester

The semestral project is checked out during every practice.

E-learning

Další požadavky na studenta

Good programming skills.

Prerequisities

Subject codeAbbreviationTitleRequirement
460-2013 DAIS Database and Information Systems Recommended
460-2036 DBS Database Systems Recommended

Co-requisities

Subject has no co-requisities.

Subject syllabus:

Lectures: 1. Introduction, data storage, RAID 2. Physical Database Design 3. Performance testing of data layer 4. Data Warehouses 5. Business Intelligence 6. Spatial DBMS 7. XML DBMS, XML query languages 8. Full-text extensions of DBMS 9. Distributed DBMS Practices: 1. Data and functional analysis 2. Object-Relational Mapping (ORM) 3. Physical database design 4. Performance testing of data layer 5. The first part of the semestral project 6. Data Warehouses, Business Intelligence 7. Spatial DBMS 8. XML DBMS, XML query languages 9. Full-text extensions of DBMS 10. The second part of the semestral project

Conditions for subject completion

Full-time form (validity from: 2013/2014 Winter semester, validity until: 2014/2015 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Exercises evaluation and Examination Credit and Examination 100 (100) 51
        Exercises evaluation Credit 45 (45) 24
                Project 1 Project 20  11
                Project 2 Project 25  13
        Examination Examination 55  27
Mandatory attendence parzicipation:

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
2014/2015 (N2647) Information and Communication Technology (2612T025) Computer Science and Technology P Czech Ostrava 1 Optional study plan
2014/2015 (N2647) Information and Communication Technology (2612T059) Mobile Technology P Czech Ostrava 1 Optional study plan
2014/2015 (N2647) Information and Communication Technology (2612T025) Computer Science and Technology K Czech Ostrava 1 Optional study plan
2014/2015 (N2647) Information and Communication Technology (2612T059) Mobile Technology K Czech Ostrava 1 Optional study plan
2013/2014 (N2647) Information and Communication Technology (2612T025) Computer Science and Technology P Czech Ostrava 1 Optional study plan
2013/2014 (N2647) Information and Communication Technology (2612T025) Computer Science and Technology K Czech Ostrava 1 Optional study plan
2013/2014 (N2647) Information and Communication Technology (2612T059) Mobile Technology P Czech Ostrava 1 Optional study plan
2013/2014 (N2647) Information and Communication Technology (2612T059) Mobile Technology K Czech Ostrava 1 Optional study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner