Appendix 3-1B.doc
From Tissue/Biospecimen Banking and Technology Tools
D. Find all participants having malignant endometrial tumor and malignant ovarian tumor. The malignant ovary should not have Pathological Status as Metastatic.
For this query, add the classes in the Diagrammatic View with conditions on the attribute as shown in the following table:
| No | Class | Attribute | Operator | Condition |
|---|---|---|---|---|
| 1 | Participant | Id | Is Not Null | |
| 2 | SpecimenCollectionGroup | Id | Is Not Null | |
| 3 | TissueSpecimen | Pathological Status | In | Malignant |
| 4 | TissueSpecimen | Pathological Status | In | Malignant |
| 5 | TissueSpecimen | Pathological Status | Not In | Metastatic |
| 6 | SpecimenCharacteristics | Tissue Site | In | Endometrium |
| 7 | SpecimenCharacteristics | Tissue Site | In | Ovary |
After adding the classes in the Diagrammatic View, connect the following classes: 1. Participant to SpecimenCollectionGroup. 2. SpecimenCollectionGroup to TissueSpecimen (1 to both). 3. SpecimenCharacteristics (with Tissue Site as Ovary) to TissueSpecimen (with Pathological Status In Malignant and Not In Metastatic). 4. SpecimenCharacteristics (with Tissue Site as Endometrium) to TissueSpecimen (with Pathological Status in Malignant). The following figure shows how the diagram will look like.
Click the Search button. The result will display all participants having malignant endometrial tumor and malignant ovarian tumor (primary, not metastatic).
Figure 144: Diagrammatic representation for case D
E. Find all cases where banked colon tissue and the associated lymph nodes are positive for cancer. For this query, add the classes in the Diagrammatic View with conditions on the attribute as shown in the following table:
| No | Class | Attribute | Operator | Condition |
|---|---|---|---|---|
| 1 | Participant | Id | Is Not Null | |
| 2 | SpecimenCollectionGroup | Id | Is Not Null | |
| 3 | TissueSpecimen | Pathological Status | In | Malignant |
| 4 | TissueSpecimen | Pathological Status | In | Malignant |
| 5 | SpecimenCharacteristics | Tissue Site | In | Colon, Nos. |
| 6 | SpecimenCharacteristics | Tissue Site | In | Lymph Node, Nos. |
After adding the classes in the Diagrammatic View, connect the following classes: 1. Participant to SpecimenCollectionGroup. 2. Tissue Specimen to SpecimenCharacteristics (1 to 1). 3. SpecimenCollectionGroup to TissueSpecimen (1 to both).
The following figure shows how the diagram will look like.
Click the Search button. The result will display all the participants whose banked colon tissue and the associated lymph nodes are cancerous.
Figure 145: Diagrammatic representation for case E
F. Find all male participants having lung cancer for which frozen tumor and matching normal tissues are available. For this query, add the classes in the Diagrammatic View with conditions on the attribute as shown in the following table:
| No | Class | Attribute | Operator | Condition |
|---|---|---|---|---|
| 1 | Participant | Gender | In | Male Gender |
| 2 | SpecimenCollectionGroup | Id | Is Not Null | |
| 3 | TissueSpecimen | Pathological Status | In | Malignant |
| Type | In | Frozen Tissue | ||
| 4 | TissueSpecimen | Pathological Status | In | Non Malignant |
| Type | In | Frozen Tissue | ||
| 5 | SpecimenCharacteristics | Tissue Site | In | Lung, Nos. |
| 6 | SpecimenCharacteristics | Tissue Site | In | Lung, Nos. |
After adding the classes in the Diagrammatic View, connect the following classes:
1. Participant to SpecimenCollectionGroup.
2. SpecimenCollectionGroup to TissueSpecimen (1 to both).
3. TissueSpecimen with SpecimenCharacteristics (1 to 1).
The following figure shows how the diagram will look like.
Click the Search button. The result will display all the male participants having lung cancer for which frozen tumor and matching normal tissues are available.
Figure 146: Diagrammatic representation for case F
