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