Sciweavers

85 search results - page 1 / 17
» A Nested Relational Approach to Processing SQL Subqueries
Sort
View
SIGMOD
2005
ACM
133views Database» more  SIGMOD 2005»
14 years 4 months ago
A Nested Relational Approach to Processing SQL Subqueries
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...
Bin Cao, Antonio Badia
ICDE
2006
IEEE
213views Database» more  ICDE 2006»
14 years 5 months ago
Optimization of Complex Nested Queries in Relational Databases
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...
Bin Cao
ICDE
2003
IEEE
148views Database» more  ICDE 2003»
15 years 16 days ago
Efficient Computation of Subqueries in Complex OLAP
Expressing complex OLAP queries using group-by, aggregation, and joins can be extremely difficult. As a result of this, many alternate ways of expressing such queries have been de...
Michael H. Böhlen, Michael O. Akinde
EDBT
2009
ACM
135views Database» more  EDBT 2009»
14 years 3 months ago
Provenance for nested subqueries
Data provenance is essential in applications such as scientific computing, curated databases, and data warehouses. Several systems have been developed that provide provenance fun...
Boris Glavic, Gustavo Alonso
SIGMOD
2007
ACM
121views Database» more  SIGMOD 2007»
14 years 11 months ago
Execution strategies for SQL subqueries
Optimizing SQL subqueries has been an active area in database research and the database industry throughout the last decades. Previous work has already identified some approaches ...
César A. Galindo-Legaria, Milind Joshi, Mos...