Benchmarking database architectures : Data Warehouse, Data Lake and Data Lakehouse

Database architectures have been subject to constant innovation, evolving with the appearance of new use cases, technical constraints and requirements. Of the three database structures we compare, the first to emerge was Data Warehouses, with the support of OnLine Analytical Processing (OLAP) systems, helping organizations cope with the increase in diverse applications by centralizing and supporting historical data to achieve competitive business analytics. Later, Data Lakes emerged, thanks to innovations in Cloud…