Gartner Research

Upgrade the Enterprise Data Warehouse Architecture With Hadoop

Published: 09 April 2015

ID: G00275430

Analyst(s): Svetlana Sicular


Hadoop is becoming an accepted component of an enterprise information architecture and infrastructure. This research explains to information management professionals the strengths and weaknesses of Hadoop in complementing an enterprise data warehouse, taking a step toward building the LDW.

Table Of Contents


  • Upgrade the EDW With Hadoop to Build the LDW
  • Drivers for Implementing Hadoop
  • Bimodality of the EDW and Hadoop
    • The EDW as Mode 1: Marathon
    • Hadoop as Mode 2: Sprint
  • How Hadoop Complements the EDW
  • Implications of the New Architecture on Your Current EDW
    • Your Data Warehouse Still Has an Important Role
    • Hadoop Affects Design Principles of Operational Data Stores and Data Marts
  • Strengths
  • Weaknesses


  • Develop Governance for Bimodal IT
  • Evolve Your Architecture on a Use-Case-by-Use-Case Basis
  • Introduce a Data Lake If Necessary, but First, Define What It Is
  • Make Choices for the Gray Areas
  • Pace Your Hadoop Adoption
  • Grow Your Internal Skills

The Details

  • Why Do Organizations Use Hadoop With the EDW?
    • Cost Reduction
    • A More Comprehensive Data Management Analytic Solution
    • Very Large Files
    • Flexibility
  • How Can Hadoop Complement the EDW?
    • Typical Hadoop Components for Complementing a DW
    • Data Integration Frameworks
    • ETL Is the Most Prominent Pattern for Integrating Hadoop and the EDW
    • Data Ingest Methods
    • Propagating Analytical Models, Data and Metadata Is the Greatest Challenge
    • What to Offload
    • Query Capability Is the Most Common Requirement
    • An Archive Is Live and Active

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.