Sciweavers

189 search results - page 20 / 38
» Translating and Optimizing SQL Queries Having Aggregates
Sort
View
SIGMOD
2002
ACM
120views Database» more  SIGMOD 2002»
16 years 1 months ago
Exploiting statistics on query expressions for optimization
Statistics play an important role in influencing the plans produced by a query optimizer. Traditionally, optimizers use statistics built over base tables and assume independence b...
Nicolas Bruno, Surajit Chaudhuri
93
Voted
ICDT
1999
ACM
97views Database» more  ICDT 1999»
15 years 6 months ago
Optimizing Large Join Queries in Mediation Systems
In data integration systems, queries posed to a mediator need to be translated into a sequence of queries to the underlying data sources. In a heterogeneous environment, with sour...
Ramana Yerneni, Chen Li, Jeffrey D. Ullman, Hector...
192
Voted
SIGMOD
2006
ACM
150views Database» more  SIGMOD 2006»
16 years 1 months ago
Automatic physical design tuning: workload as a sequence
The area of automatic selection of physical database design to optimize the performance of a relational database system based on a workload of SQL queries and updates has gained p...
Sanjay Agrawal, Eric Chu, Vivek R. Narasayya
WIDM
2004
ACM
15 years 7 months ago
A comprehensive solution to the XML-to-relational mapping problem
The use of relational database management systems (RDBMSs) to store and query XML data has attracted considerable interest with a view to leveraging their powerful and reliable da...
Sihem Amer-Yahia, Fang Du, Juliana Freire
PVLDB
2008
126views more  PVLDB 2008»
15 years 1 months ago
Parallelizing query optimization
Many commercial RDBMSs employ cost-based query optimization exploiting dynamic programming (DP) to efficiently generate the optimal query execution plan. However, optimization tim...
Wook-Shin Han, Wooseong Kwak, Jinsoo Lee, Guy M. L...