CODEWITHSUNDEEP
firebase
Mutuelinvestor
Mutuelinvestor

Reputation: 3538

Structuring Data In Firebase

I'm contemplating using Firebase for an upcoming project, but before doing so I want to make sure I can develop a data structure that will meet my purposes. I'm interested in tracking horse race results for approximately 25 racetracks across the US. My initial impression was that my use case aligned nicely with the Firebase Weather Data Set. The Weather data set is organized by city and then in various time series: currently, hourly, daily and minutely.

My initial thought was that I could follow a similar approach and use the 25 tracks as cities and then organize by years, months, days and races.

This structure lends itself nicely to accessing data from a particular track, but suppose that also want to access data across all tracks. For example, access data for all tracks for races that occurred in 2014 and had more than 10 horses.

Questions:

  1. Does my proposed data structure limit me to queries by track only or would I still be able to query across tracks, years, days, months, etc. and incorporate any and all of the various meta data attributes: number of horses, distance of race, etc.

  2. Given, my interest in freeform querying is there another data structure that would be more advantageous?

  3. Is Firebase similar to Mongodb and have issues with collections (lists) that grow or can one continue to push to a list without pre allocating or worrying about sharding?

I believe my confusion stems from url/path nature of the data storage.

EDIT:

enter image description here

Here is a sample of what I had in mind:

Thanks for your input.

Upvotes: 2

Views: 1016

Answers (1)

RByrns
RByrns

Reputation: 31

I would think that you would want to organize by horse first. I guess it depends what you are deriving from the data. One horse could be at different tracks.

Horses table

* Horsename
-----Date
-----Track
-----Racenumber
-----Gate
-----Jockey
-----Place
-----Odds
-----Mud?

Races table

----Track
----Racenumber
----Date
----Time
----NumberOfHorses

Link the tables and you could get at any one part of it.

Upvotes: 3

Related Questions