Structured Data

We've all heard the expression "comparing apples and pears", and it matters most when it comes to the structure and stability of data.

There are a million ways for businesses to store and process data, but if the way in which that data is stored isn't correct or effective, the consequences can be serious. They key here is to understand what that data is for, why it is held, how it relates to the business itself, and what relationship it has with the rest of your data.

It is equally important to make sure that data is constrained - that it is only ever stored when it can be used effectively with other data that you hold.

There are any number of problems which lead to poor data quality:

  • Duplication of data
  • "Free-format" data - data which the user can enter with no checks and balances
  • Incorrect data definitions - a number being stored as text
  • Bloating - where a set of data becomes too large and cumbersome to be useful
  • Format issues - is your date American or English in format?
  • Orphaned data - you might remove a record for a product, for example, but leave behind additional data, wasting space and causing confusion.

This list is far from exhaustive, and a properly planned and constructed data model can avoid these problems and many more.


Want to know more about how we can help? Contact us today.