Paper Info
Title
An experimental study of time-constrained aggregate queries
Abstract
Although the notion of time-constrained query was first introduced two decades ago to address the problem of long running SQL queries, none of the commercial database systems support such a feature. This is rather surprising given the fact that database systems are beginning to accommodate large datasets in the order of terabytes to petabytes. Thus, the long running SQL query problem needs to be addressed. Recently, at Oracle we investigated and proposed a mechanism of supporting time-constrained quenes to provide quick approximate answers by use of sampling for such long running SQL quenes. This we followed up by coming up with error estimates as a measure of goodness for the approximation. To further validate our time-constrained query work, in this paper we present an experimental study conducted on our time-constrained query prototype built on the Oracle Database. It is our hope that this work will revive interest in time-constrained queries.
Year
DOI
Venue
2010
10.1145/1739041.1739123
EDBT
Keywords
Field
DocType
time-constrained quenes,oracle database,time-constrained aggregate query,sql query problem,time-constrained query work,database system,time-constrained query prototype,experimental study,time-constrained query,sql query,commercial database system,sql quenes,masking,privacy,usability,security
Query optimization,SQL,Data mining,Alias,Computer science,Petabyte,Oracle,View,Query by Example,Spatial query,Database
Conference
Citations 
PageRank 
References 
1
0.37
14
Authors
4
Name
Order
Citations
PageRank
Ying Hu131228.67
Wen-Chi Hou2387274.15
seema sundara31057.97
Jagannathan Srinivasan439744.67