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
Explain the Dynamic Hashing Techniques There are two methods in it: extendible hashing - stores an access structure in addition to the file, and therefore is somewhat identica

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

Suppose that in an organisation, an employee may do different roles in dissimilar projects. Say, RAM is doing coding in one project and doing designing in another. Suppose that the

Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pictori

What is self-transition? If there is a transition which goes back to same state, it is known as "self- transition." With a trigger action exit action would be executed f

What are the object-oriented approaches Software systems which are designed with structured design methodology never support some of desired quality attributes for example reus

Create a new user : CREATE USER IDENTIFIED BY Example: //CREATE USER MCA12 IDENTIFIED BY W123 Grant: It is used to give database access permission to users. It is of

You will be analysing a set of financial data of your choice. It is not necessary to collect any primary data of your own, and publicly available secondary data will be sufficient

Describe entity referential integrity and integrity. Give an example of each. Entity Integrity Rule - If there is a attribute A of relation R is a prime attribute of R then A

Explain concept of inheritance with support of suitable example. Inheritance Inheritance is one of milestone of object-oriented programming language as it allows a creati