database 所有新/流行数据库及其用途的完整列表？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/1270321/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
A full list of all the new/popular databases and their uses?
提问by FurtiveFelon
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:
已确立的：
- DB2
- MySQL
- Oracle
- PostgreSQL
- SQLite
- SQL Server
- Sybase
- OpenEdge SQL
New:
新的：
Key-value stores:
键值存储：
Document oriented Stores:
面向文档的商店：
Graph DataBases:
图数据库：
- Neo4j
- AWS Neptune
- Sesame
- AllegroGraph
- different RDF/triplestores
- Neo4j
- 海王星
- 芝麻
- 快板图
- 不同的 RDF/triplestores
回答by Nifle
The SQLitedatabase engine
在SQLite的数据库引擎
- 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
带有大多数流行语言的库
回答by Rafa? Dowgird
To file under both 'established' and 'key-value store': Berkeley DB.
在“已建立”和“键值存储”下归档：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.
不能防止用脚射击自己。关闭锁定/事务支持，同时从两个线程访问数据库，最终得到一个损坏的文件。
回答by Dawie Strauss
Martin Fowler did an interesting blog postlast year about non-relational databases starting to gain traction. He mentions:
Martin Fowler去年发表了一篇关于非关系型数据库开始受到关注的有趣博客文章。他提到：
- Drizzle (a "bare bones" relational database)
- CouchDB(a document-oriented database)
- GemStone(an object-oriented database)
There is also Google's BigTablewhich is described as "a sparse, distributed multi-dimensional sorted map".
还有谷歌的BigTable，它被描述为“一个稀疏的、分布式的多维排序地图”。
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.
我已经与 GemStone 一起工作了很多年，生产力的提高是惊人的——让数据库直接存储你的对象消除了在表和对象之间不断来回编组的需要。
回答by nawroth
There are graph databaseslike:
有图形数据库，例如：
- Neo4j
- Sesame
- AllegroGraph
- different RDF/triplestores
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.
图数据库将数据存储为节点和关系/边。这非常适合半结构化数据、互连信息和具有深层关系/遍历的域，例如社交网络和知识表示。数据模型高度灵活且“白板友好”。所述的基础数据模型的语义网络，RDF，也是一个（标记，针对多）曲线图。
Other stackoverflow threads with information on graph databases:
其他包含图形数据库信息的 stackoverflow 线程：
- The Next-gen Databases
- Non-Relational Database Design(listing some +/-)
- Have anyone used Graph based databases
- 下一代数据库
- 非关系型数据库设计（列出一些 +/-）
- 有没有人使用过基于图形的数据库
回答by AlexCuse
回答by Julien Genestoux
What about CassandraDB, Project Voldemort, TokyoCabinet?
CassandraDB、Voldemort 项目、TokyoCabinet 怎么样？
