O'Reilly logo

DATA WAREHOUSING FUNDAMENTALS: A Comprehensive Guide for IT Professionals by Paulraj Ponniah

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

1.5. DATA WAREHOUSING-THE ONLY VIABLE SOLUTION

At this stage of our discussion, we now realize that we do need different types of decision-support systems to provide strategic information. The type of information needed for strategic decision making is different from that available from operational systems. We need a new type of system environment for the purpose of providing strategic information for analysis, discerning trends, and monitoring performance.

Let us examine the desirable features and processing requirements of this new type of system environment. Let us also consider the advantages of this type of system environment designed for strategic information.

1.5.1. A New Type of System Environment

The desired features of the new type of system environment are:

  • Database designed for analytical tasks

  • Data from multiple applications

  • Easy to use and conducive to long interactive sessions by users

  • Read-intensive data usage

  • Direct interaction with the system by the users without IT assistance

  • Content updated periodically and stable

  • Content to include current and historical data

  • Ability for users to run queries and get results online

  • Ability for users to initiate reports

1.5.2. Processing Requirements in the New Environment

Most of the processing in the new environment for strategic information will have to be analytical. There are four levels of analytical processing requirements:

  1. Running of simple queries and reports against current and historical data

  2. Ability to perform "what if ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required