The advanced stats system available exclusively on HockeyCSSI.com is a powerful tool for analysis of official hockey stats. This system builds a relational database of every hockey game. This database includes
- Shift-by-Shift data for every player on the ice.
- This shift-by-shift data is used to build a timeline of each game.
- This timeline allows the software to know which players where on the ice at any particular second of the hockey game.
- This timeline also allows the software to differentiate between 5v4, 5v3, 4v3, 4v4, etc and whether or not either goalie is in net.
- All events in a hockey game are also recorded. These events include goals, penalties, hits, giveaways, takeaways, face-offs, shots, and blocked shots.
- By cross referencing the timeline with recorded events the software can extract a great deal of information from official statistics.
Due to the large number of calculations required for even simple queries the results are cached in the database. A large number of possible queries are automatically cached in calculations that run every evening. However, due to the nature of the system the number of queries is infinite so the first time a query is run it may be slow to complete. Once the query is run once it will be cached. For instance:
- You run a Player Stats query with players A, B, and C on the Ice and players D, and E off the ice.
- No one else has run that query yet so the software first has to calculate to the second for every game when those conditions were met and then analyze every event that occurred during those blocks of time.
- Since no one has ever run the query before it is slow to complete and you have to site there for a minute.
- But now that query is cached so if you go to the Graphs section and want to graph how many goals each player had in relation to their shared ice time with number of giveaways everything should be much faster.
- Also if you or anyone else returns and runs the same query it will be fast for them as well.