Efficient Execution of Conjunctive Complex Queries on Big Multimedia Databases
Karina Fasolin, Renato Fileto, Marcelo Krugery, Daniel S. Kasterz, Monica R. P. Ferreirax, Robson L. F. Cordeirox, Agma J. M. Traina, Caetano Traina · 2013
This paper proposes an approach to efficientlyexecute conjunctive queries on big complex data together withtheir related conventional data. The basic idea is to horizontallyfragment the database according to criteria frequently usedin query predicates. The collection of fragments is indexed toefficiently find the fragment(s) whose contents satisfy some querypredicate(s). The contents of each fragment are then indexed aswell, to support efficient filtering of the fragment data according to other query predicate s) conjunctively connected to the former. This strategy has been applied to a collection of more than 106 million images together with their related conventional data. Experimental results show considerable performance gain of the proposed approach for queries with conventional and similaritybasedpredicates, compared to the use of a unique metric index for the entire database contents.