OrientDB

OrientDB is written in pure Java and weighs around 500Kb of code. It is a professional solution for working with data that needs foremost to be easily accessible before being properly classified.

This means OrientDB follows the key-value pair server model, instead of the classic relative database pattern.

Basically, OrientDB is part of the new class of NoSQL databases that has been storming the development World, covering a niche where speed is more important than order.

OrientDB is what you'd call a graph database, a database with direct connections between records, instead of connections between tables.

The database supports schema-less, schema-full, and schema-mixed modes, also supporting SQL as its query language.

What is new in this release:

• Core: logged database name on server and embedded messages
• SQL: added UNSAFE to CREATE PROPERTY command to avoid slow checks auto conversion from map when working on EMBEDDED types

What is new in version 2.1.6:

• Core: logged database name on server and embedded messages
• SQL: added UNSAFE to CREATE PROPERTY command to avoid slow checks auto conversion from map when working on EMBEDDED types

What is new in version 2.1.2:

• Core: logged database name on server and embedded messages
• SQL: added UNSAFE to CREATE PROPERTY command to avoid slow checks auto conversion from map when working on EMBEDDED types

What is new in version 2.0.9 / 2.1-rc3:

• Core: logged database name on server and embedded messages
• SQL: added UNSAFE to CREATE PROPERTY command to avoid slow checks auto conversion from map when working on EMBEDDED types

What is new in version 2.0.8 / 2.1-rc2:

• Core: logged database name on server and embedded messages
• SQL: added UNSAFE to CREATE PROPERTY command to avoid slow checks auto conversion from map when working on EMBEDDED types

What is new in version 2.0.6:

• Core: logged database name on server and embedded messages
• SQL: added UNSAFE to CREATE PROPERTY command to avoid slow checks auto conversion from map when working on EMBEDDED types

What is new in version 2.0.3:

• Core: logged database name on server and embedded messages
• SQL: added UNSAFE to CREATE PROPERTY command to avoid slow checks auto conversion from map when working on EMBEDDED types

What is new in version 1.7.4:

• Hot fixes.

What is new in version 1.7.1:

• Hot fixes only.

What is new in version 1.7:

• New "script" command to execute multiple SQL statements + transaction control
• New "next" command to move the cursor on the next record in the result set
• New "pref" command to move the cursor on the previous record in the result set
• New "move <predicate>" command to move from current record by executing a predicate
• New "eval <predicate>" command to evaluate a predicate against current record
• Ability to ignore errors by setting "set ignore = true"
• New PARALLEL keyword to run the query on multiple threads
• New "INSERT INTO ... SELECT" to copy records
• New "INSERT INTO ... RETURN <expression>" to return expressions on INSERT
• New "UPDATE ... RETURN <expression>" to return expressions on UPDATE
• Added Full-Text Lucene indexes (as plugin)
• Added GEO Spatial Lucene indexes (as plugin)
• Added WAL (Journal) support for Hash-Index so can be used in Transactions
• Added NULL support for composite and non-composite indexes
• Full-Text can be configured through METADATA keyword
• Full-Text now indexes also sub-words
• Improved SQL optimizer by avoiding calling evaluate() when not needed

What is new in version 1.6.4:

• Integrated Blueprints API in "graphdb" module
• Bug fixing

What is new in version 1.6.2:

• Support for COLLATE to case insensitive compare fields
• Bug fixing

What is new in version 1.6.0:

• Storage: new Paged-Local compressed "plocal" engine (not yet transactional)
• SQL: INSERT and UPDATE supports JSON syntax, improved usage of indexes upon ORDER BY, supported timeout in query and global, new create function command, flatten() now is expand(), new OSQLMethod classes to handle methods even in chain, new encode() and decode() functions, support for new dictionary: as target in SELECT and TRAVERSE
• new SCHEDULER component using CRON syntax
• new OTriggered class to use JS as hook
• MMap: auto flush of pages on regular basis
• Fetch-plan: support for skip field using "-2"
• Index: auto rebuild in background, usage of different data-segment
• Export: supported partial export like schema, few clusters, etc.
• Console: improved formatting of resultsets
• HTTP: new /batch command supporting transaction too, faster connection through /connect command, /document returns a JSON

What is new in version 1.5.0:

• New Hash Index type with better performance on lookups. It does not support ranges
• New "transactional" SQL command to execute commands inside a transaction. This is useful for "create edge" SQL command to avoid the graph get corrupted
• Import now migrates RIDs allowing to import databases in a different one from the original
• "Breadth first" strategy added on traversing (Java and SQL APIs)
• Server can limit maximum live connections (to prevent DOS)
• Fetch plan support in SQL statements and in binary protocol for synchronous commands too
• Distributed configuration
• Bug fixing

What is new in version 1.4.0:

• New SCHEDULER component using CRON syntax.
• New OTriggered class to use JS as hook.
• MMap: auto flush of pages on regular basis.
• Fetch-plan: support for skip field using "-2".
• Index: auto rebuild in background, usage of different data-segment.
• Export: supported partial export like schema, few clusters, etc..
• Console: improved formatting of resultsets.

What is new in version 1.3.0:

• Performance: improved opening time when a connections is reused from pool
• Performance: better management of indexes in ORDER BY
• Schema: new API to handle custom fields
• HTTP/REST: new support for fetch-plan and limit in "command"
• Moved from Google Code to GitHub: https://github.com/nuvolabase/orientdb

What is new in version 0.9.14:

• New Database structure. Logical clusters now are well integrated at storage
• level.
• Improved OrientDB Studio with authentication, user, roles, clusters,
• db and server properties, etc.
• New User and Role management.
• More flexible management of types in ODocument instances.
• Supported HTTP Authentication basic.
• Fixed some bugs in concurrency with high number of clients.

What is new in version 0.9.12:

• Full support was added for asynchronous remote command execution.
• All SQL commands can be executed remotely (select, insert, update, delete).
• A bug regarding the LIKE operator... was fixed.
• JMX monitoring support was improved for OrientDB Server: active sessions, configured handlers and protocols, status, etc.
• The default OrientDB Server port was changed to 2424.
• OrientKV Server has been assigned the port number 2431

What is new in version 0.9.7:

• Fixed problem on 'create database' and 'create cluster' console commands.
• Removed buggy 'create record' command in favor of new SQL 'insert' available in the next days.

Requirements:

• Java SDK 5.0 or higher
• Apache Ant 1.6.5 or higher