Sunday January 21st 2018




Difference between operational databases and Business Intelligence


          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.