456-0528/02 – Information Systems Development (TIS)
Gurantor department | Department of Computer Science | Credits | 6 |
Subject guarantor | prof. Ing. Michal Krátký, Ph.D. | Subject version guarantor | prof. Ing. Michal Krátký, Ph.D. |
Study level | undergraduate or graduate | Requirement | Compulsory |
Year | 3 | Semester | summer |
| | Study language | Czech |
Year of introduction | 2007/2008 | Year of cancellation | 2009/2010 |
Intended for the faculties | FEI | Intended for study types | Bachelor |
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
Other requirements
Prerequisities
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
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction