-

                                                NoSQL

                                       

NoSQL databases are purpose built for specific data models and have flexible schemas for building modern applications. NoSQL databases are widely recognized for their ease of development, functionality, and performance at scale. They use a variety of data models, including document, graph, and key-value. This page includes resources to help you better understand NoSQL databases and to get started

"NO" in SQL is an abbreviation for "not only" and not the actual word "No." This distinction is important not only because many NoSQL databases support SQL like queries. NoSQL and relational databases are now commonly used together in a single application



                                                 SQL vs NoSQL databases


  1. NoSQL databases have a dynamic schema for document type or unstructured data whereas SQL Databases have a well-designed pre-defined schema
  2. While SQL uses structured query language for defining data, NoSQL uses the collection of documents which is also known as UnQL (Unstructured Query Language).
  3. We can easily add the new data in NoSQL without requiring prior steps whereas SQL might require doing some changes like backfilling data, altering schemas.
  4. Since SQL has a standard interface for handling complex queries, it would be great to deal with complex queries. Feebly, we don’t have any standard interface in NoSQL, so it’s quite difficult to handle complex queries in NoSQL.
  5. SQL Database is a Relational Database and a structured one whereas NoSQL is a Non-relational database likely to be more document and distributed than structured.



                                                 Reasons to Use A SQL Database

       1.When need ACID compliancy.
          ACID compliancy reduces anomalies and protects the intergrity of the database.

      2.When data is structured and unchanging

                                              

                                               Reasons to Use A NoSQL Database


  1. When we have a large volume of data without structure
  2. When using cloud computing storage methods
  3. When using rapid development methodologies 
                                          

                                              Types of NoSQL Databases

  1. Key-value store
  2. Document-based store
  3. Column based store
  4. Graph-based store
                                

                                             Advantages of NoSQL Databases

  1. Large volumes of structured, semi-structured, and unstructured data
  2. Agile sprints, quick iteration, and frequent code pushes
  3. Object-oriented programming that is easy to use and flexible
  4. Efficient, scale-out architecture instead of expensive, monolithic architecture

Comments

Post a Comment

Popular posts from this blog

-
Image
                                      MERN Stack what is a stack? The technology stack is a set of frameworks and tools used to develop a software product. This set of frameworks and tools are very specifically chosen to work together in creating a well-functioning software.   MERN Mongo Express React Node  MERN Stack MERN  stack is a web development framework. It consists of MongoDB, ExpressJS, ReactJS, and NodeJS as its working components. Here are the details of what each of these components is used for in developing a web application when using MERN stack
Read more
-
Image
ReactJS React is a front-end library developed b y Facebook. ReactJS presents graceful solutions to some of front-end programming’s most persistent issues.  It is used for handling the view layer for web and mobile apps.   It’s fast, scalable, flexible, powerful, and has a robust developer community that’s rapidly growing. ReactJS allows us to create reusable UI components. It is currently one of the most popular JavaScript libraries  According to React official documentation, the following is the definition − ` React is a library for building composable user interfaces. It encourages the creation of reusable UI components, which present data that changes over time. Lots of people use React as the V in MVC. React abstracts away the DOM from you, offering a simpler programming model and better performance. React can also render on the server using Node, and it can power native apps using React Native. React implements one-way reactive data flow, which reduces the boilerp
Read more