Digital technology for the national sport development: Designing a database model to analyse elite sports data
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
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.