Sciweavers

363 search results - page 16 / 73
» Analyzing Plan Diagrams of Database Query Optimizers
Sort
View
PVLDB
2010
123views more  PVLDB 2010»
13 years 6 months ago
Sharing-Aware Horizontal Partitioning for Exploiting Correlations During Query Processing
Optimization of join queries based on average selectivities is suboptimal in highly correlated databases. In such databases, relations are naturally divided into partitions, each ...
Kostas Tzoumas, Amol Deshpande, Christian S. Jense...
SIGMOD
1997
ACM
91views Database» more  SIGMOD 1997»
13 years 12 months ago
On Saying "Enough Already!" in SQL
In this paper, we study a simple SQL extension that enables query writers to explicitly limit the cardinality of a query result. We examine its impact on the query optimization an...
Michael J. Carey, Donald Kossmann
ICDE
1995
IEEE
112views Database» more  ICDE 1995»
14 years 9 months ago
Optimizing Queries with Materialized Views
While much work has addressed the problem of maintaining materialized views, the important question of optimizing queries in the presence of materialized views has not been resolv...
Surajit Chaudhuri, Ravi Krishnamurthy, Spyros Pota...
VLDB
2005
ACM
112views Database» more  VLDB 2005»
14 years 1 months ago
Content-Based Routing: Different Plans for Different Data
Query optimizers in current database systems are designed to pick a single efficient plan for a given query based on current statistical properties of the data. However, different...
Pedro Bizarro, Shivnath Babu, David J. DeWitt, Jen...
EDBT
2006
ACM
127views Database» more  EDBT 2006»
14 years 7 months ago
Progressive Query Optimization for Federated Queries
Federated queries are regular relational queries accessing data on one or more remote relational or non-relational data sources, possibly combining them with tables stored in the ...
Stephan Ewen, Holger Kache, Volker Markl, Vijaysha...