International Journal of Advanced Research in Computer Science and Software Engineering (IJARCSSE)
Query redirection provides a mechanism for BI Server to determine the set of Logical Table Sources (LTS) applicable to a logical request whenever a request can be satisfied by more than one LTS. The Oracle BI repository shipped in Oracle Fusion applications contains metadata content for real-time reporting analysis (using Transactional Business Intelligence) and historical reporting (using BI Applications).The proposed work represents query redirection method that improved K-means clustering algorithm performance and accuracy in distributed environment. In this paper, the authors have done analysis on k-mean and hierarchical algorithm by applying validation measures like entropy, f-measure, coefficient of variance and time. The experimental results show that k-mean algorithm performs better as compared to hierarchical algorithm and takes less time for execution.