Database

Business-Oriented Conceptual Modeling for Master Data Entities - by David Loshin In my previous post, we examined some of the challenges associated with developing data models for master data entities managed within an MDM environment, and I implied that achieving the holy grail of MDM, namely the (elusive, if not purely mythical) “golden record” would first require a practice for business-oriented data conceptual and logical data modeling. We tend to have a “dimensional attitude” about master data, focusing on “customer master” or “supplier master” or “product master” as i...
Lose Data Model Errors with This One Weird Trick Are you tired of people finding errors in your data models once they go to build an application on top of that fine database you designed for them?  Would you like to be in on a secret that others have to spend thousands of hours in the gym to accomplish?  Well I have the solution for you.  All you have to do is call in the next 7:00 minutes with your credit card number handy.   Hold on.   I first heard about this trick during one of my EDW sessions on database desig...
The Evolution of Data Modeling - by Ron Huizenga When we review the evolution of new data architecture and development methodologies, along with the corresponding changes in corporate culture, we can see that there have been numerous approaches over the years. In the earlier days of traditional / waterfall processes for data modeling, there was a more rigid organizational structure with data modelers, programmers, and system analysts. Agile methodologies emerged in an attempt to address the shortcomings of traditional practices. The focus chan...
The Challenge of Master Data Modeling - by David Loshin I had a recent email exchange in which a customer was looking for guidance in developing data models for master data entities used across multiple business functions and domains. One of the motivating factors was the desire for evolving a “golden record” (a term that makes me bristle each time I hear it, by the way) for each master entity type – a golden customer record, a golden product record, etc. I expressed my concern about two things: attempting to create a model intended to represent a s...
Comprehensive Data Security Requires Metadata - by Rob Loranger Anthem Inc. – 80,000,000 records stolen; Sony Pictures – 100 terabytes of data stolen; JP Morgan Chase – 70,000,000 records stolen; and EBay – 145,000,000 records stolen. This short list is the “tip of the iceberg” of organizations across all industries that have had significant amounts of their customer, employee, and other important organization data stolen. With the increased reliance of digital information by organizations and their customers, these trends will likely continue and be fueled ...

Check out more tips and tricks in this development video: