BlackRay is an open source main memory

Main Memory database

An in-memory database is a database management system that primarily relies on main memory for computer data storage. It is contrasted with database management systems which employ a disk storage mechanism...

 high-performance relational database management system

Relational database management system

A relational database management system is a database management system that is based on the relational model as introduced by E. F. Codd. Most popular databases currently in use are based on the relational database model....

 developed by SoftMethod GmbH. It is designed to provide high performance for SQL

SQL

SQL is a programming language designed for managing data in relational database management systems ....

 queries and also supports a proprietary API. It performs significantly faster than other open source DBMS. In its current development stage it is optimized to serve as a query accelerator, where low latency is required for searches containing wildcards and fulltext (token) search features. Updates are supported only as bulk updates. While all data is kept in RAM at all times for query operations, snapshots

Snapshot (computer storage)

In computer systems, a snapshot is the state of a system at a particular point in time. The term was coined as an analogy to that in photography. It can refer to an actual copy of the state of a system or to a capability provided by certain systems....

 on disk allow persistence

Persistence (computer science)

Persistence in computer science refers to the characteristic of state that outlives the process that created it. Without this capability, state would only exist in RAM, and would be lost when this RAM loses power, such as a computer shutdown....

 of the data.

Main Features

• Client/server mode access for applications residing in remote hosts.
• Atomicity - All the operations of a transaction performed take effect on the database or none of them will effect
• Consistency - BlackRay remains be in legal state when the transaction begins and when it ends
• Isolation - read and write transactions do not interfere, "dirty reads" in a Cluster are possible.
• Durability
  Durability (computer science)
  In database systems, durability is the ACID property which guarantees that transactions that have committed will survive permanently.For example, if a flight booking reports that a seat has successfully been booked, then the seat will remain booked even if the system crashes.Durability can be...
  
   - All data modifications permanently survive engine crashes and shutdowns, via Redo Log and Snapshots
• Clustering supported
• Data Types: int, bigint, varchar
• Fulltext search capability
• Multi-Layer Index
• Support for multiple users and authentication mechanism to access database
• Support for SQL
  SQL
  SQL is a programming language designed for managing data in relational database management systems ....
  
   (subset of SQL92)
• Support for ODBC, JDBC and languages supported by PostgreSQL
  PostgreSQL
  PostgreSQL, often simply Postgres, is an object-relational database management system available for many platforms including Linux, FreeBSD, Solaris, MS Windows and Mac OS X. It is released under the PostgreSQL License, which is an MIT-style license, and is thus free and open source software...
  
   via the PostgreSQL
  PostgreSQL
  PostgreSQL, often simply Postgres, is an object-relational database management system available for many platforms including Linux, FreeBSD, Solaris, MS Windows and Mac OS X. It is released under the PostgreSQL License, which is an MIT-style license, and is thus free and open source software...
  
   drivers, as Blackray implements the same socket protocol
• Wildcards
  Wildcard character
  -Telecommunication:In telecommunications, a wildcard character is a character that may be substituted for any of a defined subset of all possible characters....
  
   supported in any combination
• Engine available under the GNU General Public Licence (GPLv2), Drivers licensed under BSD License (Postgres)
  BSD licenses
  BSD licenses are a family of permissive free software licenses. The original license was used for the Berkeley Software Distribution , a Unix-like operating system after which it is named....