Tag Archives: Data
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 … 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. Continue reading
Posted in Data Structure Modeling, DataQuality
Tagged #MDM, Data, DataQuality, UID, unique keys
8 Comments
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 … 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 … 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 … Continue reading
Posted in Data Structure Modeling, DataQuality, Master Data Management
Tagged #MDM, Data, DataQuality, modelling, tutorial
Leave a comment
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 … Continue reading
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 … Continue reading
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. … Continue reading
