It's something of a misconception that an RDBMS should be used for transactional workloads.

RDBMSs are table stores; in a sense if anything that's a model better suited for analytical than transactional not that that's really a fair conclusion either