Projecto C: Surgical Cost-Effectiveness Analysis Database

  • João Santos
  • Tomé Vardasca
  • Carlos Leishenring
  • Henrique M. G. Martins
Part of the Communications in Computer and Information Science book series (CCIS, volume 221)


In times of crisis like these, a cost-effectiveness analysis database for surgical procedures is the best tool to have. A number of clinical variables were defined to complement the cost-effectiveness analysis with one of first operation room expenditure’s database implemented in a public hospital. This study is based on the same cornerstone of the ACS-NSQIP program. Some variables were collected automatically from the information systems available in the hospital, and the remaining are entered in a custom developed application be the surgeons. The indicators to provide are being defined with the surgeons and implemented in the form of dashboards. The result of this project will provide a tool for the hospital surgeons, manager and administrators to make better decisions.


business intelligence surgery data mining database data-entry 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Doebbeling, B.N., Chou, A.F., Tierney, W.: Priorities and strategies for the implementation of integrated informatics and communications technology to improve evidence-based practice. J. Gen. Intern. Med. 21(suppl. 2), 50–57 (2006)CrossRefGoogle Scholar
  2. 2.
    Welke, K.F., Karamlou, T., Diggs, B.S.: Databases for assessing the outcomes of the treatment of patients with congenital and paediatric cardiac disease -a comparison of administrative and clinical data. Cardiol. Young. (18 suppl. 2), 137–144 (2008)Google Scholar
  3. 3.
    ACS NSQIP website, (accessed November 18, 2009)
  4. 4.
    Khuri, S.: The NSQIP: a new frontier in surgery. Surgery 138(5), 837–843 (2005)MathSciNetCrossRefGoogle Scholar
  5. 5.
    Hall, B.L., Hamilton, B.H., Richards, K., et al.: Does surgical quality improve in the American College of Surgeons National Surgical Quality Improvement Program: an evaluation of all participating hospitals. Ann. Surg. 250(3), 363–376 (2009)Google Scholar
  6. 6.
    Rogers, S.O.: The Holy Grail of surgical quality Improvement: process measures or risk-adjusted outcomes? Am. Surg. 72(11), 1046–1050 (2006); discussion 1061–1069, 1133–1148Google Scholar
  7. 7.
    Khuri, S.: Safety, quality, and the National Surgical Quality Improvement Program. Am. Surg. 72(11), 994–998 (2006); discussion 1021–1030, 1133–1148MathSciNetGoogle Scholar
  8. 8.
    Wu, W., Schifftner, T.L., Henderson, W.G., et al.: Preoperative hematocrit levels and postoperative outcomes in older patients undergoing non cardiac surgery. JAMA 297(22), 2481–2488 (2007)CrossRefGoogle Scholar
  9. 9.
    Regenbogen, S.E., Ehrenfeld, J.M., Lipsitz, S.R., et al.: Utility of the surgical apgar score: validation in 4119 patients. Arch. Surg. 144(1), 30–36 (2009); discussion 37 CrossRefGoogle Scholar
  10. 10.
    Park, A.M., Storm, D.W., Fulmer, B.R., et al.: A prospective study of risk factors for nephrolithiasis after Roux-en-Y gastricbypasssurgery. J. Urol. 182(5), 2334–2339 (2009)CrossRefGoogle Scholar
  11. 11.
    Huang, Z., Xu, L., Yang, T., et al.: Hepatic resection: ananalysis of the impact of operative and perioperative factors on morbidity and mortality rates in 2008 consecutive hepatectomy cases. Chin. Med. J. 122(19), 2268–2277 (2009)Google Scholar
  12. 12.
    Englesbe, M.J., Pelletier, S.J., Magee, J.C., et al.: Seasonal variation in surgical outcomes as measured by the American College of Surgeons-National Surgical Quality Improvement Program (ACS-NSQIP). Ann. Surg. 246(3), 456–462 (2007); discussion 463–465CrossRefGoogle Scholar
  13. 13.
    Dimick, J.B., Osborne, N.H., Hall, B.L., Ko, C.Y., Birkmeyer, J.D.: Risk adjustment for comparing hospital quality with surgery: how many variables are needed? J. Am. Coll. Surg. 210(4), 503–508 (2010)CrossRefGoogle Scholar
  14. 14.
    Dimick, J.B., Chen, S.L., Taheri, P.A., et al.: Hospital costs associated with surgical complications: a report from the private-sector National Surgical Quality Improvement Program. J. Am. Coll. Surg. 199(4), 531–537 (2004)CrossRefGoogle Scholar
  15. 15.
    Davenport, D.L., Henderson, W.G., Khuri, S.F., Mentzer, R.M.: Preoperative risk factors and surgical complexity are more predictive of costs than postoperative complications: a case study using the National Surgical Quality Improvement Program (NSQIP) database. Ann. Surg. 242(4), 463–468 (2005); discussion 468–471Google Scholar
  16. 16.
    Cohen, M.E., Bilimoria, K.Y., Ko, C.Y., Richards, K., Hall, B.L.: Effect of subjective preoperative variables on risk-adjusted assessment of hospital morbidity and mortality. Ann. Surg. 249(4), 682–689 (2009)CrossRefGoogle Scholar
  17. 17.
    Chetta, A., Tzani, P., Marangio, E., et al.: Respiratory effects of surgery and pulmonary function testing in the preoperative evaluation. Acta Biomed. 77(2), 69–74 (2006)Google Scholar
  18. 18.
    Gibbs, J., Cull, W., Henderson, W., et al.: Preoperative serum albumin level as a predictor of operative mortality and morbidity: results from the National VA Surgical Risk Study. Arch. Surg. 134(1), 36–42 (1999)CrossRefGoogle Scholar
  19. 19.
    Warner, D.O., Warner, M.A., Barnes, R.D., et al.: Perioperative respiratory complications in patients with asthma. Anesthesiology 85(3), 460–467 (1996)CrossRefGoogle Scholar
  20. 20.
    Cullen, D.J.: Obstructive sleep apnea and postoperative analgesia–a potentially dangerous combination. J. Clin. Anesth. 13(2), 83–85 (2001)CrossRefGoogle Scholar
  21. 21.
    Wong, D.H., Weber, E.C., Schell, M.J., et al.: Factors associated with postoperative pulmonary complications in patients with severe chronic obstructive pulmonary disease. Anesth. Analg. 80(2), 276–284 (1995)Google Scholar
  22. 22.
    Lee, L., Jannapureddy, M., Albo, D., et al.: Outcomes of Veterans Affairs patients older than age 80 after surgical procedures for colon malignancies. Am. J. Surg. 194(5), 646–651 (2007)CrossRefGoogle Scholar
  23. 23.
    Hammill, B.G., Curtis, L.H., Bennett-Guerrero, E., et al.: Impact of heart failure on patients undergoing major non cardiac surgery. Anesthesiology 108(4), 559–567 (2008)CrossRefGoogle Scholar
  24. 24.
    Healy, K.O., Waksmonski, C.A., Altman, R.K., et al.: Perioperative outcome and long-term mortality for heart failure patients undergoing intermediate- and high-risk non cardiac surgery: impact of left ventricular ejection fraction. Congest Heart Fail 16(2), 45–49 (2010)CrossRefGoogle Scholar
  25. 25.
    Fleisher, L.A.: Implications of preoperative heart failure: the next frontier in perioperative medicine? Anesthesiology 108(4), 551–552 (2008)CrossRefGoogle Scholar
  26. 26.
    Kałuza, G.L., Joseph, J., Lee, J.R., Raizner, M.E., Raizner, A.: Catastrophic outcomes of noncardiac surgery soon after coronary stenting. J. Am. Coll. Cardiol. 35(5), 1288–1294 (2000)CrossRefGoogle Scholar
  27. 27.
    Microsoft© Silverlight,
  28. 28.
    Microsoft© SQL Server,
  29. 29.
    Jones, D.T., Yoon, M.J., Licameli, G.: Effectiveness of postoperative follow-up telephone interviews for patients who underwent adenotonsillectomy: a retrospective study. Arch. Otolaryngol. Head Neck Surg. 133(11), 1091–1095 (2007)CrossRefGoogle Scholar
  30. 30.
    Gray, R.T., Sut, M.K., Badger, S.A., Harvey, C.: Post-operative telephone review is cost-effective and acceptable to patients. Ulster. Med. J. 79(2), 76–79 (2010)Google Scholar
  31. 31.
    QlikTech© Qlikview,

Copyright information

© Springer-Verlag Berlin Heidelberg 2011

Authors and Affiliations

  • João Santos
    • 1
  • Tomé Vardasca
    • 1
  • Carlos Leishenring
    • 1
  • Henrique M. G. Martins
    • 1
  1. 1.(CI) 2 – Centro de Investigação e Criatividade InformáticaHospital Prof. Doutor Fernando Fonseca, EPELisbonPortugal

Personalised recommendations