Page 1 of 1 [ 2 posts ] 

Tim_Tex
Veteran
Veteran

User avatar

Joined: 2 Jul 2004
Age: 46
Gender: Male
Posts: 46,693
Location: Houston, Texas

08 Nov 2019, 11:42 am

Of SQL (Oracle, et al) and NoSQL (MongoDB, et al), which is the most practical for big data technology?


_________________
Who’s better at math than a robot? They’re made of math!


Abstract_Logic
Veteran
Veteran

User avatar

Joined: 3 Dec 2008
Gender: Male
Posts: 580
Location: Here

12 Dec 2019, 10:24 pm

I know very little about databases, but I know that NoSQL databases like MongoDB and AWS's DynamoDB are more suitable to big data because the data is not structured in relational tables as in MySQL, PostgreSQL, or Microsoft Access, but rather is stored in a JSON-like format. SQL is for structured relational data; NoSQL is for non-structured data that doesn't lend itself well to the tabular schema.


_________________
Autistic (self-identified)
Open source, free software, and open knowledge geek
GoLang, Python, & SysAdmin aspirant
RPG enthusiast
Has OCD, social anxiety, CPTSD