I2B2 Patient Dimension Table

[shariqtariq]

I am looking at the Patient_Dimension Table in the i2b2demodata table and it is empty. Yet the i2b2 client is returning the right number of patients in the database. Is it possible that the i2b2 client is mapping to a different  table?

[mabaj...@mac.com]

Hello,

There could be a number of things happening.

It's important to note that the web client does not point to a database... it points to an i2b2 instance. And the databases that are pointed to by that i2b2 instance are in the *-ds.xml files inside the standalone/deployments folder in Wildfly.

Let's assume: The demo database is the same for every demo instance. The i2b2 webclient can be pointing to any demo instance and receive correct numbers.

1. The webclient by default (if I remember correctly) points to a demo system hosted by the i2b2 tranSMART Foundation. So, if you have not updated the web client's configuration to point to your own i2b2 instance, then it could be communicating with the Foundation's demo instance, and the numbers would look correct.

2.  When you say that the webclient is returning the correct number of patients, is this from a query on the patient demographics, or is this for a query on a diagnosis, medication, procedure, or lab test (clinical observation)? 

If you are getting patient counts on a Demographics-related query, and your Patient_Dimension table is empty, then that means that the counts are coming from a different database... it could be that your Wildfly *-ds.xml files are pointing to a different database, or your webclient is pointing to a completely different instance of i2b2.

If you are getting patient counts on an Observation-Facts-related query, then it's not possible to discern from the information you have provided so far where the counts may be coming from... could be from your database, could be from somewhere else.

I hope this information proves useful.

Kind regards,

Mark Abajian

Abajian Consulting, LLC
P.O. Box 8017, Glendale, CA  91224
Email  in...@abajian-consulting.com   |   Mobile  +1 (818) 726–0372

Web  https://www.abajian-consulting.com