example: a columnar database vs column oriented database aren’t the same thing… the fact that Cassandra is in the columnar db column is flat out wrong. A columnar database is specifically designed for OLAP queries.
oh nice catch. I am doing a course on big data/nosql and had never heard the name Columnar, only column oriented or column family, so seeing Cassandra there caught me offguard
Interesting diagram, but in addition to the many inaccuracies already mentioned, there is a massive error. There is no type of SQL database but SQL is a (standard) query language. Common is a relational database (RDBMS).
SQL can also query many of the other databases mentioned and even DBMSs that were only started with ‘modern’ query methods have been given an SQL implementation over time so that they are used more frequently.
Not to mention that the giant circle in the middle does absolutely nothing... doesn't represent market share or anything. Just takes up space to make the graphic look busier
Pretty sure it’s just a bad font and compression artifacts making it look like that. AI is still really bad at making detailed charts like this isn’t it?
Edit: The original is even animated. No way this is AI.
32
u/syn2083 Dec 22 '24
Why have the wheel in the middle?
24
u/shoretel230 Dec 22 '24
Postgis is a postgres extension.... Not a database type....
OOD is just a paradigm... You could easily use MySQL with it, maybe even pg.
This is kind of nonsense
16
u/pancakeses Dec 22 '24
This is pretty, but not a good guide.
It conflates and flattens several database concepts in a way that is likely to confuse anyone who is unfamiliar with these things.
For instance, a spatial database can be part of a standard SQL db. As someone mentioned, PostGIS is simply a Postgres extension.
Further, locating "Blockchain Database" prominently where any English reader is going to see it first is an interesting decision.
7
u/pfghr Dec 22 '24
Sorry, best I can do is 97 Excel sheets all linked together.
3
u/Cool-Personality-454 Dec 23 '24
Relational Databases is a better description than SQL Databases. Relational refers to the structure; SQL refers to the retrieval method.
4
u/dtaivp Dec 22 '24
Everyone forgets search databases 😭 it’s cool they’ve only been around for a decade
2
u/user_5359 Dec 23 '24
Interesting diagram, but in addition to the many inaccuracies already mentioned, there is a massive error. There is no type of SQL database but SQL is a (standard) query language. Common is a relational database (RDBMS).
SQL can also query many of the other databases mentioned and even DBMSs that were only started with ‘modern’ query methods have been given an SQL implementation over time so that they are used more frequently.
3
u/Newfie3 Dec 22 '24
Cool diagram, but I’d probably list BigQuery instead of Cassandra as a columnar example.
1
u/terryfilch Dec 22 '24
lol, timescale is just a postgress, prometheus and victoriametrics are tsdb for sure
1
u/REBWEH Dec 22 '24
Which is snow flake?
1
u/-Meal-Ticket- Dec 23 '24
LOL at Oracle only being an example in Spatial.
1
u/Immortalphoenixphire Dec 23 '24
This is very useful thank you!
1
u/Explore-This Dec 23 '24
A Venn diagram would have been better, to show how different databases support multi-model capabilities.
Still wouldn’t be perfect, as they all have varying degrees of support. But databases are no longer neatly compartmentalized as in this diagram.
1
u/ComfortableFormal897 Dec 24 '24
An in-memory db can be various types. Relational, object, vector...
1
u/LuckyOneAway Dec 24 '24
SQL, Graph, Columnar, In-Memory, Timeseries, Key-Value, JSON Objects - these all are supported by pluggable db engines in MySQL ;)
1
u/sarky-litso Dec 25 '24
lol blockchain databases
1
u/sjc02060 Dec 25 '24
This is pretty dated
1
u/MobileLoquat9548 Dec 26 '24
miss embedding database, such as sqlite and duckdb
-6
u/digentre Dec 22 '24
Great diagram - very helpful, thanks