I'm pretty sure the requirement "needing no installation" is a show-stopper for you. The alternative is to learn to make better use of Access. With careful design, it will surprise you. In the olden days, when lawyers in the US were expected to design, build, and maintain their own litigation support databases, I used to demonstrate design and queries against a 2,000,000 row Access database. Response times were less than 250 msec. I know that sounds awfully slow nowadays, but back then--early 1990s--that was ripping fast.
Not kidding about the lawyers. The canonical reference for litigation support databases at the time was Wilmer, Cutler, and Pickering Manual on Litigation Support Databases. In my experience, most lawyers believe their expertise at the bar transfers to all other fields. Including database design.
It offers a small, fast multithreaded and transactional database engine which offers in-memory and disk-based tables and supports embedded and server modes.
It's also used by JBoss AS as its internal database.
I have reviewed sqlite, derby, hsqldb. They all seem to support all requirements except the shareability through an network drive.
You might need to put a small server on the network, though :)
发布评论
评论（3）
我很确定“无需安装”的要求对您来说是一个阻碍。另一种方法是学习更好地使用 Access。经过精心设计，它会给您带来惊喜。过去，当美国的律师被要求设计、构建和维护自己的诉讼支持数据库时，我曾经针对 2,000,000 行的 Access 数据库演示设计和查询。响应时间小于 250 毫秒。我知道这在今天听起来非常慢，但在当时——20 世纪 90 年代初——那速度很快。
不是拿律师开玩笑。当时的诉讼支持数据库的规范参考是Wilmer，卡特勒和皮克林诉讼支持数据库手册。根据我的经验，大多数律师相信他们在律师行业的专业知识可以转移到所有其他领域。包括数据库设计。
I'm pretty sure the requirement "needing no installation" is a show-stopper for you. The alternative is to learn to make better use of Access. With careful design, it will surprise you. In the olden days, when lawyers in the US were expected to design, build, and maintain their own litigation support databases, I used to demonstrate design and queries against a 2,000,000 row Access database. Response times were less than 250 msec. I know that sounds awfully slow nowadays, but back then--early 1990s--that was ripping fast.
Not kidding about the lawyers. The canonical reference for litigation support databases at the time was Wilmer, Cutler, and Pickering Manual on Litigation Support Databases. In my experience, most lawyers believe their expertise at the bar transfers to all other fields. Including database design.
尝试HSQLDB。
从他们的主页：
JBoss AS 也使用它作为其内部数据库。
不过，您可能需要在网络上放置一台小型服务器:)
Try HSQLDB.
From their homepage:
It's also used by JBoss AS as its internal database.
You might need to put a small server on the network, though :)
我使用 Firebird Embedded 取得了很好的成果，唯一的问题是：无法进行多用户访问。
以下是一些信息： http://www.firebirdsql.org/manual/ufb- cs-embedded.html
I have worked with Firebird Embedded with great results, the only problem: no multi-user access is posible.
Here is some info: http://www.firebirdsql.org/manual/ufb-cs-embedded.html