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
Example : Create a sequence named SEQSS that starts at 105, has a step of 1 and can take maximum value as 2000.  CREATE SEQUENCE SEQSS START WITH 105 INCREMENT BY 1 MAX VA

Explain what is Aggregation? Aggregation: Aggregation is an significant concept in database design whereas composite objects could be modelled during the design of database a

I have a small project that contains 3 deliverable s. I have done the first one and I would like you to help me with second one

a project based on normalization with first, second and third normalization. There need to be a diagram also

what is Mapping Constraints? with examples

Problem 1. Describe the Oracle Architecture with a neat labeled diagram, Also explain the individual components of the Architecture. 2. Write about the following Oracle 9i o

State the Steps of Object Design Object design is a very iterative process in which various classes, relationships among objects are added when you move from one level to

Explain Hierarchical Model ? Hierarchical Model - It was established to model several kinds of hierarchical organizations which exist in the real world. It uses tree structur

When are they useful? Justify with an example. The temporary tables are commonly used to support specialized rollups or exact application processing needs. Unlike a permanent t

1) Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pict