Common Queries for MDRs WG4 SQL16 - PowerPoint PPT Presentation

1 / 11
About This Presentation
Title:

Common Queries for MDRs WG4 SQL16

Description:

ISO/IEC JTC1/SC32/WG2 N1484 Common Queries for MDRs WG4 SQL16 ISO/IEC JTC1 SC 32 WG2 input to WG4 on SQL-MM Part 8 November, 2010 – PowerPoint PPT presentation

Number of Views:107
Avg rating:3.0/5.0
Slides: 12
Provided by: warz150
Category:
Tags: common | mdrs | queries | sql16 | wg4

less

Transcript and Presenter's Notes

Title: Common Queries for MDRs WG4 SQL16


1
Common Queries for MDRsWG4 SQL16
ISO/IEC JTC1/SC32/WG2 N1484
  • ISO/IEC JTC1 SC 32 WG2 input to WG4 on SQL-MM
    Part 8
  • November, 2010

2
Common Queries
  • Search Data Element By Data Element names and
    definitions
  • DataElement.Preferred Name
  • DataElement.Preferred Definition
  • DE.Desingations
  • DE.Definitions
  • Search Data Element by Value Domain Permissible
    Values (possible instances)
  • VD.PV.ValueMeaning
  • 3 Search Data Element by Property name
  • 1 Property.PreferredName
  • 2 Property.ConceptName
  • 4 Search Data Element by Object Class name
  • 1 OC.PreferredName
  • 2 OC.ConceptName
  • 5 Search Data Element by Data Element Concept
    name
  • 1 DEC.Preferred Name
  • 2 DEC.ConceptName

3
Use Case 1End UserSearch Data Element Using
Names and Definitions
  • Search Data Element Preferred Name
  • Search Data Element Alternate Names
  • Search Data Element Definition

Use Case 1Returns Expanded DE Schema
4
Use Case 2End UserSearch Data Element using
Value Domain Permissible.valueMeaning
  • Search Data Element Preferred Name
  • Search Data Element Alternate Names
  • Search Data Element Definition

Use Case 2Returns Expanded DE Schema
5
Use Case 3MDR RegistrySearch Administered
ItemUsing Workflow Status and Registration Status
  • Search Data Element Registration Status
    Standard
  • Search Value Domain Workflow Status Released

Use Case 1Returns Item using appropriate type
schema
Concept
6
All Administered Items
  • ltclass name"gov.nih.nci.cadsr.domain.DataElement"
    recordNumber"1"gt
  • ltfield name"beginDate"gt09-04-2006lt/fieldgt
  • -
  • ltfield name"changeNote"gt
  • Removed explanatory comment from definition to
    facilitate reuse. mc 2/19/07
  • lt/fieldgt
  • ltfield name"createdBy"gtCOOPERMlt/fieldgt
  • ltfield name"dateCreated"gt09-04-2006lt/fieldgt
  • ltfield name"dateModified"gt02-12-2010lt/fieldgt
  • ltfield name"deletedIndicator"gtNolt/fieldgt
  • ltfield name"endDate"gt-lt/fieldgt
  • ltfield name"id"gt1CAAC0BD-A158-3370-E044-0003BA3F9
    857lt/fieldgt
  • ltfield name"latestVersionIndicator"gtYeslt/fieldgt
  • ltfield name"modifiedBy"gtREEVESDlt/fieldgt
  • ltfield name"origin"gt-lt/fieldgt
  • ltfield name"preferredDefinition"gt
  • The string of characters that represents the
    electronic mail address of a person.
  • lt/fieldgt
  • ltfield name"preferredName"gtPerson Email Address
    Textlt/fieldgt
  • Returns the attributes of the Administered Item
    additional item specific attributes
  • caDSR Class Browser
  • http//cadsrapi.nci.nih.gov/cadsrapi40/ShowDynamic
    Tree.action

