Course detail

Integration of information systems using post-relational database platforms

FP-IISPAcad. year: 2022/2023

Learning outcomes of the course unit The subject acquaints students with the problems of integration of several information systems using the Intersystems platform - the Caché object database and the Ensemble superstructure. The course focuses on the practical handling of these products as tools for the integration of enterprise information systems. Students will get acquainted with the basics of object databases, system logic and practical solutions.

Language of instruction

Czech

Number of ECTS credits

Mode of study

Not applicable.

Guarantor

doc. Ing. Miloš Koch, CSc.

Department

Institute of Informatics (ÚI)

Learning outcomes of the course unit

Students will understand the issue of integrating more information systems. I will be able to analyze the problem and create the concept of system interconnection. They will learn to design Ensemble applications that can process input data from multiple sources. They will have the ability to practically solve the tasks of interconnecting multiple systems.

Prerequisites

The student must know the basics of data and functional modeling, the basics of relational databases and work with them.

Co-requisites

Not applicable.

Planned learning activities and teaching methods

Lecture with practical examples of solutions and consultations on students' own solutions.

Assesment methods and criteria linked to learning outcomes

In the defense of the project, the student is assessed on the basis of the understanding of the problem and the relevance of the proposed solution.

Course curriculum

Integration of information systems
Object and post relational databases
The Caché database
Design of application logic
The Ensemble tool
Services and Input Adapters
Processes and algorithms of the solution
Operation
Business Intelligence
The Deep See tool

Work placements

Not applicable.

Aims

Learning outcomes of the course unit The aim of the course is to teach the students to understand the interconnection of information systems at company level or between them based on the metasystem. They will acquire basic theoretical and practical knowledge in this field.

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

During the course the students prepare the assigned task, which they present at the end. Work on the project is continuously consulted and controlled.

Recommended optional programme components

Not applicable.

Prerequisites and corequisites

Not applicable.

Basic literature

Kirsten a kol. Caché - databáze postrelačního typu a tvorba aplikací. Brno, Computer Press 2005 (CS)

Recommended reading

Not applicable.

Classification of course in study plans

  • Programme BAK-MIn-D Bachelor's

    branch BAK-MIn , 2 year of study, summer semester, elective

  • Programme MGR-SI Master's

    branch MGR-IM , 1 year of study, summer semester, elective

Type of course unit

 

Exercise

26 hod., compulsory

Teacher / Lecturer

doc. Ing. Miloš Koch, CSc.

Syllabus

Výuka probíhá prakticky na počítačích, na příkladech

- problematika intergrace více systémů
- popis filozofie Intersystems
- objektové databáze - princip
- databáze Caché
- řídící centrum - Ensemble
- Operace
- Procesy
- Příklady
- DeepSee - business intelligence