Sunday January 21st 2018

Categories

Insider

Archives

Difference between operational databases and Business Intelligence

OLTP vrs OLAP

          1-     Operational databases are design to remove redundancy, accurate updates and removal of repetitive   operations for example deposits, flight reservation. Business intelligence has the goal of business reporting and data analyses.

 

2-     Operational data bases are highly normalized in relational database format to facilitate data update. Business intelligence databases are highly demoralized for fast retrieval and analyses of large amount of data.

 

3-     In operational databases most of the data is raw and stored without any calculations, calculations are usually done when required through queries. In business intelligence large amount of data is pre-calculated or derived to save time when running queries.

 

The above are few general difference between Business intelligence and operational databases, we are keep researching and will update more.