Information Systems Development

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