SNOMED International Release Management

Page tree

Production (January 2019 DRUGS Alpha) VERSION 3 vs Production (January 2019 DRUGS Alpha) VERSION 4 traceability

Differences found in package Comparison

Number of records impactedRationale
OWLExpression files1

ISRS-492

1 record updated with the new, active concept record (770802007), replacing the now inactive concept (72651009) as expected:

< ce557fc3-6f02-4818-84f1-deb19a351838 20190131 1 900000000000207008 733073007 276206000 SubClassOf(ObjectIntersectionOf(:64572001 ObjectSomeValuesFrom(:609096000 ObjectIntersectionOf(ObjectSomeValuesFrom(:246075003 :414561005) ObjectSomeValuesFrom(:363698007 :72651009) ObjectSomeValuesFrom(:370135005 :441862004)))) :276206000)
---
> ce557fc3-6f02-4818-84f1-deb19a351838 20190131 1 900000000000207008 733073007 276206000 SubClassOf(ObjectIntersectionOf(:64572001 ObjectSomeValuesFrom(:609096000 ObjectIntersectionOf(ObjectSomeValuesFrom(:246075003 :414561005) ObjectSomeValuesFrom(:363698007 :770802007) ObjectSomeValuesFrom(:370135005 :441862004)))) :276206000)

Inferred Relationship files11

ISRS-492

One Concept has 2 missing relationships, which we will need to fix before the final Production OWL builds are started in April for July 2019 - Yong confirmed he's happy to go ahead with the Demo release in the meantime (via email at 12:13 on 31/01/2019)...Rory to confirm he is also happy with this.... :

id    effectiveTime    active    moduleId    sourceId    destinationId    relationshipGroup    typeId    characteristicTypeId    modifierId
        1        79410001    255399007    1    246454002    900000000000011006    900000000000451002
        1        79410001    78076003    1    363698007    900000000000011006    900000000000451002


