Tuesday, March 29, 2011

Comprehensive Exam Question 1

Explain the difference between Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP). How OLAP analysis is used to facilitate business intelligence?

Online Tranaction Processing supports the daily business operations. It helps to manage transaction applications such as data entry. Online Analytical Processing uses multiple sources of information and provides multidimensional analysis, such as viewing data based on time, product, and location. OLAP analysis is used to facilitate business intelligence by sifting through massive amounts of statistics to find specific information. These tools usually have a drill down feature for multilayer information.

2 comments:

  1. This comment has been removed by the author.

    ReplyDelete
  2. While writing is for everybody, technical writing can only be done by the trained ones. People who can do different forms of technical writing, such as business and academic, can make productive use of their skill by doing home-based jobs that can be found online.visit the site

    ReplyDelete