Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
search question
0 views
Skip to first unread message
elodie
Nov 17, 2011, 4:11:35 PM11/17/11
to
Hi everyone,
I am working on the following problem.
You are running a DBMS on a computer which has 3 kByte disk block
size. Reminder: 1kByte=1024bytes, 1 MByte = 1024 kBytes .
Table T in your database D has size 200MBytes. You execute a query:
"select * from T".
How much data will be read from the drive? Assume that n*size_of_tuple
= block_size, where n is natural.
I would appreciate it if somebody could give me a hand with that
problem.
I am working on the following problem.
You are running a DBMS on a computer which has 3 kByte disk block
size. Reminder: 1kByte=1024bytes, 1 MByte = 1024 kBytes .
Table T in your database D has size 200MBytes. You execute a query:
"select * from T".
How much data will be read from the drive? Assume that n*size_of_tuple
= block_size, where n is natural.
I would appreciate it if somebody could give me a hand with that
problem.
Jasen Betts
Nov 18, 2011, 5:30:36 AM11/18/11
to
hopefully no more than 204801KB
--
⚂⚃ 100% natural
--- Posted via news://freenews.netfront.net/ - Complaints to ne...@netfront.net ---
0 new messages