1 / 11

Common Queries for MDRs WG4 SQL16

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

burke
Download Presentation

Common Queries for MDRs WG4 SQL16

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 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

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

  7. 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

  8. 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

  9. 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

  10. 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

  11. 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

More Related