251 search results - page 5 / 51 » Optimizing recursive queries in SQL |
ICDE
2006
IEEE
14 years 1 months ago
2006
IEEE
In this paper, we study SQL queries with aggregate subqueries that share common tables and conditions with the outer query. While several approaches can deal with such queries, th...
ICDE
2007
IEEE
14 years 8 months ago
2007
IEEE
Optimizing nested queries is an intricate problem. It becomes even harder if in a nested query the linking predicate or the correlation predicate occurs disjunctively. We present ...
SIGMOD
2004
ACM
14 years 7 months ago
2004
ACM
Existing SQL aggregate functions present important limitations to compute percentages. This article proposes two SQL aggregate functions to compute percentages addressing such lim...
SIGMOD
1997
ACM
13 years 11 months ago
1997
ACM
In this paper, we study a simple SQL extension that enables query writers to explicitly limit the cardinality of a query result. We examine its impact on the query optimization an...
VLDB
1998
ACM
13 years 11 months ago
1998
ACM
In a recent paper, we proposed adding a STOP AFTER clause to SQL to permit the cardinality of a query result to be explicitly limited by query writers and query tools. We demonstr...