Is NoSQL used for OLTP?

Question

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. 2 июн. 2011 г.

Which database is used for OLTP?

OLTP systems use a relational database that can do the following: Process a large number of relatively simple transactions — usually insertions, updates and deletions to data.

Does NoSQL support 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 MongoDB OLTP or 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. Where you've got a user, or a system, that is working with it in realtime.

Is SQL OLTP or OLAP?

Also in brief, when you use SQL Server Management Studio to connect to SQL Server, if you choose 'Analysis Services' as server type then it's OLAP, if you choose 'Database Engine' then it's OLTP. For more details, please refer to this similar thread.

Expert · Answer