Can NoSQL be used for OLAP?

Question

NoSQL databases provide very high read and write throughput for large objects. As a rule, they are not intended to be used in atomic-level data which OLAP system requires. Though, OLAP with NoSQL use is possible if we are talking about MongoBD and hBase. In other cases, SQL wins.

Is NoSQL OLTP or OLAP?

Relational databases are designed for transactional and strongly consistent online transaction processing (OLTP) applications and are good for online analytical processing (OLAP). NoSQL databases are designed for a number of data access patterns that include low-latency applications.

Can MongoDB be used for OLAP?

MongoDB released the MongoDB connector for BI, which acts as a MySQL server on top of MongoDB data. It means you can use ROLAP (Relational OLAP) engines, such as Cube.

Can NoSQL be used for OLTP?

OLTP can be achieved using NoSQL with a custom implementation, there are two things, 1. How are you going to achieve ACID properties that an RDBMS gives.

Which database is best for OLAP?

Top 10 Best Analytical Processing (OLAP) Tools: Business...#1) Xplenty.#2) IBM Cognos.#3) Micro Strategy.#4) Palo OLAP Server.#5) Apache Kylin.#6) icCube.#7) Pentaho BI.#8) Mondrian.Top 10 Best Analytical Processing (OLAP) Tools: Business Intelligence

Expert · Answer