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
I have to solve a problem using access

Describe the candidate key functions ? Candidate Key and Alternate Key: In some instances, an entity will have more than one attribute which can serve as a primary key. Any key


Primary Index In primary index, there is a one-to-one relationship among the entries in the index table and the records in the major table. Primary index can be of two types:

What is a heterogeneous distributed database? In a heterogeneous distributed database, dissimilar sites may use different schemas, and dissimilar dbms s/w. The sites may not be

Show a centralised schema to support the operation of the system you have chosen, including in particular: the product catalogue; the outlets and respective stocks; customer record

List the data structures implemented by the storage manager. The storage manager executes the following data structure a) Data files b) Data dictionary c) indices

What are the ways in which the variable-length records arise in database systems? Storage of many record types in a file. Record types that permit variable lengths for one o

Question 1: a) What is the difference between a non-impact and impact printer? b) Which type of printer is generally used in a supermarket to print your receipt? Describe

We require an advanced system for a Sports Centre, you are concerned only with representing the data discussed below about bookings and members. (The complete system may contain ot