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
Data slice explanation

Describe the algorithm for updating indices for a single level index when a record is    (i) Inserted  (ii)  deleted What will be the modification if there are multilevel in

prototype of a distributed information system for a national car part retail outlet chain.

Which is the properties of entities? Attributes is the properties of entities.

What is a view? A view is a logical view on one or more tables.  A view on one or more tables i.e., the data from a view is not actually physically kept instead being derived f


Explain Hashing techniques The hashing techniques can be categorized as: Static Hashing Techniques - In this method, the data can be viewed a collection of buckets, along with

Atomicity : Either all functions are laid out or none are. Users could not have to think about the effect of incomplete operations. DBMS ensures this by undoing the functions

Shared lock or Read Lock It is requested by a transaction that needs to just read the value of data item. A shared lock on a data item does not permit an exclusive lock

what is cascading rollback