26 search results - page 1 / 6 » Redundancy Awareness in SQL Queries |
ICDE
2006
IEEE
13 years 10 months ago
2006
IEEE
Due to the flexible structures of SQL, no general approach works efficiently for all kinds of queries. Some special kinds of queries can be further optimized for better performa...
ICDE
2006
IEEE
13 years 10 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...
DAWAK
2003
Springer
13 years 9 months ago
2003
Springer
Abstract. Many SQL queries with aggregated subqueries exhibit redundancy (overlap in FROM and WHERE clauses). We propose a method, called the for-loop, to optimize such queries by ...
PVLDB
2010
13 years 3 months ago
2010
In this paper, we present SnipSuggest, a system that provides onthe-go, context-aware assistance in the SQL composition process. SnipSuggest aims to help the increasing population...
SIGMOD
2006
ACM
14 years 4 months ago
2006
ACM
Consider an XML view defined over a relational database, and a user query specified over this view. This user XML query is typically processed using the following steps: (a) our t...