OrientDB is an open DBMS that combines the capabilities of a document- oriented and graph- oriented database. An object- oriented database interface that runs on top of a document-oriented layer is also supported. [one]
| OrientDB | |
|---|---|
 | |
| Type of | , , , and |
| Developer | Orient Technologies LTD |
| Written on | Java |
| operating system | Linux , FreeBSD , OpenBSD , Windows , Mac |
| First edition | 2010-04-02 |
| Hardware platform | |
| Latest version | 3.0.3 ( 2018-07-02 ) |
| Test version | 3.1 |
| condition | Active |
| License | Apache v2 |
| Site | orientdb.com |
OrientDB code is written in Java and distributed under the Apache license .
This database is based on documents, but relationships are managed as in graph databases with direct connection between records. It supports the schemes: less (semi-structured data), full (strictly specifies the required fields) and mixed (mixed: mandatory + optional fields). It has a powerful security profiling system based on users and roles. Supports SQL as a query language (newSQL, as the developers call it). OrientDB uses a new indexing algorithm called RB + Tree, which combines the features of Red-Black Tree and B + -Tree , which makes it possible to take advantage of these two algorithms by balancing the operations of adding and updating data.
You can insert documents, like any other database based on documents, but also supports relationships. It does not use expensive JOIN. Instead, OrientDB uses super-fast, persistent pointers between records, taken from the world of graph databases. You can go through part or whole trees and columns of records within a few milliseconds.
Content
History
The main author, Luca Garulli, in 2010 began to rewrite the Java Orient database layer, written in C ++, into Java. Since 2012, the project has been sponsored by Orient Technologies LTD, where the main author is the CEO and founder.
Luca Garulli began working with storage algorithms in 1998 and created the first ready-made version of OrientDB in early 2010 after 17 years of experience working with other DBMSs. He created the new MVRB-Tree algorithm (the original name is RB + Tree, but another algorithm with the same name already existed) as a mixture of two Red-Black Tree and B + Tree algorithms. MVRB stands for Multi Value Red Black, because it stores several values in each node of the tree, instead of one. Luca is a member of Sun Microsystems JDO 1.0 and 2.0 Expert Groups, which wrote the JDO standard. He also published a number of technology articles in Technet, Computer Programming, IoProgrammer, and Week.it. [2]
Orient Technologies is a privately owned company that is officially developing the open source project OrientDB. Today, Orient Technologies has more than 60 customers from all over the world. [3]
Features
- Full support for ACID transactions (Atomicity - atomicity, Consistency - consistency, Isolation - isolation, Durability - reliability);
- Support for a subset of the SQL language to execute queries using the SELECT clause (OrientDB is not a relational database, so SQL does not fully support all the features);
- Stored Procedure Support in SQL and JavaScript ;
- Support for data storage without a description of the preliminary scheme, with a description of the full structure or in mixed mode;
- 100% compatible with TinkerPop Blueprints for graph-oriented databases;
- Gremlin query language support;
- Supports HTTP , REST and JSON protocols without the use of third-party components;
- The ability to work in the mode of embedding in other applications, and as a dedicated server;
- The ability to roll back local changes made to the document (ODocument.undo);
- It has a very small size and has no third-party dependencies;
- A strict access control policy is maintained based on user roles and permissions;
- The distribution is completely self-contained;
- The distribution contains Web-Studio (a tool for development and administration);
- Supports fault-tolerant configurations and replication (OrientDB architecture is originally designed for multimaster replication);
- Support for running server-side scripts (Server Side Scripting);
- Commercial support is available.
OrientDB Web Studio
Web Studio is a web interface (on its own web server, TCP / 2480 port) for the developer and system administrator. Web-Studio is present in the OrientDB distribution and contains tools for:
- Management of access rights and databases;
- View and modify data structures (Classes and Edges) and Data itself;
- View and modify data in the form of visual graph construction;
- Compiling and executing queries to the database using newSQL;
- Compiling and executing database requests via HTTP REST ;
- Writing and executing Stored Procedures (SQL, Java Script);
- Profiling query execution for OrientDB (Enterprise Edition only);
- Configuration Management and Cluster Monitoring (Enterprise Edition only);
See also
- Document Oriented DBMS
- Graph database
- MongoDB
- Couchdb
- Apache cassandra
Literature
- Claudio Tesoriero. Getting Started with OrientDB. - Packt Publishing, 2013. - 138 p. - ISBN 978-1-78216-995-6 .
- Adam Fowler. NoSQL For Dummies . - John Wiley & Sons, 2015-01-20. - 456 s. - ISBN 9781118905623 .
- Glenn Goodrich. A Look at OrientDB: The Graph-Document NoSQL (Eng.) (Neopr.) ? . SitePoint (August 19, 2013). The appeal date is January 29, 2016.
Notes
Links
- orientdb.org - the official site of OrientDB
- http://www.opennet.ru/opennews/art.shtml?num=33847
- http://yapro.ru/web-master/mysql/orientdb-nachalo.html
- https://www.udemy.com/orientdb-getting-started/ - a free course for beginners in OrientDB (English language)