Moving from Logical to Physical

by Kevin S
As we prepare to take the next step in database design, it is important to relate the new material with what we have already learned. In the article “Logical Versus Physical Database Modeling”, authors Ryan Stephens and Ronald Plew do just that. They describe data modeling as “a link between business needs and system requirements”. They summarize the logical model deliverables as including the ERD, Business process diagrams, and user feedback documentation. Where as the deliverables for physical modeling includes server model diagrams and its feedback documentation.

The logical data model, which we have been creating, will be converted into a relational database model. This process is known as physical modeling. While it seems simple by definition, the requirements of the hardware and software also need to be met which can be a hassle. Choosing the correct systems for the database can be crucial in getting the right information to the right place.

This article is nice since it is like a bridge between the previous weeks chapters and this weeks chapter. The article is written with the total novice in mind, and is completely easy to read which is nice. But I do think that the authors could have implemented a bit more technical jargon into the article so  those with an interest within the subject could be better relate.

Stephens, R. K., & Plew, R. R. (2001, March 14). Logical versus physical database modeling. Retrieved from

One thought on “Moving from Logical to Physical

  • October 21, 2012 at 3:13 pm

    Great read. It is very nice that the article explains the both logical and physical models. It is important to understand the difference between these two models and how they relate to each other. The article is pretty straightforward that logical model mainly deals with Entity relationship diagrams, Business process diagrams and User feedback documentation. While physical model deals with the actual design of a database according to the requirements that were established during logical modeling.

Comments are closed.