If you only have a single application in front of it, that's a valid approach. If you have multiple applications- maybe a separate reporting tool, for example-

If you only have a single application in front of it, that's a valid approach. If you have multiple applications- maybe a separate reporting tool, for example- you now have the problem of maintaining and invalidating multiple caches. Much easier to keep the cache located with the data since the cache changes when the data does.