Skip to main content
SpringerLink
Log in

Improvement of the Prediction of Drugs Demand Using Spatial Data Mining Tools

  • Patient Facing Systems
  • Published:
Journal of Medical Systems Aims and scope Submit manuscript

Abstract

The continued availability of products at any store is the major issue in order to provide good customer service. If the store is a drugstore this matter reaches a greater importance, as out of stock of a drug when there is high demand causes problems and tensions in the healthcare system. There are numerous studies of the impact this issue has on patients. The lack of any drug in a pharmacy in certain seasons is very common, especially when some external factors proliferate favoring the occurrence of certain diseases. This study focuses on a particular drug consumed in the city of Jaen, southern Andalucia, Spain. Our goal is to determine in advance the Salbutamol demand. Advanced data mining techniques have been used with spatial variables. These last have a key role to generate an effective model. In this research we have used the attributes that are associated with Salbutamol demand and it has been generated a very accurate prediction model of 5.78% of mean absolute error. This is a very encouraging data considering that the consumption of this drug in Jaen varies 500% from one period to another.

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

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Fig. 1
Fig. 2
Fig. 3

Similar content being viewed by others

References

  1. Bateman, C., Drug stock-outs: Inept supply-chain management and corruption. SAMJ S Afr Med J 103(9):600–602, 2013. doi:10.7196/SAMJ.7332.

    Article  PubMed  Google Scholar 

  2. Kweder, S. L., & Dill, S., Drug shortages: the cycle of quantity and quality. Clin. Pharmacol. Ther., 93(3), 245–251, 2013. doi: 10.1038/clpt.2012.235 10.1038/clpt.2012.235#pmc_ext

  3. Chin, R. K., Administrative reports for monitoring pharmacy purchasing. Am J Health-Syst Pharm 41(11):2363–2366, 1984.

    CAS  Google Scholar 

  4. Ibrahim, N., Wong, I. C., Tomlin, S., Sinha, M. D., Rees, L., and Jani, Y., Epidemiology of medication-related problems in children with kidney disease. Pediatr Nephrol 30(4):623–633, 2015. doi:10.1007/s00467-014-2982-5.

    Article  PubMed  PubMed Central  Google Scholar 

  5. Tayob, S., Challenges in the management of drug supply in public health centres in the Sedibeng District, Gauteng Province (Doctoral dissertation, University of Limpopo (Medunsa Campus)), 2012.

  6. Houben, R. M., Van Boeckel, T. P., Mwinuka, V., Mzumara, P., Branson, K., Linard, C., and Crampin, A. C., Monitoring the impact of decentralised chronic care services on patient travel time in rural Africa-methods and results in Northern Malawi. Int J Health Geogr 11(1):49, 2012. doi:10.1186/1476-072X-11-49.

    Article  PubMed  PubMed Central  Google Scholar 

  7. Fox, Erin R., Burgunda V. Sweet, and Valerie Jensen. Drug shortages: a complex health care crisis. Mayo Clinic Proceedings. Vol. 89. No. 3. Elsevier, 2014. doi: 10.1016/j.mayocp.2013.11.014

  8. Vademecum. Inc. Available via: http://www.vademecum.es/principios-activos-Salbutamol-r03cc02. Accessed February 2105.

  9. Frampton, J. E., QVA149 (indacaterol/glycopyrronium fixed-dose combination): a review of its use in patients with chronic obstructive pulmonary disease. Drugs 74(4):465–488, 2014.

    Article  PubMed  Google Scholar 

  10. Pauwel, S., Romain, A., et al., Global strategy for the diagnosis, management, and prevention of chronic obstructive pulmonary disease. NHLBI/WHO global initiative for chronic obstructive lung disease (GOLD) workshop summary. Am J Respir Crit Care Med 163(5):1256–76, 2001.

    Article  Google Scholar 

  11. Neidell, M. J., Air pollution, health, and socio-economic status: the effect of outdoor air quality on childhood asthma. J Health Econ 23(6):1209–1236, 2004. doi:10.1016/j.jhealeco.2004.05.002.

    Article  PubMed  Google Scholar 

  12. McConnell, Rob, et al. Childhood incident asthma and traffic-related air pollution at home and school. Environ. Health Perspect: 1021–1026, 2010. 10.1289/ehp.090123

  13. Li, Y., et al., Air quality and outpatient visits for asthma in adults during the 2008 summer Olympic games in Beijing. Sci Total Environ 408(5):1226–1227, 2010.

    Article  PubMed  CAS  Google Scholar 

  14. O'Connor, G. T., et al., Acute respiratory health effects of air pollution on children with asthma in US inner cities. J. Allergy Clin. Immunol 121(5):1133–1139, 2008.

    Article  PubMed  Google Scholar 

  15. Li, S., et al., Ambient temperature and lung function in children with asthma in Australia. Eur Resp J 43(4):1059–1066, 2014. doi:10.1183/09031936.00079313.

    Article  Google Scholar 

  16. Tosca, M. A., et al., Asthma exacerbation in children: relationship among pollens, weather, and air pollution. Allergol Immunopath 42(4):362–368, 2014. doi:10.1016/j.aller.2013.02.006.

    Article  CAS  Google Scholar 

  17. Şahin, B., and Tatar, M., Factors affecting use of resources for asthma patients. J Med Syst 30(5):395–403, 2006. doi:10.1007/s10916-006-9024-1.

    Article  PubMed  Google Scholar 

  18. Fernandes, R. M., and Hartling, L., Glucocorticoids for acute viral bronchiolitis in infants and young children. JAMA 311(1):87–88, 2014. doi:10.1002/14651858.CD004878.pub3.

    Article  PubMed  CAS  Google Scholar 

  19. Yilmaz, O., et al., Allergic rhinitis may impact the recovery of pulmonary function tests after moderate/severe asthma exacerbation in children. Allergy 69(5):652–657, 2014. doi:10.1111/all.12391.

    Article  PubMed  CAS  Google Scholar 

  20. Bellazzi, R., and Zupan, B., Predictive data mining in clinical medicine: issues and guidelines. Int J Med Inform 77(2):81–97, 2008.

    Article  PubMed  Google Scholar 

  21. Hoffman, K., Stein, K. V., Maier, M., Rieder, A., and Dorner, T. E., Access points to the different predictors in a country without a gatekeeping system. Results of a cross-sectional study from Austria. Eur. J. Public Health 23(6):933–939, 2013. doi:10.1093/eurpub/ckt008.

    Article  Google Scholar 

  22. Cubillas, J. J., Ramos, M. I., Feito, F. R., and Ureña, T., An improvement in the appointment scheduling in primary health care centers using data mining. J Med Syst 38(8):1–10, 2014. doi:10.1007/s10916-014-0089-y.

    Article  Google Scholar 

  23. REDIAM. Inc. Available via http://www.cma.junta-andalucia.es/medioambiente/site/web/rediam (accessed 17 feb 2015)

  24. INE. Inc. Available via http://www.ine.es (accessed 01 feb 2015)

  25. MapInfo v.11.0. User Guide MapInfo v.11.0. Pitney Bowes Software Inc., One Global View, Troy, New York 12180–83399.

  26. Grünwald P, Advances in Minimum Description Length: Theory and Applications. In: Jae Myung, Mark A. Pitt, Peter D. Grunwald, eds. MIT Press, 2010.

  27. Allen, D. M., and Cady, F. B., Analyzing experimental data by regression. CA: Lifetime Learning Publications, Belmont, 1982.

    Google Scholar 

  28. Belsley, D. A., Kuh, E., and Welsch, R. E., Regression diagnostics. Wiley, New York, 1980.

    Book  Google Scholar 

  29. Cameron, A. C., and Trivedi, P. K., Regression analysis of count data. Cambridge University Press, Cambridge, 1988.

    Google Scholar 

  30. Dobson AJ, An Introduction to Generalized Linear Models. In Chatfield C and Zidek J, eds. Texts in Statistical Science Series. Chapman & Hall/CRC: 90–100, 2000

  31. Bolker, B. M., et al., Generalized linear mixed models: a practical guide for ecology and evolution. Trends Ecol. Evol. 24(3):127–135, 2009. doi:10.1016/j.tree.2008.10.008.

    Article  PubMed  Google Scholar 

  32. Dibike, Y. B., et al., Model induction with support vector machines: introduction and applications. J. Comput. Civ. Eng 15(3):208–216, 2001. doi:10.1061/(ASCE)0887-3801(2001)15:3(208).

    Article  Google Scholar 

  33. Press WH, Teukolsky SA, Vetterling WT et al., Section Support vector machines. In Press WH, Teukolsky SA, Vetterling WT and Flannery BP, eds. Numerical recipes: The Art of Scientific Computing. New York: Cambridge University: 16.5, 2007.

  34. Cristianini N, Shawe-Taylor J, An introduction to support vector machines and other kernel based methods. In Cristianini N and Shawe-Taylor J. Cambridge: Cambridge University Press: 6, 2000

  35. Oracle. Inc. Available via http://docs.oracle.com/database/121/DMPRG/toc.htm. (Accessed February 2105)

Download references

Author information

Authors and Affiliations

  1. Department of Cartography, Geodesy and Photogrammetry Engineering, University of Jaen, Jaen, Spain

    M. Isabel Ramos

  2. Department of Computer Science, TIC-144 Andalusian Research Plan (PAI), University of Jaen, Jaen, Spain

    Juan José Cubillas

  3. Department of Computer Science, University of Jaen, Jaen, Spain

    Francisco R. Feito

Authors
  1. M. Isabel Ramos
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Juan José Cubillas
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Francisco R. Feito
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Juan José Cubillas.

Additional information

This article is part of the Topical Collection on Patient Facing Systems

Rights and permissions

Reprints and permissions

About this article

Check for updates. Verify currency and authenticity via CrossMark

Cite this article

Ramos, M.I., Cubillas, J.J. & Feito, F.R. Improvement of the Prediction of Drugs Demand Using Spatial Data Mining Tools. J Med Syst 40, 6 (2016). https://doi.org/10.1007/s10916-015-0379-z

Download citation

  • Received:

  • Accepted:

  • Published:

  • DOI: https://doi.org/10.1007/s10916-015-0379-z

Keywords

Search

Navigation