Warning: Creating default object from empty value in /home/johnnz/public_html/wp-content/themes/simplicity/functions/admin-hooks.php on line 160
Archive | August, 2009

Unique Keys are the Primary Cause of Duplication in Databases

It is perhaps the greatest paradox of data quality that the PRIMARY cause of duplication of entries in any database is the mistaken use of unique keys as the Unique Identifiers UIDs) of records.
Click on “Read More” to learn how to avoid this error.

8 Comments Continue Reading →

Extended Family – a Basic Data Model

I was recently discussing the the subject of modelling the structure of the extended family in a commercial environment. I had come across this when doing consultancy for a finance company located in London and Dublin. They were loaning money for the purchase of motor vehicles and needed to know just how much exposure they […]

2 Comments Continue Reading →

Which Customer Contact Structure?

I made this entry in response to a blog post I read about some anomalies in B2B (Business to Business) structures at Echoes in the Database. That post essentially referred to what seemed like duplicate records in a table relating to an individual within a client company and was trying to decided whether or not […]

4 Comments Continue Reading →

Five Key Steps to Quality Data Modelling

To most business people data modelling is a black art that is practiced by the company IT department. It brings no tangible business benefits and is solely designed to make mere mortals feel confused and inferior.  Sadly, many IT departments actually foster this view and, for those that do, the data modelling that they carry […]

Leave a comment Continue Reading →