Distributed DBMS - CS712 Power Point Slides Lecture 35

Tmsg 0 and ttr 1 length of a tuple is 1 so sizer cardr

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: itle(EMP ⋈eNo(ASG ⋈pNo(σpName = ‘CAD/CAM’ (PROJ))))) Relation Size Relation EMP PAY PROJ ASG 8 4 1 10 Site 1 2 3 4 Assume Tmsg = 0 and TTR = 1 Length of a tuple is 1 So size(R) = card(R) • Considering only transfers Considering costs costs • Site 1 –PAY site 1 = 4 PAY –PROJ site 1 = 1 PROJ –ASG site 1 = 10 ASG – Total = 15 Total 15 Relation Si...
View Full Document

This document was uploaded on 02/26/2014.

Ask a homework question - tutors are online