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

What is conceptual schema, What is conceptual schema? The schemas at th... What is conceptual schema? The schemas at the view level are known as subschema that describe dissimilar views of the database.

Explain sorted file with advantages, Explain sorted File with advantages? ... Explain sorted File with advantages?  Sorted file The sort utility shall perform one of the subsequent functions: 1.Sort lines of all the named files together and write the

Write a short note on participation role, write a short note on participati... write a short note on participation role? Participation role: roles are indicating in E-R diagram by labelling the lines that connect diamonds to rectangles.

Explain the ansi sparc architecture, Explain the ANSI SPARC architecture ... Explain the ANSI SPARC architecture The three-schema architecture is as well known as ANSI SPARC architecture. The aim of the three-schema architecture is to separate the user

Define database management system, Define database management system? D... Define database management system? Database management system (DBMS) is a set of interrelated data and a combination of programs to access those data.

Describe the strategies adopted by the ministry of ict, Question 1: (a)... Question 1: (a) Planning and management of ICT projects have a very poor record in developing countries. Briefly explain five critical success factors for correct implementa

Differance between open addressing and chaining collision, Differance betwe... Differance between Open addressing and chaining for collision resolution ? In open addressing , proceeding from the occupied position specified by hash address the program che

System Analysis and design, Using the questions found at the end of Chapter... Using the questions found at the end of Chapter 9 in your textbook, complete this homework activity. Students will submit a Word document answering questions 2, 3, and 4.

Seeking hr searcher, Project Description: The work is about founding the... Project Description: The work is about founding the best skilled person for the job. I will give you the job description. Skills required are Data Entry, Database Administrat

Create the table, Question: Using the data model express the following ... Question: Using the data model express the following queries in SQL. (a) Create the Table named "Cinema" and make the cinema_code to be the primary key of the relation and