7
All Administered Item Attributes
  • ltfield name"context" xlinktype"simple"
    xlinkhref"http//cadsrapi.nci.nih.gov/cadsrapi40
    /GetXML?queryContextDataElement_at_id1CAAC0BD-A15
    8-3370-E044-0003BA3F9857roleNamecontext"gtgetCon
    textlt/fieldgt
  • ltfield name"referenceDocumentCollection"
    xlinktype"simple" xlinkhref"http//cadsrapi.nc
    i.nih.gov/cadsrapi40/GetXML?queryReferenceDocumen
    tDataElement_at_id1CAAC0BD-A158-3370-E044-0003BA3F
    9857roleNamereferenceDocumentCollection"gtgetRef
    erenceDocumentCollectionlt/fieldgt
  • ltfield name"registrations" xlinktype"simple"
    xlinkhref"http//cadsrapi.nci.nih.gov/cadsrapi40
    /GetXML?queryRegistrationDataElement_at_id1CAAC0B
    D-A158-3370-E044-0003BA3F9857roleNameregistrati
    ons"gtgetRegistrationslt/fieldgt
  • ltfield name"administeredComponentContactCollectio
    n" xlinktype"simple" xlinkhref"http//cadsrapi
    .nci.nih.gov/cadsrapi40/GetXML?queryAdministeredC
    omponentContactDataElement_at_id1CAAC0BD-A158-3370
    -E044-0003BA3F9857roleNameadministeredComponent
    ContactCollection"gtgetAdministeredComponentContact
    Collectionlt/fieldgt
  • ltfield name"administeredComponentClassSchemeItemC
    ollection" xlinktype"simple" xlinkhref"http//
    cadsrapi.nci.nih.gov/cadsrapi40/GetXML?queryAdmin
    isteredComponentClassSchemeItemDataElement_at_id1C
    AAC0BD-A158-3370-E044-0003BA3F9857roleNameadmin
    isteredComponentClassSchemeItemCollection"gtgetAdmi
    nisteredComponentClassSchemeItemCollectionlt/fieldgt
  • ltfield name"designationCollection"
    xlinktype"simple" xlinkhref"http//cadsrapi.nc
    i.nih.gov/cadsrapi40/GetXML?queryDesignationData
    Element_at_id1CAAC0BD-A158-3370-E044-0003BA3F9857
    roleNamedesignationCollection"gtgetDesignationColl
    ectionlt/fieldgt
  • ltfield name"definitionCollection"
    xlinktype"simple" xlinkhref"http//cadsrapi.nc
    i.nih.gov/cadsrapi40/GetXML?queryDefinitionDataE
    lement_at_id1CAAC0BD-A158-3370-E044-0003BA3F9857r
    oleNamedefinitionCollection"gtgetDefinitionCollect
    ionlt/fieldgt
  • Context
  • Reference Documents
  • Registrations
  • Contacts
  • Classifications
  • Designations
  • Definitions

