KIAM Main page Web Library  •  Publication Searh  Русский 
Publication

KIAM Preprint № 25, Moscow, 2016
Authors: Kovalenko V. N., Kovalenko E. I.
Optimization of search queries with aggregation functions for the conditions of massive virtual integration of databases
Abstract:
The concept of virtual integration assumes that during a query execution the data from several databases are transferred via network to the integration system server where they are processed jointly. One of the possible directions of query optimization is reduction of the transmitted data amount. In this paper a method of optimization for the queries which calculate the aggregation functions of the SQL language (the sum, average et al.) is offered. Algorithms of optimizing transformation over the query execution plan and those ensuring the function evaluation directly in databases are presented. The experimental results have shown high efficiency of the proposed method.
Keywords:
database integration, query optimization, aggregation functions
Publication language: russian,  страниц: 18
Research direction:
Programming, parallel computing, multimedia
Russian source text:
View statistics (updated once a day)
over the last 30 days — 8 (-3), total hit from 01.09.2019 — 83