如何在数据模式模型中有效地设计动态层次结构？

To clarify, Let us say I have users and userstats in my database and I also have information like city, state, county, and region associated with these two tables. In this scenario I can effectively roll up my userstats to city, state, county and region levels easily by a overnight or incremental process.To clarify, Let us say I have users and usersta