Physical records, Database Management System

Physical Records

These are the records that are stored in the secondary storage devices. For the database relation, physical records are the group of fields kept in adjacent memory locations and retrieved mutually as a unit. Considering the page memory system, data page is the quantity of data read or written in single I/O operation to and from secondary storage device to the memory and vice-versa. In this context we describe a term blocking factor that is explained as the number of physical records per page.


Posted Date: 3/7/2013 6:05:04 AM | Location : United States

Related Discussions:- Physical records, Assignment Help, Ask Question on Physical records, Get Answer, Expert's Help, Physical records Discussions

Write discussion on Physical records
Your posts are moderated
Related Questions
what is the need of a log in dbms

What is horizontal fragmentation? Horizontal fragmentation divides the relation by assuming every tuple of r to one or more fragments

Why did SAP introduce the extended star schema? Explain why it is reported to be better than the traditional schema model?

Discuss how the bi-directional Implementations are made. In bi-directional implementation of the association, a pair of references must implement every link. The declarations a

Define Outer join Outer join - If there are any type of values in the one table that do not have corresponding value(s) in the other, in an equi-join which will not be selected

How do you find the final model after iterative analysis? Why is iterative analysis of any of the problem needed? The final model serves as the base for system architectur

Which element in the database can modified by changing the data dictionary? Data elements in the database can be changed or modified through changing the data dictionary.

Define shadow paging. An alternative to log-based crash recovery method is shadow paging. This technique requires fewer disk accesses than do the log-based methods.

By using the delete operation some consisting records can be deleted from a relation. To delete some definite records from the database a condition is also specified based on which

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