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.

 

know more at : http://www.tech-faq.com/transactional-database.html

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s