Can you create a Physical model without a Logical one?
The short answer: Yes. Technically, you can jump straight into a Physical Data Model (PDM) and start writing SQL code to create tables.
The long answer: You probably shouldn't.
While "skipping to the end" might seem faster, it often leads to significant issues:
| Feature | Physical Model Only (Skipping LDM) | Using Both LDM and PDM |
| Flexibility | Hard to change; tied to a specific database (e.g., PostgreSQL). | Easy to migrate or adapt to new tech. > in future if you want to change the database software , since the LDM is in place its easy to create a PDM and tables |
| Communication | Difficult for non-tech stakeholders to read. | Clear and understandable for business users. |
| Data Integrity | Prone to "missing" business rules or logic. | Ensures business rules are baked into the design. |
| Scalability | Often results in "patchwork" fixes later. | Built on a solid, future-proof foundation. |
No comments:
Post a Comment