Gartner Blog Network

Logical Data Warehouse (LDW) – Three Parallel Development Styles

by Henry Cook  |  May 23, 2017  |  Submit a Comment

I’ve recently had the opportunity to write about the Logical Data Warehouse(LDW). In the paper I describe three parallel streams rather than a single development path. The development is cyclic. Like the classic data warehouse before it, the logical data warehouse is never finished. That is because it provides a digital representation of pretty much everything that is happening in the business. Like the business itself it is constantly changing. It has to adapt to growth, acquisitions, competition, new product lines, in fact anything the business itself is subject to.

The public summary of the paper can be found here: Solution Path for Planning and Implementing the Logical Data Warehouse. To click through from there you’ll need a Gartner for Technical Professionals licence. The summary gives a brief description and an outline of the topics covered.

The paper describes the three main development styles used for analytics. Each is typically associated with the architectural elements that enable them, as illustrated in the picture below. They are:

  1. Classic data warehouse development
  2. Agile development: using marts,virtual marts, sandboxes and data virtualization
  3. Development of the data lake

The three styles of development for analytics

Much time and effort has been expended on which is ‘best’ approach. However, stepping back from this we can now see that these are not alternative development styles, but three facets of a bigger whole. Each is appropriate in the right context, and they can be used together to optimize the overall effort and the benefit obtained. That is, optimize return on investment.

During each cycle of development one, two or three of the streams are initiated and the requirements distributed among them. Collections of requirements are steered towards their most suitable mode of development. Each stream will expand a particular part of the architecture, but new servers and components will not be introduced unnecessarily. At the end of each cycle there is a wrap-up where those artifacts developed in one stream may be transferred to another if that makes sense.

For example, it may make sense that  a new piece of analysis developed quickly and simply in the agile stream may be firmed up for regular production running by transferring it into the data warehouse. As we cross the boundaries between streams this is a tripwire to remind us to put in place (or remove) the disciplines that are different between streams. Moving that new piece of agilely developed analysis into production prompts us to put in place the necessary checks on data quality, standardized metadata, restart / recovery routines etc.

Similarly, at the start of a cycle, we may make copies of artifacts from data warehouse,  to allow them to be rapidly modified in the agile stream. We’ll relax many of the checks and formal processes whilst working in the agile stream. Crossing boundaries between streams reminds us of what we need to do by explicitly switching development styles.


Solution Path for Planning and Implementing the Logical Data Warehouse

Avoid a Big Data Warehouse Mistake by Evolving to the Logical Data Warehouse Now



Additional Resources

Improve Critical Business Outcomes With Data-Driven Insights

Executive leaders can capitalize on the ability to make real-time decisions based on data to reduce costs, improve employee and customer experience, and make sales efforts more targeted.

Read Free Gartner Research

Category: data-and-analytics-strategies  data-warehouse  

Tags: data-warehouse  dw  ldw  logical-data-warehouse  

Henry Cook
Research Director
4 years at Gartner
40+ years IT Industry, 30+ in data warehousing

Henry Cook is a Research Director in Gartner for IT Leaders with particular specialization in database, data warehousing, big data, in-memory database and analytics topics. Read Full Bio

Leave a Reply

Your email address will not be published. Required fields are marked *

Comments or opinions expressed on this blog are those of the individual contributors only, and do not necessarily represent the views of Gartner, Inc. or its management. Readers may copy and redistribute blog postings on other blogs, or otherwise for private, non-commercial or journalistic purposes, with attribution to Gartner. This content may not be used for any other purposes in any other formats or media. The content on this blog is provided on an "as-is" basis. Gartner shall not be liable for any damages whatsoever arising out of the content or use of this blog.