内存数据库和磁盘内存数据库之间的区别 [英] Difference between In memory databases and disk memory database
问题描述
最近我听说过内存数据库的概念。
在任何类型的数据库中，我们终于将数据存储在计算机中，从那里我们的程序会得到
内存数据库中的数据库是否会将所有数据从数据库加载到内存（RAM）中。 / p>
感谢提前....
数据库（IMDB;也是主存储器数据库系统或MMDB或存储器驻留数据库）是主要依赖于主存储器用于计算机数据存储的数据库管理系统。它与采用磁盘存储机制的数据库管理系统形成对比。主内存数据库比磁盘优化的数据库更快，因为内部优化算法更简单，执行更少的CPU指令。访问内存中的数据消除了查询数据时的查找时间，从而提供比磁盘更快更可预测的性能。
响应时间至关重要的应用程序，如运行电信网络设备和移动广告网络，通常使用主内存数据库。
在回答您的查询时，会将数据加载到您的计算机的RAM中。
磁盘数据库
-
所有数据存储在磁盘上，磁盘I / O需要在需要时将数据移入主
内存。 -
数据始终保留到磁盘。
-
传统的数据结构，例如用于在磁盘上有效存储表和
索引的B-Trees。 -
几乎无限的数据库大小。
-
支持非常广泛的工作负载集，即OLTP，数据仓库，
混合工作负载，
内存数据库
-
存储在主内存中的所有数据，无需执行磁盘I / O查询
或更新数据。 -
根据内存数据库
产品，数据是持久性或易变性。 -
专用数据结构和索引结构假设数据总是在主存储器中为
。 -
针对特定工作负载进行了优化;
-
数据库大小受到主内存量的限制。
Recently i heard about the concept of In memory database.
In any type of database we are finally storing the data in the computer,from there our program will get the data .How in memory database operations are fast when compared to the others.
Will the in memory database load all the data from the database into memory(RAM).
Thanks in advance....
An in-memory database (IMDB; also main memory database system or MMDB or memory resident database) is a database management system that primarily relies on main memory for computer data storage. It is contrasted with database management systems that employ a disk storage mechanism. Main memory databases are faster than disk-optimized databases since the internal optimization algorithms are simpler and execute fewer CPU instructions. Accessing data in memory eliminates seek time when querying the data, which provides faster and more predictable performance than disk.
Applications where response time is critical, such as those running telecommunications network equipment and mobile advertising networks, often use main-memory databases.
In reply to your query, yes it loads the data in RAM of your computer.
On-Disk Databases
All data stored on disk, disk I/O needed to move data into main memory when needed.
Data is always persisted to disk.
Traditional data structures like B-Trees designed to store tables and indices efficiently on disk.
Virtually unlimited database size.
Support very broad set of workloads, i.e. OLTP, data warehousing, mixed workloads, etc.
In-Memory Databases
All data stored in main memory, no need to perform disk I/O to query or update data.
Data is persistent or volatile depending on the in-memory database product.
Specialized data structures and index structures assume data is always in main memory.
Optimized for specialized workloads; i.e. communications industry-specific HLR/HSS workloads.
Database size limited by the amount of main memory.
这篇关于内存数据库和磁盘内存数据库之间的区别的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
