Gartner Research

How to Design and Implement the Next-Generation Data Warehouse

Published: 24 January 2013

ID: G00238865

Analyst(s): Mei Selvage

Summary

The Nexus of Forces presents both challenges and opportunities for a traditional data warehouse (TDW). Architects need to evolve the TDW into its next generation — a logical data warehouse (LDW). This document provides practical guidelines to ensure successful design and implementation of an LDW.

Table Of Contents

Synopsis

Analysis

  • Evolving the TDW Into the LDW
    • Nexus of Converging Forces
    • Outdated TDW Assumptions and Practices
    • The Cost of Doing Nothing
    • Benefits of the LDW
  • The LDW Reference Framework
  • The LDW Reference Architecture
  • The LDW Architecture Guidelines
    • Match the LDW Styles to the Data Structure
    • Intelligent Trade-Off Between Optimization and Reusability
    • Integrate Data Using a Toolbox Approach
  • LDW Implementation Road Map
    • Step 1: "Learn" — 90 Days
    • Step 2: "Plan" — 90 Days
    • Step 3: "Act" — 180-Day Iterations

The Details

  • An LDW Case Study
    • Guideline 1: Match the Architecture to the Data Sources
    • Guideline 2: Integrate Data Using a Toolbox Approach
    • Guideline 3: Intelligent Trade-Off Between Optimization and Reusability

Conclusion

Recommended Reading

Notes

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