What is Hot, Warm & Cold Data?

ByDr. SubraMANI Paramasivam

What is Hot, Warm & Cold Data?

We all work with Data everyday, but is everyone required to access every single data on a daily basis? Mostly it is a BIG NO. Because we don’t have to see what happened, 3 years ago but may be used to compare and that too bit rarely.

When your company ask for current week, last week, this month, last month, this quarter is what we talk about latest data and this becomes the hot topics and this is referred to HOT data.

In the below picture, I have given a simple example from Jan to Dec. Let’s say we are in Dec 15 and the data showing up for Oct, Nov, Dec is going to be much more latest data compared to Jan, Feb, Mar. The below picture gives you an ideal scenario on how you can segregate the Hot, Warm & Cold data.

Also HOT data is very heavily accessed but comparing the same with cold data is very less accessed. Also the data in recent months changes quite frequently compared to the very earlier months.

HotWarmCold_Chart

About the Author

Dr. SubraMANI Paramasivam administrator

Dr.SubraMANI Paramasivam (MANI) is a Microsoft Certified Trainer & Principal Consultant, at YourSQLMan Ltd T/A DAGEOP, with 18+ years of experience, servicing various Corporates with customized training and consultancy. Highly experienced in providing solutions on Database, Business Intelligence & Analytics. He has a doctorate in IT, Microsoft Certified IT Professional & Microsoft Certified Trainer. He likes to enlighten the education & data and started his journey to tutor the ones who are in need with his FREE DATA AWARENESS PROGRAMME @ www.dageop.org. He speaks a lot about Data Awareness, Performance Tuning, DB & MSSS Architecture, DBA, Partitioning, Resource Governor, Disaster Recovery, High Availability, Development & T-SQL Programming.

Comments Are Closed!!!