所有新/流行数据库及其用途的完整列表?
最近,我发现我的雷达周围出现了许多新的数据库,我想列出它们的用途以及它们的优点/缺点。 我将在列表中添加一些名字,也许有更多知识的人可以提供有关每个名字以及它们如何叠加的一些信息。 我希望这将很快成为所有可用数据库的综合列表,以便开发人员可以利用正确的数据库来完成手头的工作!
关系数据库:
已建立:
- DB2
- MySQL
- Oracle
- PostgreSQL
- SQLite
- SQL Server
- Sybase
- OpenEdge SQL
新增功能:
键值存储:
面向文档的存储:
图形数据库:
- Neo4j
- AWS Neptune
- Sesame
- AllegroGraph
- 不同的 RDF/triplestores
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
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(6)
我怀疑我是否会在关键任务系统中使用它,但是 Derby 一直非常有趣大部头书。
I doubt I'd use it in a mission-critical system, but Derby has always been very interesting to me.
CassandraDB、伏地魔计划、东京内阁怎么样?
What about CassandraDB, Project Voldemort, TokyoCabinet?
有图形数据库,例如:
图数据库将数据存储为节点和关系/边。这非常适合半结构化数据,具有深层关系/遍历的互连信息和领域,例如社交网络和知识表示。 该数据模型高度灵活,“白板友好”。 语义网的底层数据模型,RDF,也是一个(标记的、有向的多)图。
其他包含图形数据库信息的 stackoverflow 线程:
数据库
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:
databases
Martin Fowler 去年发表了一篇有趣的博客文章,内容涉及非关系数据库开始受到关注。 他提到:
还有Google的BigTable 被描述为“一个稀疏的、分布式的多维排序映射”。
我已经使用 GemStone 多年了,生产力的提高是惊人的 - 让数据库直接存储您的对象,无需在表和对象之间不断地来回编组。
Martin Fowler did an interesting blog post last year about non-relational databases starting to gain traction. He mentions:
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.
要在“已建立”和“键值存储”下归档: Berkeley数据库。
具有事务和复制。 通常作为一个库链接(没有独立服务器,尽管您可以编写一个)。 值和键只是二进制字符串,您可以为它们提供自定义排序函数(如果适用)。
并不能防止搬起石头砸自己的脚。 关闭锁定/事务支持,同时从两个线程访问数据库,最终会得到损坏的文件。
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.
SQLite 数据库引擎
拥有最流行语言的库
The SQLite database engine
With library for most popular languages