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
Lost Updates : Suppose the two transactions T3 and T4 run simultaneously and they happen to be interleaved in the following way (suppose the initial value of X as 10000):

A database named yourusernameFMA has been set up for you to use for this assignment.  For the FMA you must create the required tables and run the queries using this database.  If y

What is magnetic disks?explain it? Magnetic disk provides the bulk of secondary storage of modern computer system. The disk capacity is growing at over 50% per year. But the st

examples of fields in a database

Name the three major set of files on disk that compose a database in Oracle. There are three main sets of files on disk that compose a database. All the files are binary. These

Critically evaluate the bulleted list of information-related items in this case study. How are each contradictory to the notion of being an information-literate knowledge worker?

Define entity integrity and referential integrity.  How does SQL allow specification of  these? Ans: Entity Integrity Rule- If the attribute A of relation R is a prime attribut

Why Like predicate used for? LIKE predicate: The LIKE predicate searches for strings in which have a certain pattern.

What is a data dictionary?  A data dictionary is a data structure which keeps Meta data about the structure of the database i.e.  the schema of the database.

State as Location within a Program In this traditional approach, location of control inside a program totally defines the program state. Any finite state machine may be implem