Thursday, September 21, 2017

When and Why I Use an In-Memory Database or a Traditional Database

DZone Database Zone
When and Why I Use an In-Memory Database or a Traditional Database
When and Why I Use an In-Memory Database or a Traditional Database

In this article, I’d like to talk about when I use an in-memory database, when I prefer a traditional DBMS, and why.

When I need to decide which DBMS to use — in-memory (let’s call it IMDB) or traditional (I’ll be calling it RDBMS) — I usually make a choice based on the type of storage where my data is going to be kept. I divide all the options into three groups: RAM, solid-state drive or flash memory (SSD), and hard disk drive (HDD). First, I pick a type (or types) of storage to use and then, I start thinking about what database (or databases) I want to have on top of that.

No comments:

Fun With SQL: Functions in Postgres

DZone Database Zone Fun With SQL: Functions in Postgres In our previous  Fun with SQL  post on the  Citus Data  blog, we covered w...