reset password
Author Message
rodthung
Posts: 14
Posted 14:57 Mar 16, 2014 |

I think this question should provide page size information to be able to calculate  how many data entries per page 

talisunep
Posts: 140
Posted 14:59 Mar 16, 2014 |

each page = 40 tuples does that help?

rodthung
Posts: 14
Posted 15:09 Mar 16, 2014 |

According to some other source to answer question 7 a)

Cost of using the B+ tree index = (1) Cost of traversing from root to leaf + (2) Cost of traversing fetching matching data entries from the index + (3) Cost of fetching tuples from the relation.

(1) Given

 (2) ceiling(No. of matching data entries/No of data entries/page)  : we can calculate No. of matching data by RF*No. of tuple 

(3) we can calculate that 

 

 

Last edited by rodthung at 15:10 Mar 16, 2014.