有没有一个像 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 数据库位于远程服务器上，因此我需要一种解决方案来将该数据库的模式复制到本地内存数据库中以加快测试速度.

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 的所有特性.

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 会更快，我也会在你的情况下考虑 Derby.

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屋！