Oracle overhauls Sleepycat's original Berkeley DB

By Mark Brunelli, News Editor 27 Sep 2006 | SearchOracle.com

News on data management trends and technology Digg This!     StumbleUpon     Del.icio.us

Oracle says that Berkeley DB 4.5, the newest version of the original DBMS offered by Sleepycat in the early '90s, has been enhanced to provide developers improved performance through multi-version concurrency control (MVCC), the ability to do upgrades on the fly, and better ease of use through prefabricated replication templates.

But while Oracle has made several moves in the open source market over the past year, and before that played a major role in driving the adoption of the open source Linux operating system, at least one analyst says that the company is not a major open source contributor in the traditional sense.

Features and functionality

Rex Wang, Oracle's vice president of embedded systems marketing, explained that MVCC in a nutshell improves the performance of highly concurrent systems -- systems with multiple readers and writers -- by giving each of the readers its own snapshot of the database.

"Instead of a writer grabbing a portion of the database and somehow blocking it or locking it, what we do is we allow readers to access their own snapshot," Wang said. "There is no blocking that happens and there is greater concurrency that can be achieved."

For more on Oracle and databases See where Oracle landed in the 2006 Gartner Magic Quadrant for data warehouse and DBMS systems Get a guide to suggested database roles and responsibilities

Wang said that the Berkeley DB's newly enhanced "replication framework" speeds up the development process by providing a pre-built set of functions for building replicated systems.

Berkeley DB's newly enhanced "non-stop upgrades" feature lets a Berkeley DB system be upgraded without downtime.

"This is for telecommunications and network providers or any kind of on-demand or software-as-a-service kind of business that has an application that can never go down," Wang said.

Oracle and industry experts point out that Berkely DB is designed to be a lightweight, embeddable database that doesn't require much tweaking by database administrators once installed.

Wang said that Berkeley DB is ideal for situations where database access patterns are predictable and a developer can write a program to access data as opposed to making use of an expressive query language like SQL.

"It's a very fast and lightweight product, but in some applications lightweight is preferred," Wang said.

Anne Thomas Manes, a research director with the Midvale, Utah-based Burton Group, added that Berkeley DB is "kind of a low end" database without all of the capabilities you'd expect from more fully-featured offerings, such as multi-step transaction support.

"It's really an advanced file system kind of thing," Manes said.

Wang said that pricing for the commercial Berkeley DB license starts at about $750 per processor. Continuing a model pioneered by Sleepycat, Berkeley DB is also available under a free open source license that comes with usage restrictions.

Berkeley DB 4.5 is the second Sleepycat product to be updated since Oracle purchased Sleepycat. Oracle unveiled a new version of Berkely DB Java Edition back in May. Oracle says it won't be long before Sleepycat's third and final product, Berkeley DB XML, gets a makeover as well.

Gauging Oracle's open source 'street cred'

Manes said that although Oracle's decision to support open source Linux went a long way towards driving the adoption of that platform in recent years, Oracle has not been a major contributor to the open source movement as a whole -- at least not in the traditional sense which involves contributing new code or open source applications.

"They don't do an awful lot of open source stuff," Manes said of Oracle. "What they have done… is that they beefed up Linux because they use Linux as a platform."

The analyst went on to say that Oracle's decision to acquire Innobase, the Finnish open source company that provided a key component of Oracle-rival MySQL's database technology, could be construed as downright hostile by the open source world.

"I view Oracle as a user of open source as opposed to a provider of open source," Manes said. p>This article originally appeared on SearchOracle.com.

Do you think Oracle has been a positive contributor to the open source movement? Why or why not? Email your comments to SearchOracle.com news editor Mark Brunelli and he'll likely contact you for a follow-up story.>

Sound Off! -   Be the first to post a message to Sound Off!

Tags: Database management systems (DBMS),  VIEW ALL TAGS

Digg This!     StumbleUpon     Del.icio.us