Explain the terms On Line Transaction Processing (OLTP) system,Dat aWarehouse (DW) and Data Mart (DM) Critically compare the purpose of these, their data requirements and utilisation scenarios Using the definitions of Business Intelligence, Online Analytical Processing (OLAP) and Data Mining explain how analytical capability embedded in ones business information systems can enhance understanding of ones business performance and create competitive advantage

Question: Explain the terms On-Line Transaction Processing (OLTP) system,Dat aWarehouse (DW) and Data Mart (DM). Critically compare the purpose of these, their data requirements and utilisation

Explain the terms On-Line Transaction Processing (OLTP) system,Dat aWarehouse (DW) and Data Mart (DM). Critically compare the purpose of these, their data requirements and utilisation scenarios.
Using the definitions of Business Intelligence, Online Analytical Processing (OLAP) and Data Mining explain how analytical capability embedded in one’s business information systems can enhance understanding of one’s business performance and create competitive advantage.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

OnLine Transaction Processing OLTP System OLTP is a type of system designed to manage and support the daily transactional operations of an organization These transactions are typically short frequent ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Do some amendment and enhance the given research paper: Table of Content Abstract..3 Action Research.4 Research Methodology and Design...5 Literature Review: NoSQL Database7 Proposal.7 Iteration 1..8...

Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...

Explain why merchants accepted gold receipts as a means of payment even though the receipts were issued by gold-smiths, not the government. What risk did goldsmiths introduce into the payments system...

A square loop of wire of edge length a carries current i. Show that the magnitude of the magnetic field produced at a point on the central perpendicular axis of the loop and a distance x from its...

Which new markets are relevant for Senseo to enter?

Let X and Y be two continuous random variables with densities fX and fY , respectively, and with the same range of values, R. Is it possible that fX(x) Answered: 1 week ago

Kennedy Company produces a product that sells for $37 per unit and has a variable cost of $22 per unit. Kennedy incurs annual fixed costs of $75,000. Required a. Determine the sales volume in units...

A security analyst for a smart home devices manufacturer works on tasks to improve the security of a new line of IoT ( Internet of Things ) devices. These devices require robust security measures to...

Christy Albright and Dan Ralls formed the Charter Company on 11/30/2012, and chose a tax year ending on 11/30. Charter was formed to operate a restaurant (at 7848 Pesca Dr., San Francisco, CA 94123)...

C11.2.3 Company Settings: Sales All associated information and instructions for the Chapter 11 project are presented between pages 534 and 598 in the text. The steps for setting up a new company in...

If an instance of ANE happens for a client, direct service providers should do the following: Record TV shows that were going to be watched for later viewing Report knowledge or suspicion of ANE to...

Learning Source, Inc. has two divisions: Test Preparation and Language Arts. Results (in millions) for the past three years are partially displayed here: (Click the icon to view the results.)...

Use DeMoivre's Theorem to find the indicated power of the complex number. Write the answer in rectangular form. [3(cos 80 + i sin 80)] [3(cos 80 + i sin 80) = (Simplify your answer, including any...

Question 17 (515108) (Elastic Collisions} = (1 points) On a frictionless surface, a block of mass m 2 kg moves at a velocity of v = +6 m/s (towards the right) headed towards another block of m 1 kg...

Grifols is a global healthcare company that since 1909 has enhanced the health and well-being of people around the world. Four divisions - Bioscience, Diagnostic, Hospital and Bio Supplies - develop,...

The comparative balance sheet of Yellow Dog Enterprises Inc. at December 31, 20Y8 and 20Y7, is as follows: Dec. 31, 20Y8 Dec. 31, 20Y7 Assets Cash $59,820 $73,390 Accounts receivable (net) 91,920...

Suppose that you are part of a virtual team and must persuade other team members on an important matter (such as switching suppliers or altering the project deadline). Assuming that you cannot visit...

Define each of the terms listed in Figure 3-3.

Create a database named MEDIA in MySQL 5.6. Use the default settings for file sizes, names, and locations (the actual database name in MySQL will appear in lowercase letters only).

Write an SQL statement to display the SKU, SKU_Description, and WarehouseID for products having QuantityOnHand greater than 0. Sort the results in descending order by WarehouseID and ascending order...

8.19. Referto Exercise 8.10, on alcohol use and cigarette use. (a) Describe the strength of association using the difference between users and nonusers of alcohol in the proportions who have used...

8.13. The sample in Table 8.15 is 157 black Americans. Table 8.23 shows cell counts and standardized residuals for income and happiness for white subjects in the 2004 GSS. (a) Explain how to...

8.28. Refer to Exercise 8.13, on happiness and income. The analysis there does not take into account the ordinality of the variables. Using software: (a) Summarize the strength of association by...