Can MongoDB be used for OLAP?

Question

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. js. This tutorial covers how to set up ROLAP on top of MongoDB Connector for BI. 2 сент. 2014 г.

Is MongoDB good for OLAP?

MongoDB is designed for OLTP workloads, so more transactional, online, realtime workloads. People definitely do use it for batch processing, and it works okay in those areas, but it's really designed for OLTP.

Which database is good for OLAP?

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 we use MongoDB as data warehouse?

MongoDB is a robust database used for high volume data storage. It is a document-oriented NoSQL database, and that makes it really easy to store and work with no relational data. MongoDB is commonly used as the database to store product data and product interactions with your customers.

Expert · Answer