Re: foundations of relational theory? - some references for the truly starving

Anthony W. Youngman wrote:

> In article <bnibhg$11vvi4$1_at_ID-152540.news.uni-berlin.de>, Costin
> Cozianu <c_cozianu_at_hotmail.com> writes
>

>>>Oh - and you want the stats? On average, to retrieve any one row, chosen
>>>at random, you need to read just *1.05* frames either to retrieve the
>>>row from its primary key, or to know that that primary key doesn't
>>>exist! The size of the file doesn't enter into the equation.
>>>
>>>Cheers,
>>>Wol
>>
>>
>>Anthony,
>>
>>You've got no clue about how modern DBMSes work. None (not even your Pick 
>>probably) reads 1.05 frames, 1.05 means 2.

Sounds like a good leadin to a discussion on overflow and proper file sizing to me.

Patrick <;=)

P.S. Don't explain about frame faults, it could give him a stroke. The *theory* would be beyond his comprehension.

>
> The average family here has 1.8 kids! So if someone can have 1.8 kids,
> why can't we have 1.05 seeks? (Don't know what the American figure is,
> probably about 2.5 kids.) Or don't you know what the word *average*
> means?
>
> Cheers,
> Wol
Received on Wed Oct 29 2003 - 18:53:53 CST