User Tools

Site Tools


databases:overview

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

databases:overview [2022/12/21 18:36] – created dimitrijdatabases:overview [2022/12/29 16:37] (current) dimitrij
Line 18: Line 18:
  
   * In-memory databases: These databases store data in the main memory (RAM) of a computer, rather than on disk. This allows them to process queries much faster than disk-based databases, but they are limited by the amount of memory available.   * In-memory databases: These databases store data in the main memory (RAM) of a computer, rather than on disk. This allows them to process queries much faster than disk-based databases, but they are limited by the amount of memory available.
 +
 +===== Relational vs. non-relational =====
 +
 +==== Relational databases ====
 +
 +... are databases that store data in tables with relationships to each other. A table typically contains records that contain similar information, and each record is made up of fields that contain specific information. The relationships between the tables are established using foreign keys, which allow data from different tables to be linked together.
 +
 +==== Non-relational ====
 +
 +... databases, also known as NoSQL databases, do not store data in tables with relationships to each other, but rather as documents, key-value pairs, or graphs. They are generally more flexible and scalable than relational databases and are therefore particularly suitable for rapidly growing amounts of data and applications with high availability requirements. However, they generally offer less functionality for data integrity and data querying compared to relational databases.
 +
databases/overview.txt · Last modified: 2022/12/29 16:37 by dimitrij

Except where otherwise noted, content on this wiki is licensed under the following license: Public Domain
Public Domain Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki