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

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 →

Does Capability Equate to Process?

Capability is a measure of the capacity of an organisation to provide a product or service that fulfills an existing or envisaged need to a customer or a market. In this sense, Capabilities are derived by bring together existing functions, data, services, products, technologies, skills, etc. to effect the delivery of the need in the […]

7 Comments Continue Reading →

Capability vs Requirement

A very common error in world of Enterprise Architecture (EA) or Strategic Enterprise Architecture (SEA) is to define “Capability” as “Requirement”. In order to resolve this confusion we need to take a brief diversion and say that the term “Requirement”, when used on its own, is quite meaningless.  To achieve clarity simply ask “who requires […]

2 Comments Continue Reading →

Software Development: Quality Checklist

Quality Essentials If your business is software production, whether for in-house or external clients, then it is essential that you have the following elements and structures in place. Each of the elements listed below are essential, whether you are building a one-off application for a specific client or a package for mass distribution. System Development […]

Leave a comment Continue Reading →

BTM – Business Transaction Modelling

Brand New Business Modelling Technique Business Transaction Modelling (BTM) is the latest technique to be added to the Integrated Modelling Method.  Like all other techniques in IMM, BTM is fully integrated with the core techniques of the overall method. What is a Business Transaction? A business transaction is a series of steps (Business Functions) that […]

6 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 →