Advertisement

Health Services Data: Managing the Data Warehouse: 25 Years of Experience at the Manitoba Centre for Health Policy

  • Mark SmithEmail author
  • Leslie L. Roos
  • Charles Burchill
  • Ken Turner
  • Dave G. Towns
  • Say P. Hong
  • Jessica S. Jarmasz
  • Patricia J. Martens
  • Noralou P. Roos
  • Tyler Ostapyk
  • Joshua Ginter
  • Greg Finlayson
  • Lisa M. Lix
  • Marni Brownell
  • Mahmoud Azimaee
  • Ruth-Ann Soodeen
  • J. Patrick Nicol
Reference work entry
Part of the Health Services Research book series (HEALTHSR)

Abstract

The “Data Repository” at the Manitoba Centre for Health Policy (MCHP) is a cornerstone of the organization and one of the three “pillars” on which it stands (the other two being Research Program and Knowledge Translation). For 25 years, MCHP has maintained one of the most extensive collections of government administrative, survey, and clinical data holdings in the world, including everything from hospital and medical claims to child welfare services and educational enrolment and outcomes. Over 70 different government and clinical databases flow into the organization on an annual basis. This chapter outlines how the data are collected, organized, documented, managed, and accessed in a privacy protecting fashion for use by researchers in Canada, North America, and around the world. The research conducted by MCHP, which is located in the Rady Faculty of Health Sciences at the University of Manitoba, in addition to being relevant to policy and government decision makers is regularly published in leading academic journals. The chapter concludes with a discussion of the relative strengths of using a population-based longitudinal registry and some of the challenges faced in organizing and using available data for research purposes.

