189 search results - page 1 / 38 » Translating and Optimizing SQL Queries Having Aggregates |
VLDB
1987
ACM
13 years 7 months ago
1987
ACM
is at least ae powerful as SQL. Two well known relational query languages that have a sound theoretical foundation are relational algebra and relational calculus. As SQL is more cl...
WWW
2002
ACM
14 years 5 months ago
2002
ACM
We present an algorithm for translating XSLT programs into SQL. Our context is that of virtual XML publishing, in which a single XML view is defined from a relational database, an...
SIGMOD
2004
ACM
14 years 4 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...
CC
2010
Springer
13 years 11 months ago
2010
Springer
Instead of writing SQL queries directly, programmers often prefer writing all their code in a general purpose programming language like Java and having their programs be automatica...
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...