Name: OrientDB
Rating: 8 (4 reviews)
Author: Open Source

Customer Training

Help Desk

Kiosk

Web and Video Conferencing

Customer Support

Agile Development

Automation Testing

Cross-Browser Testing

Interactive Application Security Testing (IAST)

Product Analytics

Service Mesh

Development

Business Intelligence (BI)

Collaboration

Emissions Management

IP PBX

Knowledge Management

Enterprise

Accounting

Travel Management

Finance and Accounting

Applicant Tracking

Corporate Learning Management

Employee Scheduling

HR Management

HR Service Delivery

Payroll

Talent Intelligence

Talent Management

Workforce Analytics

Workforce Management

Human Resources

Cloud Cost Management

Cloud Storage

Data Integration

Embedded Database

Ethernet Switches

Fraud Detection

Governance, Risk & Compliance

IP Address Management (IPAM)

Integration Platform as a Service (iPaaS)

Low-Code Development

Managed DNS

Mobile Identity

Network Performance Monitoring

Platform-as-a-Service (PaaS)

Privileged Access Management

Value Stream Management

Information Technology

A/B Testing

Account-Based Marketing (ABM)

Ad Serving & Retargeting

All-in-One Marketing

Audience Intelligence

Audio Editing

Click Fraud

Content Management

Data Cleansing

Digital Rewards

Email Marketing

Marketing Automation

Mobile Analytics

Social Media Management

Survey & Forms Building

Web Analytics

Marketing

Project Management

Video Conferencing

Writing and Proofreading Tools

Professional Services

Construction CRM

Customer Relationship Management (CRM)

Lead Management

Predictive Sales Analytics

Sales Engagement

Sales Incentive Compensation Management

Sales

Database Security

Security

Animation

Debt Collection

Laboratory Information Management

Legal Case Management

Spreadsheet

Vertical-Specific

Find top rated software and services based on in-depth reviews from verified users. 400+ software categories including PaaS, NoSQL, BI, HR, and more.

MongoDB

ArangoDB

Neo4j

Neo Technologies

MySQL

Oracle

PostgreSQL

PostgreSQL Global Development Group

Redis Software

Redis

Amazon DynamoDB

Amazon AWS

Couchbase Server

Couchbase

IBM Cloudant

Apache Cassandra

Apache

Azure Cosmos DB

Microsoft

Google Cloud Datastore

Google

Apache HBase

### Graph Database Features
Users generally praise OrientDB's graph database features for their versatility and efficiency in handling hierarchical data structures. The ability to easily connect and traverse numerous classes and unstructured data sets has been highlighted as a significant advantage. Despite some challenges with concurrency management, users appreciate OrientDB's support for graph queries and its multi-model capabilities. The graphical user interface and the integration with scripting languages have also been commended for enhancing the overall user experience. Additionally, the support for various data models, including graph, document, and key-value stores, adds to the database's versatility and appeal to a wide range of users.

### Data Structure and Modeling
Users generally appreciate OrientDB's versatility in handling complex data structures and unstructured data models. The feedback highlights the ease of connecting various classes and visualizing data relationships through traversing, which is often challenging in traditional relational databases. Despite some users finding the hybrid nature of OrientDB slightly complex to navigate, the majority acknowledge its support for graph queries and multi-model capabilities. The ability to effortlessly manage large volumes of data, including unstructured formats like JSON, is a standout feature for many users. Additionally, the integration of maps and the support for links within OrientDB are praised for simplifying data referencing and query operations.

### Network and Relationships
User feedback on OrientDB's network and relationships functionality is varied and showcases a range of experiences and opinions. Some users praise OrientDB for its ability to model complex relationships efficiently, especially in scenarios like building social networks or tracking connections in a hierarchical topology. They appreciate the ease of implementing use cases involving network analysis and distributed environments. However, others express concerns about the pricing plans for the Enterprise version, which may pose challenges for organizations with limited budgets. Despite this, OrientDB's direct storage of relationships and its support for real-time data processing are highlighted as valuable features for creating and managing networks effectively.

