A full list of all the new/popular databases and their uses? [closed]

F

6

19

Recently I have found that there are many new databases popping up all around my radar, and I would like to make a list of what they do and perhaps what their advantages/disadvantages are. I'll seed the list with some names and perhaps someone with more knowledge can chip in with some information about each and how they stack up. I hope this will fast become a comprehensive list of all the available database so that developers can leverage the right one for the job at hand!

Relational Databases:

Established:

New:

RethinkDB

Key-value stores:

Document oriented Stores:

couchDB
mongoDB
List item

Graph DataBases:

Neo4j
AWS Neptune
Sesame
AllegroGraph
different RDF/triplestores

Figurate answered 13/8, 2009 at 6:18 Comment(6)

Can't forget Oracle, or SQLite. – Amperehour 13/8, 2009 at 6:22

Such a list here would replicate a lot of other similar lists on the net, e.g. en.wikipedia.org/wiki/… – Lanner 13/8, 2009 at 7:6

@Martin: Indeed.... this seems a bit daft – Petuntse 13/8, 2009 at 7:41

you forgot SQL Server in your established list – Mirella 13/8, 2009 at 15:13

I think you need two more categories: Bigtable-like systems (HBase, Hypertable ...) and Graph Databases (see my answer below regarding graphdb). – Erasmo 13/8, 2009 at 20:22

A big list sorted by popularity can be found here: db-engines.com/en/ranking – Higgledypiggledy 13/1, 2014 at 20:14

A

4

The SQLite database engine

self-contained
serverless
zero-configuration
transactional
cross platform Unix (Linux and Mac OS X), OS/2, and Windows (Win32 and WinCE) are supported out of the box. Easy to port to other systems.
faster than heck

With library for most popular languages

.Net
perl
Feel free to edit this and add more links

Adjutant answered 13/8, 2009 at 6:18 Comment(2)

Don't forget "cross platform" & "faster than heck" – Punke 13/8, 2009 at 7:10

This is a wiki, you can edit this answer yourself if you want to add anything else. – Adjutant 13/8, 2009 at 7:32

E

1

There are graph databases like:

A graph database stores data as nodes and relationships/edges.This is a good fit for semi-structured data, interconnected information and domains with deep relationships/traversal, for example social networks and knowledge representation. The data model is highly flexible and "whiteboard friendly". The underlying data model of the semantic web, RDF, is also a (labeled, directed multi-)graph.

Other stackoverflow threads with information on graph databases:

The Next-gen Databases
Non-Relational Database Design (listing some +/-)
Have anyone used Graph based databases

Erasmo answered 13/8, 2009 at 6:18 Comment(0)

H

1

Martin Fowler did an interesting blog post last year about non-relational databases starting to gain traction. He mentions:

Drizzle (a "bare bones" relational database)
CouchDB (a document-oriented database)
GemStone (an object-oriented database)

There is also Google's BigTable which is described as "a sparse, distributed multi-dimensional sorted map".

I have been working with GemStone for a number of years now and the productivity gains is amazing - having the database store your objects directly removes the need to constantly marshall back and forth between tables and objects.

Hypothetical answered 13/8, 2009 at 6:18 Comment(0)

A

1

To file under both 'established' and 'key-value store': Berkeley DB.

Has transactions and replication. Usually linked as a lib (no standalone server, although you may write one). Values and keys are just binary strings, you can provide a custom sorting function for them (where applicable).

Does not prevent from shooting yourself in the foot. Switch off locking/transaction support, access the db from two threads at once, end up with a corrupt file.

Anciently answered 13/8, 2009 at 6:18 Comment(0)

L

0

I doubt I'd use it in a mission-critical system, but Derby has always been very interesting to me.