View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0001040 | CaseTalk Modeler | Transformation (GLR) | public | 2016-08-29 15:11 | 2020-08-20 17:01 |
Reporter | BCP Software | Assigned To | BCP Software | ||
Priority | normal | Severity | major | Reproducibility | sometimes |
Status | assigned | Resolution | open | ||
Product Version | 8.11.2 | ||||
Summary | 0001040: Reducing Object Types | ||||
Description | The attached screenshot shows a model which is partially transformed. We performed a full GLR but left Branche as not reduced. Once we reduce this fact, the subset constraint 11 completely disappears. Which results in a relational model with missing foreign keys. | ||||
Tags | No tags attached. | ||||
CaseTalk Edition | |||||
|
|
|
|
Where the reducing of Branche_Ungrouped may seem the start of the issue, it really starts in the elementary model at BankEmployee. CaseTalk already warns for: - OTFT's Branche, City, County, State may not be verbalizable - Binary facts StateName, CountyName, CityName may not group two ways These warnings should prevent the modeler to GLR, since it'll lead to apparent subset loss. First of all: the binary facts mentioned will not be reduced in the newer CaseTalk. It'll remain ungrouped. Which leads us to State,County,City which are candidates for Reduction. The following subsets will remain: SC 10->7 and 5->7. Yet without the presence of a totality constraint on State, the State will disappear completely without a trace of subset constraints. This will cascade over County, State and County. Even towards Employment, which will end up with a single subset towards Bank. This combination of effects is the true cause for foreign key failure. How could CaseTalk warn for this, or prevent it? Should it stop Reducing State, County and City if they are not verbalizable? Or is there something else we can think of? |
|
Does this still apply after the report and future fixing of bug 0002647. | |
Date Modified | Username | Field | Change |
---|---|---|---|
2016-08-29 15:11 | BCP Software | New Issue | |
2016-08-29 15:11 | BCP Software | Status | new => assigned |
2016-08-29 15:11 | BCP Software | Assigned To | => BCP Software |
2016-08-29 15:11 | BCP Software | File Added: Branche_Ungrouped.png | |
2016-08-29 18:29 | BCP Software | File Added: BankEmployee.png | |
2016-08-29 18:37 | BCP Software | Note Added: 0000629 | |
2016-08-29 22:48 | BCP Software | Note Edited: 0000629 | |
2016-09-07 09:18 | BCP Software | Summary | Reducing removes subset constraints => Reducing Object Types |
2020-04-19 09:25 | BCP Software | Category | Model Transformation (GLR) => Transformation (GLR) |
2020-08-20 17:01 | BCP Software | Note Added: 0001735 |