Question

SQL DBs (structured) v noSQL DBs (unstructured)

Explain difference in details. Provide examples and use cases

Answer 1

Answer :

Particulars	Structured	Unstructured
Characteristics	Predefined information models typically message as it were simple to seek	No predefined information models May be text,images,sound,video. or on the other hand different formates. Hard to seek.
Resides in	Relational databasee. Information distribution centers	Applications NOSQL databases Information warehpouses Information lakes
Generated by	Humans or machines	Humans or machines
Typical applications	Airline reservations frameworks. Stock control CRM frameworks ERP Systems	Word handling exhibiting programming Email clinets Tools for survey or altering media.
Examples	Dates Telephones numbers Government disability numbers Master card numbers clients names Addresses Item names and numbers Exchange data.	Text records reports email messages sound records video records pictures reconnaissance symbolism

Advantages of structured  :

1. Multi client get to.
2. Autorization and benefits control highlights permitted in RDBMS.

Advantages of unstructured  :

1. This is anything but difficult to oversee on the grounds that we can't making any table from it.
2. Generally opensource and ease.
3. No compelling reason to created point by point model.