Replaces NoSQL SQL

NoSQL - Function and advantages of NoSQL databases

Art One database for everything Different database models, such as B. Document, graph, key value and column database Data storage Individual data (e.g. “book title”) are stored in rows in a table and assigned to certain attributes (e.g. “author”, “year of publication” etc.). The data records are saved in separate tables and are merged by the system for complex search queries. NoSQL databases do not use tables but, depending on the type, entire documents, key values, graphs or columns. Schemes The data type and structure are determined in advance. In order to store new information, the entire database must be adapted (and for this purpose go offline). Flexible. New records can be added immediately. Structured, semi-structured and unstructured data can be saved together; prior conversion is not necessary. Scaling Vertical scaling. A single server has to carry the performance of the entire database system, which results in a drop in performance with large amounts of data. Horizontal scaling. Every administrator can add new commodity and cloud servers, the NoSQL database automatically sends the data to all servers. Development model Open source (e.g. MySQL) or payment software (Oracle Database) Open source or payment software ACID properties: Atomicity, Consistency, Isolation, Durability All ACID properties are given in SQL databases. In order to keep NoSQL databases flexible and horizontally scalable, ACID transactions are mostly not supported. Instead, the BASE model is used (Basically Available, Soft State, Eventually Consistent). Accordingly: availability over consistency. power Use indexes for increased data volumes. In order to increase the performance of SQL systems, queries, indexes and structure must be optimized. By using cloud servers and hardware clusters, NoSQL databases have a significantly higher level of performance. APIs Queries to store and retrieve data are submitted using Structured Query Language (SQL). Data is stored and queried via object-based APIs.