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
How does Oracle act as ODBC and give examples of front end uses with ODBC? ODBC achieve portability at the level of the executable by introducing an extra level of indirection.

What is hash file organization? What are the causes of bucket overflow within a hash file organization? What can be completed to decrease the occurrence of bucket overflow?

brief history,definition,current trends and future trends if any of data fragmentation

Define deadlock prevention. Deadlock prevention is a set of methods for ensuring that at least one of the four essential conditions like mutual exclusion, hold and wait, no pre


Write short notes on transaction state? A transaction may not always complete its implementation successfully such a transaction is termed aborted A transaction must be in o

Object Oriented model :An object has values stored in instance variables within the object. An object also has bodies of code that execute on the object. These bodies of code are

Objectives differentiate DDBMS and conventional DBMS; Describe Network topology for DDBMS; Describe the concepts of horizontal and vertical fragmentation; Descr

Explain Superkey Ans: A superkey is described in the relational model of database organization like a set of attributes of a relation variable for which it holds that in all re

Differance between DDL and SDL? DDL and SDL - The data definition language (DDL) is used through DBA and database designers to describe internal schema, conceptual schema, and