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
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.
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.
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.