460-2014/01 – Information Systems Development (TIS)

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 graduateRequirementChoice-compulsory
Year3Semestersummer
Study languageCzech
Year of introduction2010/2011Year of cancellation2010/2011
Intended for the facultiesFEIIntended for study typesBachelor, Follow-up Master
Instruction secured by
LoginNameTuitorTeacher giving lectures
CHO247 Ing. Peter Chovanec, Ph.D.
KRA28 doc. Ing. Michal Krátký, Ph.D.
KRI248 Ing. Filip Křižka
KRO080 doc. Ing. Pavel Krömer, Ph.D.
TIM008 Ing. Anton Timofieiev
WAL019 Ing. Jiří Walder
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Credit and Examination 2+2
Combined Credit and Examination 8+0

Subject aims expressed by acquired skills and competences

The goal of this course is to provide extended informations about database technology to bachelor students. Students will be able to access a DBMS from a host language environment, implement the data layer of an information system (with regard to the efficiency and security issues), and use other data models (like object-relational and XML data model).

Teaching methods

Lectures
Tutorials
Experimental work in labs
Project work

Summary

The goal of this course is to provide extended informations about database technology to bachelor students. Students will be able to access a DBMS from a host language environment, implement the data layer of an information system (with regard to the efficiency and security issues), and use other data models (like object-relational and XML data model). This course consists of two parts. The implementation of the data layer of an information system is included in the first part of this course. These topics will be presented for a DBMS like Oracle and SQL Server. Various data models like object-relational and XML data model will be presented in the second part of this course.

Compulsory literature:

- H. Garcia-Molina, J.D. Ullman, J.D. Widom. Database Systems: The Complete Book. Prentice Hall, 2001. - C.J. Date: An Introduction to Database Systems. Addison Wesley, 8th Edition, 2003.

Recommended literature:

- Oracle Documentation - DB2 Documentation - SQL Server Documentation - MonetDB/XQuery Documentation

Way of continuous check of knowledge in the course of semester

Students will be implemented a simple information system with regard to the implementation of the data layer.

E-learning

Další požadavky na studenta

Prerequisities

Subject codeAbbreviationTitleRequirement
456-0526 TZD Data Processing Theory Recommended
456-0527 DAIS Database and Information Systems Recommended

Co-requisities

Subject has no co-requisities.

Subject syllabus:

Syllabus of lectures: - Tools for development of a data layer of an information system (2 lectures) Access to a database; development of the data layer (ODBC, JDBC, ADO.NET); object-relational mapping - Development of the data layer Design patterns; technology - Object-relational data model (3 lectures) Standards, principles (objects, references); JDD, JMD - XML data model (3 lectures) XML data model, query languages: XPath, XQuery, XQuery Update Facility - Embedded databases - A transformation of a conceptual model to the object-relational data model - Security issues of the data layer Well-known security issues like SQL-injection Syllabus of computer exercises: - Stored procedures - Data layer implementation (ODBC, JDBC, ADO.NET, object-relational mapping) (2 practices) - Object-relational data model (3 practices) - XML data model (3 practices) - A transformation of a conceptual model to the object-relational data model

Conditions for subject completion

Full-time form (validity from: 2010/2011 Winter semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Exercises evaluation and Examination Credit and Examination 100 (55) 51
        Exercises evaluation Credit  (45)
                Test Other task type 20  10
                Project Semestral project 25  13
        Examination Examination 55  30
Mandatory attendence parzicipation:

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
2010/2011 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology K Czech Ostrava 3 Choice-compulsory study plan
2010/2011 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology P Czech Ostrava 3 Choice-compulsory study plan
2010/2011 (B2647) Information and Communication Technology (1103R031) Computational Mathematics P Czech Ostrava 3 Optional study plan
2010/2011 (B2647) Information and Communication Technology (2601R013) Telecommunication Technology P Czech Ostrava 3 Optional study plan
2010/2011 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology P Czech Ostrava 3 Optional study plan
2010/2011 (B2647) Information and Communication Technology (2612R059) Mobile Technology P Czech Ostrava 3 Optional study plan
2010/2011 (B2647) Information and Communication Technology (1103R031) Computational Mathematics K Czech Ostrava 3 Optional study plan
2010/2011 (B2647) Information and Communication Technology (2601R013) Telecommunication Technology K Czech Ostrava 3 Optional study plan
2010/2011 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology K Czech Ostrava 3 Optional study plan
2010/2011 (B2647) Information and Communication Technology (2612R059) Mobile Technology K Czech Ostrava 3 Optional study plan
2010/2011 (N2647) Information and Communication Technology (2612T025) Computer Science and Technology (01) Exchange Students P Czech Ostrava Optional study plan
2010/2011 (B2649) Electrical Engineering (2601R004) Measurement and Control Engineering (01) Exchange Students P Czech Ostrava Optional study plan
2010/2011 (B2649) Electrical Engineering (2602R014) Applied and Commercial Electronics (01) Exchange Students P Czech Ostrava Optional study plan
2010/2011 (B2649) Electrical Engineering (3901R039) Biomedical Technician (01) Exchange Students P Czech Ostrava Optional study plan
2010/2011 (B2649) Electrical Engineering (3907R001) Electrical Power Engineering (01) Exchange Students P Czech Ostrava Optional study plan
2010/2011 (B2647) Information and Communication Technology (1103R031) Computational Mathematics (01) Exchange Students P Czech Ostrava Optional study plan
2010/2011 (B2647) Information and Communication Technology (2601R013) Telecommunication Technology (01) Exchange Students P Czech Ostrava Optional study plan
2010/2011 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology (01) Exchange Students P Czech Ostrava Optional study plan
2010/2011 (B2647) Information and Communication Technology (2612R059) Mobile Technology (01) Exchange Students P Czech Ostrava Optional study plan
2010/2011 (N2647) Information and Communication Technology (1103T031) Computational Mathematics (01) Exchange Students P Czech Ostrava Optional study plan
2010/2011 (N2647) Information and Communication Technology (2601T013) Telecommunication Technology (01) Exchange Students P Czech Ostrava Optional study plan
2010/2011 (N2647) Information and Communication Technology (2612T059) Mobile Technology (01) Exchange Students P Czech Ostrava Optional study plan
2010/2011 (N2649) Electrical Engineering (2601T004) Measurement and Control Engineering (01) Exchange Students P Czech Ostrava Optional study plan
2010/2011 (N2649) Electrical Engineering (2612T015) Electronics (01) Exchange Students P Czech Ostrava Optional study plan
2010/2011 (N2649) Electrical Engineering (3901T009) Biomedical Engineering (01) Exchange Students P Czech Ostrava Optional study plan
2010/2011 (N2649) Electrical Engineering (3907T001) Electrical Power Engineering (01) Exchange Students P Czech Ostrava Optional study plan
2010/2011 (B2646) Information Technology (2612R025) Computer Science and Technology P Czech Ostrava 3 Choice-compulsory study plan
2010/2011 (B2646) Information Technology (2612R025) Computer Science and Technology K Czech Ostrava 3 Choice-compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner