Question: Objective: To practice data preparation, modeling and distribution Consider the following table which shows the correlation between queries and tables they access. The company wants

Objective: To practice data preparation, modeling and distribution Consider the following table which shows the correlation between queries and tables they access. The company wants you to find the best distribution plan for them to maximize the availability of their data assuming they can afford at most 3 replicas per table. QUERIES Q1 Q2 Q3 Q4 Q5 Q6 Q7 Q8 Q9 Q10 ACCESSED TABLES T1, T2, T3, T5, T6 T1, T5, T7 T2, T3, T4, T5, T7 T1,T3, T4, T5 T1, T2, T3 T1, T2, T3, T4, T6 T2,13,15,16, 17 T2, T4, T5 T1,T3, T5 T1, T2, T5 Run frequent pattern mining with T1 minimum support of your choice, find closed itemsets and then decides or replicas. Show all the steps of your work
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
