Databases for Business Intelligence
Not what you're looking for?
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?
Purchase this Solution
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.
Solution Preview
Dear Student,
Please find the attached word document a chart and diagram for this topic. I hope it'll be useful.
Thanks,
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 ...
Purchase this Solution
Free BrainMass Quizzes
C# variables and classes
This quiz contains questions about C# classes and variables.
Inserting and deleting in a linked list
This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.
Basic Computer Terms
We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.
C++ Operators
This quiz tests a student's knowledge about C++ operators.
Word 2010: Tables
Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.