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 [...]
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 [...]
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.
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 [...]
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 [...]
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 [...]
Listen to John Owens introduce some of the basics of producing an information architecture for data management in this 1 minute MP3.
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 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 [...]
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 [...]