Categories
Data Science Software Architecture

How do you decide which type of database to use?

There are hundreds or even thousands of databases available today, such as Oracle, MySQL, MariaDB, SQLite, PostgreSQL, Redis, ClickHouse, MongoDB, S3, Ceph, etc. How do you select the architecture for your system? My short summary is as follows:

πŸ”ΉRelational database. Almost anything could be solved by them.
πŸ”ΉIn-memory store. Their speed and limited data size make them ideal for fast operations.
πŸ”ΉTime-series database. Store and manage time-stamped data.
πŸ”ΉGraph database. It is suitable for complex relationships between unstructured objects.
πŸ”ΉDocument store. They are good for large immutable data.
πŸ”ΉWide column store. They are usually used for big data, analytics, reporting, etc., which needs denormalized data.

Leave a Reply Cancel reply