SPIKE: Database research

jfizzy commented 5 years ago

Determine what databases are available to us on Azure services.

AC:

Determine what kind of database will be suitable for our application (Relational or Non Relational)
Determine the most COST EFFECTIVE solution that we can use to accomplish our goals

tlagore commented 5 years ago

If we decide to use a scraper for any portion of our data, I think we should use a non relational database as the schemas will differ pretty greatly across resources. If we keep it relational, it would require a lot of cleaning of the data before storing.

If we decide to use freely available data, it might be better to use a relational database, but we might still take from multiple different locations. Even if it is all the same, we probably won't have enough data to really notice a performance difference.

I vote non relational.

JohnnySimmonds commented 5 years ago

Footy_Taint DB Info.docx

DB Columns so far

@tlagore @jfizzy

tlagore / footy

SPIKE: Database research #5