Advanced Database Systems

Joint topics

27h 5min

Understanding Understanding database analytics in a practical SQL manner (8%)
Understanding Understand basic concepts of data streaming systems (8%)
Understanding Understanding different optimization techniques (8%)
Understanding Understanding indexing and partitioning techniques (8%)
Applying Applying different optimization techniques in complex database applications (8%)
Applying Temporal data management (8%)
Analysing Analyze conflicts in active databases (8%)
Creating Implement a basic data streaming system using a given data streaming system (8%)
Creating Creating database analysis using a specific data model (8%)
Creating Implement an active database using a given database management system (8%)
Data Streaming

The unit will cover data streaming managements systems and provide examples of usage.


Acquisition
1 Introduction
Introductory lecture on data streaming system and applications.

1h 30min
Practice
2 Environment setup
Students will install the appropriate data streaming system (for example Kafka) and setup the necessary environment.

30 min
Practice
3 Examples
Students will go trough prepared examples and test each example on their environment.

30 min
Discussion
4 Question & Answer Session
Students will be able to ask questions about the installation, examples, exercises.

30 min
Assessment
5 Exercise
Students will solve a preprared exercise that builds upon the given theory and examples.

2h 0min
5
Database Optimization Techniques

Applying different optimization techniques. Indices. Horizontal and vertical partitioning.


Acquisition
1 Logical optimization techniques
Learning about different optimization techniques and how to apply them.

45 min
Acquisition
2 Overview of PL/SQL
Lite overview of PL/SQL concepts

35 min
Practice
3 Optimization techniques practice
Optimization techniques practice

60 min
Discussion
4 Optimization techniques discussion
Optimization techniques discussion

30 min
Assessment
5 Mini test
Mini test about covered topics in lectures

10 min
5
Indexing and partitioning

Indexing and partitioning


Acquisition
1 Indexing
Getting to know different types of indices.

45 min
Acquisition
2 Partitioning
Horizontal and vertical partitioning.

35 min
Practice
3 Indexing and partitioning practice
Indexing and partitioning practice

60 min
Discussion
4 Indexing and partitioning discussion
Discussion about indexing and partitioning

30 min
Assessment
5 Mini test - Copy
Mini test about covered topics in lectures

10 min
5
Temporal databases

Date and Time management


Acquisition
1 Data type specification
Date, Timestamp, Interval + variants across database systems

20 min
Acquisition
2 Functions related to the date management
Functions and packages dealing with the Date and Time management, focusing on the SYSDATE, SYSTIMESTAMP and client perspective

30 min
Acquisition
3 Duration management + interval
Modeling duration using Interval, explicit definition, transformations and relationships

20 min
Discussion
4 Time zone reflection + cloud
Cloud management, migrations with emphasis on the time zone reflection, region management

40 min
Discussion
5 Question & Answer Session
Students will be able to ask questions about the Date and Time management

10 min
Practice
6 Date and time management lab
Implementation (lab)

40 min
Assessment
7 NLS parameter impacts
National Language Support parameters - language, formats, territorial parameters

30 min
Investigation
8 Own study and implementation

2h 0min
Assessment
9 Mini test
Mini test about covered topics in lectures

10 min
5
Active Databasess
Acquisition
1 Introduction to active databases

10 min
Acquisition
2 Events, actions and transactions

30 min
Acquisition
3 Production rules and triggers

30 min
Acquisition
4 Conflicts in active databases

20 min
Practice
5 Implementing active databases in SQL

45 min
Assessment
6 Exercise
Students will solve a preprared exercise that builds upon the given theory and examples.

2h 0min
5
Database analytics
Acquisition
1 Data warehouses, analytical databases
Principles of data warehousing, ETL

40 min
Acquisition
2 Database analytics - analytical functions + dynamic windows
Aggregate and analytical functions, principles, dynamic windows

60 min
Practice
3 Practical examples of database analytics
Practical examples - race results, house building, managing markets

60 min
Discussion
4 Database analytics - discussions
Q&A

20 min
Practice
5 Processing and analysing data from the student source

1h 30min
5
Investigation
6 Own study and implementation

2h 0min