Common queries for mdrs wg4 sql16
Download
1 / 11

Common Queries for MDRs WG4 SQL16 - PowerPoint PPT Presentation


  • 74 Views
  • Uploaded on

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. Common Queries. Search Data Element By Data Element names and definitions DataElement.Preferred Name DataElement.Preferred Definition DE.Desingations

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Common Queries for MDRs WG4 SQL16' - burke


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Common queries for mdrs wg4 sql16

ISO/IEC JTC1/SC32/WG2 N1484

Common Queries for MDRsWG4 SQL16

ISO/IEC JTC1 SC 32 WG2 input to WG4 on SQL-MM Part 8

November, 2010


Common queries
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


Use case 1 end user search data element using names and definitions
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


Use case 2 end user search data element using value domain permissible valuemeaning
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


Use case 3 mdr registry search administered item using workflow status and registration status
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


All administered items
All Administered Items

<class name="gov.nih.nci.cadsr.domain.DataElement" recordNumber="1">

<field name="beginDate">09-04-2006</field>

<field name="changeNote">

Removed explanatory comment from definition to facilitate reuse. mc 2/19/07

</field>

<field name="createdBy">COOPERM</field>

<field name="dateCreated">09-04-2006</field>

<field name="dateModified">02-12-2010</field>

<field name="deletedIndicator">No</field>

<field name="endDate">-</field>

<field name="id">1CAAC0BD-A158-3370-E044-0003BA3F9857</field>

<field name="latestVersionIndicator">Yes</field>

<field name="modifiedBy">REEVESD</field>

<field name="origin">-</field>

<field name="preferredDefinition">

The string of characters that represents the electronic mail address of a person.

</field>

<field name="preferredName">Person Email Address Text</field>

<field name="publicID">2517550</field> {Item Identifier}

{registration authority Identifier}

<field name="registrationStatus">Standard</field>

<field name="unresolvedIssue">-</field>

<field name="version">1.0</field>

<field name="workflowStatusDescription">Reviewed and approved administered component</field>

<field name="workflowStatusName">RELEASED</field>

Returns the attributes of the Administered Item + additional item specific attributes

caDSR Class Browser:

http://cadsrapi.nci.nih.gov/cadsrapi40/ShowDynamicTree.action


All administered item attributes
All Administered Item Attributes

<field name="context" xlink:type="simple" xlink:href="http://cadsrapi.nci.nih.gov/cadsrapi40/GetXML?query=Context&DataElement[@id=1CAAC0BD-A158-3370-E044-0003BA3F9857]&roleName=context">getContext</field>

<field name="referenceDocumentCollection" xlink:type="simple" xlink:href="http://cadsrapi.nci.nih.gov/cadsrapi40/GetXML?query=ReferenceDocument&DataElement[@id=1CAAC0BD-A158-3370-E044-0003BA3F9857]&roleName=referenceDocumentCollection">getReferenceDocumentCollection</field>

<field name="registrations" xlink:type="simple" xlink:href="http://cadsrapi.nci.nih.gov/cadsrapi40/GetXML?query=Registration&DataElement[@id=1CAAC0BD-A158-3370-E044-0003BA3F9857]&roleName=registrations">getRegistrations</field>

<field name="administeredComponentContactCollection" xlink:type="simple" xlink:href="http://cadsrapi.nci.nih.gov/cadsrapi40/GetXML?query=AdministeredComponentContact&DataElement[@id=1CAAC0BD-A158-3370-E044-0003BA3F9857]&roleName=administeredComponentContactCollection">getAdministeredComponentContactCollection</field>

<field name="administeredComponentClassSchemeItemCollection" xlink:type="simple" xlink:href="http://cadsrapi.nci.nih.gov/cadsrapi40/GetXML?query=AdministeredComponentClassSchemeItem&DataElement[@id=1CAAC0BD-A158-3370-E044-0003BA3F9857]&roleName=administeredComponentClassSchemeItemCollection">getAdministeredComponentClassSchemeItemCollection</field>