8
Data Element Specific Attributes
  • ltfield name"valueDomain" xlinktype"simple"
    xlinkhref"http//cadsrapi.nci.nih.gov/cadsrapi40
    /GetXML?queryValueDomainDataElement_at_id1CAAC0BD
    -A158-3370-E044-0003BA3F9857roleNamevalueDomain
    "gtgetValueDomainlt/fieldgt
  • ltfield name"derivedDataElement"
    xlinktype"simple" xlinkhref"http//cadsrapi.nc
    i.nih.gov/cadsrapi40/GetXML?queryDerivedDataEleme
    ntDataElement_at_id1CAAC0BD-A158-3370-E044-0003BA3
    F9857roleNamederivedDataElement"gtgetDerivedData
    Elementlt/fieldgt
  • ltfield name"dataElementDerivationCollection"
    xlinktype"simple" xlinkhref"http//cadsrapi.nc
    i.nih.gov/cadsrapi40/GetXML?queryDataElementDeriv
    ationDataElement_at_id1CAAC0BD-A158-3370-E044-0003
    BA3F9857roleNamedataElementDerivationCollection
    "gtgetDataElementDerivationCollectionlt/fieldgt
  • ltfield name"dataElementConcept"
    xlinktype"simple" xlinkhref"http//cadsrapi.nc
    i.nih.gov/cadsrapi40/GetXML?queryDataElementConce
    ptDataElement_at_id1CAAC0BD-A158-3370-E044-0003BA3
    F9857roleNamedataElementConcept"gtgetDataElement
    Conceptlt/fieldgt
  • ltfield name"childDataElementRelationshipsCollecti
    on" xlinktype"simple" xlinkhref"http//cadsrap
    i.nci.nih.gov/cadsrapi40/GetXML?queryDataElementR
    elationshipDataElement_at_id1CAAC0BD-A158-3370-E04
    4-0003BA3F9857roleNamechildDataElementRelations
    hipsCollection"gtgetChildDataElementRelationshipsCo
    llectionlt/fieldgt
  • ltfield name"parentDataElementRelationshipsCollect
    ion" xlinktype"simple" xlinkhref"http//cadsra
    pi.nci.nih.gov/cadsrapi40/GetXML?queryDataElement
    RelationshipDataElement_at_id1CAAC0BD-A158-3370-E0
    44-0003BA3F9857roleNameparentDataElementRelatio
    nshipsCollection"gtgetParentDataElementRelationship
    sCollectionlt/fieldgt
  • lt/classgt
  • Value Domain
  • Data Element Derivations
  • Data Element Concept
  • Child/Parent Data Elements

9
Value Domain Specific Attributes
  • ltfield name"characterSetName"gt-lt/fieldgt
  • ltfield name"datatypeDescription"gt
  • A character string of letters, symbols, and/or
    numbers
  • lt/fieldgt
  • ltfield name"datatypeIsCodegenCompatible"gtNolt/fiel
    dgt
  • ltfield name"datatypeName"gtCHARACTERlt/fieldgt
  • ltfield name"datatypeSchemeReference"gtNot
    Specifiedlt/fieldgt
  • ltfield name"decimalPlace"gt-lt/fieldgt
  • ltfield name"formatName"gt-lt/fieldgt
  • ltfield name"maximumLengthNumber"gt320lt/fieldgt
  • ltfield name"UOMName"gt-lt/fieldgt
  • ltfield name"parentValueDomainRelationshipCollecti
    on" xlinktype"simple" xlinkhref"http//cadsrap
    i.nci.nih.gov/cadsrapi40/GetXML?queryValueDomainR
    elationshipNonenumeratedValueDomain_at_id151AFFDC-
    BE0F-04A1-E044-0003BA3F9857roleNameparentValueD
    omainRelationshipCollection"gtgetParentValueDomainR
    elationshipCollectionlt/fieldgt
  • ltfield name"conceptualDomain" xlinktype"simple"
    xlinkhref"http//cadsrapi.nci.nih.gov/cadsrapi4
    0/GetXML?queryConceptualDomainNonenumeratedValue
    Domain_at_id151AFFDC-BE0F-04A1-E044-0003BA3F9857r
    oleNameconceptualDomain"gtgetConceptualDomainlt/fie
    ldgt
  • ltfield name"childValueDomainRelationshipCollectio
    n" xlinktype"simple" xlinkhref"http//cadsrapi
    .nci.nih.gov/cadsrapi40/GetXML?queryValueDomainRe
    lationshipNonenumeratedValueDomain_at_id151AFFDC-B
    E0F-04A1-E044-0003BA3F9857roleNamechildValueDom
    ainRelationshipCollection"gtgetChildValueDomainRela
    tionshipCollectionlt/fieldgt
  • ltfield name"represention" xlinktype"simple"
    xlinkhref"http//cadsrapi.nci.nih.gov/cadsrapi40
    /GetXML?queryRepresentationNonenumeratedValueDom
    ain_at_id151AFFDC-BE0F-04A1-E044-0003BA3F9857role
    Namerepresention"gtgetRepresentionlt/fieldgt
  • lt/classgt
  • Character Set
  • Datatype
  • Decimal Places
  • Format
  • Maximum Character Quantity
  • Unit of Measure
  • Parent/Child Value Domain
  • Conceptual Domain
  • Representation
  • Data Element Collection

