Integrity constraints (ICs) provide a valuable tool for expressing and enforcing application
semantics. However, formulating constraints manually requires domain expertise, is prone to …

Dependencies play an important role in databases. We study order dependencies (ODs)--
and unidirectional order dependencies (UODs), a proper sub-class of ODs--which describe …

We investigate the parameters in terms of which the complexity of sublinear-time algorithms
should be expressed. Our goal is to find input parameters that are tailored to the …

Indexes in data systems accelerate data access by adding structure to otherwise
unstructured data at the cost of index construction and maintenance. Data systems, and …

Business-intelligence queries often involve SQL functions and algebraic expressions. There
can be clear semantic relationships between a column's values and the values of a function …

Indexing in modern data systems facilitates efficient query processing when the selection
predicate is on an indexed key. As new data is ingested, indexes are gradually populated …

In this paper, we utilize the perspective of property testing to consider the testability of
relational database queries. A primary motivation is the desire to avoid reading an entire …

Search trees, like B+-trees, are often used as index structures in data systems to improve
query performance at the cost of index construction and maintenance. Production data …

Indexes facilitate efficient querying when the selection predicate is on an indexed key. As a
result, when loading data, if we anticipate future selective (point or range) queries, we …

This paper studies the problem of how to conduct external sorting on flash drives while
avoiding intermediate writes to the disk. The focus is on sort in portable electronic devices …