Explore BrainMass

Databases for Business Intelligence

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Business intelligence systems are sometimes called online analytical processing (OLAP) systems. These OLAP systems are used to make decisions and are characterized by few users submitting long running queries that do not update the database to analyze the historic data of the company. What are some other differences between online transaction processing (OLTP) and online analytical processing systems? How are data warehouses similar or different from these two database models?

© BrainMass Inc. brainmass.com October 25, 2018, 7:51 am ad1c9bdddf

Solution Preview

Dear Student,
Please find the attached word document a chart and diagram for this topic. I hope it'll be useful.
Jasbir Virdi

Databases for Business Intelligence

Online analytical processing, also known as OLAP, is used for very different purposes compared to OLTP. OLAP systems focus on market research and ways to increase market share, as well as awareness. This type of processing focuses on ways that customers or users of OLTP systems behave and allow the users of OLAP systems to make decisions based on those behaviours. Data in OLAPs is historical and not in real time. Processing in OLAPs uses the historical data to identify and analyze patterns of customer orientation and market behaviour. The database design and architecture ...

Solution Summary

This essay talks about the differences and similarities between Online Analytic Processing System and Online Transaction Processing System. Both these database types are used for business intelligence based on the varying requirements of an organization.

See Also This Related BrainMass Solution

Data warehouse and business intelligence

Data warehouse and business intelligence

In preparing a response, you may wish to think about questions such as:

What are the differences among database and data warehouse?
What are the data warehouse technologies?
Relationship between data warehouse and business intelligence

View Full Posting Details