251 search results - page 6 / 51 » Optimizing recursive queries in SQL |
EDBT
2009
ACM
14 years 3 days ago
2009
ACM
We consider a near future scenario in which users of a Web 2.0 application, such as a social network, contribute to the application not only data, but also rules which automatical...
SIGMOD
2001
ACM
14 years 7 months ago
2001
ACM
Time-referenced data are pervasive in most real-world databases. Recent advances in temporal query languages show that such database applications may benefit substantially from bu...
DAWAK
2003
Springer
14 years 21 days ago
2003
Springer
Abstract. Many SQL queries with aggregated subqueries exhibit redundancy (overlap in FROM and WHERE clauses). We propose a method, called the for-loop, to optimize such queries by ...
ICDE
2000
IEEE
14 years 8 months ago
2000
IEEE
Statistics play a key role in influencing the quality of plans chosen by a database query optimizer. In this paper, we identify the statistics that are essential for an optimizer....
BIRTHDAY
2010
Springer
13 years 7 months ago
2010
Springer
Abstract. Current peer-to-peer (p2p) systems place the burden of application-level query execution on the application developer. Not only do application developers lack the experti...