### Query Performance
Users widely praise OrientDB for its exceptional query performance capabilities. The consensus among reviewers is that OrientDB's query engine is fast, efficient, and flexible, allowing for quick retrieval of data from multiple tables or collections with just one request. Additionally, users appreciate the ease of transitioning from SQL to graph-based queries, as well as the support and community available for assistance. The fast query engine and the ability to develop custom applications using OrientDB's Java API further enhance its appeal for both OLAP and OLTP operations in distributed environments.

### Scalability and Distribution
Users consistently highlight OrientDB's strength in scalability and distribution, emphasizing its ability to handle large volumes of data efficiently in a distributed environment. The clustering and replication features are particularly commended for their role in enhancing performance and ensuring data integrity across multiple nodes. Despite occasional challenges with manageability due to frequent releases and patches, users generally find OrientDB's scalability and distribution capabilities to be reliable and well-suited for complex data analysis and network operations.

### Performance and Optimization
User consensus seems to be that performance and optimization is a strong point of OrientDB. Reviewers highlight the lightning speed at which data can be inserted and fetched, making it an efficient choice for cache memory usage. Despite some concerns about scalability and occasional performance issues when handling large records, OrientDB's ability to handle large data sets with ease and its support for SQL-like queries are often praised by users. The community version's cost-effectiveness and the flexibility it offers for various use cases make it a popular choice among those seeking a multipurpose database solution.

### Document Management
Users generally appreciate OrientDB's versatility in handling document-based data. The ability to integrate well with JSON structures and maps has been highlighted as a strong point by users. However, some users have expressed concerns about the hybrid nature of OrientDB, finding it challenging to pinpoint their specific database model needs. Compatibility issues with standards and complexities around mixing different modes have also been noted as areas for improvement. Despite these challenges, OrientDB's support for document storage and key-value store functionalities, along with its free software nature, have been commended for saving costs. In conclusion, OrientDB is recommended for projects where graphical views of data are critical, especially in multi-node and distributed environments.

### Data Handling and Storage
Users generally praise OrientDB's robust data handling and storage capabilities, highlighting its efficiency in managing records, caches, and replicas. While some users appreciate the lightning-fast data insertion and retrieval speeds, others express concerns about scalability and performance when dealing with large datasets. The ability to handle unstructured data, index records effectively, and support SQL and Java-based queries are noted as significant advantages by users. However, there are occasional challenges reported, such as unnecessary clutter in responses and migration failures impacting record identification. Despite these drawbacks, OrientDB's users acknowledge its versatility in supporting various data storage formats and its potential for further improvements in production-grade transactions.

Users commonly recommend three key points when it comes to OrientDB. 

First, users suggest that OrientDB is best suited for graph and document based projects where graphical views of all the data are critical and required. This recommendation emphasizes the strength of OrientDB in handling complex relationships and providing visual representations of data.

Second, users highlight that OrientDB is well-suited for multi-node and distributed environments. This recommendation indicates that OrientDB can effectively handle large-scale data storage and processing across multiple nodes, making it a reliable choice for scalable projects.

Lastly, users advise performing a proof of concept with OrientDB from the perspective of a graph database rather than trying to turn it into a relational database with graph features. This recommendation recognizes that while OrientDB offers graph capabilities, its true strength lies in its graph-oriented design and should be approached as such during implementation.

OrientDB is a multi-model database management system that supports graph, document, key-value, and object-oriented models within a single database. According to the vendor, it offers a flexible and scalable solution for managing complex data relationships. OrientDB is suitable for companies of all sizes, including small startups and large enterprises. It is commonly used by IT professionals, developers, data scientists, analysts, software companies, technology firms, as well as the financial services, e-commerce, and retail industries.

## Key Features

**Multi-Model Database**: OrientDB supports multiple data models, such as graph, document, key-value, and object-oriented models, allowing users to store and query data in various formats within one database.

