Gartner Research

Data Modeling to Support End-to-End Data Architectures

Published: 08 February 2019

ID: G00377645

Analyst(s): Joe Maguire

Summary

The complexity of data architecture demands deft data design. Technical professionals must model each data artifact, but different ones require different modeling techniques. Modelers must coordinate these techniques and retain one — conceptual data modeling — for gathering requirements from users.

Table Of Contents

Analysis

  • Use Cases for Data Modeling
    • Conceptual Data Models
    • Business
    • Data Persistence
    • Runtime
    • Data Integration
    • End-User Representations
  • Strengths
  • Weaknesses

Guidance

  • Create Appropriately Detailed Conceptual Models
    • Do Not Equate “Conceptual” With “Enterprise-Scale”
    • Do Not Misuse Generalization
    • Include Attributes
    • Deliver Something Useful as Soon as Possible
  • Consult Multiple Subject Matter Experts
    • Manage the Provincial View of Data
    • Where Possible, Cede Control to Users
  • Separate Solution Design From Problem Description
    • Within Limits, Relational Can Approximate Conceptual
    • NoSQL Design Is Not Conceptual

Gartner Recommended Reading

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