Operational Vs Historical

Posted by Sudheer Sharma 19 January 2009
What do you think of this post?
Awesome  Interesting  Useful 

 

Operational systems are designed to support Transaction Processing whereas Data Warehouse systems are designe to support  Online analytical Processing

 

Operational Systems

 

  • It supports high volume transaction processing with minmal reporting
  • Process oriented. Usually focused on specific business processes or tasks
  • Generally concerned with the Current data
  • These systems are generally updated regularily 
  • Optimized to perform fast inserts and updates of small volume of data
  • These are application specific, non-integrated systems and contains redundant data.

 

 

Historical Systems

 

  • It supports high volume analytical processing and supports report generation
  • Subject oriented. Subject areas are usually populated from one or more operational systems
  • Generally concerned with the historical data
  • It is non-volatile, that means new data may be added regulaily but once data is loaded , the data is changed rarely. 
  • Optimized to perform fast retrievals of large volume of data
  • These are Integrated systems, to avoid data redundancy problems.
What do you think of this post?
Awesome  Interesting  Useful 

Leave a Reply

*


Fatal error: Call to undefined function is_new_post() in /hermes/web06/b862/moo.godasudheer/wp-content/themes/MagHo/MagHo/page.php on line 20