**Scalability and Performance**: According to the vendor, OrientDB is designed to handle large-scale data and high-performance workloads. It enables horizontal scaling by distributing data across multiple servers, ensuring increased throughput and minimizing the risk of a single point of failure.

**ACID Transactions**: OrientDB ensures data integrity and consistency through support for ACID (Atomicity, Consistency, Isolation, Durability) transactions. This feature provides reliable and secure data operations, even in the event of system failures.

**SQL and Gremlin Query Languages**: OrientDB supports SQL and Gremlin query languages, offering users flexibility in querying and manipulating data. SQL enables structured query language operations, while Gremlin is a graph traversal language for querying graph data.

**Distributed Architecture**: OrientDB's distributed architecture allows for data replication and distribution across multiple servers, ensuring high availability and fault tolerance. This ensures data accessibility, even in the event of server failures.

**Full-Text Search**: OrientDB includes full-text search capabilities, enabling users to perform text-based searches across documents and other data stored in the database. This feature enhances the ability to find and retrieve relevant information.

**Security and Authentication**: OrientDB provides robust security features, including user authentication and authorization mechanisms. It supports role-based access control, ensuring that only authorized users have access to specific data and operations.

**Real-Time Analytics**: According to the vendor, OrientDB supports real-time analytics by processing complex queries and aggregations on large datasets. This enables users to gain valuable insights from their data in real-time.

**Replication and Sharding**: OrientDB supports data replication and sharding, facilitating data distribution and synchronization across multiple servers. This enhances performance and scalability by enabling parallel processing and reducing the load on individual servers.

**High Availability**: OrientDB's high availability features ensure continuous accessibility to the database, even in the event of server failures or network disruptions. It includes automatic failover and recovery mechanisms to minimize downtime and ensure data availability.

OrientDB has become a go-to solution for users dealing with unmanaged and unstructured data. Its ability to handle large datasets and perform data analysis, network analysis, and monitor network devices has made it ideal for uses in telecom inventory management, log management tools, and monitoring high availability problems. The product's embedded maps have also been helpful in analyzing large datasets. Additionally, OrientDB's use of lightweight pointers instead of JOIN operators has improved performance when retrieving interconnected entities, which is a critical factor when dealing with complex and deep relationships. 

Moreover, building IoT applications and social networks require the establishment and maintenance of numerous relationships, making OrientDB's relational database approach ideally suited for these cases. It stores relationships directly, which enables it to construct enterprise knowledge graphs that can be used for various types of network analysis projects. This feature has also proven to be very crucial in shortening the time it takes software products to approve drugs while tracking documentation and supporting versioning and changes tracking in Pharma companies. Its data model is very similar to the OOP approach, making it an ideal tool for most applications focused on business logic. Overall, OrientDB has found its way into various industries and replaced traditional databases as a primary choice database system due to its versatility and efficient handling of relational databases.

Inadequate documentation: Users have consistently reported facing difficulty finding solutions due to OrientDB's inadequate and scattered documentation. The lack of comprehensive documentation has led some users to resort to reading source code for a solution.

Difficulty scaling and using in production: Many users have found it difficult to scale OrientDB, making it hard to use in production. This issue can be attributed to the problematic concurrency handling in the graph, as well as compatibility issues that arise when mixing different modes such as document, graph, SQL vs Tinkerpop.

Performance issues: There have been consistent reports of performance issues with OrientDB. Some users have had to spend time splitting files and opening the database file by closing the currently opened one due to performance problems. Additionally, queries that involve nodes with many edges can take a long time to execute which could impact productivity negatively.

Flexible and Easy to Use: Many users appreciate OrientDB's flexibility and ease of use, with some praising its simple structure and Java API support. The open-source software allows for customization according to project requirements, making it ideal for creating representations of any type of domain. Its interactive web interface and easy-to-use APIs make development a hassle-free experience.

Good Performance: Users find that OrientDB's performance is efficient and fast, even when handling large amounts of data with queries returning hundreds of thousands of records. Some reviewers have been impressed with the database's robustness and scalability, while others praise its ability to streamline tasks that are typically time-consuming in other databases.

