Parallel Processing
You know that the data warehouse is a user-centric and query-intensive environment. Your users will constantly he executing complex queries to perform all types or analyses. Each query would need to read large volumes or data to produce result sets. Analysis usually performed interactively. requires the execution or several queries, one after the other, by each user. if the data warehouse is not tuned properly for handling large, complex, simultaneous queries efficiently, the value of the data warehouse will be lost. Performance is of primary importance.
The other functions for which performance is crucial arc the functions of loading diva and creating indexes. Because of large volumes, loading or data can the slow again, indexing is usually elaborate in a data warehouse because of the need to access the data in many different ways. Because of large numbers of indexes, index creation could also be slow.
How do you speed sip query processing data loading, and index creation? A very effective way to do accomplish this is to use parallel processing. Both hardware configurations and software techniques go hand in hand to accomplish parallel processing. A task is divided into smaller units and these smaller units are executed concurrently.
You know that the data warehouse is a user-centric and query-intensive environment. Your users will constantly he executing complex queries to perform all types or analyses. Each query would need to read large volumes or data to produce result sets. Analysis usually performed interactively. requires the execution or several queries, one after the other, by each user. if the data warehouse is not tuned properly for handling large, complex, simultaneous queries efficiently, the value of the data warehouse will be lost. Performance is of primary importance.
The other functions for which performance is crucial arc the functions of loading diva and creating indexes. Because of large volumes, loading or data can the slow again, indexing is usually elaborate in a data warehouse because of the need to access the data in many different ways. Because of large numbers of indexes, index creation could also be slow.
How do you speed sip query processing data loading, and index creation? A very effective way to do accomplish this is to use parallel processing. Both hardware configurations and software techniques go hand in hand to accomplish parallel processing. A task is divided into smaller units and these smaller units are executed concurrently.
