Issues relating to the design of the physical database files, Database Management System

The issues relating to the Design of the Physical Database Files

Physical File is a file as stored on the disk. The major issues relating to physical files are:

 •      Constructs to link two piece of data:

•     Sequential storage.

•    Pointers.

  • File Organisation: How the files are in order on the disk?
  • Access Method: How will the data can be retrieved based on the file Organisation?

 

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







Related Discussions:- Issues relating to the design of the physical database files, Assignment Help, Ask Question on Issues relating to the design of the physical database files, Get Answer, Expert's Help, Issues relating to the design of the physical database files Discussions

Write discussion on Issues relating to the design of the physical database files
Your posts are moderated
Related Questions
This project requires you to create a database design.  Your design will be documented in a set of Entity-Relationship diagrams.  Draw a set of Entity-Relationship diagrams to mode

Describe Application programming interface? Application Programming Interface - Commercial SQL implementations take one of the two primary techniques for involving SQL in a p

Give an example of enforcement in Typing. You can understand the idea of enforcement as it makes sure objects of dissimilar classes may not be interchanged as below:  Exampl

External failure : A failure can also result because of an external cause, such as earthquakes, fire, floods, etc. The database must be duly backed up to avoid troubles occurring d

What are the states of transaction? The states of transaction are:- a) Active b) Partially committed c) Failed d) Aborted e )Committed   f) Terminated

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

What are temporary tables? Temporary tables exist solely for a particular session or whose data persists for the duration of the transaction.


List and also explain the dissimilar stages of DDLC ?

What is the archtetype/instance pattern? The archetype/instance pattern happens when one entity tracks occurrences of another entity. A common example is the relationship among