There are Three Types of Data – Effective Database Management (2024)

As I see it, there are really only three types of data contained within a typicalassociationmanagement system: short-term data, long-term data, and useless data. Allow me to expand:

  • Short-term data. This is typically transactional data. For example, during an event registration we will collect data on dietary needs of the attendee. This is short-term data (i.e., it’s only used for the event itself, and once the event is done, it won’t be used again). It’s important to collect but it has a short shelf-life.
  • Long-term data. One of the best examples of this type of data is certification or accreditation data. While all certification programs are different, a typical certification program has a join and renew date, and requirements for attaining and retaining the certification. So there is data collected over a much longer period of time, all of which needs to be saved until at least the next renewal period, if not longer.

    Another example is areas of interest or opt-ins/outs. These will change over time, but they are also used over the long-term.

  • Useless data. Alas, too much of our databases are filled with truly useless data.One of the most common examples of this is demograhpic data. So many associations collect this data with theintent of using it (e.g., race, gender, age, in order to report on “makeup” of theassociationmembership) but too often never do. How many times have you filled out a registration form that included ten questions about who you are, and as you answered the questions you thought to yourself “What are they going to DO with this data?!?”

So as you collect data on a day-to-day basis, ask yourself which category the data falls into. The 80/20 rule probably applies here; 80% of what you’re collecting needs to be collected (it’s short-term or long-term data). But what about that other 20%? And how much effort are you putting into collecting that 20%, which is ultimately useless data? Imagine the time savings that could be had!

There are Three Types of Data – Effective Database Management (2024)
Top Articles
Latest Posts
Article information

Author: Gov. Deandrea McKenzie

Last Updated:

Views: 6440

Rating: 4.6 / 5 (66 voted)

Reviews: 81% of readers found this page helpful

Author information

Name: Gov. Deandrea McKenzie

Birthday: 2001-01-17

Address: Suite 769 2454 Marsha Coves, Debbieton, MS 95002

Phone: +813077629322

Job: Real-Estate Executive

Hobby: Archery, Metal detecting, Kitesurfing, Genealogy, Kitesurfing, Calligraphy, Roller skating

Introduction: My name is Gov. Deandrea McKenzie, I am a spotless, clean, glamorous, sparkling, adventurous, nice, brainy person who loves writing and wants to share my knowledge and understanding with you.