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
The File Based System File based systems are an early attempt to computerise the manual filing system. For example, a manual file can be set up to hold all the correspondence r

Improved availability: The data in a distributed system may be replicated so that it is at more than one site. Thus, the failure of a node or a communication link does not necessar

What are the DBMS languages? Briefly explain? Data Definition language (DDL):A database schema is specified through a set of definitions expressed through a special language

How does the two phase protocol ensure serializability in database schedules?   Ans:  A transaction is termed to follow the two-phase locking protocol if all locking operations

What is the function of IO/M signal in the 8085? It is a status signal. It is used to differentiate among memory locations and I/O operations. When this signal is low (IO/M = 0

Sequential File Organisation The most necessary way to organise the collection of records in a file is to use sequential Organisation. Records of the file are stored in series

explain normalization,and give the examples 1NF,2NF,3NF,BCNF.AND FUNCTIONAL DEPANDENACY AND DECOMPOSITION TECHNIQUES.

Describe the different RAID levels.  Discuss the choices of the different RAID levels for different applications.          Ans:   There are several combinations of these approa

Ask question #MinimRead Dennis et al. Chapter 6: Minicase 2. Work through it and answer the questions. See the attached example. SequenceDiagram.png Based on the structural mod

Explain the function of Object model Object model describes the classes of objects in system, including their attributes and operations which they support. The analysis object