Database Server

SQLite

SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine. Features include:

- Transactions are atomic, consistent, isolated, and durable (ACID) even after system crashes and power failures.
- Zero-configuration - no setup or administration needed.
- Implements most of SQL92. (Features not supported)
- A complete database is stored in a single disk file.
- Database files can be freely shared between machines with different byte orders.
- Supports databases up to 2 terabytes (241 bytes) in size.
- Sizes of strings and BLOBs limited only by available memory.
- Small code footprint: less than 250KiB fully configured or less than 150KiB with optional features omitted.
- Faster than popular client/server database engines for most common operations.
- Simple, easy to use API.
- TCL bindings included. Bindings for many other languages available separately.
- Well-commented source code with over 95% test coverage.
- Self-contained: no external dependencies.
- Sources are in the public domain. Use for any purpose.

The SQLite distribution comes with a standalone command-line access program (sqlite) that can be used to administer an SQLite database and which serves as an example of how to use the SQLite library.

MySQL 5.x Community Edition

MySQL 5.0 Community Edition is a freely downloadable version of the world's most popular open source database. It is supported by a huge and active community of open source developers and enthusiasts. The MySQL Community Edition is:

PostgreSQL

PostgreSQL is a powerful, open source relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL92 and SQL99 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation.

An enterprise class database, PostgreSQL boasts sophisticated features such as Multi-Version Concurrency Control (MVCC), point in time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online/hot backups, a sophisticated query planner/optimizer, and write ahead logging for fault tolerance. It supports international character sets, multibyte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting. It is highly scalable both in the sheer quantity of data it can manage and and in the number of concurrent users it can accommodate. There are active PostgreSQL systems in production environments that manage in excess of 4 terabytes of data. Some general PostgreSQL limits are included in the table below.

VoltDB

Created by DBMS R&D pioneer, Mike Stonebraker, VoltDB is a next-generation open-source DBMS that scales way beyond traditional databases, without sacrificing SQL or ACID for transactional data integrity. VoltDB is for database applications that support fast-growing transactional workloads and require:

Orders of magnitude better performance than conventional DBMS
Linear scalability
SQL as the DBMS interface
ACID transactions to ensure data consistency and integrity
High availability 24x7x365

Oracle 10g

Oracle 11g

db4o

db4o is the open source object database that enables Java and .NET developers to store and retrieve any application object with only one line of code, eliminating the need to predefine or maintain a separate, rigid data model.

Xindice

Apache Xindice is a database designed from the ground up to store XML data or what is more commonly referred to as a native XML database. The name is pronounced zeen-dee-chay in your best faux Italian accent. Don't worry if you get it wrong though, we won't mind. We just care that you spell it correctly.

You might be wondering what a native XML database is good for? Well it pretty much has one purpose, storing XML data. If you don't have any XML data, don't want any XML data or think XML is the most over-hyped technology of the new millennium, then Xindice is not for you. We're not out to change the way data in general is stored, only to provide a good solution for storing XML data. If you survey your projects and see XML popping out of every corner, then Xindice might be a real help for storing that XML.

The benefit of a native solution is that you don't have to worry about mapping your XML to some other data structure. You just insert the data as XML and retrieve it as XML. You also gain a lot of flexibility through the semi-structured nature of XML and the schema independent model used by Xindice. This is especially valuable when you have very complex XML structures that would be difficult or impossible to map to a more structured database.

At the present time Xindice uses XPath for its query language and XML:DB XUpdate for its update language. We provide an implementation of the XML:DB API for Java development and it is possible to access Xindice from other languages using an available XML-RPC plugin. As standards in the XML database area mature Xindice will include support for those that are most important.

Xindice is the continuation of the project that used to be called the dbXML Core. The dbXML source code was donated to the Apache Software Foundation in December of 2001.

eXist

eXist is an Open Source native XML database featuring efficient, index-based XQuery processing, automatic indexing, extensions for full-text search, XUpdate support and tight integration with existing XML development tools. The database implements the current XQuery 1.0 working draft as of November, 2003, with the exception of the XML schema related features.