GOOD NEWS IS THE REST ARE THE SAME CHANGES AS IN PROD (2 records inactivated plus 9 records reactivated as expected) + 20 Role Group only changes (still a result of Kai's fixes):

Expected by Yong:
THIS RECORD TO BE REMOVED: 10524475027,2019-01-31,1,900000000000207008,402134005,59258008,0,116680003,900000000000011006,900000000000451002
Expected by SCA Classification results:
REDUNDANT 11190159022 402134005 116680003 Is a (attribute) 59258008 900000000000011000 0
Actual:
< 10524475027 20190131 1 900000000000207008 402134005 59258008 0 116680003 900000000000011006 900000000000451002
----------------------------------------------------------------------------------------------------------------------------------------
Expected by Yong:
NEW ACTIVE RECORD TO BE ADDED
Expected by SCA Classification results:
INFERRED 402134005 116680003 Is a (attribute) 47382004 900000000000011000 0
Actual:
< 2706361027 20050731 0 900000000000207008 402134005 47382004 0 116680003 900000000000011006 900000000000451002
> 2706361027 20190131 1 900000000000207008 402134005 47382004 0 116680003 900000000000011006 900000000000451002
----------------------------------------------------------------------------------------------------------------------------------------
Expected by Yong:
NEW ACTIVE RECORD TO BE ADDED, PLUS OLD ACTIVE RECORD TO BE INACTIVATED
Expected by SCA Classification results:
REDUNDANT 11190128020 414941008 116680003 Is a (attribute) 312146001 900000000000011000 0
INFERRED 414941008 116680003 Is a (attribute) 276206000 900000000000011000 0
Actual:
< 2686759022 20050131 1 900000000000207008 414941008 312146001 0 116680003 900000000000011006 900000000000451002
> 2686759022 20190131 0 900000000000207008 414941008 312146001 0 116680003 900000000000011006 900000000000451002

> 11187378027 20190131 1 900000000000207008 414941008 276206000 0 116680003 900000000000011006 900000000000451002
----------------------------------------------------------------------------------------------------------------------------------------
Expected by Yong:
NEW ACTIVE RECORD TO BE ADDED
Expected by SCA Classification results:
INFERRED 23549005 116680003 Is a (attribute) 415723000 900000000000011000 0
Actual:
< 2689698024 20050731 0 900000000000207008 23549005 415723000 0 116680003 900000000000011006 900000000000451002
> 2689698024 20190131 1 900000000000207008 23549005 415723000 0 116680003 900000000000011006 900000000000451002
----------------------------------------------------------------------------------------------------------------------------------------
Expected by Yong:
NEW ACTIVE RECORD TO BE ADDED
Expected by SCA Classification results:
INFERRED 403060001 116680003 Is a (attribute) 403072007 900000000000011000 0
Actual:
< 2249445023 20050731 0 900000000000207008 403060001 403072007 0 116680003 900000000000011006 900000000000451002
> 2249445023 20190131 1 900000000000207008 403060001 403072007 0 116680003 900000000000011006 900000000000451002
----------------------------------------------------------------------------------------------------------------------------------------
Expected by Yong:
NEW ACTIVE RECORD TO BE ADDED
Expected by SCA Classification results:
INFERRED 403061002 116680003 Is a (attribute) 415723000 900000000000011000 0
Actual:
< 2706478024 20050731 0 900000000000207008 403061002 415723000 0 116680003 900000000000011006 900000000000451002
> 2706478024 20190131 1 900000000000207008 403061002 415723000 0 116680003 900000000000011006 900000000000451002
----------------------------------------------------------------------------------------------------------------------------------------
Expected by Yong:
NEW ACTIVE RECORD TO BE ADDED
Expected by SCA Classification results:
INFERRED 403062009 116680003 Is a (attribute) 403083003 900000000000011000 0
Actual:
< 2249450028 20050731 0 900000000000207008 403062009 403083003 0 116680003 900000000000011006 900000000000451002
> 2249450028 20190131 1 900000000000207008 403062009 403083003 0 116680003 900000000000011006 900000000000451002
----------------------------------------------------------------------------------------------------------------------------------------
Expected by Yong:
NEW ACTIVE RECORD TO BE ADDED
Expected by SCA Classification results:
INFERRED 403063004 116680003 Is a (attribute) 403084009 900000000000011000 0
Actual:
< 2249451029 20050731 0 900000000000207008 403063004 403084009 0 116680003 900000000000011006 900000000000451002
> 2249451029 20190131 1 900000000000207008 403063004 403084009 0 116680003 900000000000011006 900000000000451002
----------------------------------------------------------------------------------------------------------------------------------------
Expected by Yong:
NEW ACTIVE RECORD TO BE ADDED
Expected by SCA Classification results:
INFERRED 403064005 116680003 Is a (attribute) 403086006 900000000000011000 0
Actual:
< 2249454021 20050731 0 900000000000207008 403064005 403086006 0 116680003 900000000000011006 900000000000451002
> 2249454021 20190131 1 900000000000207008 403064005 403086006 0 116680003 900000000000011006 900000000000451002
----------------------------------------------------------------------------------------------------------------------------------------
Expected by Yong:
NEW ACTIVE RECORD TO BE ADDED
Expected by SCA Classification results:
INFERRED 68543009 116680003 Is a (attribute) 403065006 900000000000011000 0
Actual:
< 2230481025 20050731 0 900000000000207008 68543009 403065006 0 116680003 900000000000011006 900000000000451002
> 2230481025 20190131 1 900000000000207008 68543009 403065006 0 116680003 900000000000011006 900000000000451002

Production (January 2019 DRUGS Alpha) VERSION 2 vs Production (January 2019 DRUGS Alpha) VERSION 3 traceability

Differences found in package Comparison

Number of records impactedRationale
Inferred Relationship files4022
Classification results improved after Kai's fixes to external classifier - confirmed by Kai to now be correct

Production (January 2019 International MEMBER Release) vs Production (January 2019 DRUGS Alpha) VERSION 2 traceability

Differences found in package Comparison

Number of records impactedRationale
OWL Expression Refset files349545

349545 new active records added, BUT 349752 records expected (UNLESS OWLExpression Delta FROM OWL TOOLKIT INCLUDES PREVIOUSLY PUBLISHED 200 RECORDS??)

Original JULY 2018 OWLExpression file = 7 active (Ontology) records + 11 active (Axiom) records = 18 total

Jan 2019 MEMBER OWLExpression DELTA file = 1 inactive record (Axiom), 206 active records (Axiom) + 0 (Ontology) = 207 total

Jan 2019 MEMBER OWLExpression file = 1 inactive record (Axiom), 216 active records (Axiom) + 7 (Ontology) = 224 total

New Jan 2019 OWL DEMO OWLExpression file = 1 inactive records, 349768 active records = 349769 total

******* THIS IS CORRECT AS EXPECTED TOTAL SHOULD BE:

original July 2018 = 18 + 349752 (in Toolkit Delta) = 349770 *But 1 has been inactivated so has 2 records in Delta but not Snapshot


Cross checked - New OWL DEMO OWLExpression file contains: July 2018 Ontology+Axiom records + Jan 2019 Member records + NEW ones!

Stated Relationship files944975

815005 active records removed, BUT only 735261 inactive records added!

PLUS 770835 changes expected from Stated Rel Delta from OWL TOOLKIT - ALL INACTIVATION RECORDS...


Original JULY 2018 Stated Rel file = 174140 inactive records, 770835 active = 944975 total

Original MEMBER Stated Rel file = 209835 inactive records, 814884 active records = 1024719 total

New OWL DEMO Stated Rel file = 944975 inactive records, 0 active records = 944975 total

Inferred Relationship files140898

TOTALS NOT INCLUDING ROLE GROUP CHANGES + ID CHANGES: 140898 records (both active + inactive) removed, 139802 records added back in????

TOTALS NOT INCLUDING ID CHANGES: 162875 records (both active + inactive) removed, 161779 records added back in????

THEREFORE ROLE GROUP CHANGES: 21977 records removed, 21977 records added back in


Original JULY 2018 inferred snapshot file = 1660367 inactive records + 1095378 active records = 2755745 total

New Jan 2019 MEMBER inferred snapshot file = 1774500 inactive records + 1102030 active records = 2876530 total

New Jan 2019 OWL DEMO inferred snapshot file = 1773406 inactive records + 1102028 active records = 2875434 total


Diff between Jan 2019 Member release total + Jan 2019 OWL DEMO total = 1094 active + 2 inactive = 1096 total


Production (January 2018 DRUGS Alpha) VERSION 1 vs Production (January 2018 DRUGS Alpha) VERSION 2 traceability

Differences found in package Comparison

Number of records impactedRationale
OWL Ontology Refset files7All 7 records updated to Component Model ModuleID, as planned
MRCM Refset files76 new AttributeDomain and AttributeRange records, plus 7 new Domain records, as expected for new MRCM content since Jan 2018 release
Inferred Relationship files
Fixed property chains, as expected (though this is obviously obscured by the new inferred relationship data in Main since yesterday!)

Production (January 2018 International Release) vs Production (January 2018 DRUGS Alpha) VERSION 1 traceability

Differences found in package Comparison

Number of records impactedRationale
OWL Axiom Refset files
All 11 records present as expected - however the termServer has exported them with the Component Model ModuleID instead of the Core ModuleID, so have emailed Yong to ask for confirmation if this will impact the Alpha release, or can be fixed in time for the Production release.
OWL Ontology Refset files
All 7 records present and correct, as expected.
All other Full/Snapshot files
Larger than Int Edition as expected, as additional content added to MAIN since Jan 2018 release cut off.
All other Delta files
Smaller than Int Edition as expected, as only 3 months editing vs normal 6 months!
  • No labels