AN EFFECTIVE ADAPTIVE APPROACH FOR JOINING DATA IN DATA WAREHOUSE

Sudha.S, Manikandan.S

Abstract: Formulation of efficient assessment is important for the businesses, because its retrieve lot of details from the data warehouse. In Data warehouses have materialize as original business information pattern where data store and maintain in concurrent. The adaptations are requiring in the implementation of Extract Transform Load (ETL) operations. The several methods are included to joining stream and produce the innovative relation .The previous work was used the adaptive join in data warehouse using ETL procedure. This approach was common conspire, which create many possible solution. But the drawback of the previous approach is its not consider exact reproduction. To rise above the question, we are going to present genetic algorithm for joining stream of data . Several queries and streams are combined in data warehouse the selection of exact grouping of multiple associations are complete via genetic algorithm. The crossover as well as mutation prefer the paramount consortium of several associations of link for by retrieving the data and produces the output in data warehouse. The performance of the proposed genetic algorithm used to deliver efficient highest join data and increase the scalability

Keywords: join, stream, relation, Genetic algorithm.

DOI: https://doi.org/10.15623/ijret.2014.0319046