Gartner Research

The Structured Components of the Logical Data Warehouse: Enterprise Warehouse, Mart, Hub and ODS

Summary

The traditional data warehouse is alive and well. It is used stand-alone or as an essential component of the LDW. The data warehouse mission remains the same, but its implementation has changed. Data and analytics technical professionals responsible for data management should continue to use DWs.

Published: 16 October 2019

ID: G00383909

Analyst(s): Henry Cook

Table Of Contents

Analysis

  • Essential Components for Handling Structured Data
  • Summary of the Data Warehousing Mission vs. Implementation
  • Extensions to the Structured Data Stores and Servers
  • Relational Massively Parallel Processing (MPP)
  • Column Stores and In-Memory Column Stores
  • Data Models
    • Higher Normal Forms — Third Normal Form (3NF) and Beyond
    • Dimensional Modelling
    • Data Vault Modelling
    • Schema on Read
    • Transformation on the Fly and Use of Views
  • Handling Less Structured Data
    • Textual Data
    • Optimization of Data Processing and Data Formatting
  • Autonomous Data Warehousing
  • Machine Learning Within and Alongside the Data Warehouse
  • Hardware Acceleration
  • Data Warehouse Automation
  • Automated Data Mapping
  • Automated Data Profiling
  • Automate Data Warehouse Testing
  • Data Marts
  • The Operational Data Store (ODS)
  • Augmented Transactions — aka HTAP
  • Data Hubs
  • Cloud Data Warehouse
  • Any Data, Anywhere, Any Language
  • Workloads Move — Bring Engine to Data or Data to Engine
  • Strengths
  • Weaknesses

Guidance

The Details

  • Data Warehouse Mission vs. Implementation

Gartner Recommended Reading

Already a Gartner client?

Become a Client

This research is reserved for paying clients. Speak with a Gartner specialist to learn how you can access this research as a client, plus insights, advice and tools to help you achieve your goals.

Contact Information

All fields are required.

By clicking the "Submit" button, you are agreeing to the Gartner Terms of Use and Privacy Policy.

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