by Penny P
In database analysis and design, there are three major steps that are followed: conceptual design, logical design, and physical design. The author of the article explains that there is a need to extend and include a fourth step: implementation design. This step would come in after the logical design and before the physical design. The current view of the implementation step is seen as a substep of either the logical or physical design. In other words, it’s lumped in with the design of the logical or the physical. By making the implementation design a separate step, designers can fulfill several important actions before the physical design is created. Doing so will allow the logical design to stay focused on tasks that need not consider them, such as how to implement the database when they move on to the next step. And for the physical design stage, the designer can better focus on the best way they could access the database with the DBMS.
With all design modifications, its goal is to enhance the performance. However, there is a possibility that the modification can either help database operations execute faster or end up slowing things down. With the designs being modified, it can also make the database more complex. This can result in more complex SQL commands. With more complexity, there can also be an increase of opportunities for user to make errors. So the main question is whether implementing the fourth step is worth the trouble.
I thought this article was helpful because it help lay out the key steps in database design. It also showed that there is a possibility that the creation of the fourth step can better improve the design process. It’s interesting to know that some people consider the implementation design as part of the logical design while others thought it was part of the physical. For beginners starting out on database design, I can see that it could be pretty confusing for them since there isn’t a set rule as to when to consider the implementation. With the creation of the fourth step, people can focus on the tasks at hand and build a better database. They won’t have to worry about things that will be solved in a later step.
Martyn, Tim. (2000). “Implementation Design for Databases: The “Forgotten” Step.” IT Professional Magazine. (Mar/April 2000) P. 42-49. Retrieved from http://search.proquest.com/docview/206312115?accountid=10357.