If the data is manageable in both systems, relational databases (RDBMS) are generally the better choice because they provide:
Strong ACID compliance → ensures consistency and reliability.
Complex queries and reporting → joins, aggregations, and analytics are much easier.
Mature tooling → backup, recovery, and monitoring are well-supported.
Non-relational (NoSQL) databases shine primarily when you need:
Massive horizontal scaling across multiple nodes.
High write throughput or very flexible/unstructured schema.
So, for datasets that both systems can handle comfortably, RDBMS is usually preferable unless your access patterns or scalability needs strongly favor NoSQL.