Question

In: Computer Science

Describe a business situation in which you would want to choose OLAP over OLTP or OLTP...

Describe a business situation in which you would want to choose OLAP over OLTP or OLTP over OLAP. How would you describe the purpose and advantages of one over the other?

Solutions

Expert Solution

Let us first consider the use case of OLAP

OLAP stands for Online Analytical Processing . It is a group of software tools which are mainly used for analytical purposes of a buisness solution.

OLAP applications will store informations from multiple databases in a warehouse and apply analytiacal tools on this warehouse datas. It actually handles historical data.For example, suppose an organization needs to find how customers buy their products and needs to analyze what can be done to increase the sales . Then the organization needs to apply the analytical tools. So it will collect purchase history of users from various databases and process it. In such kind of buisness solutions use of OLTP is not encouraged. Because , OLTP databases are used for continuous transaction like normal fetch , update operations on database. It does not support advanced analytical tools. Also , an OLAP can handle datas from variety of databases but for an OLTP datas are of almost same type.

Now coming to OLTP

OLTP stands for online Transaction processing . It consist of only current data . These datas are used for day to day applications . For example , an Online Banking system is an example of an OLTP application. OLTP is capable of handling the ACID properties.

It is important to note here that OLTP is optimized for transactions instead of data analysis.For example , assume a couple has a joint account in a bank . Suppose , both of them have done an online banking simultaneously to transfer some amout the online banking system should make sure that withdrawn amount will not be greater than the current balance.

Normally , large organizations store datas for day to day operations on OLTP and historical datas for analytical processes in OLAP.


Related Solutions

Choose a business with which you are familiar. Describe the ways in which this business has...
Choose a business with which you are familiar. Describe the ways in which this business has advantages or disadvantages in relation to: (a) visibility (b) cost (in terms of likely premises expenses and transport costs) (c) proximity to customers (d) proximity to suppliers (e) proximity to any complementary businesses.
if you want to prepare a buffer at pH = 5.2 which buffer would you choose?...
if you want to prepare a buffer at pH = 5.2 which buffer would you choose? a) MES --> Ka = 7.9 x 10^-7 b) CHES --> Ka = 5.0 x 10^-7 c) Tris --> Ka = 6.3 x 10^-9 d) acetic aid --> Ka = 1.8 x 10^-5
1) In no less than 100 words, describe a situation where you would want to kill...
1) In no less than 100 words, describe a situation where you would want to kill a process? 2) Give an example of when the pstree command would be helpful. 3) Provide an example of when you would want to run a process as a background process. 4) Which NICE priority is the fastest priority? Which is exactly in the middle? 5) Discuss a command that an administrator would want to schedule on Friday of every week. Give an example...
Describe a leadership situation you would handle differently if you had to do over again now...
Describe a leadership situation you would handle differently if you had to do over again now that you have improved understanding on what is an Effective Leadership
1. In your business, describe a decision you would need to make where you would want...
1. In your business, describe a decision you would need to make where you would want to use some type of optimization tool. In regards to this decision, explain the importance of optimizing and how it will be beneficial for your business. 2. Think of an example where simulation could be beneficial to your business. Explain how you could use simulation and describe the type of simulation. (There are several listed in the text. i.e. probabilistic, time-dependent/independent, discrete event, visual,...
Describe a business situation where you felt uncomfortable or ill at ease What would you do...
Describe a business situation where you felt uncomfortable or ill at ease What would you do differently to handle the situation? What can you do to maintain composure in even the most difficult or stressful business situation?
If you were to start your own business, which business entity structure would you choose? Justify...
If you were to start your own business, which business entity structure would you choose? Justify why your chosen structure is the best organizational form. Explain the following business structures: sole proprietorship, partnership, LLC, and a corporation. In your analysis address the following for each business structure: Steps to form Personal liability for owners Taxation Advantages and disadvantages Your paper must be three to five pages
Describe a situation in which you might find yourself where you would need to perform an...
Describe a situation in which you might find yourself where you would need to perform an immediate titration. Think hard. This should be a solid paragraph answer.
Briefly describe a business situation where you would use any three of the eight Highlight Cells...
Briefly describe a business situation where you would use any three of the eight Highlight Cells Rules sub-menu options that are found on the Conditional Formatting drop-down menu. The options are Greater Than, Less Than, Between, Equal To, Text that Contains, A Date Occurring, Duplicate Values, and More Rules.
What is a job order cost system? Describe a situation in which you would use job...
What is a job order cost system? Describe a situation in which you would use job order cost information. What type of information is useful in making your decision?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT