nosql vs sql

sql	nosql
Relational Databases (RDBMS);	non-relational or distributed database.
table based databases	document based, key-value pairs, graph databases or wide-column stores
have predefined schema	have dynamic schema for unstructured data.
vertically scalable	horizontally scalable
uses SQL for defining and manipulating the data	focused on collection of documents. Sometimes it is also called as UnQL

What kind of data is a good fit for an SQL database?

SQL Databases are best fit for heavy duty transactional type applications, as it is more stable and promises the atomicity as well as integrity of the dat

Give a real world example.

Oracle.

What kind of data is a good fit a NoSQL database?

NoSQL databases are fit for transactional applications.

Give a real world example.

Amazo

Which type of database is best for hierarchical data storage?

NoSQL

Which type of database is best for scalability?

SQL

video question sql vs nosql

What does SQL stand for?

Structured Query Language

What is a realational database?

type of database that stores and provides access to data points that are related to one another.

What type of structure does a relational database work with?

tables

What is a ‘schema’?

collection of logical structures of data.

What is a NoSQL database?

Database that provides a mechanism for storage and retrieval of data that is modeled in means other than the tabular relations used in relational databases.

Howo does it work?

each item stand on its own with its own key and value.

What is inside of a Mongo database?

Records which are made up of documents that contain a data structure composed of field and value pairs.

Which is more flexible - SQL or MongoDB? and why.

MongoDB because it uses multiple kind of data.

What is the disadvantage of a NoSQL database?

NoSQL databases don’t have the reliability functions