Databases for Process Control (FSI-VDC)

Academic year 2025/2026
Supervisor: Ing. Jiří Kovář, Ph.D.  
Supervising institute: ÚAI all courses guaranted by this institute
Teaching language: Czech
Aims of the course unit:

The aim of the course is to introduce students to basic database technologies for effective design and management of applications with large amounts of data in the Internet environment.
The course is designed to introduce students to the theoretical aspects of database application design and implementation in an Internet environment, including the programming techniques involved. They will be able to create an application for efficient management of large amounts of data and also learn how to use cloud services.
Learning outcomes and competences:
 
Prerequisites:

To study database systems, basic knowledge of algorithm development is sufficient.
Course contents:

The course is an introduction to database systems.
Data processing, redundancy and inconsistency, integrity, confidentiality, multi-user access to data. Index-sequential data organization. Integrity constraints for relationships.
Database system architecture, data models. E-R model, relational algebra, query language of relational algebra.
Theoretical aspects of information systems design. Functional dependencies, normal forms of relations, decomposition theorem.
SQL query language.
Data security.
Clouds and grids.
NoSQL databases.
MongoDB. ElasticSearch. Redis/Valkey.
Teaching methods and criteria:
 
Assesment methods and criteria linked to learning outcomes:

A condition for credit is the implementation of a non-trivial database application using appropriate resources.
The exam is written or electronic. Students demonstrate knowledge of data structure design, relational algebra, SQL and programming.
As the exercises are compulsory, the instructor will check attendance at regular intervals. In case of an excused absence, the student will be given examples to work on independently so that he/she can master the missed material.
Controlled participation in lessons:
 
Type of course unit:
    Lecture  13 × 2 hrs. optionally                  
    Computer-assisted exercise  13 × 2 hrs. compulsory                  
Course curriculum:
    Lecture

Lectures:
1. Definition of the subject, study literature. Database paradigm. Data classification (physical classification, index files). Disadvantages of classical file processing. Database systems, DDL and DML languages. Database system architecture. Physical and logical independence. Data models - relation to JSON and XML.
2. Relational algebra, basic operations, relational algebra as a query language. T-SQL statements - SELECT.
3. Design of data structures. Normal forms of relations. Index. Aggregation functions. Composite aggregation key.
4. SQL. Subqueries. Multiple openings of the same table, 1:N sessions within the same table, examples of use. Nested aggregation, query implementation by SQL query sequences.
5. SQL. Counting with NULL value. Expression of existential and universal quantifier in SQL. Cross query. Action queries. Definitional queries.
6. No-SQL databases.
7. MongoDB. BSON. JSON.
8. Key-Value database. Redis/Valkey.
9. Key-Value database. Redis/Valkey.
10. No-scheme database - ElasticSearch.
11. No-scheme database - ElasticSearch.
12. Graph databases - Neo4j.
13. Implementation models for using multiple database types by application type
    Computer-assisted exercise

1. The most common software implementation methods for working with databases, Entity Framework
2. Implementing a database resource in a REST application
3. Ensuring the validity of the data source from an implementation point of view
4. Using database procedures for data access, advanced querying
5. Methods of integrating multiple database sources
6. Database modification and update
7. - 8. Implementation of No-SQL database for unstructured data
9. -10. Implementation of an in-memory database for processing data flows
11. - 12. Demonstration of ElasticSearch/Neo4j implementation.
13. Project consultation.
Literature - fundamental:
1. Connoly, T.M. and Begg, C.E.: Database Systems : A Practical Approach to Design, Implementation and Management. Pearson Education, 2004 (4th edition).
2. Date, C.J.: An Introduction to Database Systems. Addison Wesley, New York, 2003 (8th edition).
3. Fortier, P.J.: Database Systems Handbook. McGraw-Hill, 1997.
4. Lacko, L.: SQL. Hotová řešení pro SQL Server, Oracle a MySQL. Computer Press, Brno, 2003.
7. Pratt, J.P.: A Guide to SQL. Course Technology, 2003 (6th edition).
8. Ullman, L.: PHP and MySQL for Dynamic Web Sites. Pearson Education, 2003 (český překlad: PHP a MySQL: Názorný průvodce tvorbou dynamických www stránek. Computer Press, Brno, 2004).
10. Williams, H.E. and Lane, D.: Web Database Applications with PHP and MySQL. O’Reilly, 2002 (český překlad: Programujeme webové aplikace pomocí PHP a MySQL. Computer Press, Praha, 2002).
11. Holubová, I, Kosek, J., Minařík, K., Novák, D.: Big Data a NoSQL databáze. Grada, Praha, 2015.
12. Velte, T. A., Velte, T. J., Elsenpeter, R: Cloud Computing. A Practical Approach. McGraw Hill, New York, 2010.
13. Stanoevska-Slabeva, K., Wozniak, T., Ristol, S. (eds.): Grid and Cloud Computing. A Business Perspective on Technology and Applications. Springer-Verlag, Berlin, 2010.
14. Redmond, E., Wilson, J. R.: Seven Databases in Seven Weeks. A Guide to Modern Databases and the NoSQL. Movement-Pragmatic Bookshelf, 2012.
Literature - recommended:
1. Date, C.J.: An Introduction to Database Systems. Addison Wesley, New York, 2003 (8th edition).
2. Elmasri, R., Navathe, S.B.: Fundamentals of Database Systems. Addison Wesley, 4th edition, 2003.
The study programmes with the given course:
Programme Study form Branch Spec. Final classification   Course-unit credits     Obligation     Level     Year     Semester  
B-STR-P full-time study AIŘ Applied Computer Science and Control -- Cr,Ex 6 Compulsory 1 3 W
B-MAI-P full-time study --- no specialisation -- Cr,Ex 6 Compulsory-optional 1 3 W
N-AIŘ-P full-time study --- no specialisation -- Cr,Ex 6 Compulsory 2 2 W