Cost of reading a file , A file of employee have 10,000 blocks on a cylinder of a disk, Database Management System

Cost of reading a file , Database Management System

Assignment Help:

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

Related Discussions:- Cost of reading a file

Explain cursors in sql, Explain cursors in SQL? Cursors in SQL - An o...

Explain cursors in SQL? Cursors in SQL - An object used to store the output of a query for row-through-row processing through the application programs. Cursors are constructs

Primary key, explaination

explaination

Provide examples of different types of time and date formats, Provide Examp...

Provide Examples of different types of Time and Date formats. It's most common store dates using a dash (-) as a colon (:)and the delimiter as the time delimiter. The given fo

Log based recovery, under what condition log based recovery is feasible?

under what condition log based recovery is feasible?

Relationship between security and integrity, Relationship between Security ...

Relationship between Security and Integrity: Database security usually refers to access, while database integrity refers to avoidance of accidental loss of consistency. But usually

Write a short note on qbe, Write a short note on QBE? Stands for "Quer...

Write a short note on QBE? Stands for "Query By Example." QBE is a feature involved along with various database applications which gives user-friendly techniques of running da

Equi join-table handling, Equi Join: A join in which the joining condition...

Equi Join: A join in which the joining condition is based on equality among values in the common columns. Common columns show (redundantly) in the result table. Let us Consider th

Explain the functions of data manager, Explain the functions of data manage...

Explain the functions of data manager? Functions of Data Manager : - Convert operations in user's queries coming directly through query processor or indirectly in an applicatio

Write a query that uses the union operator, Write a Query that uses the UNI...

Write a Query that uses the UNION Operator 1. Use the Software Experts database to: a. Display the first and the last name of all consultants who worked on any projects f

Primary and foreign key, Primary Key The primary key is the candidate k...

Primary Key The primary key is the candidate key that is selected by the database designer as the principal denotes of identifying entities within an entity set. The left candi

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages

Cost of reading a file , Database Management System

Related Discussions:- Cost of reading a file

Explain cursors in sql, Explain cursors in SQL? Cursors in SQL - An o...

Primary key, explaination

Provide examples of different types of time and date formats, Provide Examp...

Log based recovery, under what condition log based recovery is feasible?

Relationship between security and integrity, Relationship between Security ...

Write a short note on qbe, Write a short note on QBE? Stands for "Quer...

Equi join-table handling, Equi Join: A join in which the joining condition...

Explain the functions of data manager, Explain the functions of data manage...

Write a query that uses the union operator, Write a Query that uses the UNI...

Primary and foreign key, Primary Key The primary key is the candidate k...

Write Your Message!

Featured Services

Online Tutoring

Project Development

Exam Preparation

Course Help

Assignment Help

Popular Subjects

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT