Gartner Research

Adopt Logical Data Warehouse Architectural Patterns to Mature Your Data Warehouse

Published: 01 October 2015

ID: G00276720

Analyst(s): Mei Selvage


Every data warehouse, whether new or old, should be built on or evolving toward an LDW to support business intelligence and analytics. This research provides proven LDW architectural patterns and targeted action plans to help you reap a high return on your LDW investment.

Table Of Contents


  • The Importance of Shared Data Access
  • Common Components
    • Data Integration
    • Delivery and Presentation
    • Information Governance
  • The LDW: Repository Style
    • Data Sources
  • The LDW: Data Virtualization Style
    • Data Sources
  • The LDW: Distributed Process Style
    • Data Sources
  • Architectural Considerations
    • Deployment
    • Comparing the ODS, Sandbox and Data Lake
  • Strengths
  • Weaknesses


  • Beginner: Build a Sound Data Platform
  • Intermediate: Evolve Traditional Data Warehousing Toward the LDW
  • Advanced: Optimize the LDW to Support Digital Business

The Details

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.