Warning: Creating default object from empty value in /home/johnnz/public_html/wp-content/themes/simplicity/functions/admin-hooks.php on line 160
Archive | Data Structure Modeling RSS feed for this section

Business Modelling Architecture

All good analysis and modelling is achieved by starting in the right place, and that place is with the core activities of the enterprise – the Business Functions. If you have not started in the right place, then you need to know how to get back there. The Hierarchy of Models shown in the diagram in this post will enable you to do this.
If you are working on any model and have not built the preceding model(s) then you are not going to achieve a Quality outcome.  For example, if you are modelling Processes and have not yet built your Function Model, then you are in trouble.  This failure to first model Functions is one of the main reasons why most BPM projects fail to deliver.

3 Comments Continue Reading →

A Data Quality Profession?

Do We Need a Data Quality Profession? In a recent article on Data Quality Arkady Maydanchik was suggesting that a key solution to the current data quality issues that plague business everywhere is the creation of a dedicated Data Quality profession. In a reply to the article I suggested that, far from solving the problems, the […]

4 Comments Continue Reading →

Bad Data Structures Prevent Growth

Postal addresses present data database developers with a constant challenge. Traditional approaches fail, either because they hard code in inadequate structures, or they provide the chaos of no structure at all. Generic data modeling can overcome both of these shortcomings and enable to expand and grow into multinational markets.

Leave a comment Continue Reading →

Dead Crows Fly East

This is a very useful rule to use when building an Entity Relationship Diagram. No crows were hurt during the construction of this diagram.

4 Comments Continue Reading →

Data Modelling: The Power of QUACKs and UIDs

Codes are Not Identifiers In my previous post on how unique keys cause duplication in databases I demonstrated that codes are not identifiers for data entities and, by extension, they cannot be unique identifiers (UIDs). Why Do People Use Codes? If codes are not identifiers how come they are used so extensively?  Because, when used […]

Leave a comment Continue Reading →

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 →

Five Fatal Errors for Business Analysts

Proper business analysis can bring untold benefits to a business by bring power through simplicity and enabling quality information systems to be built to support and accelerate business success. Bad business can bring untold misery to a business and can lock the staff inside complicated and inefficient procedures supported by poor information systems that severely […]

5 Comments Continue Reading →