Data Quality is a Fatally Flawed Approach The trouble with Data Quality is that it is all about data – and this is a fatal flaw!! Managing data in any enterprise as a standalone element with an imagined intrinsic value is a fundamentally flawed approach that brings no sustainable benefits of any kind. Double Whammy [...]
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 [...]
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.
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 [...]
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 [...]
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 [...]
John Owens Discusses Data Management
Listen to John Owens introduce some of the basics of producing an information architecture for data management in this 1 minute MP3.
Stages in Data Modeling
A newcomer to this subject asked me the question “Where do I start and what are the stages in Data Modeling?”. Here, in brief, is the answer I gave. The first step in data modeling is data analysis. This means gathering information that will tell you what data entities are required by the business. You then need [...]
Data Management
Data is an invaluable asset. Not only is it essential for successfully supporting current operations but it will enable you to plan the future growth and success of your enterprise. To this end Data Management is essential. Effective Data Management needs an effective Data Architecture. An effective Data Architecture can only be achieved by doing [...]
Data Models are for Wimps!
In the building industry, before a building is ever erected you will have an architect’s plan defining in full each of its facets. You would then have wiring diagrams and plumbing diagrams. Last of all a decoration and furnishing plan. All of this before a brick is laid. No builder would consider building a house [...]
-
John Owens Hi Lew The answer is a very definite 'Yes�
-
Lew Hi John, Good information. Do your ought to be
-
-
Robert Suzic How do you see on business rules originating from
-
Multi-Dimensional MEM (MDM) Online Course 
Online Mentoring 
Information Flow Modelling eBook 
Business Process Modelling eBook 
Data Structure Modelling eBook 
