Implementing aggregate tables
In order to improve query performance, we have created aggregate tables at the database level. Now we're going to modify the Physical and BMM layers of the repository to gain benefit of summary data.
- Physical layer: Aggregate tables should be imported and physical joins should be created
- Business Model and Mapping layer: Secondary logical table sources are going to be added to the corresponding logical tables
- Presentation layer: No modification will be made at this layer. Usage of aggregate tables will be transparent to the end users
- As we have already demonstrated how to import tables into the Physical layer in Chapter 1, Exploring and Building the Repository, you won't find every detailed step in this ...