Q1. What is NoSQL?
NoSQL aka "not only SQL" is a non-relational Database Management system that is used for distributed data stores. It is easy to scale as it doesn't require a fixed schema. In other words, NoSQL is access to database design that provides a variety of data models that includes key-value, column, document and graph formats. The big data and real-time applications use a NoSQL database to store their data.
Q2. Why is NoSQL document-oriented data model an attractive choice?
As data-sensitive organizations have faced many data-related problems, so a new solution has been introduced and the answer is NoSQL Document Databases. It is attractive to the users because it keeps data in documents rather than rows and columns. Some minimum standard format rules must be followed by these documents. The format choices could be JSOS, XML, YAML, etc. The priority is always JSON for NoSQL databases due to its better compatibility and readability.
Q3. Explain BASE properties, as seen in NoSQL
The BASE acronym is used to explain the properties of the NoSQL database. The BASE tells about the properties of databases, usually NoSQL databases. The full form of BASE is Basically Available, Soft state, Eventual consistency.
Q4. Why to use NoSQL?
Reasons to use NoSQL:
Q5. What are the advantages and disadvantages of NoSQL?
Advantages of NoSQL:
Disadvantages of NoSQL
Q6. What are the categories of NoSQL databases?
There are four categories of NoSQL databases which are:
Q7. How is data in a NoSQL database stored?
It depends on the type of NoSQL database is used. Each database stores the data using different methods like some use column store, some graphs, and some documents, etc. Below is the explanation of each database and how they store the data.
Q8. What are examples of NoSQL databases?
Some of the examples of NoSQL databases are:
Q9. What are the differences between the SQL and NoSQL databases?
The major differences between SQL and NoSQL Databases are:
|It is primarily called as a non-relational or distributed database.||It is called a relational database (RDBMS).|
|It is horizontally scalable.||It is vertically scalable.|
|It follows the CAP theorem.||It follows the ACID properties.|
|They have a dynamic schema.||They have a fixed schema.|
|Best suitable for hierarchical data storage.||This is not suitable for hierarchical data storage.|
|This is not good for complex queries.||This is best for complex queries.|
Q10. What do you understand by " Polyglot Persistence " in NoSQL?
Polyglot Persistence refers to handle diverse data storage needs by using different data storage technologies. It can be also said that it is an offshoot of Polyglot programming which use many programming languages to build an application. In short, it uses more than one core database technology.
Q11. What is CAP theorem? How is it applicable to NoSQL systems?
The CAP theorem is known as Brewer's theorem states that a distributed database system can guarantee/ strongly supports only two of the three properties described below.
Since, in NoSQL, partition tolerance is a must so there is a tradeoff between availability and consistency. Therefore, it cannot provide consistency and availability together.