Cost of reading a file , Database Management System

A file of employee have 10,000 blocks on a cylinder of a disk with characteristics r=8ms and btt=0.6ms I want to know the cost of read inthe file under following conditions for a query say to read highest salary ..1.using single buffer and a memory buffer of 10pg 2. Using double buffer and a memory buffer of 10 pgs
3. Usiing single buffer and a memory buffer of 50 pgs
4. Using double buffer and a memory of 50 pgs
Posted Date: 1/19/2013 5:28:50 AM | Location : USA







Related Discussions:- Cost of reading a file , Assignment Help, Ask Question on Cost of reading a file , Get Answer, Expert's Help, Cost of reading a file Discussions

Write discussion on Cost of reading a file
Your posts are moderated
Related Questions
I want a professional with strong IT background who provide me timely assignments Project Description: I want a professional who can do my assignments for my major i.e. Infor

Define Outer join Outer join - If there are any type of values in the one table that do not have corresponding value(s) in the other, in an equi-join which will not be selected

What was the method in which records are physically stored in a specified order according to a key field in each record ? A method in which records are physically stored within

Define a table in SQL known as Client that is used to store information about the clients. Define CLIENT_NO as the primary key whose first letter must begin with ‘C'. Also ensure t

What is data integrity? Ans: It is the data consisted of in database that is accurate and consistent.  (Data integrity means that the data should be valid as per to the give

he SQL query that will return the order number, quantity ordered, price each and total cost of an order (quantity * price each) from the order details table. Label the calculated c

The domain that you will model in this assignment is that of courses and students at a university. So as not to make the task too large and unspecified, you will here get a descrip

What is Functional Dependency? A Functional dependency is shown by X Y among two sets of attributes X and Y that are subsets of R specifies a constraint on the possible tuple

What are the advantages of object oriented databases in comparison with others? Why it is still not widely used? Object oriented designs are coherent, efficient and less prone

1.Why we need data mining? Give an example to illustrate your answer. 2. Why data mining is considered as "misleading name"? 3. Distinguish the difference between database an