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

Dependency Diagram, A Structure of a dependency diagram

A Structure of a dependency diagram

Define the third normal form, Define the Third Normal Form: The third ...

Define the Third Normal Form: The third normal form (3NF) is a normal form employed in database normalization. 3NF was initially defined by E.F. Codd in 1971. Codd's definitio

Cases of constraint violations, (1) Insert into PERSON Violated con...

(1) Insert into PERSON Violated constraint: - Key constraint Reason: - Primary key 1 already exists in PERSON. Dealing: - DBMS could ask the user to provide valid PER

Cost of reading a file , A file of employee have 10,000 blocks on a cylinde...

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 q

#title using the invoice, using the invoice table shown below,write the rel...

using the invoice table shown below,write the relational schema,draw a dependencies,inclunding all partial and transitive dependencies.assume that the table does not contain repeat

Mapping, external and internal mapping with examples

external and internal mapping with examples

Explain the term - adjustment of inheritance, Explain the term - Adjustment...

Explain the term - Adjustment of inheritance The inheritance can be enlarged as object design progresses by changing class structure. The designer should do: i) Adjust or r

The sap profile parameter, While sorting, if the main storage available is ...

While sorting, if the main storage available is not enough, the system writes data to an external help file. The SAP profile parameter, which determines DIR_SORTTMP

Explain physical and logical independence, Define Physical and Logical inde...

Define Physical and Logical independence Ans: Physical data independence: The ability to modify physical level without causing application program to be rewritten. Logic

Fragmentation, let us consider a table having 2200 records and the fixed si...

let us consider a table having 2200 records and the fixed size of the table to be considered as 25.then how many numbers of table is requredto perform horizontal fragmentation

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

Dependency Diagram, A Structure of a dependency diagram

Define the third normal form, Define the Third Normal Form: The third ...

Cases of constraint violations, (1) Insert into PERSON Violated con...

Cost of reading a file , A file of employee have 10,000 blocks on a cylinde...

#title using the invoice, using the invoice table shown below,write the rel...

Mapping, external and internal mapping with examples

Explain the term - adjustment of inheritance, Explain the term - Adjustment...

The sap profile parameter, While sorting, if the main storage available is ...

Explain physical and logical independence, Define Physical and Logical inde...

Fragmentation, let us consider a table having 2200 records and the fixed si...

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