CFP last date
20 May 2024
Reseach Article

Effort Estimation Approach for Integrated Medical Warehouses

by Naveen Aggarwal, Nupur Prakash, Sanjeev Sofat
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 48 - Number 11
Year of Publication: 2012
Authors: Naveen Aggarwal, Nupur Prakash, Sanjeev Sofat
10.5120/7394-0381

Naveen Aggarwal, Nupur Prakash, Sanjeev Sofat . Effort Estimation Approach for Integrated Medical Warehouses. International Journal of Computer Applications. 48, 11 ( June 2012), 32-39. DOI=10.5120/7394-0381

@article{ 10.5120/7394-0381,
author = { Naveen Aggarwal, Nupur Prakash, Sanjeev Sofat },
title = { Effort Estimation Approach for Integrated Medical Warehouses },
journal = { International Journal of Computer Applications },
issue_date = { June 2012 },
volume = { 48 },
number = { 11 },
month = { June },
year = { 2012 },
issn = { 0975-8887 },
pages = { 32-39 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume48/number11/7394-0381/ },
doi = { 10.5120/7394-0381 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T20:43:50.467427+05:30
%A Naveen Aggarwal
%A Nupur Prakash
%A Sanjeev Sofat
%T Effort Estimation Approach for Integrated Medical Warehouses
%J International Journal of Computer Applications
%@ 0975-8887
%V 48
%N 11
%P 32-39
%D 2012
%I Foundation of Computer Science (FCS), NY, USA
Abstract

Medical warehouses are architectural construct of an information system that provides users with current and historical decision support information. But medical warehouse projects suffers from overestimation of resources because of improper estimation approaches which do not suit well on poorly defined architecture of medical warehouses. In this paper, we have first proposed a framework for an integrated medical warehouse that covers the different aspects of health care management. Then we proposed an effort estimation approach based on this framework which is designed to be used at the very early stage of requirement analysis. The data from the three different set of data warehousing projects are studied and the linear regression approach is used to finalize the model. Final effort is estimated using the project size and the different adjustment factors. For analytical estimation of project size and its complexity, extended function point analysis is used and identified object are categorized and their complexity weight age is determined. The proposed approach is validated by studying three different set of projects having different level of complexity. First set contains eight business data warehousing projects completed in different domains. Second set contains medical OLAP projects and third set has clinical data marts. A set of questionnaire is used to estimate the complexity of the project, which has to be filled by the developers after completing the initial requirement analysis. The proposed effort estimation model shows a great improvement as compared to the earlier models used in effort estimation of medical warehousing projects.

References
  1. Samuel, J. W. , Blackford M, Lisa A. P. , & Christiana G. B. , "A Cost Benefit Analysis of Electronic Medical Records in Primary Care. " American Journal of Medicine 114, no. 5 ,April 2003, pages: 397-403.
  2. Bates, D. W. , Leape L. L. , and Cullen D. J. . "Effect Of Computerized Physician Order Entry And A Team Intervention Or Prevention Of Serious Medication Errors. " JAMA, 1998, pages: 1311-1316.
  3. Ewen, E. F. , Medsker C. , Dusterhoft L. E. , Levan-Shultz K. , Smith J. L. , and Gottschall M. A. , "Data Warehousing In Integrated Health System: Building the Business Case. " International Workshop on data Warehousing and OLAP. New York: ACM Press, 1998, pages: 47-53.
  4. Jane R Schubart, Jonathan S Einbinder, "Evaluation of a data warehouse in an academic health sciences center", International Journal of Medical Informatics, Vol. 60, Issue 3, 2000 Pages 319-333.
  5. Mordechai Shani, "The impact of information on medical thinking and health care policy", International Journal of Medical Informatics, Vol. 58, 2000, Pages 3-10,.
  6. Pedersen, T. B. , and Jensen C. S. , "Research Issues in Clinical Data Warehousing. " International conference on Scientific and Statistical Database Management (SSDBM ). IEEE Computer Society Press, 2001. 43-52.
  7. Szirbik, N. B. , Pelletier, C. and Chaussalet, T. , "Integration of Data on Long Term Care from Heterogeneous Sources For Research Purposes. " Medicon'04, Ischia, Italy, 2004.
  8. Cynthia A Brandt, Richard Morse, Keri Matthews, Kexin Sun, Aniruddha M Deshpande, Rohit Gadagkar, Dorothy B Cohen, Perry L Miller, Prakash M Nadkarni, "Metadata-driven creation of data marts from an EAV-modeled clinical research database", International Journal of Medical Informatics, Vol. 65, Issue 3, 2002, Pages 225-241.
  9. Valentin Dinu, Prakash Nadkarni, "Guidelines for the effective use of entity–attribute–value modeling for biomedical databases", International Journal of Medical Informatics, Vol. 76, Issue 11, 2007 Pages 769-779.
  10. Nguyen, T. B. , Tjoa A. M. , and Mangisengi O. "Metacube XTM: A Multidimensional Metadata Approach For Semantic Web Warehousing Systems. " International conference of data warehousing and knowledge discovery. Berlin: Lecture Notes in computer Science, Springer Verlag, 2003. 76-88.
  11. "XML Topic Maps (XTM) 1. 0. " TopicMaps. org Specifications. 6 June 2001. http://www. topicmaps. org/xtm/1. 0/xtml-20010806. html.
  12. Laxminarayan, P. , Ruiz C, Alvarez SA, and Moonis M. "Mining Associations over human sleep time series. " Symposium Computer based Medical Systems (CBMS `05). IEEE Computer Society, 2005. 323-328.
  13. Banek, Marko, A Min Tjoa, Nevena Stolba, " Integrating different grain levels in medical data warehouse federation", Lecture Notes in computer science, Springer, 2006, ISSN: 0302-9743, 185-194
  14. Delphine Rossille, Jean-François Laurent, Anita Burgun, "Modelling a decision-support system for oncology using rule-based and case-based reasoning methodologies", International Journal of Medical Informatics, Vol. 74, Issue 2, Pages 299-306, 2005.
  15. Matthew Scotch, Bambang Parmanto, "Development of SOVAT: A numerical–spatial decision support system for community health assessment research", International Journal of Medical Informatics, Vol. 75, Issue 10, 2006, Pages 771-784.
  16. Yvan Bédard, Pierre Gosselin, Sonia Rivest, Marie-Josée Proulx, Martin Nadeau, Germain Lebel, Marie-France Gagnon, "Integrating GIS components with knowledge discovery technology for environmental health decision support", International Journal of Medical Informatics, Vol. 70, Issue 1, 2003, Pages 79-94.
  17. Antonio Abelha, J. Machado, V. Alves, J. Neves, "Data Warehousing Through Multi-Agent Systems in the Medical Arena", in proceedings of First International conference on knowledge engineering and decision support, Porto, Portugal, 2004.
  18. Isabel H. Manssour, S. S. Furuie, Luciana P. Nedel, CMDS Freitas, "A Framework to visualize and interact with multimodal medical images", in International workshop on volume graphics, New York, IEEE Computer Society, 2001
  19. Song, I. Y. , Rowen, W. , Medseker, C. , and Ewen E. F. . "An analysis of many to many relationships between the fact and dimensions tables in dimensions modelling. " International Workshop on Design management of Data Warehouses (DMDW '01). CEUR Workshop Proceedings Ceur WS-org, 2001. 1-13.
  20. Pravin Vajirkar, Sachin Singh, Y Lee, "Context aware data mining framework for wireless medical applications", Lecture Notes in computer science, Springer, 2003, ISSN: 0302-9743, 381-391
  21. Chen, G. , and Kotz D. "A Survey Of Context-Aware Mobile Computing Research. " Technical Report TR2000-381, Dartmouth: Dartmouth Computer science, 2000.
  22. Brown, P. J. , Bovey J. D. , and Chen X. "Context-Aware Applications From Laboratory To Market Place. " IEEE Personal Communications, 1997: 58-64.
  23. Dey, A. K. , and Abowd G. D. , "Towards A Better Understanding Of Context And Context Awareness". GUV Technical Report GITGUV -99-22, Georgia: College of Computing, Georgia Institute of Technology, 1999.
  24. Szirbik, N. B. , Pelletier, C. and Chaussalet, T. , "Six Methodological Steps To Build Medical Warehouse For Research. " International Journal of Medical informatics, 683-691, 2006.
  25. Huff, S. M. , "Clinical Data Exchange Standards And Vocabularies For Messages. " AIMA Symposiym. 1998. 62-71.
  26. M. Body, M. Miquel, Y. Bedard, and A. Tchounikine, "Handling Evolutions in Multidimensional Structures", ICDE, 2003.
  27. Johann Eder and Christian Koncilia, "Evolution of Dimension Data in Temporal Data Warehouses", DaWaK, 284—293, 2001.
  28. Beverly Collins, Mary Wagner, "Early experiences in using computerized patient record data for monitoring charting compliance, supporting quality initiatives and assisting with accurate charging at Allina Hospitals & Clinics", International Journal of Medical Informatics, Vol. 74, Issue 11, 2005, Pages 917-925.
  29. A. J. Albrecht, J. F. Gaffney, "Software function, source lines of code and development effort prediction: A software science validation", IEEE Transaction on Software Engineering, Vol SE-9, no. 6, , 1983, pp 639-647.
  30. Vahan Harput, Hermann Kaindl and Stefan Kramer, "Extending Function Point Analysis of Object-Oriented Requirements Specifications", Proceedings of the 11th IEEE International Software Metrics Symposium, 2005.
  31. Boehm, B. W. , Clark B, Horrowitz E, Westland C, Nadachy R, and Selby R. "The COCOMO 2. 0 Software Cost Estimation Model. " American Programmer, 1996.
  32. Boehm. B. W. , "Software Engineering Economics". Englewood Cliffs NJ: Prentice-Hall, 1981.
  33. Boehm, B. W. , "Anchoring the software processes", IEEE Software, Vol 13, No 4, July 1996
  34. Function Point Counting Practice Manual, Release 4. 1. 1, International Function Point User Group (IFPUG), 2001 available at http://www. ifpug. org/publications/manual. htm
  35. Coleman, D. , Ash, D. , Lowther, B. , and Oman, P. "Using Metrics to Evaluate Software System Maintainability", IEEE Computer, pp 44-49, 1994.
  36. Chulani, S. Boehm, B. and Steece, B. , "Calibrating Software Cost Models Using Bayesian Analysis", IEEE Transactions on Software Engineering, Special Issue on Empirical Methods in Software Engineering, Vol. 25, No. 4, July/August 1999.
Index Terms

Computer Science
Information Sciences

Keywords

Medical Warehouses Effort Estimation Data Warehousing Medical Support Systems Electronic Medical Records