ICE HOCKEY DATABASE SCHEMA DESIGN: FOR NATIONAL TEAM'S BIOMECHANICAL ANALYSIS

Authors

SeungKyo Jin, University of Science & Technology, KISTI & University of Science & Technology (UST)Follow
Sun-tae Kim, KISTIFollow
Hye young Kim, Korea National Sport UniversityFollow
Ji-hyun Jang, KNSUFollow

Category

Other

Document Type

Paper

Abstract

This study presented database schema to manage ice hockey data shown in official record of World Championships. We selected data fields to design database schema considering which fields were contributing to the victory. We also sorted all fields into six tables to reflect the elements of ice hockey games; Game Information, Team Information, Offensice Stats, Defence Stats, Face-off Stats, Time On Ice Stats. This study was a prior research designing database schema in which the analysis of ice hockey official record is used to advance from statistical models to data science techniques. After storing raw data pre-processed into the database, researcher can analyze biomechanically to improve performance.

Recommended Citation

Jin, SeungKyo; Kim, Sun-tae; Kim, Hye young; and Jang, Ji-hyun (2018) "ICE HOCKEY DATABASE SCHEMA DESIGN: FOR NATIONAL TEAM'S BIOMECHANICAL ANALYSIS," ISBS Proceedings Archive: Vol. 36: Iss. 1, Article 138.
Available at: https://commons.nmu.edu/isbs/vol36/iss1/138