NoSQL is a storage that does not conform to the relational database model and its characteristics, such as they do not have schemas, are not joined, and do not guarantee the ACID property. The NO system scales horizontally and uses a wide amount of main memory of the computer, solving the problem of large amounts of information.
Native native types are a new methodology for developing non-relational NoSQL databases implemented by large companies to meet corporate needs, such as Google’s BigTable, which is considered the first NoSQL system, and Amazon DynamoDB. The success of these systems gave rise to the development of a number of similar open source and proprietary database systems, the most popular of which are Hypertable, Cassandra, MongoDB, DynamoDB.
The SQL scalability problem has been recognized by Web 2.0 companies with huge, growing data and infrastructure needs, such as Google, Amazon, and Facebook. They found their own solutions to the problem by implementing BigTable, DynamoDB, and Cassandra technologies. The growing interest has led to the emergence of a number of NoSQL database management systems (DBMS) with a focus on performance, reliability, and consistency. A number of existing indexing structures have been reused and improved in order to improve search and read performance.
The term was coined by Calor Strozzi back in 1998 and revived in 2009 by Rackspace employee Eric Evans to address the problems of web companies with a large volume of transactions and information.
One key difference between NoSQL databases and traditional relational databases is that the former is a form of unstructured storage.
Thus, NoSQLs do not have a fixed table structure, as in a relational system. This table provides a brief comparison of NoSQL and SQL capabilities.
It should be noted that the table shows a comparison at the database level, not the DBMSs that implement both models. These systems provide their own proprietary methods to overcome some of the problems and shortcomings of both systems, which greatly improves performance and reliability.