Abstract:Relational Database Management Systems designed for Online Analytical Processing (RDBMS-OLAP) have been foundational to democratizing data and enabling analytical use cases such as business intelligence and reporting for many years. However, RDBMS-OLAP systems present some well-known challenges. They are primarily optimized only for relational workloads, lead to proliferation of data copies which can become unmanageable, and since the data is stored in proprietary formats, it can lead to vendor lock-in, restricting access to engines, tools, and capabilities beyond what the vendor offers. As the demand for data-driven decision making surges, the need for a more robust data architecture to address these challenges becomes ever more critical. Cloud data lakes have addressed some of the shortcomings of RDBMS-OLAP systems, but they present their own set of challenges. More recently, organizations have often followed a two-tier architectural approach to take advantage of both these platforms, leveraging both cloud data lakes and RDBMS-OLAP systems. However, this approach brings additional challenges, complexities, and overhead. This paper discusses how a data lakehouse, a new architectural approach, achieves the same benefits of an RDBMS-OLAP and cloud data lake combined, while also providing additional advantages. We take today's data warehousing and break it down into implementation independent components, capabilities, and practices. We then take these aspects and show how a lakehouse architecture satisfies them. Then, we go a step further and discuss what additional capabilities and benefits a lakehouse architecture provides over an RDBMS-OLAP.

Architecture of an Open-Sourced, Extensible Data Warehouse Builder: InterBase 6 Data Warehouse Builder (IB-DWB)

Data Warehouse Benchmarking with DWEB

DWEB: A Data Warehouse Engineering Benchmark

Benchmarking data warehouses

The Architectures of Engineering Database Management Systems

Toward Spreadsheet-Based Data Management in Distributed Enterprise Environment

Multi-database Middleware System Based on SEDA

The Data Lakehouse: Data Warehousing and More

Integration of Data Warehouse into Knowledge-based System on Construction Management Decision Making

An Architecture Framework for Complex Data Warehouses

DICOM Data Warehouse: Part 2

Data Lakehouse: Next Generation Information System

On the issues of building Information Warehouses

Building Web Information Integration Systems

Implementation of An Open and Extensible SDAI System

Conception d'un banc d'essais décisionnel

A Data Warehouse Design for a Typical University Information System

ORDBase : A Common Architecture for Web Ontologies , Rules , and Data

Intelligent Implementation Processor Design for Oracle Distributed Databases System

The End of an Architectural Era for Analytical Databases

Prototype for Extended XDB Using Wiki