Oracle Berkeley DB 中国研发团队的博客

Oracle Berkeley DB 11g release 2即将发布，更多的用户可能会关心其SQL接口的一些具体衡量指标，包括性能、并发性、可扩展性以及客户反馈（包括开源社区和合作伙伴等）。下面是我目前收集到的信息，希望能对大家有用。

内部测试数据（总的指标，包括Berkeley DB以及SQL）：

• 性能：
  • 约以万计(10s of thousands)的Insert/Update/Delete每秒；
  • 约以十万计(100s of thousands)的Select每秒；
  • 约比native SQLite快3倍；
  • 有些极端测试比SQLite慢，但在一个数量级别。
• 并发性
  • 细粒度的锁（Page level locking），保证了更好的并行读/写；
  • TPC-B测试显示，多线程的情形下（比单线程）快6-8倍；
  • 支持数据库运行中的进行数据压缩（database online compact）。
• 可扩展性
  • 单个数据库支持TB级别的数据量；
  • 支持多节点集群。
• 数据同步
  • 可以通过Oracle Mobile Server 10.3向企业端的大型Oracle数据库进行同步；
  • Xcsdasd 的同步客户端。
• SQL功能集
  • SQLite3 API, SQL92标准；
  • ODBC，JDBC标准；
  • 支持Full-Text Search 和R*Tree （Spatial，空间数据库）。
• 运行平台
  • Windows Mobile, 2000, XP, 7
    
  • Andriod
  • VxWorks
  • Linux, Solaris, HP/UX and virtually any *nix variant
    

注意：由于测试不具有代表性和平台环境等差异，这些指标仅供大家参考。

合作伙伴及用户反馈：

• Mike Owens, “The Definitive Guide to SQLite”一书的作者：

Oracle Berkeley DB's new SQLite compatibly offers powerful features for its users and the SQLite community at large. The combination of the two technologies provides developers with tremendous flexibility in a single SQL/API.  Oracle has done a fantastic job of integrating the technologies, and also being an exemplary participant in the open source community by contributing time, expertise and resources to the SQLite project.

• Dr. Richard Hipp, SQLite 数据库的作者及架构师：

Oracle Berkeley DB 11g combines seamlessly the benefits of SQLite’s ubiquitous API with Berkeley DB’s concurrency and performance into an easy-to-use product. SQLite users can now benefit from enhanced concurrency and performance, and Oracle Berkeley DB users can now benefit from an easy-to-use SQL API.

• Liam McLoughlin, Google Chromium OS的开发者：

In my experience Berkley DB 11gR2 is a fully drop-in replacement for SQLite3. I was hugely surprised at just how easy it was; I'd had zero experience in using Berkeley DB in products before, but within a couple hours I had my application powered by Berkeley DB. From there you get all the benefits of Berkeley DB including concurrency and long term stability compared to SQLite3 from an API you're already familiar with. It's quite simply amazing.

• Marie-Anne Neimat, Oracle 数据库产品研发的VP（仿谷歌对VP的解释为：数据库研发全球副总裁）

Mobile applications and mobile infrastructure applications need fast, scalable and reliable storage services - yet must be self-managing and operate without administrators.  With new SQL capabilities and Android support, Oracle Berkeley DB 11g  makes it easier for developers to quickly develop and deploy new ‘edge’ applications that meet users high performance and scalability demands.

• Marco Bambini, SQLabs的CEO

Berkeley DB 11gR2 combines the familiar SQLite API with the powerful, proven Berkeley DB data storage technology. I re-compiled my SQLiteManager product against the Berkeley DB library without any major issues in very little time. I have now a product that is fully able to manage BDB databases without changing a single line of my code. Performance and concurrency are excellent and I am thrilled to think about the future of this great product.

最后，关于Oracle Berkeley DB 11g release 2的更多垂询，欢迎留言或者给我发邮件：chao.huang[at]oracle.com。请至官方网址：http://www.oracle.com/database/berkeley-db/index.html 下载Oracle Berkeley DB 11g release 2。