OrientDB Pros and Cons

As of my professional use of this software database system OrientDB provides me a huge and verified data for engagement of niche. Review collected by and hosted on G2.com.

There is not a specific reason of dislike but sometimes I found duplicacy in there given data. Review collected by and hosted on G2.com.

We optimize query performance execution in OrientDB as it's simple & convenient for our client procurements. We effectively avoid the least significant relationships to our use cases and only return accurate records. OrientDB also offers explicit relationship record storage, which avoids connectivity issues between our data source and evolving schema. Review collected by and hosted on G2.com.

Pricing plans for Enterprise is relatively high. This is a hurdle as many mid-scale and small-scale organizations have hinged client budgets. Apart from this, all other features offered by OrientDB are impressive. It allows us to include new nodes & relationships easily without drastically changing our existing data models. Review collected by and hosted on G2.com.

the best thing about the oriented DB is that it manages the relation without using the joins.

and it the open-source so we can design and manage all the things according to us. Review collected by and hosted on G2.com.

all the things are good but if there is any issue while using the DB it's horrible to find the solution due to the documentation.

it is the fastest-growing database but less solution is available on google itself it take lot of time and efforts to find the solution Review collected by and hosted on G2.com.

one of the fastest databases in the market

you can fetch data from many tables with one request and it's very fast Review collected by and hosted on G2.com.

small community that leads to hard to find resources and help

still has a few bugs Review collected by and hosted on G2.com.

Orientdb is a great database for modelling data with complex relationships.

Some of the reasons why we preferred using OrientDB

- Master-master replication and clustering

- Decent tool set to start with, although there weren't any ORMs for OrientDB as such

- its embeddable directly in Java code, no need for a separate install, which made development easy Review collected by and hosted on G2.com.

- gremlin and tinkerpop are counterintuitive to understand at times

- because its hybrid, its hard to zero-in on your needs and what model you want for your database

- at the time we used it, there were some compatibility issues with the standards and some complications around mixing different modes - document, graph and sql vs tinkerpop Review collected by and hosted on G2.com.

I liked that OrientDB did everything - Graph Db, Key based, Document based. Plus it had elastic search built in. Additionally, the studio has a graphical user interface to the graph DB itself. This helped to visually understand how things were working when you saved objects and created connections. Review collected by and hosted on G2.com.

The documentation is horrible

features of database that are not documented and I found them on forums

DB seems very powerful but the documentation is bad

Wish I didn't need a java based server to run orientdb

It can be expensive to host OrientDB Review collected by and hosted on G2.com.

I didn't have to do join tables and all, I could think everything in terms of graphs.

I like the web interface too Review collected by and hosted on G2.com.

I used it in the early 2014-2015 if I remember correctly. So I don't remember a lot. But I think it was a pretty neiche tech.

It was slower when compared to postgres. Review collected by and hosted on G2.com.

It's support for graph db , document store and key value store make it quite versatile . Other things like being free software, saves a lot of money. Review collected by and hosted on G2.com.

As it is new, so community support is not that smooth. Have very few question and answers on online forums like stack overflow. Because of this, it is relatively difficult to debug issues. Current release cycles and critical patches are too frequent. Hence, to remain up to date, version upgradation is almost necessary every time. Review collected by and hosted on G2.com.

Few Things I would like to mention one by one

1. Links: OrientDB supports links which makes referencing other classes very easy, THe kind of vast support for links in the form of a list and as singular, it helps to shorthand a lot of queries. I was trying to look for the same possibilities with Cosmos DB of Azure (which is claimed to be graph DB but I doubt it) and it doents even comes close.

2. Maps and unstructured data like json: I have worked with many SQL and NoSQL DBs but I think orientDB integrates very well with json kind of structure and maps.

3. Handling of large data: OrientDB handles large data very easily. There were times when some of the queries returned records in lacs (more than 100 k), but it was never a problem performance wise Review collected by and hosted on G2.com.

1. Unnecessary clutter returned with response: So I used orient DB with Node JS and its driver is fairly good. But it fails miserable when there is any kind of circular dependency. It attaches a lot of unnecessery data to records, we had to write a samll utility to remove unnecessery clutter from returned data. For example for links, it sometimes returned the link with full data of the refenved claass (same for another refence, so it will create a chain or tree of references if all the subsequent records have any links in them)

2.Migration failures: It is claimed by orientDB that in the migration if we set certain parameters, it will keep the original RIDs of records as it is. But this is not the case. Certainly with the database where lot of create deletion operations happened and rids are something like (35:104, 15:204) RIDs are not persisted after migration. Review collected by and hosted on G2.com.

The GUI of orientDB is very practical and user-friendly, it is comparable to other competitors their UI and allows of easy management of indexes, relations and nodes. Review collected by and hosted on G2.com.

The small community, lack of professional tools and performance. Their is no easy way to manage the community version of OrientDB and the enterprise edition is a big step us in price. Great ways to resolve this would be scalable cloud offerings which allow you to test OrientDB in a managed fashion to later on decide for yourself if the step to the Enterprise edition is necessary for yourself. Review collected by and hosted on G2.com.