Gartner Research

Embrace Sound Design Principles to Architect a Successful Logical Data Warehouse

Published: 08 September 2014

ID: G00268536

Analyst(s): Mei Selvage

Summary

The LDW — the next-generation data warehouse — requires architectural thinking and a holistic approach that includes data, people, process and technology. This document assesses the LDW's strengths and weaknesses. It also presents six design principles and the case study of a successful LDW.

Table Of Contents

Analysis

  • The LDW Overview
  • The Critical Need to Embrace the LDW
    • Multiple Challenges to the TDW
    • The Nexus of Forces Intensifies the Challenges of the TDW
  • Separating Myth From Reality
  • Strengths
  • Weaknesses

Guidance

  • Design Principle No. 1: Create an LDW Road Map Based on the Four Pillars
  • Design Principle No. 2: Decide Appropriate LDW Styles Based on Use Cases
  • Design Principle No. 3: Integrate Data Using a Toolbox Approach
  • Design Principle No. 4: Process Data Using a Toolbox Approach
  • Design Principle No. 5: Evolve Toward a Hybrid Cloud Architecture
  • Design Principle No. 6: Apply the Separation-of-Concerns Principle

The Details

  • An LDW Case Study
    • Design Principle No. 1: Create an LDW Road Map Based on the Four Pillars
    • Design Principle No. 2: Decide Appropriate LDW Styles Based on Use Cases
    • Design Principle No. 3: Integrate Data Using a Toolbox Approach
    • Design Principle No. 4: Process Data Using a Toolbox Approach
    • Design Principle No. 5: Evolve Toward a Hybrid Cloud Architecture
    • Design Principle No. 6: Apply the Separation-of-Concerns Principle
  • Close Examination of a Popular Data Warehouse Definition

Conclusion

Gartner Recommended Reading

©2021 Gartner, Inc. and/or its affiliates. All rights reserved. Gartner is a registered trademark of Gartner, Inc. and its affiliates. This publication may not be reproduced or distributed in any form without Gartner’s prior written permission. It consists of the opinions of Gartner’s research organization, which should not be construed as statements of fact. While the information contained in this publication has been obtained from sources believed to be reliable, Gartner disclaims all warranties as to the accuracy, completeness or adequacy of such information. Although Gartner research may address legal and financial issues, Gartner does not provide legal or investment advice and its research should not be construed or used as such. Your access and use of this publication are governed by Gartner’s Usage Policy. Gartner prides itself on its reputation for independence and objectivity. Its research is produced independently by its research organization without input or influence from any third party. For further information, see Guiding Principles on Independence and Objectivity.

Already have a Gartner Account?

Become a client

Learn how to access this content as a Gartner client.