Question: When compared to process-specific flat files, state three organisational benefits of using a centralised relational database. (i) Describe what is meant by online analytic processing

When compared to process-specific flat files, state three organisational benefits of using a centralised relational database.

(i) Describe what is meant by online analytic processing (OLAP) and using two examples describe when OLAP can be effectively used.

(ii) Explain a key difference between OLAP and data mining.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Organizational Benefits of Using a Centralized Relational Database 1 Data Consistency and Integrity Centralized relational databases ensure data consi... 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...

1. Discuss the key factors that caused the great depression 2. What was the new deal? List major legislation passed to combat the depression. 3. Explain and describe importance of key interest rates...

The rise of data sciences and artificial intelligence means that data has become the modern currency. From this perspective, the data management systems are essential to the working of modern...

Given that log 10 (x 2 y) = 4 and log 10 (x 4 /y 3 ) = 18, find the value of log 10 x and of log 10 y.

Consider the relations r1 (A, B, C), r2 (C, D, E), and r3 (E, F) of Exercise. Assume that there are no primary keys, except the entire schema. Let V (C, r1) be 900, V (C, r2) be 1100, V (E, r2) be...

What do you learn about the privacy of your emails on your work servers?

Will other people benefit if I act according to this value?

One thousand liters of a 95 wt% glycerol5% water solution is to be diluted to 60% glycerol by adding a 35% solution pumped from a large storage tank through a 5-cm ID pipe at a steady rate. The pipe...

PLEASE Respond! Calculate the taxable income for Alex Santander: FORM 1040 DATA TAX YEAR 2021 ALEX SANTANDER IS SINGLE. SHE IS 47 YEARS OLD AND IS A CONSULTANT. SHE HAS ONE CHILD, AGE 8, THAT LIVES...

For each of the following cases, respond to the question and indicate the accounting principle or concept that applies. 1. Williamson, LLC, paid insurance premiums of $8,400 on December 1, 2019....

needhelp asap Datribution of Aesource Cociunespit: The ariount of octieny far the yeor is as folows.custimes who placed four orden in a yoa? a $ \$ 1208 $ h. $ \mathbf{s t a , t a t} $ C \( \$...

What are the specific activities that could make up your project? pleaselist the activities with their information on immediate predecessor andcompletion time, in both a table, and PERT chart.

from your own experience, describe a situation in which you provided a double message. Did you intentionally provide it?

Free vibration of two rotor system The flywheel of an engine driving a dynamo has mass of 200kg and has a radius of gyration of 30cm. The shaft at the flywheel end has as an effective length of 25cm...

All-A-Buzz makes three products from a joint production process using honey. Joint cost for the process for the year is $246,400. Per Unit Incremental Units of Selling Price Processing Final Sales...

You are the dealer in one of the reputable banks and one of your roles is related to trading and monitoring of changes in the derivative markets. You are interested in one stock for Bally...

a. Depreciation on the company's equipment for 2017 is computed to be $16.000. b. The Prepaid Insurance account had a $7,000 debit balance at December 31, 2017, before adjusting for the costs of any...

Create a data model for one of the processes in the end-of-chapter Exercises for Chapter 4. Explain how you would balance the data model and process model.

Identify several alternate processing arrangements that might be included in a disaster recovery plan.

A CPAs audit working papers contain a narrative description of a segment of the Croyden Factory, Inc., payroll system and an accompanying flowchart as follows: The internal control system with...

What role does an organizations control environment play in information systems security? Give several specific examples.

Burger Master bought the food concession for a baseball stadium for five years at a price of $1.2 million. If the operating profit is $400,000 per year, what IRR will Burger Master realize on its...

A venture requiring an immediate investment of $500,000 and an additional investment of $200,000 three years from now will generate annual profits of $150,000 for seven years starting in the first...

A machine can be leased for four years at $1000 per month payable at the beginning of each month. Alternatively, it can be purchased for $45,000 and sold for $5000 after four years. Should the...