A key part of growing the DVD rental business has been targeted email marketing to members. One
Question:
A key part of growing the DVD rental business has been targeted email marketing to members. One of the suggestions to improve performance of marketing analysis has been to implement a RentalHistory table. A major concern is that as the rental history table grows, these queries may take longer and consume increasing resources. Our client is aware that as they continue to grow, they will need a data warehouse to support these marketing analyses. They do not want to undertake the effort at this time, the client does want to improve the performance of the marketing queries against the existing OLTP schema. In a later assignment you will design a dimensional data warehouse for our DVD rental business client, so we are not asking for that solution now.
Questions: Answer needs to be single spaced and half a page
1. How would you design a denormalized RentalHistory table to reduce the number of tables that need to be joined?
2. How would you maintain this data, meaning how and when would it be populated and updated? Compare and contrast some different approaches (think stored procedures vs. triggers).