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

Three level architecture, explain external view

explain external view

Normalization e, explain normalization,and give the examples 1NF,2NF,3NF,BC...

explain normalization,and give the examples 1NF,2NF,3NF,BCNF.AND FUNCTIONAL DEPANDENACY AND DECOMPOSITION TECHNIQUES.

Insulation between conceptual and physical structures, Insulation between c...

Insulation between conceptual and physical structures It can be defined as: 1. The Database Administrator should be capable to vary the storage structures without affectin

Operator precedence-data manipulation language, Operator Precedence The...

Operator Precedence The basic operators used in SQL are * / - + Operators of the similar priority are evaluated From Left to right Parentheses are used to force priorit

Discuss the problem of spurious tuples, Discuss the problem of Spurious tup...

Discuss the problem of Spurious tuples and how we may prevent it. Ans: A spurious tuple is, mainly, a record in a database that gets created while two tables are joined bad

Differentiate between a global and a local temporary table, Differentiate b...

Differentiate between a Global and a Local temporary table? - A local temporary table exists only for the duration of a connection or if defined inside a compound statement, fo

Data analysis and design, give some example real-life situations where DBMS...

give some example real-life situations where DBMS are most suiitabe

What are the dbms languages, What are the DBMS languages? Briefly explain?...

What are the DBMS languages? Briefly explain? Data Definition language (DDL):A database schema is specified through a set of definitions expressed through a special language

Identify all renters who have viewed all properties, Consider the subsequen...

Consider the subsequent relations RENTER(rno, fname, lname, address, tel_no, pref_type, max_rent) VIEWING(rno, pno, date, comment) PROPERTY_FOR_RENT( pno, street, area ,city,

Explain the terms primary key, Explain the terms primary key, candidate key...

Explain the terms primary key, candidate key, alternate key and secondary key. In the given table identify every key? STUDENT(SID,Regno, Name, City) Primary Key: The prim

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

Three level architecture, explain external view

Normalization e, explain normalization,and give the examples 1NF,2NF,3NF,BC...

Insulation between conceptual and physical structures, Insulation between c...

Operator precedence-data manipulation language, Operator Precedence The...

Discuss the problem of spurious tuples, Discuss the problem of Spurious tup...

Differentiate between a global and a local temporary table, Differentiate b...

Data analysis and design, give some example real-life situations where DBMS...

What are the dbms languages, What are the DBMS languages? Briefly explain?...

Identify all renters who have viewed all properties, Consider the subsequen...

Explain the terms primary key, Explain the terms primary key, candidate key...

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