<field name="designationCollection" xlink:type="simple" xlink:href="http://cadsrapi.nci.nih.gov/cadsrapi40/GetXML?query=Designation&DataElement[@id=1CAAC0BD-A158-3370-E044-0003BA3F9857]&roleName=designationCollection">getDesignationCollection</field>

<field name="definitionCollection" xlink:type="simple" xlink:href="http://cadsrapi.nci.nih.gov/cadsrapi40/GetXML?query=Definition&DataElement[@id=1CAAC0BD-A158-3370-E044-0003BA3F9857]&roleName=definitionCollection">getDefinitionCollection</field>

Context

Reference Documents

Registrations

Contacts

Classifications

Designations

Definitions


Data element specific attributes
Data Element Specific Attributes

<field name="valueDomain" xlink:type="simple" xlink:href="http://cadsrapi.nci.nih.gov/cadsrapi40/GetXML?query=ValueDomain&DataElement[@id=1CAAC0BD-A158-3370-E044-0003BA3F9857]&roleName=valueDomain">getValueDomain</field>

<field name="derivedDataElement" xlink:type="simple" xlink:href="http://cadsrapi.nci.nih.gov/cadsrapi40/GetXML?query=DerivedDataElement&DataElement[@id=1CAAC0BD-A158-3370-E044-0003BA3F9857]&roleName=derivedDataElement">getDerivedDataElement</field>

<field name="dataElementDerivationCollection" xlink:type="simple" xlink:href="http://cadsrapi.nci.nih.gov/cadsrapi40/GetXML?query=DataElementDerivation&DataElement[@id=1CAAC0BD-A158-3370-E044-0003BA3F9857]&roleName=dataElementDerivationCollection">getDataElementDerivationCollection</field>

<field name="dataElementConcept" xlink:type="simple" xlink:href="http://cadsrapi.nci.nih.gov/cadsrapi40/GetXML?query=DataElementConcept&DataElement[@id=1CAAC0BD-A158-3370-E044-0003BA3F9857]&roleName=dataElementConcept">getDataElementConcept</field>

<field name="childDataElementRelationshipsCollection" xlink:type="simple" xlink:href="http://cadsrapi.nci.nih.gov/cadsrapi40/GetXML?query=DataElementRelationship&DataElement[@id=1CAAC0BD-A158-3370-E044-0003BA3F9857]&roleName=childDataElementRelationshipsCollection">getChildDataElementRelationshipsCollection</field>

<field name="parentDataElementRelationshipsCollection" xlink:type="simple" xlink:href="http://cadsrapi.nci.nih.gov/cadsrapi40/GetXML?query=DataElementRelationship&DataElement[@id=1CAAC0BD-A158-3370-E044-0003BA3F9857]&roleName=parentDataElementRelationshipsCollection">getParentDataElementRelationshipsCollection</field>

</class>

Value Domain

Data Element Derivations

Data Element Concept

Child/Parent Data Elements


Value domain specific attributes
Value Domain Specific Attributes

<field name="characterSetName">-</field>

<field name="datatypeDescription">

A character string of letters, symbols, and/or numbers

</field>

<field name="datatypeIsCodegenCompatible">No</field>

<field name="datatypeName">CHARACTER</field>

<field name="datatypeSchemeReference">Not Specified</field>

<field name="decimalPlace">-</field>

<field name="formatName">-</field>

<field name="maximumLengthNumber">320</field>

<field name="UOMName">-</field>

<field name="parentValueDomainRelationshipCollection" xlink:type="simple" xlink:href="http://cadsrapi.nci.nih.gov/cadsrapi40/GetXML?query=ValueDomainRelationship&NonenumeratedValueDomain[@id=151AFFDC-BE0F-04A1-E044-0003BA3F9857]&roleName=parentValueDomainRelationshipCollection">getParentValueDomainRelationshipCollection</field>

<field name="conceptualDomain" xlink:type="simple" xlink:href="http://cadsrapi.nci.nih.gov/cadsrapi40/GetXML?query=ConceptualDomain&NonenumeratedValueDomain[@id=151AFFDC-BE0F-04A1-E044-0003BA3F9857]&roleName=conceptualDomain">getConceptualDomain</field>

