- Trending Categories
- Data Structure
- Operating System
- C Programming
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
What is NoSQL (Not Only SQL database)
Conventional relational databases were the product of a great deal of research and testing to obtain optimal storage structures. However, their flaw is that they have a rigid structure which cannot be altered if there are different specifications. To combat this problem, NoSQL databases were created.
There are many different types of NoSQL databases, with different specifications. Some of these are −
Column - Data is stored in a columnar form. Some examples of this type of database are: Accumulo, Cassandra, Druid, Vertica etc.
Key Value - These databases are organised as key value pairs, where each key appears exactly once. The keys are usually arranged in a sorted fashion. Examples of this type of databases are: Aerospike, ArangoDB, Couchbase, Dynamo etc.
Graph - The databases are arranged in the form of a graph with the elements connected using the relations between them. Examples are AllegroGraph, InfiniteGraph,MarkLogic etc.
Document - The database is stored in the form of documents that are accessed using a unique key. A single key references a document. Examples of Domument based databases are: Apache CouchDB, BaseX, Clusterpoint erc.
Rating of different NoSQL databases
|Graph Database||VARIABLE||VARIABLE||HIGH||HIGH||GRAPH THEORY|
|Key value database||HIGH||HIGH||HIGH||NONE||VARIABLE|
Disadvantages of NoSQL databases
The data is not as consistent in NoSQL databases as in traditional relational databases. Moreover, while SQL databases uphold the ACID properties and provide reliable transactions, the NoSQL databases often sacrifice the ACID properties for speed and scalability.
Basically, both the SQL and NoSQL databases provide different functionalities and compliment each other in the long run. It is up to the user to choose whichever type of database suits their needs the best.
- Difference between SQL and NoSQL
- NoSQL Databases
- What is SQL?
- What is NoSQL and is it the next big trend in databases?
- What is PL/SQL?
- What is SQL Injection?
- Create User SQL in SAP HANA database
- Create View SQL in SAP HANA database
- What is JDBC SQL Escape Syntax Explain?
- What is a database(dbms)?
- What is a distributed database?
- What is a multimedia database?
- Run SQL file in MySQL database from terminal?
- MySQL query to check if database is empty or not?
- Using SQL statements in ABAP Programming and Database performance