Physical Database Design and Performance

912 Words2 Pages

A proper physical database design is one of the most important steps that a database designer can complete to impact the overall performance of the database. When doing the physical database design it is important for the designer to understand what type of data is going to be included and how this data will be used. To better understand why this is important lets first break down a few of the basic elements that are important when completing the physical database design.

One of the most basic measures that most be examined and planned involves the smallest units within the database, the fields. The fields are derived from the simple attributes that were defined in the logical data model. A few decisions need to be made regarding each of these individual fields. First what type of data is going to be storied in them? The data type that is assigned to each field should be able to accurately represent every possible valid value, while limiting invalid values as much as possible. Special consideration should be taken for any manipulations that will be done on the data as some data types allow these manipulations a lot easier than other ones. When considering data manipulations it is important to keep in mind simple things like addition, if finding the sum of the data field’s values the data type that worked for the fields may not be large enough to support the resulting summation.

Related to the actual data type chosen, are a number of other controls that can be attached to the fields to better insure the integrity of the data. One of these controls is simple the default value that the field should take, unless another value is assigned to it. If done correct, defining a default value can be very beneficial as it coul...

... middle of paper ...

...grity can be implemented and the performance impact can be minimized. When looking at some of the more advanced design methods mentioned it is critical to understand the data and how it is used, it also doesn’t hurt to have a few tools to help you along the way.

Works Cited

Hoffer, J. (2011). Modern database management. Upper Saddle River, N.J: Prentice Hall.

Lightstone, S. (2007). Physical database design : the database professional's guide to exploiting indexes, views, storage, and more. Amsterdam Boston: Morgan Kaufmann/Elsevier.

Konig, A.C.; Nabar, S.U. (2006). ICDE '06 proceedings : 22nd International Conference on Data Engineering : 3-7 April, 2006, Atlanta, Georgia / editors, Roger S. Barga, Xiofang Zhou. Los Alamitos, Calif: IEEE Computer Society. Retrieved from: http://ieeexplore.ieee.org.portal.lib.fit.edu/stamp/stamp.jsp?tp=&arnumber=1617405

Open Document