Does MongoDB support OLTP?

Question

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. Where you've got a user, or a system, that is working with it in realtime. 9 нояб. 2014 г.

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.

What is supported by MongoDB?

Explanation: MongoDB supports JSON format compared to XML.

Which database is good for OLAP?

Your option will be definitely SQL. The deal is using NoSQL for OLAP - is not for what this server intended. 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.

Expert · Answer