{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,2,8]],"date-time":"2026-02-08T07:39:46Z","timestamp":1770536386541,"version":"3.49.0"},"reference-count":12,"publisher":"Elsevier","isbn-type":[{"value":"9780127224428","type":"print"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2003]]},"DOI":"10.1016\/b978-012722442-8\/50078-1","type":"book-chapter","created":{"date-parts":[[2007,9,4]],"date-time":"2007-09-04T08:42:39Z","timestamp":1188895359000},"page":"826-837","source":"Crossref","is-referenced-by-count":17,"title":["Avoiding Sorting and Grouping In Processing Queries"],"prefix":"10.1016","author":[{"given":"Xiaoyu","family":"Wang","sequence":"first","affiliation":[]},{"given":"Mitch","family":"Cherniack","sequence":"additional","affiliation":[]}],"member":"78","reference":[{"key":"10.1016\/B978-012722442-8\/50078-1_bib1","series-title":"Tenth International Conference on Very Large Data Bases","first-page":"323","article-title":"Hashing methods and relational algebra operations","author":"Bratbergsengen","year":"1984"},{"key":"10.1016\/B978-012722442-8\/50078-1_bib2","series-title":"Proceedings of the Twentieth International Conference on Very Large Databases","first-page":"354","article-title":"Including Group-By in Query Optimization","author":"Chaudhuri","year":"1994"},{"issue":"3","key":"10.1016\/B978-012722442-8\/50078-1_bib3","doi-asserted-by":"crossref","first-page":"190","DOI":"10.1007\/s007780000030","article-title":"Exploiting early sorting and early partitioning for decision support query processing","volume":"9","author":"Claussen","year":"2000","journal-title":"VLDB Journal: Very Large Data Bases"},{"key":"10.1016\/B978-012722442-8\/50078-1_bib4","series-title":"Relational Database Writings 1989\u20131991","article-title":"The role of functional dependencies in query decomposition","author":"Darwen","year":"1992"},{"key":"10.1016\/B978-012722442-8\/50078-1_bib5","series-title":"Order-preserving hash joins: Sorting (almost) for free","author":"Kossmann","year":"1998"},{"key":"10.1016\/B978-012722442-8\/50078-1_bib6","series-title":"Proc. ACM SIGMOD Int'l Conference on Management of Data","first-page":"23","article-title":"Access path selection in a relational database management system","author":"Griffiths Selinger","year":"1979"},{"key":"10.1016\/B978-012722442-8\/50078-1_bib7","article-title":"Database System Concepts","author":"Silberschatz","year":"2001"},{"key":"10.1016\/B978-012722442-8\/50078-1_bib8","series-title":"Proc. ACM SIGMOD Int'l Conference on Management of Data","article-title":"Fundamental techniques for order optimization","author":"Simmen","year":"1996"},{"issue":"2","key":"10.1016\/B978-012722442-8\/50078-1_bib9","doi-asserted-by":"crossref","first-page":"5","DOI":"10.1145\/565117.565119","article-title":"Bringing order to query optimization","volume":"31","author":"Slivinskas","year":"2002","journal-title":"ACM SIGMOD Record"},{"issue":"1","key":"10.1016\/B978-012722442-8\/50078-1_bib10","doi-asserted-by":"crossref","first-page":"125","DOI":"10.1109\/69.50912","article-title":"The implementation of postgres","volume":"2","author":"Stonebraker","year":"1990","journal-title":"Transactions in Knowledge and Data Engineering"},{"key":"10.1016\/B978-012722442-8\/50078-1_bib11","article-title":"Avoiding ordering and grouping during query processing","author":"Wang","year":"2003","journal-title":"Brandeis Technical Report"},{"key":"10.1016\/B978-012722442-8\/50078-1_bib12","series-title":"Proceedings of the 10th IEEE International Conference on Data Engineering","first-page":"89","article-title":"Performing group-by before join","author":"Yan","year":"1994"}],"container-title":["Proceedings 2003 VLDB Conference"],"original-title":[],"language":"en","deposited":{"date-parts":[[2019,1,4]],"date-time":"2019-01-04T16:22:10Z","timestamp":1546618930000},"score":1,"resource":{"primary":{"URL":"https:\/\/linkinghub.elsevier.com\/retrieve\/pii\/B9780127224428500781"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2003]]},"ISBN":["9780127224428"],"references-count":12,"URL":"https:\/\/doi.org\/10.1016\/b978-012722442-8\/50078-1","relation":{},"subject":[],"published":{"date-parts":[[2003]]}}}