Skip to main content
SpringerLink
Log in

Linking Databases

  • Chapter
  • First Online:
Pediatric and Congenital Cardiac Care

Abstract

Multicenter datasets are increasingly utilized in pediatric cardiovascular research. In this chapter, we discuss the rational for linking information across data sources, and describe different linkage mechanisms which enable analyses not possible with individual datasets alone.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 89.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 119.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book
USD 169.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

References

  1. Pasquali SK, Hall M, Li JS, Peterson ED, Jaggers J, Lodge AJ, Marino BS, Goodman DM, Shah SS. Corticosteroids and outcome in children undergoing congenital heart surgery: analysis of the Pediatric Health Information Systems Database. Circulation. 2010;122:2123–30.

    Article  CAS  PubMed Central  PubMed  Google Scholar 

  2. Fudge JC, Li S, Jaggers J, O’Brien SM, Peterson ED, Jacobs JP, Welke KF, Jacobs ML, Li JS, Pasquali SK. Outcomes in patients with Down syndrome undergoing congenital heart surgery: analysis of a national clinical database. Pediatrics. 2010;126:315–22.

    Article  PubMed Central  PubMed  Google Scholar 

  3. Karamlou T, Hirsch J, Welke K, Ohye RG, Bove EL, Devaney EJ, Gajarski RJ. A United Network for Organ Sharing analysis of heart transplantation in adults with congenital heart disease: outcomes and factors associated with mortality and retransplantation. J Thorac Cardiovasc Surg. 2010;140:161–8.

    Article  PubMed  Google Scholar 

  4. Pasquali SK, Jacobs JP, He X, Hornik CP, Jaquiss RDB, Jacobs ML, O’Brien SM, Peterson ED, Li JS. The complex relationship between center volume and outcome in patients undergoing the Norwood operation. Ann Thorac Surg. 2012;93:1556–62.

    Article  PubMed Central  PubMed  Google Scholar 

  5. Welke KF, Diggs BS, Karamlou T, Ungerleider RM. The relationship between hospital surgical case volumes and mortality rates in pediatric cardiac surgery: an national sample, 1988–2005. Ann Thorac Surg. 2008;86:889–96.

    Article  PubMed  Google Scholar 

  6. Jacobs JP, Jacobs ML, Mavroudis C, Lacour-Gayet FG, Tchervenkov CI, Pasquali SK. Executive summary: the Society of Thoracic Surgeons Congenital Heart Surgery Database – 18th Harvest – (January 1, 2009 – December 31, 2013). The Society of Thoracic Surgeons (STS) and Duke Clinical Research Institute (DCRI), Duke University Medical Center; Durham; 2013 Harvest.

    Google Scholar 

  7. Kugler JD, Beekman RH, Rosenthal GL, Jenkins KJ, Klitzner TS, Martin GR, Neish RS, Lannon C. Development of a pediatric cardiology quality improvement collaborative: from inception to implementation. From the Joint Council on Congenital Heart Disease Quality Improvement Task Force. Congenit Heart Dis. 2009;4:318–28.

    Article  PubMed  Google Scholar 

  8. Pediatric Congenital Cardiac Surgery in New York State 2006–2009. Available at: http://www.health.ny.gov/statistics/diseases/cardiovascular/heart_disease/docs/2006-2009_pediatric_congenital_cardiac_surgery.pdf. Accessed 7/10/2013.

  9. U.S. News & World Report’s Annual Ranking of Best Hospitals. Available at: http://www.rti.org/besthospitals. Accessed 28 May 2013.

  10. OptumHealth Congenital Heart Disease Center of Excellence. Available at: https://www.myoptumhealthcomplexmedical.com/gateway/public/chd/providers.jsp. Accessed 28 May 2013.

  11. Martin GR, Beekman RH, Ing FF, Jenkins KJ, McKay CR, Moore JW, Ringel RE, Rome JJ, Ruiz CE, Vincent RN. The IMPACT registry: improving pediatric and adult congenital treatments. Semin Thorac Cardiovasc Surg Pediatr Card Surg Annu. 2010;13:20–5.

    Article  PubMed  Google Scholar 

  12. Pasquali SK, Peterson ED, Jacobs JP, He X, Li JS, Jacobs ML, Gaynor JW, Hirsch JC, Shah SS, Mayer JE. Differential case ascertainment in clinical registry vs. administrative data and impact on outcomes assessment in pediatric heart surgery. Ann Thorac Surg. 2013;95:197–203.

    Article  PubMed Central  PubMed  Google Scholar 

  13. Pasquali SK, Jacobs JP, Shook GJ, O’Brien SM, Hall M, Jacobs ML, Welke KF, Gaynor JW, Peterson ED, Shah SS, Li JS. Linking clinical registry data with administrative data using indirect identifiers: implementation and validation in the congenital heart surgery population. Am Heart J. 2010;160:1099–104.

    Article  PubMed Central  PubMed  Google Scholar 

  14. Jacobs JP, Edwards FH, Shahian DM, et al. Successful linking of the Society of Thoracic Surgeons adult cardiac surgery database to Centers for Medicare and Medicaid Services Medicare data. Ann Thorac Surg. 2010;90:1150–7.

    Article  PubMed  Google Scholar 

  15. Jacobs JP, Edwards FH, Shahian DM, et al. Successful linking of the STS database to social security data to examine survival after cardiac surgery. Ann Thorac Surg. 2011;92:32–7.

    Article  PubMed  Google Scholar 

  16. Saleeb SF, Li WYV, Warren SZ, Lock JE. Effectiveness of screening for life-threatening chest pain in children. Pediatrics. 2011;128:e1062–8.

    Article  PubMed  Google Scholar 

  17. Dokholyan RS, Muhlbaier LH, Falletta J, et al. Regulatory and ethical considerations for linking clinical and administrative databases. Am Heart J. 2009;157(6):971–82.

    Article  PubMed  Google Scholar 

  18. Hammill BG, Hernandez AF, Peterson ED, Fonarow GC, Schulman KA, Curtis LH. Linking inpatient clinical registry data to Medicare claims data using indirect identifiers. Am Heart J. 2009;157:995–1000.

    Article  PubMed Central  PubMed  Google Scholar 

  19. Pasquali SK, Li JS, He X, Jacobs ML, O’Brien SM, Hall M, Jaquiss RDB, Welke KF, Peterson ED, Shah SS, Gaynor JW, Jacobs JP. Perioperative methylprednisolone and outcome in neonates undergoing heart surgery. Pediatrics. 2012;129:e385–91.

    Article  PubMed Central  PubMed  Google Scholar 

  20. Pasquali SK, Li JS, He X, Jacobs ML, O’Brien SM, Hall M, Jaquiss RDB, Welke KF, Peterson ED, Shah SS, Jacobs JP. Comparative analysis of antifibrinolytic medications in pediatric heart surgery. J Thorac Cardiovasc Surg. 2012;143:550–7.

    Article  CAS  PubMed Central  PubMed  Google Scholar 

  21. Pasquali SK, He X, Jacobs ML, Hall M, Gaynor JW, Shah SS, Peterson ED, Hill KD, Li JS, Jacobs JP. Hospital variation in post-operative infection and outcome following congenital heart surgery. Ann Thorac Surg. 2013;96(2):657–63.

    Article  PubMed  Google Scholar 

  22. Burstein DS, Jacobs JP, Sheng S, et al. Care models in congenital heart surgery and associated outcomes. Pediatrics. 2011;127:6.e1482–9.

    Article  Google Scholar 

  23. Gaies M, Jeffries H, Niebler R, Pasquali SK, Donohue J, Yu S, Thiagarajan R. Vasoactive inotropic score (VIS) is associated with outcome after infant cardiac surgery: a report of the Pediatric Cardiac Critical Care Consortium (PC4). J Am Coll Cardiol. 2013;61:E424.

    Article  Google Scholar 

  24. Jacobs JP, Jacobs ML, Austin EH, Mavroudis C, Pasquali SK, Lacour–Gayet FG, Tchervenkov CI, Bacha EA, del Nido PJ, Fraser CD, Gaynor JW, Hirsch JC, Morales DLS, Pourmoghadam KK, Tweddell JT, Prager RL, Mayer JE. Quality measures for congenital and pediatric cardiac surgery. World J Pediatr Congenit Heart Surg. 2012;3:32–47.

    Article  PubMed  Google Scholar 

  25. Vener DF, Jacobs JP, Schindler E, Maruszewski B, Andropoulos D. Databases for assessing the outcomes of the treatment of patients with congenital and paediatric cardiac disease – the perspective of anaesthesia. Cardiol Young. 2008;18 Suppl 2:124–9.

    Article  PubMed  Google Scholar 

  26. Pearson GD, Kaltman JR, Lauer MS. Evidence-based medicine comes of age in pediatric cardiology. J Am Coll Cardiol. 2013;61:2565–7.

    Article  PubMed  Google Scholar 

  27. Johnson SB, Whitney G, McAuliffe M. Using global unique identifiers to link autism collections. J Am Med Inform Assoc. 2010;17:689–95.

    Article  PubMed Central  PubMed  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Department of Pediatrics, C.S. Mott Children’s Hospital, University of Michigan Congenital Heart Center, 1540 E. Hospital Drive 11-715z, Ann Arbor, MI, 48109, USA

    Sara K. Pasquali MD, MHS

  2. Division of Cardiac Surgery, Department of Surgery, Johns Hopkins School of Medicine, 1800 Orleans Street, Baltimore, MD, 21287, USA

    Marshall L. Jacobs MD

  3. Division of Cardiac Surgery, Department of Surgery, Johns Hopkins All Children’s Heart Institute, All Children’s Hospital and Florida Hospital for Children, Johns Hopkins University, Saint Petersburg, Tampa and Orlando, FL, USA

    Jeffrey P. Jacobs MD, FACS, FACC, FCCP

  4. Division of Cardiac Surgery, Department of Surgery, Johns Hopkins University, Baltimore, MD, USA

    Jeffrey P. Jacobs MD, FACS, FACC, FCCP

