Six methodological steps to build medical data warehouses for research

PURPOSE We propose a simple methodology for heterogeneous data collection and central repository-style database design in healthcare. Our method can be used with or without other software development frameworks, and we argue that its application can save a relevant amount of implementation effort. Also, we believe that the method can be used in other fields of research, especially those that have a strong interdisciplinary nature. BACKGROUND The idea emerged during a healthcare research project, which consisted among others in grouping information from heterogeneous and distributed information sources. We developed this methodology by the lessons learned when we had to build a data repository, containing information about elderly patients flows in the UK's long-term care system (LTC). DESIGN We explain thoroughly those aspects that influenced the methodology building. The methodology is defined by six steps, which can be aligned with various iterative development frameworks. We describe here the alignment of our methodology with the RUP (rational unified process) framework. The methodology emphasizes current trends, as early identification of critical requirements, data modelling, close and timely interaction with users and stakeholders, ontology building, quality management, and exception handling. RESULTS Of a special interest is the ontological engineering aspect, which had the effects with the highest impact after the project. That is, it helped stakeholders to perform better collaborative negotiations that brought better solutions for the overall system investigated. An insight into the problems faced by others helps to lead the negotiators to win-win situations. We consider that this should be the social result of any project that collects data for better decision making that leads finally to enhanced global outcomes.

[1]  Lina Fatima Soualmia,et al.  Combining different standards and different approaches for health information retrieval in a quality-controlled gateway , 2005, Int. J. Medical Informatics.

[2]  Erik M. van Mulligen,et al.  Databases for knowledge discovery: Examples from biomedicine and health care , 2006, Int. J. Medical Informatics.

[3]  M Joubert,et al.  A semantic-based kernel for advanced health information systems , 2000, Medical informatics and the Internet in medicine.

[4]  Lucila Ohno-Machado,et al.  Protecting patient privacy by quantifiable control of disclosures in disseminated databases , 2004, Int. J. Medical Informatics.

[5]  G. Kelly,et al.  Security, privacy, and confidentiality issues on the Internet , 2002, Journal of medical Internet research.

[6]  Knut Bernstein,et al.  Modelling and implementing electronic health records in Denmark , 2005, Int. J. Medical Informatics.

[7]  Steve Caine,et al.  Developing a large electronic primary care database (Doctors' Independent Network) for research , 2004, Int. J. Medical Informatics.

[8]  Philippe Kruchten,et al.  The Rational Unified Process: An Introduction , 1998 .

[9]  P. H. Millard,et al.  Modelling Decisions of a Multidisciplinary Panel for Admission to Long-Term Care , 2002, Health care management science.

[10]  Peter H. Millard,et al.  A continuous time Markov model for the length of stay of elderly people in institutional long‐term care , 2005 .

[11]  Hans-Ulrich Prokosch,et al.  Cross-institutional data exchange using the clinical document architecture (CDA) , 2005, Int. J. Medical Informatics.

[12]  Peter H. Millard,et al.  A simple graphical decision aid for the placement of elderly people in long-term care , 2007, J. Oper. Res. Soc..

[13]  Christine Pelletier,et al.  A framework for predicting gross institutional long-term care cost arising from known commitments at local authority level , 2005, J. Oper. Res. Soc..

[14]  Klaus A. Kuhn,et al.  Towards a continuous evolution and adaptation of information systems in healthcare , 2004, Int. J. Medical Informatics.

[15]  Philippe Kruchten,et al.  What Is the Rational Unified Process ? , 2001 .

[16]  Knut Bernstein,et al.  Modelling and implementing Electronic Health Records in Denmark , 2003, MIE.

[17]  Philippe Kruchten.  The Rational Unified Process - An Introduction, 3rd Edition , 2004, Addison Wesley object technology series.