Digital technology for the national sport development: Designing a database model to analyse elite sports data

Alan de Carvalho Dias Ferreira, Pedro Sobreiro, Júlio B. Mello, Alberto Reinaldo Reppold Filho

Article ID: 7489
Vol 8, Issue 11, 2024

VIEWS - 42 (Abstract) 16 (PDF) 5 (Supp. file)

Abstract


Relational database models offer a pathway for the storage, standardization, and analysis of factors influencing national sports development. While existing research delves into the factors linked with sporting success, there remains an unexplored avenue for the design of databases that seamlessly integrate quantitative analyses of these factors. This study aims to design a relational database to store and analyse quantitative sport development data by employing information technology tools. The database design was carried out in three phases: (i) exploratory study for context analysis, identification, and delimitation of the data scope; (ii) data extraction from primary sources and cataloguing; (iii) database design to allow an integrated analysis of different dimensions and production of quantitative indicators. An entity-relationship diagram and an entity-relationship model were built to organize and store information relating to sports, organizations, people, investments, venues, facilities, materials, events, and sports results, enabling the sharing of data across tables and avoiding redundancies. This strategy demonstrated potential for future knowledge advancement by including the establishment of perpetual data updates through coding and web scraping. This, in turn, empowers the continuous evaluation and vigilance of organizational performance metrics and sports development policies, aligning seamlessly with the journal’s focus on cutting-edge methodologies in the realm of digital technology.


Keywords


sport development; sport management; digital technology; business intelligence; software; sports policy; data analysis

Full Text:

PDF Supp. file


References


Baca, A., Dabnichki, P., Hu, C.-W., et al. (2022). Ubiquitous Computing in Sports and Physical Activity—Recent Trends and Developments. Sensors, 22(21), 8370. https://doi.org/10.3390/s22218370

Bai, Z., & Bai, X. (2021). Sports Big Data: Management, Analysis, Applications, and Challenges. Complexity, 2021(1). Portico. https://doi.org/10.1155/2021/6676297

Bayle, E., & Robinson, L. (2007). A Framework for Understanding the Performance of National Governing Bodies of Sport. European Sport Management Quarterly, 7(3), 249–268. https://doi.org/10.1080/16184740701511037

Bohlmann, H. R., & Heerden, J. H. V. (2008). Predicting the economic impact of the 2010 FIFA World Cup on South Africa. International Journal of Sport Management and Marketing, 3(4), 383. https://doi.org/10.1504/ijsmm.2008.017214

Budovich, L. S. (2021). Business management of the sport industry by considering the digitalization. Journal of Human Sport and Exercise. https://doi.org/10.14198/jhse.2021.16.proc4.07

Bunker, R. P., & Thabtah, F. (2019). A machine learning framework for sport result prediction. Applied Computing and Informatics, 15(1), 27–33. https://doi.org/10.1016/j.aci.2017.09.005

Camps, A., & Pappous, A. S. (2016). Predicting the Evolution of Sports Federation Membership: AnImportant Tool to Asses National Governing Bodies’ Strategic Planning. Journal of Sports Science, 4(2). https://doi.org/10.17265/2332-7839/2016.02.001

Caya, O., & Bourdon, A. (2016). A Framework of Value Creation from Business Intelligence and Analytics in Competitive Sports. In: Proceedings of the 2016 49th Hawaii International Conference on System Sciences (HICSS). https://doi.org/10.1109/hicss.2016.136

Codd, E. F. (1970). A relational model of data for large shared data banks. Communications of the ACM, 13(6), 377–387. https://doi.org/10.1145/362384.362685

Cossich, V. R. A., Carlgren, D., Holash, R. J., et al. (2023). Technological Breakthroughs in Sport: Current Practice and Future Potential of Artificial Intelligence, Virtual Reality, Augmented Reality, and Modern Data Visualization in Performance Analysis. Applied Sciences, 13(23), 12965. https://doi.org/10.3390/app132312965

Dabnichki, P., Hu, C.-W., Kornfeind, P., & Exel, J. (2022). Ubiquitous computing in sports and physical activity—Recent trends and developments. Sensors, 22(21), 8370. https://doi.org/10.3390/s22218370

De Bosscher, V., De Knop, P., Van Bottenburg, M., et al. (2006). A Conceptual Framework for Analysing Sports Policy Factors Leading to International Sporting Success. European Sport Management Quarterly, 6(2), 185–215. https://doi.org/10.1080/16184740600955087

De Bosscher, V., Shibli, S., Westerbeek, H., & Van Bottenburg, M. (2015). Successful elite sport policies: an international comparison of the sports policy factors leading to international sporting success (SPLISS 2.0) in 15 nations. Meyer & Meyer.

De Bosscher, V., Shibli, S., Westerbeek, H., et al. (2016). Convergence and Divergence of Elite Sport Policies: Is There a One-Size-Fits-All Model to Develop International Sporting Success? Journal of Global Sport Management, 1(3–4), 70–89. https://doi.org/10.1080/24704067.2016.1237203

Exel, J., & Dabnichki, P. (2024). Precision Sports Science: What Is Next for Data Analytics for Athlete Performance and Well-Being Optimization? Applied Sciences, 14(8), 3361. https://doi.org/10.3390/app14083361

Ferreira, A. D. C. D., Vitor, K. P., Haiachi, M. D. C., et al. (2018). Financing paralympic sport in Brazil: agreements (Portugal). Cadernos de Educação Tecnologia e Sociedade, 11(1), 22. https://doi.org/10.14571/brajets.v11.n1.22-36

Green, M., & Oakley, B. (2001). Elite sport development systems and playing to win: uniformity and diversity in international approaches. Leisure Studies, 20(4), 247–267. https://doi.org/10.1080/02614360110103598

