- Research Article
- 10.1080/1206212x.2018.1474166
Multi connection query optimization in data warehouse dependent on multiple linear regression algorithm
- May 18, 2018
- International Journal of Computers and Applications
- Yuping Jin
ABSTRACTThe traditional query optimization method is to reduce the size of the intermediate relationship as much as possible when calculating the multi relation connection. It does not take into account the mass of data in the data warehouse, which is read mainly and the fact table is generally indexed often cannot obtain the disadvantage of the optimal effect, and puts forward the data warehouse suitable for frequent additions and deletions query environment. Multi connection query optimization in data warehouse, MCQODW) method: By using multiple linear regression algorithm to write the detection sequence of data, and then to optimize the data warehouse multi connection query without changing the sequence of other query detection sequences, in order to reduce repeated calculation. Theoretical analysis and experimental results show that the algorithm reduces significantly in the data warehouse multi join query optimization and execution time, and the method is effective.
Read more