The main topics of the course are:
1. information systems and operational databases, classification and description of information systems in terms of volume of processed data, technology OLTP, OLAP, data warehouse environment;
2. the data warehouse modeling phase and its description, data structures and models;
3. multidimensional data analysis, dimension, multidimensional databases, data models at internal level;
4. SQL expansion towards solving descriptive tasks, creation and realization of intensive queries, data visualization, possibilities of using data warehouses in the concept of large data, queries on association rules;
5. internal data organization, use of B-trees, bitmap indexes and join indexes.
1. information systems and operational databases, classification and description of information systems in terms of volume of processed data, technology OLTP, OLAP, data warehouse environment;
2. the data warehouse modeling phase and its description, data structures and models;
3. multidimensional data analysis, dimension, multidimensional databases, data models at internal level;
4. SQL expansion towards solving descriptive tasks, creation and realization of intensive queries, data visualization, possibilities of using data warehouses in the concept of large data, queries on association rules;
5. internal data organization, use of B-trees, bitmap indexes and join indexes.