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
Using your cache simulator and using smalltex.din as your memory trace determine the total miss rate, compulsory miss rate, capacity miss rate, and conflict miss rate for the follo

What are the comparison operator in SQL?  Comparison operator in SQL are =, LIKE and BETWEEN

Explain data dictonary on oracle ? Data Dictionary - Data dictionaries are the system tables in which contain descriptions of the database objects and how they are structured.

Discuss deferred update technique of recovery.  What are the advantages?  Ans:  The deferred update methods do not physically update the database on disk till after a transact

Differentiate OO development from structured development. Structured approach of problem solving is based upon the idea of decomposition of system into subsystem. In this appro

I have a homework assignment due today by midnight. I need help understanding databasse normalization and determining the type of form violation & how to fix the violation.

Distributed And Client Server Databases Introduction This unit tells the distributed database systems which are primarily relational and one important execution model: the

Add generation capabilities and/or tailor the built-in functionality of generator. This enables you to produce "all" the test data for the MySQL tables you produced in the previous

What is a super key? A super key is a set of one or more attributes that collectively permits us to recognize uniquely an entity in the entity set.

er diagram on cosmetics.