189 search results - page 2 / 38 » Translating and Optimizing SQL Queries Having Aggregates |
IEEECSA
2009
13 years 2 months ago
2009
- The SQL language allows users to express queries that have nested subqueries in them. Optimization of nested queries has received considerable attention over the last few years. ...
DAWAK
2003
Springer
13 years 10 months ago
2003
Springer
We introduce a new method for optimization of SQL queries with nested subqueries. The method is based on the idea of Boolean aggregates, aggregates that compute the conjunction or ...
SIGMOD
2005
ACM
13 years 10 months ago
2005
ACM
One of the most powerful features of SQL is the use of nested queries. Most research work on the optimization of nested queries focuses on aggregate subqueries. However, the solut...
SIGMOD
2006
ACM
14 years 4 months ago
2006
ACM
Although it has been acknowledged for many years that querying and updating time-varying information using standard (i.e., non-temporal) SQL is a challenging task, the proposed te...
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...