是否有一个良好的内存数据库将像DB2一样运行 [英] Is there a good in-memory database that would act like DB2

问题描述

我目前正在使用DB2进行单元测试，但有时候相当慢。我需要一个好的内存数据库，其中包括DB2的所有功能。这种类型的内存数据库是否存在，还是只允许标准SQL功能？

I am currently using DB2 to do unit tests, but it is sometime quite slow. I would need a good in-memory database that would include all the feature of DB2. Does this type of in-memory database exist, or do they only allow standard SQL feature?

谢谢。

编辑
DB2数据库位于远程服务器上，因此我需要一个解决方案来在本地内存数据库中复制该数据库的架构，以加速测试。 / p>

EDIT The DB2 Database is on a remote server, so I would need a solution to replicate the schema of that database on a local in-memory database to speed up the tests.

推荐答案

我需要一个良好的内存数据库，包括DB2的所有功能。 / p>

I would need a good in-memory database that would include all the feature of DB2.

Derby（来自Cloudscape）是DB2的语言兼容。它有一个内存模式。

Derby (ex Cloudscape) is DB2's language compatible. And it has an in memory mode.

也可以看看H2（使用DB2 兼容模式）。但即使H2会更快，我会考虑你的情况下的德比。

Maybe also have a look at H2 (with the DB2 compatibility mode). But even if H2 would be faster, I would consider Derby in your case.

这篇关于是否有一个良好的内存数据库将像DB2一样运行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！