Sciweavers

251 search results - page 7 / 51
» Optimizing recursive queries in SQL
Sort
View
ICDE
2007
IEEE
119views Database» more  ICDE 2007»
14 years 1 months ago
Stream Variables: A Quick but not Dirty SQL Extension for Continuous Queries
The ability to query data streams is of increasing importance and has been identified as a crucial element for modern organizations and agencies. This paper identifies a class o...
Damianos Chatziantoniou, Yannis Sotiropoulos
IDEAS
2009
IEEE
176views Database» more  IDEAS 2009»
14 years 2 months ago
Evaluation of skyline algorithms in PostgreSQL
In this paper, we present our work on evaluating the skyline algorithms BNL, SFS, and a variant of LESS in PostgreSQL. It is well known that the performance of skyline queries is ...
Hannes Eder, Fang Wei
SIGMOD
2000
ACM
141views Database» more  SIGMOD 2000»
13 years 12 months ago
Counting, Enumerating, and Sampling of Execution Plans in a Cost-Based Query Optimizer
Testing an SQL database system by running large sets of deterministic or stochastic SQL statements is common practice in commercial database development. However, code defects oft...
Florian Waas, César A. Galindo-Legaria
SIGMOD
2007
ACM
121views Database» more  SIGMOD 2007»
14 years 7 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...
SIGMOD
2005
ACM
133views Database» more  SIGMOD 2005»
14 years 1 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