Skip to Content
Information-Driven Business: How to Manage Data and Information for Maximum Advantage
book

Information-Driven Business: How to Manage Data and Information for Maximum Advantage

by Robert Hillard
August 2010
Beginner to intermediate
235 pages
6h 18m
English
Wiley
Content preview from Information-Driven Business: How to Manage Data and Information for Maximum Advantage

Chapter 7. Describing the Enterprise

Data modeling often needs to be a labor of love, with many subtle twists and turns required to completely describe a business problem. Ted Codd defined the science and art of data modeling, starting with his paper "A Relational Model of Data for Large Shared Data Banks," as introduced in Chapter 4. The techniques continued to be developed through the 1970s and 1980s by many practitioners.

It used to be believed that it was possible to write a model for the entire organization—a so-called enterprise data model. Such a model would adhere to what's technically called third normal rules of normalization. Briefly, this means that the entities are related to each other in a unique way, avoiding the duplication of data and representing the business relationships in a completely generic way. Such an enterprise model is extremely attractive, providing flexible applications that consistently integrate. However, few businesses of any complexity have ever successfully developed such a model.

There are a number of reasons why the grand enterprise data model experiments have failed. First, to understand a data model it is necessary to understand all of the processes that use or populate the content. Such an analysis is a massive undertaking. Second, enterprise data models are an all-or-nothing affair; they do not prioritize. That is, even a minor entity can dramatically change the type of relationship. Finally, the data model is so much work that everyone assumes ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Marketing in the Public Sector: A Roadmap for Improved Performance

Marketing in the Public Sector: A Roadmap for Improved Performance

Philip Kotler, Nancy Lee
How to Develop a Great Digital Strategy

How to Develop a Great Digital Strategy

Jeanne W. Ross, Cynthia M. Beath, Ina M. Sebastian
What Successful Project Managers Do

What Successful Project Managers Do

W. Scott Cameron, Jeffrey S. Russell, Edward J. Hoffman, Alexander Laufer

Publisher Resources

ISBN: 9780470625774Purchase book