CRUD Operation in Orientdb

3 min readJul 18, 2022

What is Orientdb?

OrientDB is the first Multi-Model Open-Source NoSQL DBMS that combines the power of graphs and the flexibility of documents into one scalable, high-performance operational database. It has a strong security profiling system based on users and roles and supports querying with Gremlin along with SQL extended for graph traversal.
OrientDB was originally authored by Luca Garulli in 2010.

https://en.wikipedia.org/wiki/OrientDB

Applications of Orientdb

Banking
Big Data
Fraud prevention
Loan management software
Master data management
Non-coding RNA human interaction database
Recommendation engines
Social networking
Traffic management systems

https://en.wikipedia.org/wiki/OrientDB

DataSet: Best Selling Smartphones

https://www.kaggle.com/datasets/muhammedtausif/best-selling-mobile-phones

111 Rows and 5 Columns

Following were the attributes in the dataset provided.
Manufacturer (Name)
Model
Form (Bar / touchscreen)
Smartphone (Yes/No)
Year
Units Sold

STEP 1: Creating a Cluster with master and slaves

This change was made in the hazlecast file stored in the config folder of the downloaded orientdb setup. The same thing was done for all master and 3 slaves. They were connected to each other but using the device Ip and different ports from 2434 to 2437.

Creating master slave using tcp-ip configuration

Running 1 master and 3 slaves in such a way that when a change is being made in master then it is replicated to all the slaves as well. These were run by running the dserver batch files stored in the bin folder of the downloaded orientdb setup.

STEP 2: OPENING ORIENTDB

The following user interface of orientdb could be opened by the local host link provided in the console after running the master and its slaves.

The task was to configure the Orientdb in document model and import the given data set in it and perform the CRUD (create, read, update, delete) operations on the data provided in data set.

The database was created in the Orientdb Document model but I didn’t find anyway to import the data in the database in order to perform CRUD operations. So for this I used a public database from Orientdb itself.