Physical Database Design Issues

The database design includes the process of logical design with the use of E-R diagram, normalisation, etc., followed by the physical design.

The Key issues in the Physical Database Design are:

• The use of physical database design is to alter the logical description of data into the technical specifications for retrieving and storing data for the DBMS.
• The aim is to create a design for storing data that will give adequate performance and make sure database integrity, recoverability and security.

Some of the basic inputs needed for Physical Database Design are:

• Normalised relations
• Attribute definitions
• Data usage: retrieved, entered, deleted, updated
• Requirements for security, recovery, backup, retention, integrity
• DBMS characteristics.
• Performance criterion such as response time necessity with respect to volume estimates.

Though, for this type of data some of the Physical Database Design Decisions that are to be taken are:

• Modifying the logical design.
• Optimising attribute data types.
• Specifying the file Organisation.
• Choosing indexes.

Posted Date: 3/7/2013 6:03:39 AM | Location : United States

Ask an Expert

Related Discussions:- Physical database design issues, Assignment Help, Ask Question on Physical database design issues, Get Answer, Expert's Help, Physical database design issues Discussions

Write discussion on Physical database design issues
Your posts are moderated

Write your message here..

Related Questions

Types of fragmentation, vertical fragmentation vertical fragmentation

Entity set that does not have sufficient attributes known as, An entity set... An entity set that does not have sufficient attributes to form a primary key is called? An entity set that doesn't have sufficient attribute to form a primary key is known as w

Domains, A domain is a set of permissible values that can be given to an at... A domain is a set of permissible values that can be given to an attribute. So each attribute in a table has a definite domain. Values to these attributes cannot be assigned outside

Many-to-many relationship, For each m:n relationship type R, we make a new ... For each m:n relationship type R, we make a new table (say S) to represent R. We also contain the primary key attributes of both the participating entity types as a foreign key att

External failure-database recovery and security, External failure : A failu... 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

Describe integrity constraints, Describe integrity constraints? Integr... Describe integrity constraints? Integrity Constraints - A database is just as excellent as the information stored in it, and a DBMS must therefore help avoid the entry of inc

Explain the recoverable schedule, Explain the Recoverable Schedule A r... Explain the Recoverable Schedule A recoverable schedule is one in which for each pair of transactions Ti and Tj such that Tj reads a data item formerly written by Ti, the comm

Erd, er diagram on cosmetics. er diagram on cosmetics.

Create a database model, Submit the table creation statements (including co... Submit the table creation statements (including constraints) for the Database Model. Submit them all in a single script file. Also submit a document explaining what test data yo

Advantages of Observation Methods, Advantages of Observation  Methods: ... Advantages of Observation  Methods: Bailey has pointed  out four  advantages of observation: 1. Superior in Data  Collection  on Non Verbal Behavior: When  a person  a opi