Course detail

ICT integration using the post-relational database platform

FP-IISAcad. year: 2022/2023

Learning outcomes of the course unit The subject is aimed at understanding of information systems integration with each other, using Caché and Ensemble products from Intersystems. Students will acquire basic knowledge of working with object databases, will understand the work with objects. Using Ensemble, they learn how to create meta-systems that allow multiple systems to connect. During the semester, it solves a comprehensive example that demonstrates integration issues and Ensemble. The lecturers from the Czech branch of the Intersystems company participate in the course.

Language of instruction

Czech

Number of ECTS credits

3

Mode of study

Not applicable.

Learning outcomes of the course unit

Students will acquire knowledge of working with one of the major products in the field of information systems integration, which are mainly used in banking, healthcare and big data processing. Students will be able to work independently with Caché and Ensemble to create an enterprise integration platform, analyze data, and produce business management-friendly outputs.

Prerequisites

Basic knowledge of data modeling, relational data models and SQL, and the basics of algorithmization are expected.

Co-requisites

Not applicable.

Planned learning activities and teaching methods

Teaching is a combination of presentation of theoretical knowledge and its practical application on examples. In the course of the semester, students elaborate a comprehensive project under the guidance of a teacher, and gradually extend the functionality in such a way that they fix the basic concepts and procedures of the solution by repeating them.

Assesment methods and criteria linked to learning outcomes

Students are evaluated on the basis of processing a global project. The course is free, offered within all BUT study programs, and is evaluated only by credit for passing the course and submitting a full-term project.

Course curriculum

1 Introduction to Systems Integration
2 Introduction to Object Data Models
3 Introducing Caché
4 Introduction Enseble
5 Basic production scheme
6 Creating input services, adapters
7 Creating a Process
8 Creating Operations
9 Working with SQL
10 Metrics
11 Creating a Dashboard
12 Project presentation
13 Credit

Work placements

Not applicable.

Aims

Learning outcomes of the course unit The aim of the course is to understand the problems of integration of information systems and to know one of the tools used in this area. Students will be able to work with Caché and Ensemble to create an enterprise integration platform.

Specification of controlled education, way of implementation and compensation for absences

The course requires students' own interest, which is expected in the selection of the subject. Teaching is optional.

Recommended optional programme components

Not applicable.

Prerequisites and corequisites

Not applicable.

Basic literature

Intersystems. Interní školící materiály
Kolektiv autorů. Caché - Databáze postrelačního typu a tvorba aplikací. Computer Press 2005.

Recommended reading

EMBLEY, D: Object Database Development: Concepts and Principles.Addison-Wesley; 1st edition ISBN-13: 978-0201258295

Classification of course in study plans

  • Programme BAK-MIn Bachelor's 2 year of study, summer semester, elective

Type of course unit

 

Exercise

26 hod., optionally

Teacher / Lecturer

Syllabus

1 Introduction to Systems Integration
2 Introduction to Object Data Models
3 Introducing Caché
4 Introduction Enseble
5 Basic production scheme
6 Creating input services, adapters
7 Creating a Process
8 Creating Operations
9 Working with SQL
10 Metrics
11 Creating a Dashboard
12 Project presentation
13 Credit