Difference between revisions of "Column Names"

From CaseTalk Wiki
Jump to: navigation, search
m
 
(16 intermediate revisions by the same user not shown)
Line 1: Line 1:
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 very long and elaborate.
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.


Therefor CaseTalk and the Viewer allow these column names to be formatted using on of the following naming conventions:
A generated ''Project'' table may contain columns for project, manager and client. In the  
diagram it shows all resulting column names, depending on the algorithm preference.


A generated employee table may contain columns for first name and last name, originating from a person fact type.
[[File:Column naming Relational.png]]
= Full Path =
* Employee_Person_FirstName
* Employee_Person_LastName
 
= Relevant Path =
 
= Compressed Path =
 
= Unique Tail =

Latest revision as of 05:35, 5 February 2024

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 Project table may contain columns for project, manager and client. In the diagram it shows all resulting column names, depending on the algorithm preference.

Column naming Relational.png