1) What are the reasons for considering a noSQL database, rather than a relation

Question

1) What are the reasons for considering a noSQL database, rather than a relational database

Select or more:

a) A database can allow the insertion of data without a predefined schema

b) Complex transactions can be performed to pressure consistency across difference tranasctions

c) Data is growing fast and changing in structure which requires a database to scale out quickly

d) A declerative query language is preffered for quering data and managing data integrity

2) Document-oriented data stores keep data as documents. Such a document is defined as

Select one or more

a) An ASCII or UTF-8 file

b) A written or drawn representation of thoughts

c) A JSON-like or BSON like document

d) An object that has a set of keys and values stores as pairs

e) A text document such as spreadsheet, powerpoint etc

Explanation / Answer

below the points for considering a noSQL over relational database :

Highly and easily scalable

Relational database or RDBMS databases are vertically Scalable When load increase on RDBMS database then we scale database by increasing server hardware power ,need to by expensive and bigger servers and NoSQL databases are designed to expand horizontally and in Horizontal scaling means that you scale by adding more machines into your pool of resources.

Maintaining NoSQL Servers is Less Expensive

Maintaining high-end RDBMS systems is expensive and need trained manpower for database management but NoSQL databases require less management. it support many Features like automatic repair, easier data distribution, and simpler data models make administration and tuning requirements lesser in NoSQL.

Lesser Server Cost and open-Source

NoSQL databases are cheap and open source. NoSql database implementation is easy and typically uses cheap servers to manage the exploding data and transaction while RDBMS databases are expensive and it uses big servers and storage systems. So the storing and processing data cost per gigabyte in the case of NoSQL can be many times lesser than the cost of RDBMS.

No Schema or Fixed Data model

NoSQL database is schema less so Data can be inserted in a NoSQL database without any predefined schema. So the format or data model can be changed any time, without application disruption.and change management is a big headache in SQL.

Support Integrated Caching

NoSQL database support caching in system memory so it increase data output performance and SQL database where this has to be done using separate infrastructure.

1:  a) A database can allow the insertion of data without a predefined schema

c) Data is growing fast and changing in structure which requires a database to scale out quickly

2 :

d) An object that has a set of keys and values stores as pairs

c) A JSON-like or BSON like document

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.