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
What are audit trails? An audit trail is a log of all alters to the database along with information like which user performed the change and when the alter was performed.

Self-Join:   In a self join a table is joined with itself.  Let consider the following sample partial data of EMP table EMPNO ENAME MGRID

1 NF Normal Form The domain of attribute must add only atomic (simple, indivisible) values First normal form (Minimal Form or 1NF) is a normal form need in database normalizat

it can be possible to create any table without primary key

Describes the several relationship constraints through giving suitable example? Constraints on relationships: There are two kinds of constraints on relationships. 1) Mapping

Can you assist me in Database management system? I need help in my courses, please email me at and get back me soon...


Aggregation Aggregation is stronger form of association. It represents the "has-a" or "part-of" relationship. An aggregation association depicts a complex object which is comp

Assignment #1 Data Management The questions on this exam are based on the Baxter Aviation case scenario. 1. (5 points) The systems analyst proposes the following two relationshi

What is called block-level striping? Block level striping stripes blocks across many disks. It treats the array of disks as a large disk, and provides blocks logical numbers