Method for transforming overlapping paths in a logical model to their physical equivalent based on transformation rules and limited traceability

1. A method for transforming paths in a logical model to their physical equivalent in a physical model, comprising:

retrieving a logical model;

mapping all entities in the logical model;

mapping all paths connecting the entities of the logical model;

creating tables corresponding to the entities in the logical model for traceability;

creating columns corresponding to attributes of the paths in the logical model for traceability;

wherein the tables represent the entities; and

wherein creating the tables comprises:

considering the attributes for each of the entities to obtain the columns for each of the entities;

from the columns, obtaining each of the tables that the columns belong to and

for each of the attributes in each of the entities that participate in a logical relationship, obtaining a physical column for each of the entities which is a physical equivalent to the logical relationship;

creating a reduced logical model by reducing overlapping paths in the logical model;

creating virtual logic paths where an entity is rolled up, is rolled down, and participates in a many-to-many relationship in the reduced logical model; and

transforming the reduced logical model into a physical model.

2. The method of claim 1 , wherein the method for transforming paths in a logical model to their physical equivalent in a physical model is tangibly embodied on a computer readable medium including instructions for causing a computer to execute the method.