My reading journal for Code Fellows.
SQL databases are good for heavy duty transactional applications.
MySQL can be used to serve this purpose, especially with its server sharding ability.
NoSQL is best used for hierarchical data storage. It is preferred for large data sets.
Hbase is used for this purpose.
NoSQL is better because it stores data using key-value pairs.
NoSQL databases are better because they can scale both horizontally and vertically. You can upgrade the hardware of the server to handle increased load instead and add additional servers when needed.
SQL stands for Structured Query Language.
A relational database stores data across multiple tables that are connected based on their relationship.
Relational databases work with tables.
A schema is basically a rule for formatting data storage. Everything needs to follow this set of rules, which may require you to adapt your data to follow this format before being able to store it.
NoSQL is a database that uses documents to store data rather than tables. It does not have any schema, which makes it a very flexible data storage solution.
NoSQL has collections. These collections hold many documents. They can hold any data you want and the format can very between each document because there isn’t any schema in NoSQL.
A Mongo database holds many collections that can each have many documents. Inside the documents, you find the data being stored as key-value pairs. This data and its format can very greatly between each document due to the flexible nature of NoSQL.
Mongo is more flexible because it doesn’t use schemas. This lets the user store whatever data they want, however they want.
Not having relations can be an issue if you need to write to the database a lot. Since NoSQL can have the same data stored in multiple documents and collections, multiple write requests will have to be made for a single change because each document must get updated separately. NoSQL also struggles with complex requests and heavy duty transactional data.
I want to learn a bit more about SQL storage. I think the concept of how a relational database works is really cool and tieing the tables together appeals to my logical thinking.