Column Names
Fact Oriented Modeling requires all fact types to be uniquely named. When a FOM Model is transformed towards a logical model, or implementation, the column names may become too long and elaborate. Therefor CaseTalk and the Viewer allow column names to be formatted using naming conventions.
A generated employee table may contain columns for first name and last name, originating from a person fact type.
Full Path
The full path will name the full paths from the very first role to the final label type.
- Employee_Person_PersonID
- Employee_Person_PersonFirstName_FirstName
- Employee_Person_PersonLastName_LastName
Relevant Path
The relevant path setting will skip intermediate fact types names. Naming the first and complimenting that with a unique tail.
- Employee_PersonID
- Employee_PersonFirstName_FirstName
- Employee_PersonLastName_LastName
Compressed Path
This compressed path setting starts with the full paths, and then removes repetitive redundant names from it.
- Employee_PersonID
- Employee_PersonFirstName
- Employee_PersonFirstName
Unique Tail
The unique tail setting starts from the label type and work it's way to the table name. Inserting parts until all column names are unique.
- PersonID
- FirstName
- LastName
Unique Path
This will probably result in the most informative and shortest column names possible. Combining the start and only add secondary information if needed.
- PersonID
- FirstName
- LastName