The new XQuery support in eXist makes it possible to write entire web applications with just XQuery and XSLT. XQuery files can be directly passed to the database, using either the XQueryServlet, the XQueryGenerator for Cocoon or the REST-style API (see Developer's Guide).

Implemented features include: user-defined functions and modules, static type checking, type casts, constructors, order by, ...

Additional features: Java binding, fultext-search functions, extension modules for HTTP support, database manipulation and XSL transformations.

To avoid memory-intensive document tree traversals during query processing, eXist uses an efficient index structure which is based on a numerical indexing scheme for identifying XML nodes in the index. The database is lightweight, completely written in Java and may be easily deployed in a number of ways, running either as a stand-alone server process, inside a servlet-engine or directly embedded into an application.

MaxDB (formaly SAP DB)

MaxDB by MySQL is a re-branded and enhanced version of SAP DB, SAP AG's open source database. MaxDB is a heavy-duty, SAP-certified open source database that offers high availability, scalability and a comprehensive feature set. MaxDB complements the MySQL database server, targetted for large mySAP ERP environments and other applications that require maximum enterprise-level database functionality.

Today, about 5,000 customer installations are using MaxDB technology globally, including Intel, DaimlerChrysler, Braun, Bayer, Colgate, Yamaha, Deutsche Post (the German Post Office) and Toyota South Africa.

MaxDB is available under the MySQL AB "dual licensing" model. Under this model, users may choose to use MySQL products under the free software/opensource GNU General Public License (commonly known as the "GPL") or under a commercial license.

EnterpriseDB

EnterpriseDB is an enterprise-class relational database management system (RDBMS) that is built on PostgreSQL, the world's most advanced open source database. EnterpriseDB is compatible with Oracle applications, reliable and scalable for high-volume, mission-critical enterprise use, and affordable.

EnterpriseDB Advanced Server is a complete product suite that includes the following components:

* Database Server - The RDBMS engine
* Replication Server - Asynchronous master-slave replication
* DBA Management Server - Monitoring, performance profiling, and reporting
* Developer Studio - Graphical console for developers and DBAs
* Procedural Language Debugger - Interactive debugger for stored procedures
* Client Connectors - Access from various programming environments
* Oracle Migration Toolkit - Transfer schemas, logic, and data to EnterpriseDB
* Reporting Tools - JasperReports engine and graphical report designer

Berkeley DB XML

Berkeley DB XML is an embedded XML database with XQuery-based access to documents stored in containers and indexed based on their content. Berkeley DB XML is built on top of Berkeley DB and inherits its rich features and attributes. Like Berkeley DB, Berkeley DB XML is a library, not a server, exposes a programmatic API for developers, and runs in process with the application with no need for human administration.

Thanks to Berkeley DB as the underlying storage engine, Berkeley DB XML inherits full ACID transactions, automatic recovery, hot standby, XA for distributed transactions, on-disk data encryption with AES, and replication for high availability. In addition, both XML and non-XML data can be stored in Berkeley DB XML, which may be an advantage for some applications. No other XML database in the market is based on such proven, field-tested technology.

Berkeley DB XML adds a document parser, XML indexer and XQuery engine on top of Berkeley DB. XQuery is quickly becoming the query language of choice for XML data access. Berkeley DB XML supports XQuery 1.0 and XPath 2.0, XML Namespaces, schema validation, naming and cross-container operations and document streaming. The XQuery engine uses a sophisticated cost-based query optimizer and supports pre-compiled query execution with embedded variables. Large documents can be stored intact or broken up into nodes, enabling more efficient retrieval and partial document updates. Berkeley DB XML supports flexible indexing of XML nodes, elements, attributes and meta-data to enable the fastest, most efficient retrieval of data.

Berkeley DB XML provides fast, reliable and scalable persistence for applications that need to store and retrieve both XML and non-XML data.

Berkeley Database

Berkeley DB is a database engine that provides developers with fast, reliable, local persistence with zero administration. Berkeley DB is a library that links directly into your application. Your application makes simple function calls, rather than sending messages to a remote server, eliminating the performance penalty of client-server architectures. Berkeley DB stores data in application native format, as simple key/value pairs, eliminating the need for translation or mapping. Berkeley DB eliminates the overhead of SQL query processing, enabling applications with predictable access patterns to run faster.

Database Server

Jobs in Open Source