#146: map CDM-in-i2b2 to existing i2b2 data and/or ontologies
-------------------------+-----------------------------------
Reporter: dconnolly | Owner: ngraham
Type: enhancement | Status: assigned
Priority: major | Milestone: initial-data-domains
Component: data-stds | Resolution:
Keywords: | Blocked By: 109
Blocking: 144 |
-------------------------+-----------------------------------
Changes (by ngraham):
* cc: SNMURPHY@… (added)
Comment:
To answer diagnosis questions for #144, I attempted to add a diagnosis CDM
view (see [https://bitbucket.org/njgraham/pcori-annotated-data-
dictionary/commits/eb6e04281dfd9fd92758da1d51c7baf1d38e8e2e eb6e042]) much
like I did for demographics and encounters. Unfortunately, querying this
view results in really bad performance - I let it run for several minutes
before killing the session. I plan to take a look at the execution plans.
Without index hints, some of the other queries in the same file took a
long time so maybe Oracle has generated an non-ideal plan and I can make
it better with some tuning.
--
Ticket URL:
<http://informatics.gpcnetwork.org/trac/Project/ticket/146#comment:5>
gpc-informatics <http://informatics.gpcnetwork.org/>
Greater Plains Network - Informatics
_______________________________________________
Gpc-dev mailing list
Gpc-dev@listserv.kumc.edu
http://listserv.kumc.edu/mailman/listinfo/gpc-dev
