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
Analyzing Association Traversal Till now, we have supposed that associations are bi-directional. But in the case of traversal, it is in only one direction in any application,

Part: Recommended (Non-query) Optimisations This section entitled "Recommended (non-query) optimisations" should be a brief report containing recommended optimisations you would

a) Distinguish between ‘database' and ‘Database Management Systems (DBMS)'. b) List and briefly describe five potential benefits of the database approach compared to conventio

Consider the following relational scheme: R (a,b,c,d,e,f) and its corresponding set of FDs {d→ a, be → c, ac → e, b → f, f → d, a → c}. a. Is the following decomposition i) non

Consistency error : These errors happen due to the inconsistent state of database caused may be due to wrong implementation of commands or in case of a transaction abort.  To overc

#ques 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 p

System level permissions : With the use of data dictionary you can view them.       Let us take the table name as user_sys_privs (used in oracle).       DESCRIBE USER_SYS_PRI

After going by the database architecture, let us now dwell on an important query: how is the data organised in a database? There are a lot of basic structures that exist in a datab


Differentiate between a subquery and a join If we need to acquire information from one or more tables after that either subquery or join can be used. If the columns which are t