By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData Collective
  • Analytics
    AnalyticsShow More
    predictive analytics in dropshipping
    Predictive Analytics Helps New Dropshipping Businesses Thrive
    12 Min Read
    data-driven approach in healthcare
    The Importance of Data-Driven Approaches to Improving Healthcare in Rural Areas
    6 Min Read
    analytics for tax compliance
    Analytics Changes the Calculus of Business Tax Compliance
    8 Min Read
    big data analytics in gaming
    The Role of Big Data Analytics in Gaming
    10 Min Read
    analyst,women,looking,at,kpi,data,on,computer,screen
    Promising Benefits of Predictive Analytics in Asset Management
    11 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-23 SmartData Collective. All Rights Reserved.
Reading: Data Design Is Not Optional
Share
Notification Show More
Latest News
ai digital marketing tools
Top Five AI-Driven Digital Marketing Tools in 2023
Artificial Intelligence
ai-generated content
Is AI-Generated Content a Net Positive for Businesses?
Artificial Intelligence
predictive analytics in dropshipping
Predictive Analytics Helps New Dropshipping Businesses Thrive
Predictive Analytics
cloud data security in 2023
Top Tools for Your Cloud Data Security Stack in 2023
Cloud Computing
become a data scientist
Boosting Your Chances for Landing a Job as a Data Scientist
Jobs
Aa
SmartData Collective
Aa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Data Management > Best Practices > Data Design Is Not Optional
Best PracticesBig DataCRMData ManagementITPolicy and Governance

Data Design Is Not Optional

zamaes
Last updated: 2013/06/10 at 9:57 PM
zamaes
4 Min Read
data modeling
SHARE

data modelingThe data model is designed to enforce certain rules on the information – such as ensuring that customer identifiers are never duplicated, that no account exists without a customer to own it, and that all the information about a customer has been filled in.

data modelingThe data model is designed to enforce certain rules on the information – such as ensuring that customer identifiers are never duplicated, that no account exists without a customer to own it, and that all the information about a customer has been filled in.

By applying a disciplined approach to the creation of these structures to store information it is possible to more easily make use of it, to find what one needs and to bring information from different systems together.

This, in brief, is the practice of data modeling; and it serves a number of key functions:

More Read

understand the difference between fact tables and dimension tables

Data Driven Companies Must Understand Differences Between Fact Tables & Dimension Tables

Top 10 Powerful Data Modeling Tools For 2021
6 Amazing Cloud Based Data Modeling Tools to Try in 2017
Data Design Matters
Recommended read: The Predictioneer’s Game
  1. Helps to communicate clearly by crafting precise definitions, and drafting concise diagrams. It helps to articulate business information through the definitions that frequently fall to the modeler to prepare; through the isolation of specific business concepts as model “entities” with specified attributes and relationships to other business concepts.
  2. Protects the organization against change by systematically re-orienting business information away from the specifics of a given source system and into a more “essential” form – conforming to a standard that any new system will also have to conform – and so buffering processes that consume from the new standard against future changes.
  3. Maximizes the value of data assets by creating an inventory that makes those assets visible, assesses their quality, ensures their accuracy before allowing them to be consumed.
  4. Communicates to business users by passing on the output to business intelligence tools, business glossaries and other vehicles for dissemination of the information.
  5. Helps track deliverables against requirements by formally identifying the required data elements and applying due rigour to their placement in the target system.
  6. Provides a central point of reference for stakeholders as a repository of metadata; information about the information that the system holds, that is of use to the whole development team.
  7. When practiced with due rigour and discipline, reduces the risk to the development project by increasing efficiency, reducing the need for rework, increasing accuracy, and helping users be more productive because they gain a fundamental trust in the system.

In their excellent book on data design concepts, Data Modeling Essentials, Graeme C Simsion and Graham C. Witt, suggest that data modeling involves design, choice, and creativity.

The role of data modeling involves design because we are being asked to design the structures that will hold information most effectively.

It involves choice, because there is always more than one way to do things – although there may be a single best way.

It involves creativity, because we are asked to think laterally around problems, with the imagination and openness to see things from multiple perspectives.

Should we data model?

  • ž Data modeling is part of a deliberate, disciplined, dedicated effort to analyze, articulate and address issues.
  • ž The alternative is a hurried, haphazard, half-baked set of tables that are ill-conceived, undocumented and leave problems unchanged.

There are really only two paths to follow: one leads to a well-ordered system, the other, potentially, (possibly inevitably), to a type of chaos.

Data modeling is a critical, essential, mandatory part of the development of any information system.

(Data modeling / shutterstock)

TAGGED: data design, data modeling
zamaes June 10, 2013
Share this Article
Facebook Twitter Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

ai digital marketing tools
Top Five AI-Driven Digital Marketing Tools in 2023
Artificial Intelligence
ai-generated content
Is AI-Generated Content a Net Positive for Businesses?
Artificial Intelligence
predictive analytics in dropshipping
Predictive Analytics Helps New Dropshipping Businesses Thrive
Predictive Analytics
cloud data security in 2023
Top Tools for Your Cloud Data Security Stack in 2023
Cloud Computing

Stay Connected

1.2k Followers Like
33.7k Followers Follow
222 Followers Pin

Sign Up for Our Newsletter

Subscribe to our newsletter to get our newest articles instantly!

[mc4wp_form id=”1616″]

You Might also Like

understand the difference between fact tables and dimension tables
Big Data

Data Driven Companies Must Understand Differences Between Fact Tables & Dimension Tables

5 Min Read
data modeling tools to analyze
Modeling

Top 10 Powerful Data Modeling Tools For 2021

8 Min Read
data-modeling-tools
Modeling

6 Amazing Cloud Based Data Modeling Tools to Try in 2017

4 Min Read

Data Design Matters

3 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

ai is improving the safety of cars
From Bolts to Bots: How AI Is Fortifying the Automotive Industry
Artificial Intelligence
AI and chatbots
Chatbots and SEO: How Can Chatbots Improve Your SEO Ranking?
Artificial Intelligence Chatbots Exclusive

Quick Link

  • About
  • Contact
  • Privacy
Follow US

© 2008-23 SmartData Collective. All Rights Reserved.

Removed from reading list

Undo
Go to mobile version
Welcome Back!

Sign in to your account

Lost your password?