Optimism Analysis of Parallel Queries in Databases Through Multicores
Apart from data management techniques such as datawarehousing and mining this paper focus mainly on parallelism optimization for peculiar queries for particular applications. Queries involved in day to day database application may of different types such as queries with multiple relations, queries with single relations and multiple operations, multiple queries with multiple relations. These queries consists usually many join (single and multiple) and aggregate operators. The existing Parallel processing methodologies that treat these kinds of queries are very sensitive to data distribution and involve more IO and Communication cost in processing. In order to overcome the issues an analysis is made how to cover parallelism on behalf on architectural basis.