Instruct: Identify the main and secondary category of Arxiv papers based on the titles and abstracts
Query: Optimizing Query Predicates with Disjunctions for Column Stores   Since its inception, database research has given limited attention to
optimizing predicates with disjunctions. What little past work there is has
focused on optimizations for traditional row-oriented databases. A key
difference in predicate evaluation for row stores and column stores is that
while row stores apply predicates to one record at a time, column stores apply
predicates to sets of records. Not only must the execution engine decide the
order in which to apply the predicates, but it must also decide how many times
each predicate should be applied and on which sets of records it should be
applied to. In our work, we tackle exactly this problem. We formulate, analyze,
and solve the predicate evaluation problem for column stores. Our results
include proofs about various properties of the problem, and in turn, these
properties have allowed us to derive the first polynomial-time (i.e., O(n log
n)) algorithm ShallowFish which evaluates predicates optimally for all
predicate expressions with a depth of 2 or less. We capture the exact property
which makes the problem more difficult for predicate expressions of depth 3 or
greater and propose an approximate algorithm DeepFish which outperforms
ShallowFish in these situations. Finally, we show that both ShallowFish and
DeepFish outperform the corresponding state of the art by two orders of
magnitude.

27
The categories of this paper are: comp-gas
18
The categories of this paper are: econ
15
The categories of this paper are: nucl-ex
31
The categories of this paper are: ao-sci
35
The categories of this paper are: mtrl-th
25
The categories of this paper are: patt-sol
23
The categories of this paper are: solv-int
30
The categories of this paper are: q-alg
0
The categories of this paper are: hep-ph
19
The categories of this paper are: eess
6
The categories of this paper are: astro-ph
26
The categories of this paper are: bayes-an
36
The categories of this paper are: cmp-lg
33
The categories of this paper are: plasm-ph
12
The categories of this paper are: nucl-th
28
The categories of this paper are: alg-geom