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
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

In the architecture of a database system which external level used? In the architecture of a database system view external level used.

Determine the method of Choosing Algorithms In general, most of operations are easy and have a satisfactory algorithm since description of what is to be done also shows how i

Hi is anyone well versed in accounting information systems available now to help me work through an important assignment due tomorrow at noon?

What is called a query evaluation plan? A sequence of primitive operations that can be used to assess a query is a query evaluation plan or a query implementation plan.

What is OLAP? OnLine Analytical Processing (OLAP) is a Business Intelligence (BI) reporting system. OLAP gives the user with the capability to sum, count, average and do other

Use again the GE Flight Quest Data and build on the work done for homework 1 and 2. The goal is to create a classification model which classifies flights into "on-time" (you can de

Complexity : A distributed DBMS that is available, reliable, and secure is inherently more difficult than a centralised DBMS. Though, adequate data replication is essential to have

Sparse and Dense Indexes These indexes in principle are the similar as that of indexes used at the back of the book. The key facts of the indexes are: They are arranged

What is OCR? OCR (Optical Character Recognition) is a technology that enables you to change different types of machine-readable documents, like scanned paper documents, PDF fil