Chapter 15

Fully Agile EDW with Hyper Generalization

EDW team leaders can make their data warehouses flexible and inexpensive to adapt for changing requirements by “hyper generalizing” their integration layers. Hyper generalized data models place all EDW dimensional data in an associative data store requiring only six logical tables, with measure data housed in lightly dimensionalized transaction tables. Hyper generalization allows for a high level of EDW automation because business models of a company’s information can be machine read, allowing the computer to construct the bulk of an application’s integration, presentation, and semantic layers. Hyper generalization requires teams to acquire commercially available tools that will perform the ...

Get Agile Data Warehousing for the Enterprise now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.