Physical database design issues, Database Management System

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







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
Related Questions
we need example of 2phase locking

Submit SQL INSERT Statements that will populate the database with sample data.  You must insert at least 5 records into each table in your database.Submit your SQL INSERT Statement

What is Outer join?  They can be employed while we want to keep all the tuples in R, or all those in S or all those in both relations in the result of the JOIN in spite of of w

In an organization several projects are undertaken. Each project can employ one or more employees. Each employee can work on one or more projects. Each project is undertaken on the

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

What are the physical characteristics of magnetic disks?   Ans: A magnetic disk is a circular plate or platter of plastic or metal that is coated with magnetizable material lik

Need for Multiple Access Paths In practice, most of the online information systems need the support of multi-key files. For example, consider a banking database application hav

Cardinality shows the number of instances of an entity associated with another entity participating in a relationship. Depend on the cardinality binary relationship can be further

What is meant by normalization of data? It is a process of examining the given relation schemas based on their Functional Dependencies (FDs) and primary key to achieve the prop

Change the city of First Bank Corporation to ‘New Delhi' UPDATE COMPANY SET CITY = ‘New Delhi' WHERE COMPANY_NAME = ‘First Bank Corporation';