Data Warehouse Architectures and Technologies: Solutions and Still Open Issues

In this course, we will discuss fundamental data warehouse architectures, followed by modeling data warehouse schemas and data warehouse internals. Ultimately it will also be about alternatives to traditional data warehouses, namely data lakes and data meshes. In particular, the course will cover the following topics:
Data integration challenges and architectures
Data warehouse architectures
Challenges in designing data integration processes
Evolution of data sources and its impact on integration processes: research challenges
Optimizing the performance of process integration processes: research and industrial approaches
Data quality issues: data cleansing
Entity matching: Standard processing pipeline
Entity matching: algorithms and techniques
Research challenge: automatic entity matching
Data Lake and data mesh