+-----------+----------+-----------------+----+-----------------------+
| Date:     | **Last   |                 | *  |                       |
| 0         | U        |                 | *R |                       |
| 1/12/2009 | pdate:** |                 | eq |                       |
|           |          |                 | ue |                       |
|           |          |                 | st |                       |
|           |          |                 | ed |                       |
|           |          |                 | b  |                       |
|           |          |                 | y: |                       |
|           |          |                 | ** |                       |
|           |          |                 |    |                       |
|           |          |                 | C  |                       |
|           |          |                 | ha |                       |
|           |          |                 | rl |                       |
|           |          |                 | es |                       |
|           |          |                 | G  |                       |
|           |          |                 | ri |                       |
|           |          |                 | ff |                       |
|           |          |                 | in |                       |
+-----------+----------+-----------------+----+-----------------------+
| Software  | **Change |                 |    | Area:                 |
| ver.      | Type     |                 |    |                       |
|           | (u       |                 |    | Database              |
| caDSR     | nderline |                 |    |                       |
| 4.0.0.0   | all that |                 |    |                       |
|           | a        |                 |    |                       |
|           | pply):** |                 |    |                       |
|           |          |                 |    |                       |
|           | [C       |                 |    |                       |
|           | ode]{.un |                 |    |                       |
|           | derline} |                 |    |                       |
|           | \| Data  |                 |    |                       |
|           | \|       |                 |    |                       |
|           | Server   |                 |    |                       |
|           | Config   |                 |    |                       |
|           | \|       |                 |    |                       |
|           | Docum    |                 |    |                       |
|           | entation |                 |    |                       |
|           | \|       |                 |    |                       |
|           | Other:   |                 |    |                       |
|           | \_       |                 |    |                       |
|           | \_\_\_\_ |                 |    |                       |
+-----------+----------+-----------------+----+-----------------------+
| **Problem |          |                 |    |                       |
| Sta       |          |                 |    |                       |
| tement**: |          |                 |    |                       |
|           |          |                 |    |                       |
| In the    |          |                 |    |                       |
| caDSR     |          |                 |    |                       |
| Database, |          |                 |    |                       |
| Class     |          |                 |    |                       |
| in        |          |                 |    |                       |
| heritance |          |                 |    |                       |
| for UML   |          |                 |    |                       |
| models is |          |                 |    |                       |
| being     |          |                 |    |                       |
| in        |          |                 |    |                       |
| correctly |          |                 |    |                       |
| retrieved |          |                 |    |                       |
| by the    |          |                 |    |                       |
| database  |          |                 |    |                       |
| UML       |          |                 |    |                       |
| Browser   |          |                 |    |                       |
| mat       |          |                 |    |                       |
| erialized |          |                 |    |                       |
| views.    |          |                 |    |                       |
+-----------+----------+-----------------+----+-----------------------+
| **Root    |          |                 |    |                       |
| Cause:**  |          |                 |    |                       |
|           |          |                 |    |                       |
| This is   |          |                 |    |                       |
| due to    |          |                 |    |                       |
| the fact  |          |                 |    |                       |
| that      |          |                 |    |                       |
| class     |          |                 |    |                       |
| in        |          |                 |    |                       |
| heritance |          |                 |    |                       |
| rela      |          |                 |    |                       |
| tionships |          |                 |    |                       |
| are being |          |                 |    |                       |
| filtered  |          |                 |    |                       |
| for       |          |                 |    |                       |
| classes   |          |                 |    |                       |
| that      |          |                 |    |                       |
| belong to |          |                 |    |                       |
| the same  |          |                 |    |                       |
| UML Model |          |                 |    |                       |
| and       |          |                 |    |                       |
| package.  |          |                 |    |                       |
| The       |          |                 |    |                       |
| filtering |          |                 |    |                       |
| should    |          |                 |    |                       |
| not       |          |                 |    |                       |
| include   |          |                 |    |                       |
| the UML   |          |                 |    |                       |
| package   |          |                 |    |                       |
| for the   |          |                 |    |                       |
| related   |          |                 |    |                       |
| classes.  |          |                 |    |                       |
| The only  |          |                 |    |                       |
| filtering |          |                 |    |                       |
| criteria  |          |                 |    |                       |
| should be |          |                 |    |                       |
| the UML   |          |                 |    |                       |
| Model,    |          |                 |    |                       |
| which     |          |                 |    |                       |
| should be |          |                 |    |                       |
| the same  |          |                 |    |                       |
| for the   |          |                 |    |                       |
| related   |          |                 |    |                       |
| classes.  |          |                 |    |                       |
+-----------+----------+-----------------+----+-----------------------+
| Proposed  |          |                 |    |                       |
| Solution: |          |                 |    |                       |
|           |          |                 |    |                       |
| Correct   |          |                 |    |                       |
| class     |          |                 |    |                       |
| in        |          |                 |    |                       |
| heritance |          |                 |    |                       |
| d         |          |                 |    |                       |
| erivation |          |                 |    |                       |
| by        |          |                 |    |                       |
| changing  |          |                 |    |                       |
| the       |          |                 |    |                       |
| filtering |          |                 |    |                       |
| for       |          |                 |    |                       |
| related   |          |                 |    |                       |
| classes   |          |                 |    |                       |
| to be     |          |                 |    |                       |
| based on  |          |                 |    |                       |
| the UML   |          |                 |    |                       |
| Model     |          |                 |    |                       |
| only,     |          |                 |    |                       |
| rather    |          |                 |    |                       |
| than the  |          |                 |    |                       |
| UML model |          |                 |    |                       |
| and       |          |                 |    |                       |
| package.  |          |                 |    |                       |
+-----------+----------+-----------------+----+-----------------------+
| Impact    |          |                 |    |                       |
| as        |          |                 |    |                       |
| sessment: |          |                 |    |                       |
|           |          |                 |    |                       |
| -         |          |                 |    |                       |
|   Changes |          |                 |    |                       |
|     to    |          |                 |    |                       |
|     Mat   |          |                 |    |                       |
| erialized |          |                 |    |                       |
|     View  |          |                 |    |                       |
|     Code  |          |                 |    |                       |
|           |          |                 |    |                       |
| (Database |          |                 |    |                       |
|     Code  |          |                 |    |                       |
|     de    |          |                 |    |                       |
| ployment) |          |                 |    |                       |
|           |          |                 |    |                       |
| -   Ap    |          |                 |    |                       |
| plication |          |                 |    |                       |
|           |          |                 |    |                       |
|  services |          |                 |    |                       |
|           |          |                 |    |                       |
|   restart |          |                 |    |                       |
+-----------+----------+-----------------+----+-----------------------+
| Changes   |          |                 |    |                       |
| needed to |          |                 |    |                       |
| c         |          |                 |    |                       |
| ompensate |          |                 |    |                       |
| /mitigate |          |                 |    |                       |
| impact:   |          |                 |    |                       |
|           |          |                 |    |                       |
| Modify    |          |                 |    |                       |
| the       |          |                 |    |                       |
| database  |          |                 |    |                       |
| mat       |          |                 |    |                       |
| erialized |          |                 |    |                       |
| view      |          |                 |    |                       |
| (         |          |                 |    |                       |
| SBREXT.UP |          |                 |    |                       |
| _GEN_META |          |                 |    |                       |
| DATA_MVW) |          |                 |    |                       |
| that      |          |                 |    |                       |
| retrieves |          |                 |    |                       |
| class     |          |                 |    |                       |
| inh       |          |                 |    |                       |
| eritance, |          |                 |    |                       |
| to filter |          |                 |    |                       |
| related   |          |                 |    |                       |
| classes   |          |                 |    |                       |
| based on  |          |                 |    |                       |
| the UML   |          |                 |    |                       |
| Model or  |          |                 |    |                       |
| CS        |          |                 |    |                       |
| id        |          |                 |    |                       |
| entifier, |          |                 |    |                       |
| rather    |          |                 |    |                       |
| than the  |          |                 |    |                       |
| CS-CSI    |          |                 |    |                       |
| i         |          |                 |    |                       |
| dentifier |          |                 |    |                       |
| (model    |          |                 |    |                       |
| and       |          |                 |    |                       |
| package). |          |                 |    |                       |
+-----------+----------+-----------------+----+-----------------------+
| **URL of  |          |                 |    |                       |
| s         |          |                 |    |                       |
| upporting |          |                 |    |                       |
| documen   |          |                 |    |                       |
| tation**: |          |                 |    |                       |
|           |          |                 |    |                       |
| Link to   |          |                 |    |                       |
| Gforge    |          |                 |    |                       |
| Tracker   |          |                 |    |                       |
| \# 1866:  |          |                 |    |                       |
| [[h       |          |                 |    |                       |
| ttps://gf |          |                 |    |                       |
| orge.nci. |          |                 |    |                       |
| nih.gov/t |          |                 |    |                       |
| racker/in |          |                 |    |                       |
| dex.php?f |          |                 |    |                       |
| unc=detai |          |                 |    |                       |
| l&aid=186 |          |                 |    |                       |
| 66&group_ |          |                 |    |                       |
| id=60&ati |          |                 |    |                       |
| d=323]{.u |          |                 |    |                       |
| nderline} |          |                 |    |                       |
| ](https:/ |          |                 |    |                       |
| /gforge.n |          |                 |    |                       |
| ci.nih.go |          |                 |    |                       |
| v/tracker |          |                 |    |                       |
| /index.ph |          |                 |    |                       |
| p?func=de |          |                 |    |                       |
| tail&aid= |          |                 |    |                       |
| 18666&gro |          |                 |    |                       |
| up_id=60& |          |                 |    |                       |
| atid=323) |          |                 |    |                       |
|           |          |                 |    |                       |
| DRT       |          |                 |    |                       |
| request   |          |                 |    |                       |
| \# 872    |          |                 |    |                       |
| for QA    |          |                 |    |                       |
| M         |          |                 |    |                       |
| igration: |          |                 |    |                       |
|           |          |                 |    |                       |
| <         |          |                 |    |                       |
| https://s |          |                 |    |                       |
| ystem-req |          |                 |    |                       |
| uests-tes |          |                 |    |                       |
| t.nci.nih |          |                 |    |                       |
| .gov:7443 |          |                 |    |                       |
| /jira/bro |          |                 |    |                       |
| wse/TASKM |          |                 |    |                       |
| GT-872>\[ |          |                 |    |                       |
| [[Show    |          |                 |    |                       |
| »]{.unde  |          |                 |    |                       |
| rline}]() |          |                 |    |                       |
| \]        |          |                 |    |                       |
|           |          |                 |    |                       |
| [[Nadine  |          |                 |    |                       |
| Azie]{.u  |          |                 |    |                       |
| nderline} |          |                 |    |                       |
| ](https:/ |          |                 |    |                       |
| /system-r |          |                 |    |                       |
| equests-t |          |                 |    |                       |
| est.nci.n |          |                 |    |                       |
| ih.gov:74 |          |                 |    |                       |
| 43/jira/s |          |                 |    |                       |
| ecure/Vie |          |                 |    |                       |
| wProfile. |          |                 |    |                       |
| jspa?name |          |                 |    |                       |
| =azien) - |          |                 |    |                       |
| 08/Jan/09 |          |                 |    |                       |
| 10:27 AM  |          |                 |    |                       |
| Link to   |          |                 |    |                       |
| Gforge    |          |                 |    |                       |
| Tracker   |          |                 |    |                       |
| \# 1866:  |          |                 |    |                       |
| [[h       |          |                 |    |                       |
| ttps://gf |          |                 |    |                       |
| orge.nci. |          |                 |    |                       |
| nih.gov/t |          |                 |    |                       |
| racker/in |          |                 |    |                       |
| dex.php?f |          |                 |    |                       |
| unc=detai |          |                 |    |                       |
| l&aid=186 |          |                 |    |                       |
| 66&group_ |          |                 |    |                       |
| id=60&ati |          |                 |    |                       |
| d=323]{.u |          |                 |    |                       |
| nderline} |          |                 |    |                       |
| ](https:/ |          |                 |    |                       |
| /gforge.n |          |                 |    |                       |
| ci.nih.go |          |                 |    |                       |
| v/tracker |          |                 |    |                       |
| /index.ph |          |                 |    |                       |
| p?func=de |          |                 |    |                       |
| tail&aid= |          |                 |    |                       |
| 18666&gro |          |                 |    |                       |
| up_id=60& |          |                 |    |                       |
| atid=323) |          |                 |    |                       |
+-----------+----------+-----------------+----+-----------------------+
| Comments  |          |                 |    |                       |
| from      |          |                 |    |                       |
| Board or  |          |                 |    |                       |
| 3^rd^     |          |                 |    |                       |
| Parties:  |          |                 |    |                       |
+-----------+----------+-----------------+----+-----------------------+
| Approval  |          | Decision:       |    | Signatures:           |
| Date:     |          |                 |    |                       |
|           |          | Implement as    |    | Infrastructure        |
|           |          | described       |    | Engineering:          |
|           |          |                 |    |                       |
|           |          | Further         |    | Applications          |
|           |          | research        |    | Engineering:          |
|           |          | /design         |    |                       |
|           |          |                 |    | Quality Assurance:    |
|           |          | \[give details  |    |                       |
|           |          | below\]         |    | Biomedical            |
|           |          |                 |    | Informatics:          |
|           |          | Defer to next   |    |                       |
|           |          | release         |    | Community/Alliances:  |
|           |          |                 |    |                       |
|           |          | Not approved    |    |                       |
+-----------+----------+-----------------+----+-----------------------+
| **If      |          |                 |    |                       |
| further   |          |                 |    |                       |
| research  |          |                 |    |                       |
| required, |          |                 |    |                       |
| describe  |          |                 |    |                       |
| in        |          |                 |    |                       |
| formation |          |                 |    |                       |
| that is   |          |                 |    |                       |
| needed to |          |                 |    |                       |
| render a  |          |                 |    |                       |
| de        |          |                 |    |                       |
| cision:** |          |                 |    |                       |
+-----------+----------+-----------------+----+-----------------------+
| **Other   |          |                 |    |                       |
| Co        |          |                 |    |                       |
| mments:** |          |                 |    |                       |
+-----------+----------+-----------------+----+-----------------------+