10
Data Element Concept Specific Attributes
  • ltfield name"property" xlinktype"simple"
    xlinkhref"http//cadsrapi.nci.nih.gov/cadsrapi40
    /GetXML?queryPropertyDataElementConcept_at_idFA0F
    3C50-6790-7512-E034-0003BA3F9857roleNamepropert
    y"gtgetPropertylt/fieldgt
  • ltfield name"objectClass" xlinktype"simple"
    xlinkhref"http//cadsrapi.nci.nih.gov/cadsrapi40
    /GetXML?queryObjectClassDataElementConcept_at_idF
    A0F3C50-6790-7512-E034-0003BA3F9857roleNameobje
    ctClass"gtgetObjectClasslt/fieldgt
  • ltfield name"conceptualDomain" xlinktype"simple"
    xlinkhref"http//cadsrapi.nci.nih.gov/cadsrapi4
    0/GetXML?queryConceptualDomainDataElementConcept
    _at_idFA0F3C50-6790-7512-E034-0003BA3F9857roleNam
    econceptualDomain"gtgetConceptualDomainlt/fieldgt
  • ltfield name"dataElementCollection"
    xlinktype"simple" xlinkhref"http//cadsrapi.nc
    i.nih.gov/cadsrapi40/GetXML?queryDataElementData
    ElementConcept_at_idFA0F3C50-6790-7512-E034-0003BA3
    F9857roleNamedataElementCollection"gtgetDataElem
    entCollectionlt/fieldgt
  • ltfield name"parentDataElementConceptRelationshipC
    ollection" xlinktype"simple" xlinkhref"http//
    cadsrapi.nci.nih.gov/cadsrapi40/GetXML?queryDataE
    lementConceptRelationshipDataElementConcept_at_idF
    A0F3C50-6790-7512-E034-0003BA3F9857roleNamepare
    ntDataElementConceptRelationshipCollection"gtgetPar
    entDataElementConceptRelationshipCollectionlt/field
    gt
  • ltfield name"childDataElementConceptRelationshipCo
    llection" xlinktype"simple" xlinkhref"http//c
    adsrapi.nci.nih.gov/cadsrapi40/GetXML?queryDataEl
    ementConceptRelationshipDataElementConcept_at_idFA
    0F3C50-6790-7512-E034-0003BA3F9857roleNamechild
    DataElementConceptRelationshipCollection"gtgetChild
    DataElementConceptRelationshipCollectionlt/fieldgt
  • Property
  • Parent/Child Property
  • Object Class
  • Conceptual Domain
  • Data Element Collection

11
Object Class Specific Attributes
  • ltfield name"conceptDerivationRule"
    xlinktype"simple" xlinkhref"http//cadsrapi.nc
    i.nih.gov/cadsrapi40/GetXML?queryConceptDerivatio
    nRuleObjectClass_at_idF9FC6DF7-66EB-4CAB-E034-0003
    BA3F9857roleNameconceptDerivationRule"gtgetConce
    ptDerivationRulelt/fieldgt
  • ltfield name"dataElementConceptCollection"
    xlinktype"simple" xlinkhref"http//cadsrapi.nc
    i.nih.gov/cadsrapi40/GetXML?queryDataElementConce
    ptObjectClass_at_idF9FC6DF7-66EB-4CAB-E034-0003BA3
    F9857roleNamedataElementConceptCollection"gtgetD
    ataElementConceptCollectionlt/fieldgt
  • Concept
  • Data Element Concept Collection
Write a Comment
User Comments (0)
About PowerShow.com