RE: Articles as requested.

[Hannan, Terry J (DHHS)]

Dear Madhuri,

Thank you for the feedback. I am c.c. this to the Developers and Implementers communities in OpenMRS where there are people with the expertise in how to manage large databases. I do not have those capabilities.

Also Prof William Tierney of Regenstrief who led the MMRS project and involved the current  leaders of OpenMRS to create the system has also written on the topic of analysing large databases and also cost factors.

[To the OpenMRS groups-I am not sure if this is the correct way to post this notification].

Terry

 

Dr Terry J. Hannan MBBS;FRACP;FACHI;FACMI
Consultant Physician
Clinical Associate Professor  School of Human Health Sciences, University of Tasmania Department of Medicine, Launceston General Hospital
Charles Street Launceston 7250

Moderator: http://www.ghdonline.org/

Ph. 61 3 6348 7578
Mob. 0417 144 881
Fax 61 3 6348 7577
Email terry....@dhhs.tas.gov.au

Skype: thehannans

 

From: Madhuri Gandikota [mailto:madhuri....@gmail.com]
Sent: Thursday, 19 February 2015 5:36 AM
To: Hannan, Terry J (DHHS)
Subject: Re: Articles as requested.

 

Dear Prof. Hannan,

Please accept my congratulations on the flawless design and implementation of MMRS in developing nation.
I can fully relate to the experiences of such an endevour, both in terms of the technology and resource constraints such as power supply.

Despite that you were able to clearly change the flow of health care in MRHC.

 I started with HANA (after learning Access, and using Redcap)  so, I only know the strengths of HANA.  But I want to  to understand the strengths of technology.  In terms of Analytics I know STATA and its strengths.

I have a fair understanding of SAS.

But What i do not know is a) How kind of  large databases are developed in Health care?

b) what are the analytic capabilities of these databases?

Can you please suggest some references of projects of large scale implementation efforts -say for a 500,000 to million patients.
The pros and cons of each system- in terms of costs, scalability, database vs. analytics.

Not necessarily in developing countries.

Thanks for your support and valuable suggestions .

Look forward to hear from you.

 

Regards
Madhuri

 

On Fri, Feb 13, 2015 at 11:04 PM, Hannan, Terry J (DHHS) <terry....@dhhs.tas.gov.au> wrote:

Please ask at any time.

Sent from my iPad

On 14 Feb 2015, at 6:03 pm, Madhuri Gandikota <madhuri....@gmail.com> wrote:

Dear Prof. Hannan,

Thanks a million !!. I truly appreciate  your help and all your contribution to the GH-community.

Regards
Madhuri

 

On Fri, Feb 13, 2015 at 7:37 PM, Hannan, Terry J (DHHS) <terry....@dhhs.tas.gov.au> wrote:

Dear Madhuri, here are two of the articles you requested. The MD Computing article is unavailable as the journal does not exist anymore.

I have added a few extras you may find interesting. Thank you for the request. Terry

 

Dr Terry J. Hannan MBBS;FRACP;FACHI;FACMI
Consultant Physician
Clinical Associate Professor  School of Human Health Sciences, University of Tasmania Department of Medicine, Launceston General Hospital
Charles Street Launceston 7250

Moderator: http://www.ghdonline.org/

Ph. 61 3 6348 7578
Mob. 0417 144 881
Fax 61 3 6348 7577
Email terry....@dhhs.tas.gov.au

Skype: thehannans

 

 

---

CONFIDENTIALITY NOTICE AND DISCLAIMER
The information in this transmission may be confidential and/or protected by legal professional privilege, and is intended only for the person or persons to whom it is addressed. If you are not such a person, you are warned that any disclosure, copying or dissemination of the information is unauthorised. If you have received the transmission in error, please immediately contact this office by telephone, fax or email, to inform us of the error and to enable arrangements to be made for the destruction of the transmission, or its return at our cost. No liability is accepted for any unauthorised use of the information contained in this transmission.

--

Thanks and Regards,

Madhuri Gandikota, Ph.D
Santa Clara

 

---

CONFIDENTIALITY NOTICE AND DISCLAIMER
The information in this transmission may be confidential and/or protected by legal professional privilege, and is intended only for the person or persons to whom it is addressed. If you are not such a person, you are warned that any disclosure, copying or dissemination of the information is unauthorised. If you have received the transmission in error, please immediately contact this office by telephone, fax or email, to inform us of the error and to enable arrangements to be made for the destruction of the transmission, or its return at our cost. No liability is accepted for any unauthorised use of the information contained in this transmission.

--

Thanks and Regards,

Madhuri Gandikota, Ph.D
Santa Clara

---

CONFIDENTIALITY NOTICE AND DISCLAIMER
The information in this transmission may be confidential and/or protected by legal professional privilege, and is intended only for the person or persons to whom it is addressed. If you are not such a person, you are warned that any disclosure, copying or dissemination of the information is unauthorised. If you have received the transmission in error, please immediately contact this office by telephone, fax or email, to inform us of the error and to enable arrangements to be made for the destruction of the transmission, or its return at our cost. No liability is accepted for any unauthorised use of the information contained in this transmission.

[Naomi Kimuyu]

Dear Madhuri,
To partially answer some of your questions,

We are currently running a project which we call the Clinical Information Network here in Kenya. The project runs in the paediatric departments of 14 public hospitals. The setup is such that we collect all paediatric admission information on patient discharge from the patients files. The data is entered onto a redcap database locally in the hospitals by a data entry clerk. We have cleaning files(written in R) that are run at the end of each day that generate an error log for the clerk. The clerk is required to counter check the data and once all is well the data is then transmitted to a central server where further checks are done using another R script and reports sent back to the hospital. [In essence this could easily be done by an EMR but since we dont have any running successfully in our setting this is our workaround]

a) How kind of  large databases are developed in Health care?

In our case we have started to build a large database with over 42,000 patients so far and over 300 variables collected.

b) what are the analytic capabilities of these databases?

the data collected is pre-coded which makes it easy for us to run cleaning files to verify the data and run other scripts that auto generate hospital reports. We try to limit the use of free text as much as possible.

We dont have a publication out yet but there is one which has been submitted by one of our team members and we hope to get it published in the near future. It details what our setup is and the rationale behind what we are doing.

Regards,

Naomi Muinga

--
OpenMRS Implementers: http://om.rs/implist
Post: implem...@openmrs.org | Unsubscribe: implementers...@openmrs.org
Manage your OpenMRS subscriptions: http://om.rs/id
 
Visit OpenMRS Talk at http://om.rs/talk for chat and discussions!

To unsubscribe from this group and stop receiving emails from it, send an email to implementers...@openmrs.org.

[Hannan, Terry J (DHHS)]

Here is some accurate data on patient numbers, visits and accumulated clinical data from AMPATH supplied to me by Bill Tierney.