References

  1. Brownell M, Chartier M, Au W, Schultz J. Evaluation of the healthy baby program. 2010. http://mchp-appserv.cpe.umanitoba.ca/reference/MCHP-Healthy_Baby_Full_Report_WEB.pdf. Accessed 29 May 2013.
  2. Brownell MD, Nickel NC, Chateau D, et al. Long-term benefits of full-day kindergarten: a longitudinal population-based study. Early Child Dev Care. 2014;185:291–316.CrossRefGoogle Scholar
  3. Chartier M, Finlayson G, Prior H, McGowan K-L, Chen H, de Rocquigny J, Walld R, Gousseau M. Health and healthcare utilization of francophones in Manitoba. 2012. http://mchp-appserv.cpe.umanitoba.ca/reference/MCHP_franco_report_en_20120513_WEB.pdf. Accessed 29 May 2013.
  4. Chateau D, Doupe M, Walld R, Soodeen RA, Ouelette C, Rajotte L. Projecting personal care home bed equivalent needs in Manitoba through 2036. 2012. http://mchp-appserv.cpe.umanitoba.ca/reference/MCHP_pch_days_report_WEB.pdf. Accessed 29 May 2013.
  5. Daas PJH, Arends-Tóth J, Schouten B, Kuijvenhoven L, Statistics Netherlands. Quality framework for the evaluation of administrative data. 2008. http://www.pietdaas.nl/beta/pubs/pubs/21Daas.pdf
  6. Doupe M, Fransoo R, Chateau D, Dik N, Burchill C, Soodeen R-A, Bozat-Emre S, Guenette W. Population aging and the continuum of older adult care in Manitoba. 2011. http://mchp-appserv.cpe.umanitoba.ca/reference/LOC_Report_WEB.pdf. Accessed 29 May 2013.
  7. Fransoo R, Martens P, The Need to Know Team, Prior H, Burchill C, Koseva I, Bailly A, Allegro E. The 2013 RHA indicators atlas. 2013. http://mchp-appserv.cpe.umanitoba.ca/reference//RHA_2013_web_version.pdf. Accessed 20 Nov 2013.
  8. Holman CDJ, Bass AJ, Rouse IL, et al. Population-based linkage of health records in Western Australia: development of a health services research linked database. Aust N Z J Public Health. 1999;23:453–9.CrossRefGoogle Scholar
  9. Jutte DP, Roos LL, Brownell MD. Administrative record linkage as a tool for public health research. Annu Rev Public Health. 2011;32:91–108.CrossRefGoogle Scholar
  10. Lyman JA, Scully K, Harrison JH. The development of health care data warehouses to support data mining. Clin Lab Med. 2008;28:55–71.CrossRefGoogle Scholar
  11. Martens PJ, Sanderson D, Jebamani L. Mortality comparisons of First Nations to all other Manitobans: a provincial population-based look at health inequalities by region and gender. Can J Public Health. 2005;96:S33–8.PubMedGoogle Scholar
  12. Martens PJ, Bartlett J, Burland E, Prior H, Burchill C, Huq S, Romphf L, Sanguins J, Carter S, Bailly A. Profile of metis health status and healthcare utilization in Manitoba: a population-based study. 2010. http://mchp-appserv.cpe.umanitoba.ca/reference/MCHP-Metis_Health_Status_Full_Report_(WEB)_(update_aug11_2011).pdf. Accessed 29 May 2013.
  13. Martens PJ, Bartlett JG, Prior HJ, et al. What is the comparative health status and associated risk factors for the Metis? A population-based study in Manitoba, Canada. BMC Public Health. 2011;11:814.CrossRefGoogle Scholar
  14. Oreopoulos P, Stabile M, Walld R, et al. Short, medium, and long term consequences of poor infant health: an analysis using siblings and twins. J Hum Resour. 2008;43:88–138.Google Scholar
  15. Roos NP. Establishing a population data-based policy unit. Med Care. 1999;37:JS15–26.CrossRefGoogle Scholar
  16. Roos NP, Roos LL, Henteleff PD. Elective surgical rates: do high rates mean lower surgical standards? N Engl J Med. 1977;297:360–5.CrossRefGoogle Scholar
  17. Roos LL, Fisher ES, Brazauskas R, et al. Health and surgical outcomes in Canada and the United States Summer. Health Aff (Millwood). 1992;11(Summer):56–72.CrossRefGoogle Scholar
  18. Roos LL, Brownell M, Lix L, et al. From health research to social research: privacy, methods, approaches. Soc Sci Med. 2008;66:117–29.CrossRefGoogle Scholar
  19. Roos LL, Hiebert B, Manivong P, et al. What is most important: social factors, health selection, and adolescent educational achievement. Soc Indic Res. 2013;110:385–414.CrossRefGoogle Scholar
  20. SAS Institute Inc. SAS data integration studio 3.3: user’s guide. 2006. http://support.sas.com/documentation/onlinedoc/etls/usage33.pdf. Accessed 12 Aug 2014.
  21. Wolfson M. A shining light in Canada’s health information system. Healthcare Policy. 2011;6:8–13.PubMedGoogle Scholar

Copyright information

© Springer Science+Business Media, LLC, part of Springer Nature 2019

Authors and Affiliations

  • Mark Smith
    • 1
    Email author
  • Leslie L. Roos
    • 1
  • Charles Burchill
    • 1
  • Ken Turner
    • 1
  • Dave G. Towns
    • 1
  • Say P. Hong
    • 1
  • Jessica S. Jarmasz
    • 1
  • Patricia J. Martens
    • 7
  • Noralou P. Roos
    • 1
  • Tyler Ostapyk
    • 2
  • Joshua Ginter
    • 3
  • Greg Finlayson
    • 4
  • Lisa M. Lix
    • 5
  • Marni Brownell
    • 1
  • Mahmoud Azimaee
    • 6
  • Ruth-Ann Soodeen
    • 1
  • J. Patrick Nicol
    • 1
  1. 1.Manitoba Centre for Health PolicyUniversity of ManitobaWinnipegCanada
  2. 2.University AdvancementCarleton UniversityOttawaCanada
  3. 3.MontrealCanada
  4. 4.Finlayson and Associates ConsultingKingstonCanada
  5. 5.Department of Community Health SciencesUniversity of ManitobaWinnipegCanada
  6. 6.ICES CentralTorontoCanada
  7. 7.WinnipegCanada

Personalised recommendations