Definition of Logical Data Warehouse

What does is it mean and how is it used

What is Logical Data Warehouse (LDW)?

A Logical Data Warehouse (LDW) is an architectural layer that sits on top of the usual data warehouse stores (silos) of persisted data and provides several mechanisms for viewing data without relocating and transforming data ahead of view time.

It has the advantage of providing data that is fresher and not limited to the format used in the traditional data warehouse although it does require the resources of a powerful analytic engine.

Why use a Logical Data Warehouse?

A logical layer that allows you to see all the data in your data warehouse and elsewhere across your business without moving or needing to transform any data before you can do this – so it removes the hassle of having to consolidate critical data that’s scattered across silos. It also has the advantage of enabling you to access more up-to-the-minute data and doesn’t limit this to the format used in the traditional data warehouse – although it does require the resources of a powerful analytic engine.

Did you know?

Gartner invented the term in 2011 when considering technical architectures of the future that were designed to incorporate and organize all the data held within an organization.

Latest Logical Data Warehouse Insights

Predictions 2019: Data analytics trends to watch

It is important for all businesses to be aware of the current trends in order to keep up with the competition. Read about our prediction of 2019’s technology trends from data-centricity to Natural language processing.

Read about 2019’s tech trends >

Choosing the best AWS data warehouse

If you’re using Amazon Web Services you already know the sound business reasons for using the cloud for data warehousing. But all data warehouses are not built the same. In this white paper a number of factors of AWS Redshift and Exasol are compared, including speed, cost, concurrency, load times, and support.

Explore how Redshift compares to Exasol >

Put your data warehouse to work

Even if you have already invested time and resources in a data warehouse it might be the case that your business questions are not getting answered. Learn more about how Exasol can help your data warehouse to become the very heart of your business.

Read more on Data Warehousing >

Interested in learning more?

Whether you’re looking for more information about our fast, in-memory database, or to discover our latest insights, case studies, video content and blogs and to help guide you into the future of data.