Aggregation, summarization, and abstraction demystified
Posted in Abstraction and Subtypes, Business Intelligence and Dimensional
0 Comments

As a data modeling expert in your company, you are frequently being asked modeling advice. After dazzling your coworkers with a clear explanation as when to use surrogate keys (see To surrogate key or not to surrogate key), you have received a big promotion and a corner office near the CIO’s office. The CIO is now asking you for frequent advice, including this request: “I have heard a lot of buzzwords at a recent business intelligence gathering. Give me a short yet complete explanation for aggregation, summarization, and abstraction.”
How would you respond? In the text box below, write your definitions for each of these terms.