What are the Advantages and Disadvantages of Transactional Databases?
The primary advantage to database transactions is flexibility. Database users are able to modify some information without having to touch sensitive or isolated information. The interface and rules for manipulating the data store can be accomplished without changing the overall structure of the system. Additionally, database transactions allow users to have an improved ability to retrieve history with the data being stored in a constrained environment. Finally, due to the consistent information stores provided by transactional databases, there is minimal risk of losing data due to system or power failure.
Some of the disadvantages of transactional databases include potentially less readable data due to some implementations only having an “insert only” feature for information. Additionally, there is less opportunity or ability to change information within a transactional database for many end-users. This puts a greater onus on ensuring data correctness before conducting a transaction on the database.