Grix, J. (2013). Sport Politics and the Olympics. Political Studies Review, 11(1), 15–25. https://doi.org/10.1111/1478-9302.12001

Houlihan, B., & Green, M. (2008). Comparative Elite Sport Policy: Systems, Structures, and Public Policy. 1st ed. Elsevier, pp. 316. https://doi.org/10.4324/9780080554426

International Olympic Committee. (n.d.). Available online: Https://Olympics.Com/Ioc/Documents/Olympic-Games/Rio-2016-Olympic-Games (accessed on 2 June 2023).

Kroenke, D. M., & Auer, J. D. (2007). Database Concepts, 3rd ed. Prentice.

Link, D. (2018). Sports Analytics. German Journal of Exercise and Sport Research, 48(1), 13–25. https://doi.org/10.1007/s12662-017-0487-7

Lopez, M. J. (2020). Bigger data, better questions, and a return to fourth down behavior: an introduction to a special issue on tracking datain the National football League. Journal of Quantitative Analysis in Sports, 16(2), 73–79. https://doi.org/10.1515/jqas-2020-0057

Madella, A., Bayle, E., & Tome, J. (2005). The organisational performance of national swimming federations in Mediterranean countries: A comparative approach. European Journal of Sport Science, 5(4), 207–220. Portico. https://doi.org/10.1080/17461390500344644

Mamo, Y. Z. (2023). Big Data and Innovative Research Methods. International Journal of Sport Communication, 16(3), 352–360. https://doi.org/10.1123/ijsc.2023-0109

O’Boyle, I. (2015). Developing a performance management framework for a national sport organisation. Sport Management Review, 18(2), 308–316. https://doi.org/10.1016/j.smr.2014.06.006

Ofoghi, B., Zeleznikow, J., MacMahon, C., et al. (2013). Data Mining in Elite Sports: A Review and a Framework. Measurement in Physical Education and Exercise Science, 17(3), 171–186. https://doi.org/10.1080/1091367x.2013.805137

Qiao, J. (2022). Intelligent Big Data Framework for the Technical Design of Public Management Applications in Sports. Mathematical Problems in Engineering, 2022, 1–9. https://doi.org/10.1155/2022/1900548

Rajšp, A., & Fister, I. (2020). A Systematic Literature Review of Intelligent Data Analysis Methods for Smart Sport Training. Applied Sciences, 10(9), 3013. https://doi.org/10.3390/app10093013

Ren, P., & Liu, Z. (2021). Efficiency Evaluation of China’s Public Sports Services: A Three-Stage DEA Model. International Journal of Environmental Research and Public Health, 18(20), 10597. https://doi.org/10.3390/ijerph182010597

Rewilak, J. (2021). The (non) determinants of Olympic success. Journal of Sports Economics, 22(5), 546–570. https://doi.org/10.1177/1527002521992833

Sands, W. A., Kavanaugh, A. A., Murray, S. R., et al. (2017). Modern Techniques and Technologies Applied to Training and Performance Monitoring. International Journal of Sports Physiology and Performance, 12(s2), S2-63-S2-72. https://doi.org/10.1123/ijspp.2016-0405

SAP. (n.d.) Unveils SAP sports one solution for soccer. Available online: http://News.Sap.Com/Sap-Unveils-Sap-Sports-One-Solution-for-Soccer/ (accessed on 2 June 2023).

Shilbury, D., & Moore, K. A. (2006). A Study of Organizational Effectiveness for National Olympic Sporting Organizations. Nonprofit and Voluntary Sector Quarterly, 35(1), 5–38. https://doi.org/10.1177/0899764005279512

Shin, S.-S. (2022). Teaching Method for Entity–Relationship Models Based on Semantic Network Theory. IEEE Access, 10, 94908–94923. https://doi.org/10.1109/access.2022.3206028

Strittmatter, A.-M., Stenling, C., Fahlén, J., et al. (2018). Sport policy analysis revisited: the sport policy process as an interlinked chain of legitimating acts. International Journal of Sport Policy and Politics, 10(4), 621–635. https://doi.org/10.1080/19406940.2018.1522657

Sun, G., Zhang, X., & Lin, Y. (2022). Evaluation Model of Sports Culture Industry Competitiveness Based on Fuzzy Analysis Algorithm. Mathematical Problems in Engineering, 2022, 1–8. https://doi.org/10.1155/2022/9708646

Wanless, L. (2022). Progressive Analytics Diffusions: Rewiring our Software. Journal of Applied Sport Management. https://doi.org/10.7290/jasm14mxjx

Ward, P., Windt, J., & Kempton, T. (2019). Business Intelligence: How Sport Scientists Can Support Organization Decision Making in Professional Sport. International Journal of Sports Physiology and Performance, 14(4), 544–546. https://doi.org/10.1123/ijspp.2018-0903

Watanabe, N. M., Shapiro, S., & Drayer, J. (2021). Big Data and Analytics in Sport Management. Journal of Sport Management, 35(3), 197–202. https://doi.org/10.1123/jsm.2021-0067

Winand, M., Vos, S., Claessens, M., et al. (2014). A unified model of non-profit sport organizations performance: perspectives from the literature. Managing Leisure, 19(2), 121–150. https://doi.org/10.1080/13606719.2013.859460




DOI: https://doi.org/10.24294/jipd.v8i11.7489

Refbacks

  • There are currently no refbacks.


Copyright (c) 2024 Alan de Carvalho Dias Ferreira, Pedro Sobreiro, Júlio B. Mello, Alberto Reinaldo Reppold Filho

License URL: https://creativecommons.org/licenses/by/4.0/

This site is licensed under a Creative Commons Attribution 4.0 International License.