Berkeley DB

From Wikipedia, the free encyclopedia

Berkeley DB (BDB) is a high-performance, embedded database library with bindings in C, C++, Java, Perl, Python, Ruby, Tcl, Smalltalk and many other programming languages. BDB stores arbitrary key/data pairs as byte arrays, and supports multiple data items for a single key. DB can support thousands of simultaneous threads of control or concurrent processes manipulating databases as large as 256 terabytes, on a wide variety of systems including most UNIX-like and Windows systems as well as real-time operating systems.

Berkeley DB was first developed at U.C. Berkeley as part of the transition from BSD 4.3 to 4.4 and the effort to remove AT&T encumbered code. The authors of Berkeley DB were asked by Netscape to improve and extend the library, then version 1.85, to suit their requirements for an LDAP server and for use in the Netscape browser. That request led to the creation of Sleepycat Software (acquired by Oracle Corporation in February 2006). Berkeley DB is redistributed under the Sleepycat Public License, an OSI and FSF approved license. The product ships with complete source code, build tools, test suite, and documentation. The code quality and general utility along with the free software/open source license has led to its use in a multitude of free software/open source programs. Those who don't wish to abide by the terms of the Sleepycat Public License have the option of purchasing another proprietary license for redistribution from Oracle Corporation. This technique is called dual licensing.

Berkeley DB includes compatibility interfaces for some historic UNIX database libraries: dbm, ndbm and hsearch.

Contents

[edit] Architecture

Berkeley DB is notable for having a simple architecture compared with other database systems like Microsoft SQL Server and Oracle. For example, it does not provide support for network access — programs access the database using in-process API calls. It does not support SQL or any other query language, nor does it support table schema or table columns. A program accessing the database is free to decide how the data is to be stored in a record; DB puts no constraints on the record's data. The record and its key can both be up to four gigabytes long.

Despite having a simple architecture, Berkeley DB supports many advanced database features such as ACID transactions, fine-grained locking, an XA interface, hot backups and replication.

[edit] Programs that use Berkeley DB

Berkeley DB is the underlying storage system of several LDAP servers, database systems, and many other proprietary and free/open source applications. Below is a list of notable programs that use Berkeley DB for data storage.

[edit] Licensing

Versions 2.0 and higher of Berkeley DB are available under a dual license. Versions earlier than 2.0 are available under a BSD-like license that has an unusual additional clause similar to the GNU GPL version 2's Section 3.

The Sleepycat Public License requires that software that uses the Berkeley DB code be free/open source software (under an approved OSI license) to allow redistribution. Alternately, if the application using the Sleepycat licensed code is not redistributed (see the GPL's definition of 'redistribution') then the Sleepycat license terms are not broken. If an application is using Berkeley DB and redistributing it under a non-free/closed source license then the publisher of is in violation of the Sleepycat Public License and must negotiate a new license allowing those rights from the copyright holder (in this case Oracle).

[edit] External links


Topics in database management systems (DBMS)view  talk  edit )

Concepts
Database • Database model • Relational database • Relational model • Relational algebra • Primary key, Foreign key, Surrogate key, Superkey, Candidate key • Database normalization • Referential integrity • Relational DBMS • Distributed DBMS • ACID

Objects
Trigger • View • Table • Cursor • Log • Transaction • Index • Stored procedure • Partition

Topics in SQL
Select • Insert • Update • Merge • Delete • Join • Union • Create • Drop

Implementations of database management systems

Types of implementations
Relational • Flat file • Deductive • Dimensional • Hierarchical • Object oriented • Temporal • XML data stores

Components
Query language • Query optimizer • Query plan • ODBC • JDBC

Database products

Apache Derby • Berkeley DB • Caché • DB2 • DBase • Filemaker Pro • Firebird • H2 • Helix • Informix • Ingres • InterBase • Microsoft Access • Microsoft SQL Server • MySQL • NonStop SQL • OpenLink Virtuoso • OpenOffice.org Base • Oracle • Oracle Rdb • Paradox • Perst • PostgreSQL • SQLite • Sybase IQ • Sybase • Teradata • Visual FoxPro


Other: Object-oriented (comparison) • relational (comparison)