Please use this identifier to cite or link to this item:
https://doi.org/10.1109/ICDE.2010.5447894
Title: | Optimized query evaluation using cooperative sorts | Authors: | Cao, Y. Bramandia, R. Chan, C.-Y. Tan, K.-L. |
Issue Date: | 2010 | Citation: | Cao, Y., Bramandia, R., Chan, C.-Y., Tan, K.-L. (2010). Optimized query evaluation using cooperative sorts. Proceedings - International Conference on Data Engineering : 601-612. ScholarBank@NUS Repository. https://doi.org/10.1109/ICDE.2010.5447894 | Abstract: | Many applications require sorting a table over multiple sort orders: generation of multiple reports from a table, evaluation of a complex query that involves multiple instances of a relation, and batch processing of a set of queries. In this paper, we study how multiple sortings of a table can be efficiently performed. We introduce a new evaluation technique, called cooperative sort, that exploits the relationships among the input set of sort orders to minimize I/O operations for the collection of sort operations. To demonstrate the efficiency of the proposed scheme, we implemented it in PostgreSQL and evaluated its performance using both TPC-DS benchmark and synthetic data. Our experimental results show significant performance improvement over the traditional non-cooperative sorting scheme. © 2010 IEEE. | Source Title: | Proceedings - International Conference on Data Engineering | URI: | http://scholarbank.nus.edu.sg/handle/10635/41624 | ISBN: | 9781424454440 | ISSN: | 10844627 | DOI: | 10.1109/ICDE.2010.5447894 |
Appears in Collections: | Staff Publications |
Show full item record
Files in This Item:
There are no files associated with this item.
SCOPUSTM
Citations
8
checked on Jun 21, 2022
WEB OF SCIENCETM
Citations
5
checked on Jun 21, 2022
Page view(s)
128
checked on Jun 23, 2022
Google ScholarTM
Check
Altmetric
Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.