251 search results - page 6 / 51 » Optimizing recursive queries in SQL |
EDBT
2009
ACM
15 years 2 months 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
15 years 9 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
15 years 2 months 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 ...
155
click to vote
ICDE
2000
IEEE
15 years 11 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
14 years 9 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...