<field name="childValueDomainRelationshipCollection" xlink:type="simple" xlink:href="http://cadsrapi.nci.nih.gov/cadsrapi40/GetXML?query=ValueDomainRelationship&NonenumeratedValueDomain[@id=151AFFDC-BE0F-04A1-E044-0003BA3F9857]&roleName=childValueDomainRelationshipCollection">getChildValueDomainRelationshipCollection</field>

<field name="represention" xlink:type="simple" xlink:href="http://cadsrapi.nci.nih.gov/cadsrapi40/GetXML?query=Representation&NonenumeratedValueDomain[@id=151AFFDC-BE0F-04A1-E044-0003BA3F9857]&roleName=represention">getRepresention</field>

</class>

Character Set

Datatype

Decimal Places

Format

Maximum Character Quantity

Unit of Measure

Parent/Child Value Domain

Conceptual Domain

Representation

Data Element Collection


Data element concept specific attributes
Data Element Concept Specific Attributes

<field name="property" xlink:type="simple" xlink:href="http://cadsrapi.nci.nih.gov/cadsrapi40/GetXML?query=Property&DataElementConcept[@id=FA0F3C50-6790-7512-E034-0003BA3F9857]&roleName=property">getProperty</field>

<field name="objectClass" xlink:type="simple" xlink:href="http://cadsrapi.nci.nih.gov/cadsrapi40/GetXML?query=ObjectClass&DataElementConcept[@id=FA0F3C50-6790-7512-E034-0003BA3F9857]&roleName=objectClass">getObjectClass</field>

<field name="conceptualDomain" xlink:type="simple" xlink:href="http://cadsrapi.nci.nih.gov/cadsrapi40/GetXML?query=ConceptualDomain&DataElementConcept[@id=FA0F3C50-6790-7512-E034-0003BA3F9857]&roleName=conceptualDomain">getConceptualDomain</field>

<field name="dataElementCollection" xlink:type="simple" xlink:href="http://cadsrapi.nci.nih.gov/cadsrapi40/GetXML?query=DataElement&DataElementConcept[@id=FA0F3C50-6790-7512-E034-0003BA3F9857]&roleName=dataElementCollection">getDataElementCollection</field>

<field name="parentDataElementConceptRelationshipCollection" xlink:type="simple" xlink:href="http://cadsrapi.nci.nih.gov/cadsrapi40/GetXML?query=DataElementConceptRelationship&DataElementConcept[@id=FA0F3C50-6790-7512-E034-0003BA3F9857]&roleName=parentDataElementConceptRelationshipCollection">getParentDataElementConceptRelationshipCollection</field>

<field name="childDataElementConceptRelationshipCollection" xlink:type="simple" xlink:href="http://cadsrapi.nci.nih.gov/cadsrapi40/GetXML?query=DataElementConceptRelationship&DataElementConcept[@id=FA0F3C50-6790-7512-E034-0003BA3F9857]&roleName=childDataElementConceptRelationshipCollection">getChildDataElementConceptRelationshipCollection</field>

Property

Parent/Child Property

Object Class

Conceptual Domain

Data Element Collection


Object class specific attributes
Object Class Specific Attributes

<field name="conceptDerivationRule" xlink:type="simple" xlink:href="http://cadsrapi.nci.nih.gov/cadsrapi40/GetXML?query=ConceptDerivationRule&ObjectClass[@id=F9FC6DF7-66EB-4CAB-E034-0003BA3F9857]&roleName=conceptDerivationRule">getConceptDerivationRule</field>

<field name="dataElementConceptCollection" xlink:type="simple" xlink:href="http://cadsrapi.nci.nih.gov/cadsrapi40/GetXML?query=DataElementConcept&ObjectClass[@id=F9FC6DF7-66EB-4CAB-E034-0003BA3F9857]&roleName=dataElementConceptCollection">getDataElementConceptCollection</field>

Concept

Data Element Concept Collection


ad