Can NoSQL be used for OLTP?

Question

OLTP stands for Online Transaction Processing, which suggests that a relational database, with transaction support is essential. Hence NoSQL databases are very .Which database is best for OLTP and OLAP queries at the same time?Which NoSQL database can be a good choice for OLAP engine?What nosql data stores can be used for OLTP and OLAP? - QuoraWhat are the pros and cons of OLTP, OLAP, relational, graph .Другие результаты с сайта www.quora.com

Can we use NoSQL 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.

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 NoSQL be used 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.

Can we use MongoDB for OLTP?

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.

Expert · Answer