Ideal Choice for Graph-based Applications: According to several reviewers, OrientDB excels at modelling data with complex relationships, making it an ideal choice for social network applications like LinkedIn or Facebook. Reviewers also appreciate OrientDB's multimodel graph properties which enable them to visualize data easily and index records effectively.

OrientDB is a NoSQL embeddable graph database developed by UK company Orient Technologies which was acquired by CallidusCloud in 2017, who in turn was acquired by SAP in 2018. At present OrientDB is an open source database available free on an Apache 2 license.

MongoDB is an open source document-oriented database system. It is part of the NoSQL family of database systems. Instead of storing data in tables as is done in a "classical" relational database, MongoDB stores structured data as JSON-like documents with dynamic schemas (MongoDB calls the format BSON), making the integration of data in certain types of applications easier and faster.

Shared

Serverless

Dedicated

Amazon DynamoDB is a cloud-native, NoSQL, serverless database service.

On-Demand - Write Operation

On-Demand Read Operation

On-Demand Data Stored

On-Demand Point-in-Time Recovery

On-Demand Snapshot

On-Demand Restoring a Backup

On-Demand Global Tables

On-Demand Streams

On-Demand Data Requests Outside AWS Regions

Provisioned - Write Operation

Provisioned - Read Operation

Provisioned - Data Stored

Provisioned - Point-in-Time Recovery

Provisioned - Snapshot

Provisioned - Restoring a Backup

Provisioned - Global Tables

Provisioned - Streams

Provisioned - Data Requests Outside AWS Regions

OrientDB

Some cloud platforms offer options for using a database as a service, without physically launching a virtual machine instance for the database. In this configuration, application owners do not have to install and maintain the database on their own. Instead, the database service provider takes responsibility for installing and maintaining the database, and application owners pay according to their usage. For example, Amazon Web Services provides three database services as part of its cloud offering, SimpleDB, a NoSQL key-value store, Amazon Relational Database Service, an SQL-based database service with a MySQL interface, and DynamoDB.

NoSQL Databases

Sysmon OrientDB Demo

Questa è la versione "Director's Cut": per la versione senza inutili pause vedere https://www.youtube.com/watch?v=-0EXtwB8IUU

Il talk vuole presentare alcune caratteristiche peculiari di OrientDB, che si è evoluto da document/graph noSQL database verso una architettura multi-model. Nello specifico parleremo della capacità di OrientDB di effettuare ricerche testuali e geospaziali, non tralasciando una demo con dati reali. Come bonus track verrà illustrato il codice utilizzato per la demo.

Graph full text and spatial indexes made easy with OrientDB - Roberto Franchini - 5 Ottobre 2016

OrientDB | Demo

OrientDB Demo

Open Source

NoSQL databases are designed to be used across large distrusted systems. They are notably much more scalable and much faster and handling very large data loads than traditional relational databases.

Performance

How fast the database performs under data load

Availability

Availability is the probability that the NoSQL database will be available to preform its function when called upon.

Concurrency

Concurrency is the ability for multiple processes to access or change shared data simultaneously. The greater the number of concurrent user processes that can execute without blocking each other, the greater the concurrency of the database system.

Security features include authentication against external security mechanisms liker LDAP, Windows Active Directory, and authorization or privilege management. Some NoSQL databases also support encryption.

Scalability

NoSQL databases are inherently more stable than relational databases and have built-in support for replication and partitioning of data to support scalability.

Data model flexibility

NoSQL databases do not rely on rely on tables, columns, rows, or schemas to organize and retrieve data,  but use use more flexible data models to accommodate the large volume and variety of data being generated by modern applications.

Deployment model flexibility

Can be deployed on-premise or in the cloud.

TrustRadius is a technology and business research firm based in Austin, Texas. The company is known as a review platform for verified B2B technology and software reviews through a proprietary algorithm and human verification.

TrustRadius

Home

OrientDB

Overview

What is OrientDB?