OrientDB interview questions and Answers
Most Frequently Asked OrientDB interview questions
OrientDB is a database management system written in Java, and it is open source and uses NoSQL. It is used as a cross system database since it can be installed on Linux, Windows or Mac. OrientDB is used for Big Data applications as it provides a unified database for different types of data models.
The latest version of OrientDB is 3.0.12 which was released on 10th December 2018
- Download the in-built OrientDB binary set up file. This file gives different already compiled binary packages for the different OS.
- Extract and then install the OrientDB. In Linux, the file name will be orientDB-community-2.1.9.tar.gz, and In windows, the file will be orientdb-community-2.1.9.zip .
- Configure an OrientDB server as a service. Configuration procedure depends on the Operating System.
- Verify the Installation of OrientDB. Verification is done using three steps:-
Run the server.
Run the console.
Run the studio.
The verification procedure is different for different Operating Systems.
This is a fundamental OrientDB interview question
- Many database modules integrated into one db.
- Good user profile based security system.
- SQL engine developed from scratch to improve performance.
- Storage caching better for reducing latency.
- Remote connection with increased transaction isolation.
| S.no | MongoDB | OrientDB |
|---|---|---|
| 1. | MongoDB does not support ACID transactions, but MongoDB supports atomic operations. | OrientDB supports both ACID transactions and atomic operations. |
| 2. | MongoDB has its own language which is based on JSON | The query language is fundamentally built on SQL. |
| 3. | MongoDB uses B-Tree algorithm for all the indexes. | OrientDB helps three different indexing algorithms so that the user can achieve the best performance. |
- OrientDB is open source and can be installed on any system very quickly
- Provides 300% better speeds on write operation.
- Implements SQL engine from scratch.
- Backward compatible API for production users.
| S.no | OrientDB | Neo4j |
|---|---|---|
| 1. | OrientDB is the multi-model database management system | Neo4j is an open source graph database. |
| 2. | OrientDB is written in Java | Neo4j is written in Java and Scala |
| 3. | Replication Method:- Causal Clustering using the Raft protocol info | Replication Method:- master - master |
This is one of the most asked OrientDB interview questions.
There are several data types which OrientDB supports. The primary data types in OrientDB are:-
- Boolean
- Integer
- Long
- Float
- Double
- Date-time
- String
- Byte
- Date
- Decimal
Clusterin OrientDB is used to store the group of documents, records or vertices. By default, OrientDB creates only one cluster in each class and in that one cluster which has the same name as of the class stores all the record of the class. In a database up to 32,767(2^15-1) clusters can be created.
A CREATE command is used to create a cluster in a class with a specific name. By default, only one cluster can be formed in a class, but multiple clusters can also be produced by spawning the records in various places
OrientDB is a multi-master or master-less distributed architecture. OrientDB is used in different ways in different servers to get the scalability.