A Study on the Conceptual Frame Work of Dataware Housing in Health Sector in Pakistan A Case Study of a Hospital System and Disease (Hepatitis C)
The decisions of people about medical treatments have a great impact on their lives. Health related sectors and patients often make decisions without complete understanding of the medical circumstances. The main cause is that health related data are available in fragmented, disparate and heterogeneous data silos. Without a centralized data warehouse structure to integrate these data silos, it is highly unlikely and impractical for the users (of concerned departments) to get all the information required on time to make a correct decision. In this research study, a case study has been discussed hospital system and a disease (Hepatitis C only ) through literature review, it was found that in government hospital the data recorded analyzed in old fashioned, manually where as in private hospitals there is computerized Database to record the patients data, but failure is that there is no coordination between government and private hospitals to share the patients history and also no concept of Database overall in government hospitals in Pakistan. After all , in this research study, a conceptual frame work has been discussed and proposed model for implementation of Dataware house in health sector to centralized the data for analysis and decision making .Outcomes of this research are: one is ; documenting the comparisons of data warehousing architectures, logical and conceptual data warehousing models, other is proposing a data-warehousing model ( taking one disease Hepatitis C ) as model for implementation which is suitable for Government Health Sector as well as other concerned departments in Pakistan.ext fonts are prescribed; please do not alter them.
Lacey Benson, et al. “When is family history obtained? – Lack of timely documentation of family history among overweight and hypertensive paediatric patients” .Jul. 2010 (Full publication history). DOI: 10.1111/j.1440- 1754.2010.01798.x .
Goldstein et al. “Neural substrates of the interaction of emotional stimulus processing and motor inhibitory control: An emotional linguistic” , 2007.
Available:http://levylab.psych.psu.edu/publications/2007/neural- substrates-of- the- interaction-of-emotional-stimulus-processing-and-motor-inhibitory-control an- emotional- linguistic-go-no-go- fmri-study/at_download/file.
Knaup P. ,et al. “Electronic patient records: moving from islands and bridges towards electronic health records for continuity of care.” 2007. Available:
Hersh W. “ Health Care Information Technology: Progress and Barriers”. JAMA. 2004, 292(18):2273-2274. Available: https://doi.org/10.1001/jama.292.18.2273.
Sahama & Croll (2007 “ article” A Data Warehouse Architecture for clinical Data warehousing”,2010),
Thomas Handler et al. “HIMSS Electronic Health Record Definitional Model, Version 1.0”, by HIMSS Electronic Health Record Committee.2003.
Pearce & Haikerwal (2010. Available:
Pedersen & Jensen (1998): “SSDBM '98 Proceedings of the 10th International Conference on Scientific and Statistical Database Management.”. July 01 - 03, 1998 IEEE Computer Society Washington, DC, USA ©1998. Page 43-52 .available: ISBN:0- 8186-8575-1 doi>10.1109/SSDM.1998.688110.
Siliya Nugawela “Dataware Housing Model for integrating fragmented Electronic Health Records from Desperate and Heterogeneous Clinical Data Stores” Jun.2013.
Inmon W. H., Building the Data Warehouse. , New York: Wiley Computer Publishing, 2002. Available: https://leseprobe.buch.de/images- adb/e2/e7/e2e7f926-314c-4e83-86a1-e481fafaf580.pdf
Başaran, B. “A Comparison of Data Warehouse Design Models.” MS. Thesis. Computer Engineering, Atilim University, Turkey. 2005.
Martyn T. “Reconsidering Multi-Dimensional Schemas”, SIGMOD Record, Vol. 33, No. 1. Mar.2004.Available: https://sigmodrecord.org/publications/sigmodRecord/0403/B6.Martyn_6page.pdf.
Kerkri E. M., et al. “An approach for integrating heterogeneous information sources in a medical data warehouse”. Journal of Medical Systems, 2001, 25(3), pp.167- 176. Available: doi: 10.1023/A:1010728915998.
S. Aziz and M. H. Rao. “Existing Record Keeping System in Government Teaching Hospitals of Karachi”. DOW. Karachi, funded by Govt. of Pakistan. Apr.2002. Available: http://www.jpma.org.pk/full_article_text.php?article_id=2202
US Department of Health; The World Health Organization. Available: https://books.google.com.pk/books?id=7W7QAQAAQBAJ&pg=PA65&dq=US+Department+of+Health;+The+World+Health+Organization&hl=en&sa=X&ved=0ahUKEwjOtYm3v9PZAhVNsKQKHWZq ByoQ6AEIJTAA.
National Institute of Population Studies (NIPS) ,Pakistan, 2006 .
Available:http://www.nips.org.pk/abstract_files/Priliminary%20Report%20Final.pdf. [Mar. 4, 2018]
Altaf Bosan, et al. “ A review of hepatitis viral infections in Pakistan” 2010.
Butt AS, et al. “Hepatocellular carcinoma in Native South Asian Pakistani Population; Trends, linico- pathological characteristics & differences in Viral Marker Negative & Viral-HCC (A 10 year Experience)”., 2011.
Authors who submit papers with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).
- By submitting the processing fee, it is understood that the author has agreed to our terms and conditions which may change from time to time without any notice.
- It should be clear for authors that the Editor In Chief is responsible for the final decision about the submitted papers; have the right to accept\reject any paper. The Editor In Chief will choose any option from the following to review the submitted papers:A. send the paper to two reviewers, if the results were negative by one reviewer and positive by the other one; then the editor may send the paper for third reviewer or he take immediately the final decision by accepting\rejecting the paper. The Editor In Chief will ask the selected reviewers to present the results within 7 working days, if they were unable to complete the review within the agreed period then the editor have the right to resend the papers for new reviewers using the same procedure. If the Editor In Chief was not able to find suitable reviewers for certain papers then he have the right to reject the paper.
- Author will take the responsibility what so ever if any copyright infringement or any other violation of any law is done by publishing the research work by the author
- Before publishing, author must check whether this journal is accepted by his employer, or any authority he intends to submit his research work. we will not be responsible in this matter.
- If at any time, due to any legal reason, if the journal stops accepting manuscripts or could not publish already accepted manuscripts, we will have the right to cancel all or any one of the manuscripts without any compensation or returning back any kind of processing cost.
- The cost covered in the publication fees is only for online publication of a single manuscript.