A comparative study analysis of materialized view for selection cost

Abstract

Abstract

Application of Materialized View in Incremental Data Mining Operation

“…So, the number "44" identifies the participating attributes in this transaction. In the first iteration, since the number of transactions was 18, the minimum support value was chosen to be 6 as already explained and after this iteration, only one frequent set was identified and that was [6,8,12,14,16,18,19] which had the minimum support value of 6, i.e., this set has occurred 6 times in the whole set of transactions as depicted in table 1. In accordance with the reason explained above, this set is identified by the binary number 01101010100010100000 (with the MSB corresponds to the 20 th attribute and the LSB corresponds to the 1 st attribute) which has the equivalent decimal number 436384.…”

“…Similarly, in the second step of the iteration, as shown in table 2, a new set of 18 transactions was considered along with the already considered set and hence in this iteration, the total number of participating transactions was 36 and the minimum support values has been increased to 12 (1/3 rd of 36). 4,5,6,7,8,9,10,11,12,13,14,15,16,17,19 16 1,4,6,8,11,12,14,15,20 17 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20 18 8 After applying the algorithm, only the set [10,14,16,18] was identified to be materialized, i.e., crossed the threshold value of the minimum support. It was also found that the above-mentioned set has got the minimum support value of 13.…”

“…The next step was to find out the confidence value of the other attributes on [6,8,12,14,16,18,19]. This calculation is based on the method as described in section 3.…”

“…It was also found that the above-mentioned set has got the minimum support value of 13. So, like the previous iteration, the next step was to find out the confidence value of the other attributes on [10,14,16,18], i.e., on 00101010001000000000 2 or 172544 10 .…”

“…This calculation is based on the method as described in section 3. It was calculated that no other attributes crossed the minimum confidence value of 0.7 and hence after the first set of 18 transactions, the materialized view set has become [6,8,12,14,16,18,19] and the non-materialized view set has become [1,2,3,4,5,7,9,10,11,13,15,17,20]. So, it can be concluded that the seven attributes present in the materialized view have got preference over others and thus only these attributes can be mined.…”