![]() I can only achieve this by building an n:m relationship between the newly created unpivoted matches table and the events table (via matchID). But only for a specific game Liverpool was playing. ![]() I want to browse some key stats out of the events table. MGI: the international database resource for the laboratory mouse, providing integrated genetic, genomic, and biological data for researching human health. What's best practice when it comes to storing other match metadata like result, date, location? I could store it into another table with matchID as column with unique value (1*n relationship). With this I can filter the teamID column to let only games appear where t2 (Liverpool) is playing. How to deal with it other than changing the data structure of the matches table into something like that: results and some game metadata) that Liverpool is playing (either home or away). Select a team slicer filtering dimension table "Teams" with e g Liverpool to show only games (incl. Aerospike Cloud is a Database-as-a-Service (DBaaS) solution offering developers and data teams the full power of the multi-model Aerospike Database delivered as an on-demand, pay-as-you-go, fully elastic service. This is what the real dataset actually looks like. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |