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

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 →

Formalisation Creates Models

I have been having some discussions lately about with various people around the globe on what constitutes a “model”. Some of those with whom I have been in discussion hold the view that any concept or mental picture that a person holds in their head constitutes a model.  While this might be valid from a […]

Leave a comment Continue Reading →

Function Modelling – a Tutorial

I was recently invited by the team at DataQualityPro to put together a tutorial on the basics of function modelling. The team are familiar with the power of the Integrated Modelling Method and how it puts Business Functions at the core of the Corporate Business Model. The tutorial summaries the IMM Function Modelling process.  It […]

1 Comment Continue Reading →

Five Stages of Business Analysis (2)

Stage 1: Information Gathering: One-to-One Interviews The one-to-one strategic in-depth interview is the most effective means of gathering information from senior directors and senior executives. The purpose of these interviews is to find out from these key people what their opinions are regarding the business area in question and the project itself. Such interviews will […]

2 Comments Continue Reading →

Five Stages of Business Analysis (1)

Stage 1: Information Gathering This stage consists of finding identifying the key people or other sources within the business that can tell you: What the business OUGHT to be doing. The order in which it ought to be done. The information required to do it. What this business modelling / systems development project ought to achieve. […]

Leave a comment Continue Reading →

Five Stages of Business Modelling

In the Integrated Modelling Method there are five distinct stages to Business Modeling:     Information gathering     Analysis and investigation     Modelling     Feedback     Implementation All of these stages should be followed whether you are doing modelling in an organisation with 5 employees 5,000 employees or 25,000 employees.  If you are doing work in […]

Leave a comment Continue Reading →

BPM for the Building Industry

When Business Process Management (BPM) was introduced to the business world, business analysts no longer needed to bother busy executives to find out what should be going on in their businesses. With this new approach, analysts could now simply look at what was currently being done in any business and use their analytical genius to […]

1 Comment Continue Reading →