Design and Evaluation of a Lakehouse Architecture Integrating Data Lakes and Data Warehouses

Abstract

The increasing volume and complexity of organizational data have exposed the limitations of traditional data management platforms in supporting modern analytical workloads. While data warehouses provide high-performance querying, strong governance, and structured data management, they are less suitable for handling diverse and rapidly growing datasets. Conversely, data lakes offer scalable and cost-effective storage for structured, semi-structured, and unstructured data but often face challenges related to data quality, governance, and query performance. Lakehouse architecture has emerged as a unified approach that integrates the strengths of data lakes and data warehouses to support both business intelligence and advanced analytics on a single platform. This study aims to design and evaluate a Lakehouse architecture integrating data lakes and data warehouses. The proposed architecture will be implemented using cloud-native technologies and evaluated through standardized analytical workloads. Performance will be assessed using metrics including query execution time, throughput, scalability, storage efficiency, resource utilization, and cost efficiency. Comparative analysis will be conducted against traditional data lake and data warehouse architectures to determine the effectiveness of the proposed solution. The study is expected to demonstrate that the Lakehouse architecture provides a balanced platform that combines the scalability and flexibility of data lakes with the reliability, governance, and analytical performance of data warehouses. The findings will contribute to the advancement of cloud-native data management and provide practical guidance for organizations seeking efficient and scalable analytical platforms.