嵌入在代码中的良好内存数据库。 [英] A good In-Memory Database that is embedded in your code.

问题描述

Heya家伙CoProjs，



我们需要一个很好的内存数据库解决方案（不是混合解决方案，纯粹的内存解决方案）。

我们在几周的艰苦努力下运行一个服务器场，我们连续使用100％的CPU！

我们现在正在考虑提高性能移动Worker应用程序以严格执行内存直到完成（每次使用不同的params执行的定期任务）。



最后我们想把数据库保存为文件，然后将它迁移到另一个基于文件的数据库，如SQL Server或Oracle。 />


我听说过 TimesTen ， eXtremeDB ，SAP Hana ，那里是关于 MS 在下一批SQL Server中取消内存数据库的传言!!



但是，我不是经历了以上所有这些，如果你能有一分钟的话我想要推荐，



主要要求是：



- 最佳性能（每秒超过10万次交易）

- 跨平台，即Linux和Windows（不一定非常非常好）
- 不是一个设备

- 最好可能嵌入代码中，比如在你的项目中使用DLL和编译数据库（我知道eXtremeDB和Raima也是这样工作的，也许是其他人） br />
- 使用群集的能力（优势）

- 能够节省t他在程序结束时提交了





所以问题是，我猜，选择什么，何时以及为什么？ ：）



干杯，

Edo

Heya fellow CoProjs,

We need a good solution for an in-memory DB (not a hybrid solution, a pure in-memory one).
We run a server farm on strenuous efforts of several weeks at a time, in which we use 100% CPU on all continuously!
We are now looking into performance improve by moving the Worker application to perform strictly in-memory till it is finished (a periodical task performed each time with different params).

At the end we want to take the DB and save it as a file and\or migrate it to another File based DB like SQL Server or Oracle.

I''ve heard of TimesTen, eXtremeDB, SAP Hana, and there are rumors about MS to unvail an in-memory DB in the next shipment of SQL Server!!

However, I''m not experienced with all the above too much, and I''d like recomendations if you can spare a minute,

Major requirements are:

- Top performance (over 100K transactions per second)
- Cross Platform, i.e. both Linux and Windows (not a must be very very nice-to-have
- Not an Appliance
- Preferably possible embed in the code, like using DLLs and compiling the DB in your project (I know eXtremeDB and Raima work this way, perhaps others too)
- Ability to work with clustering (advantage)
- Ability to save the file at the end of the process


So the question is, I guess, what to pick, when and why? :)

Cheers,
Edo

推荐答案

请尝试以下站点： http://nosql-database.org/ [ ^ ]

Try the following site : http://nosql-database.org/[^]

解决了！



在对市场上8种顶级解决方案进行基准测试后，

我们已经提出了Oracle的TimesTen和McObject的eXtreneDB以适应这项工作，只是为了给人留下印象事情：每秒回答超过300,000次插入！



价格围绕

Solved!

After benchmarking around 8 of the top solutions in the market,
We''ve come up with Oracle''s TimesTen, and McObject''s eXtreneDB as suiting for the job, just to get the impression of things: both answer for over 300,000 inserts per second!

Prices are around

100K -

这篇关于嵌入在代码中的良好内存数据库。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！