View Issue Details

IDProjectCategoryView StatusLast Update
0000243CaseTalk ModelerRepositorypublic2017-04-25 16:25
ReporterBCP Software 
Assigned ToBCP Software 
PrioritynormalSeverityfeatureReproducibilityhave not tried
Status assignedResolutionopen 
Product Version7.1.1 
Target VersionFutureFixed in Version 
Summary0000243: Rolepaths
DescriptionRolepaths should be implemented to reflect additional fact names through the role path. This is an addition to elementary facts.
Steps To ReproduceConsider the expressions

Child: "Pete is born out of the relation John and Mary"

The role path should be declarable as well:

Father: "Person -> Child -> Relation -> Man -> Person"

And the reverse or similars like Child, Grandchild, Grandmother etc..

(This can be used instead of the flatline with rolefixes)
TagsNo tags attached.

Relationships

Activities

BCP Software

BCP Software

2016-05-29 20:02

administrator   ~0000586

Last edited: 2017-04-25 13:39

View 2 revisions

Where this path exists after GLR, a column name override could be specified as well. This rolepath alias should be entered in addition to the otft-alias. The otft and alias and rolefixes as visible in the otft-list. Additionally a rolepath name could be presented there as well..

If used as a rolefix it should be unique among the OTFT names. If not used as such, the path names should be unique within the names of paths.

BCP Software

BCP Software

2017-03-29 10:37

administrator   ~0000790

Path requires no name, for various rolepaths may be "joined" before the end result may be named. The "join"-part is not yet modelled.
BCP Software

BCP Software

2017-04-04 15:09

administrator   ~0000813

Last edited: 2017-04-25 16:21

View 11 revisions

-- Table "PATH"
--
-- "Named Path path <PathNo> is called <Path Name>."
-- "Path <PathNo> exists."
-- "Path <PathNo> is of type <Path Kind>."
CREATE TABLE "PATH" (
   "PATH_NO" "PATH_NO" NOT NULL, -- PathNo
   "PATH_NAME" "PATH_NAME", -- Named Path/Path Name
   "PATH_KIND" "PATH_KIND" NOT NULL, -- Path Kind
  "COMMENT" "COMMENT" NULL, -- Path Comment
   PRIMARY KEY ("PATHNO")
);

-- Table "PATH_PART"
--
-- "Path <Path>.<Part No>, references <Role>."
CREATE TABLE "PATH_PART" (
   "PATH" "PATH_NO" NOT NULL, -- Path
   "PART_NO" "PART_NO" NOT NULL, -- Part No
   "ROLE" "ROLENO" NOT NULL, -- PathPart Role/Role
  "COMMENT" "COMMENT" NULL, -- Path Part Comment
   PRIMARY KEY ("PATH", "PART_NO")
);

-- Table "PATH_PART_EXPRESSION"
--
-- "Path <Path>.<Part No> uses verbalization with <Expression>."
CREATE TABLE "PATH_PART" (
   "PATH" "PATH_NO" NOT NULL, -- Path
   "PART_NO" "PART_NO" NOT NULL, -- Part No
   "EXPRESSION" "EXPCODE" NOT NULL, -- Part Expression / Expression / ExpCode

   PRIMARY KEY ("PATH", "PART_NO", "EXPRESSION")
);

BCP Software

BCP Software

2017-04-05 12:49

administrator   ~0000814

Last edited: 2017-04-25 16:25

View 3 revisions

In addition to simply documenting the rolepaths, they may be used for fixing (aka overruling column names after glr), simple select paths for xml or other hierarchy purposed, of for future joining of various rolepaths. So, the PATH_KIND needs to be extended for future possibilities. Also some COMMENT or CUSTOM_ATTRIBUTE needs to be applicable to PATH and PART.

Also a non destructive GLR could perhaps be implemented here. It requires all rolepaths to be build, and than duplicate these paths for a specific GLR implementation which have the roles removed from them. This would require the PATH to include a SCOPE which is set to GLR_SQL, G_XSD, etc..

BCP Software

BCP Software

2017-04-06 09:55

administrator  

CaseTalkRolePathModel.png (22,926 bytes)
CaseTalkRolePathModel.png (22,926 bytes)
BCP Software

BCP Software

2017-04-25 13:36

administrator   ~0000847

A subset constraint should also be applicable to roles in this rolepath parts.
BCP Software

BCP Software

2017-04-25 13:48

administrator   ~0000848

Last edited: 2017-04-25 13:59

View 3 revisions

"Path Part" should get a "Role Replace Fix" to overcome the limited 'fixes in role'. This allows the modelers to use role fixing (only full replacefix) as proper naming columns in database implementations. These rolefixes are only used for naming implementations.

Issue History

Date Modified Username Field Change
2013-04-01 17:48 BCP Software New Issue
2013-04-01 17:48 BCP Software Status new => assigned
2013-04-01 17:48 BCP Software Assigned To => BCP Software
2016-05-29 20:02 BCP Software Note Added: 0000586
2016-05-29 20:02 BCP Software Note View State: 0000586: public
2017-03-14 12:28 BCP Software File Added: Path.html
2017-03-14 12:28 BCP Software File Added: Path.png
2017-03-29 10:28 BCP Software View Status private => public
2017-03-29 10:37 BCP Software Note Added: 0000790
2017-04-04 15:04 BCP Software File Deleted: Path.html
2017-04-04 15:04 BCP Software File Deleted: Path.png
2017-04-04 15:04 BCP Software File Added: CaseTalkRolePathModel.png
2017-04-04 15:09 BCP Software Note Added: 0000813
2017-04-04 15:25 BCP Software Note Edited: 0000813 View Revisions
2017-04-04 16:18 BCP Software Note Edited: 0000813 View Revisions
2017-04-04 16:19 BCP Software Note Edited: 0000813 View Revisions
2017-04-04 16:19 BCP Software Note Edited: 0000813 View Revisions
2017-04-04 16:20 BCP Software Note Edited: 0000813 View Revisions
2017-04-04 18:00 BCP Software File Deleted: CaseTalkRolePathModel.png
2017-04-04 18:01 BCP Software File Added: CaseTalkRolePathModel.png
2017-04-04 18:04 BCP Software Note Edited: 0000813 View Revisions
2017-04-05 12:49 BCP Software Note Added: 0000814
2017-04-05 13:21 BCP Software Target Version => Future
2017-04-06 08:53 BCP Software Note Edited: 0000813 View Revisions
2017-04-06 08:53 BCP Software File Deleted: CaseTalkRolePathModel.png
2017-04-06 09:54 BCP Software File Added: CaseTalkRolePathModel.png
2017-04-06 09:55 BCP Software File Deleted: CaseTalkRolePathModel.png
2017-04-06 09:55 BCP Software File Added: CaseTalkRolePathModel.png
2017-04-06 09:59 BCP Software Note Edited: 0000813 View Revisions
2017-04-06 10:00 BCP Software Note Edited: 0000813 View Revisions
2017-04-25 13:36 BCP Software Note Added: 0000847
2017-04-25 13:38 BCP Software Note Edited: 0000814 View Revisions
2017-04-25 13:39 BCP Software Note Edited: 0000586 View Revisions
2017-04-25 13:48 BCP Software Note Added: 0000848
2017-04-25 13:49 BCP Software Note Edited: 0000848 View Revisions
2017-04-25 13:59 BCP Software Note Edited: 0000848 View Revisions
2017-04-25 16:21 BCP Software Note Edited: 0000813 View Revisions
2017-04-25 16:25 BCP Software Note Edited: 0000814 View Revisions