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
Define the concept of generalization A generalization is relationship between specific kind of thing and general thing. It is also known as "is-a-kind-of" relationship. Inher

This project will involve designing and creating a database for an organization.  In the design of a database, there is no single "perfect" design.  So your database design may not


What is the use of RAID? A variety of disk-organization methods, collectively called redundant arrays of independent disks are used to better the performance and reliability.

Compute the closure (F+) for the following set of the functional dependencies defined on R(a,b,c,d), where F - {c→ a, ab → d, a → b, d → c}, i.e. what are all of the FDs implied b

Give a sample of the Dynamic Model. The sample of dynamic model is given below:  Dynamic model for the car: Brake and Accelerator            Brake or Applies Accelerator

Differentiate between static hashing and dynamic hashing.  Ans: Static Hashing comprises the number of primary pages in the directory fixed. So, while a bucket is full, we requ

OPENCART - Want Massive amount of products Imported through CSV We have a massive list of products that would take completely too long to do data entry. We require a slick progr

, write the relational schema, and draw the new dependency diagrams. Identify the normal forms for each table structure you created

What is data independence? Data Independence: Techniques which permit data to be changed without affecting the applications in which procedure it. There are two types of data