Authors
  1. Sara K. Pasquali MD, MHS
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Marshall L. Jacobs MD
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Jeffrey P. Jacobs MD, FACS, FACC, FCCP
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Sara K. Pasquali MD, MHS .

Editor information

Editors and Affiliations

  1. School of Medicine,, University of Oslo, Oslo, Norway

    Paul R. Barach

  2. Division of Cardiac Surgery, Department of Surgery, Johns Hopkins University, Division of Cardiac Surgery, Department of Surgery, Johns Hopkins All Children’s Heart Institute, All Children’s Hospital and Florida Hospital for Children, Johns Hopkins University, St. Petersburg, Tampa, Orlando, FL, USA,, Baltimore, Maryland, USA

    Jeffery P. Jacobs

  3. Wayne State University, Detroit, Michigan, USA

    Steven E. Lipshultz

  4. The Hospital for Sick Children, Toronto, Ontario, Canada

    Peter C. Laussen

Rights and permissions

Reprints and permissions

Copyright information

© 2015 Springer-Verlag London

About this chapter

Cite this chapter

Pasquali, S.K., Jacobs, M.L., Jacobs, J.P. (2015). Linking Databases. In: Barach, P., Jacobs, J., Lipshultz, S., Laussen, P. (eds) Pediatric and Congenital Cardiac Care. Springer, London. https://doi.org/10.1007/978-1-4471-6587-3_30

Download citation

  • DOI: https://doi.org/10.1007/978-1-4471-6587-3_30

  • Published:

  • Publisher Name: Springer, London

  • Print ISBN: 978-1-4471-6586-6

  • Online ISBN: 978-1-4471-6587-3

  • eBook Packages: MedicineMedicine (R0)

Publish with us

Policies and ethics

Search

Navigation