Describe the data redundancy difference between operational and analytical database systems

What will be an ideal response?


Reducing the redundancy of information is a major goal of operational databases. One of the main reasons for minimizing the redundancy in operational databases is to eliminate the possibility of update anomalies. However, the updating of data by the end users is not allowed in analytical databases, and therefore, there is no particular danger of update anomalies. Hence, eliminating redundancy is not as critical in analytical databases as it is in operational databases.

Business

You might also like to view...

Thinking Cap Corp. prices its various cap designs at different price levels, ranging from $2.05 to $5.95. This is an example of optional product pricing

Indicate whether the statement is true or false

Business

Global corporations, due to their integrative international focus, must manage their human capital through a transnational HRM system. What are the three attributes of this HRM system?

What will be an ideal response?

Business

The doctrine of undue influence, by which a court may permit the rescission of a contract, is a(n) ________ doctrine.

A. law B. equitable C. statutory D. constitutional

Business

The level of risk associated with future expected dividends affects dividend policies of companies around the world.?

Answer the following statement true (T) or false (F)

Business