Thursday, March 01, 2018

Properly Getting Into Jail: Counting Inmates and Other Hard Problems

DZone Database Zone
Properly Getting Into Jail: Counting Inmates and Other Hard Problems
Properly Getting Into Jail: Counting Inmates and Other Hard Problems

In prison, the notion of counting people is sacred. This is probably because the whole point of having a prison is to keep the people you put in there inside, and that means that you count inmates multiple times a day.

The dirty secret, however, is that you almost never get to that perfect occupancy number, where all the inmates that are registered to a particular block are actually in that block. In most cases, you have at least a few that are outside the block (court dates, medical issues with offsite care, visitations, outside work, etc.).

No comments:

Fun With SQL: Functions in Postgres

DZone Database Zone Fun With SQL: Functions in Postgres In our previous  Fun with SQL  post on the  Citus Data  blog, we covered w...