Parallel Processing Hardware Options Explain

Implementing a data warehouse without parallel processing options is almost thinkable in the current slate of the technology. In summary, you will realize the following significant advantages when you adopt parallel processing in your data warehouse:

• Performance improvement for & piety processing, data loading, and index creation
• Scalability, allowing, the addition of CPUs Is and memory modules without any changes to the existing application
•  Fault tolerance so that the database would be available even when some of the parallel processors fail o Single logical view of the database even though the data may reside on the disks of multiple nodes

Query Tools

In a data warehouse, if there is one set of functional took that arc most significant, it is the set of query tools, the success of your data warehouse oil your query tools because of this data warehouse vendors have improved query tools during the past few years. We will discuss query toots in greater detail in Chapter 14. At this stage, just note the following functions for which vendors have greatly enhanced their query tools.

• Flexible presentations--- Easy to use and able to present results online and on reports in many different formats
• Aggregate awareness__ Able to recognize the existence of summary of aggregate in-ables and automatically route queries to the summitry tables when summarized results are desired
• Crossing subject areas—Able to cross over from one subject data mart to another automatically .
• Multiple heterogeneous sources—Capable of accessing heterogeneous data sources on different plat forms
• Integration—Integrate query tools for online queries, hatch reports, and data extraction for analysis and provide seamless hued-ace to go from one type of output to another
• Overcoming SQL limitations--Provide SQL extensions to handle requests that can-not usually be done through standard SQL.