{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,10,24]],"date-time":"2025-10-24T08:12:25Z","timestamp":1761293545587},"publisher-location":"Cham","reference-count":16,"publisher":"Springer International Publishing","isbn-type":[{"type":"print","value":"9783319557526"},{"type":"electronic","value":"9783319557533"}],"license":[{"start":{"date-parts":[[2017,1,1]],"date-time":"2017-01-01T00:00:00Z","timestamp":1483228800000},"content-version":"unspecified","delay-in-days":0,"URL":"http:\/\/www.springer.com\/tdm"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2017]]},"DOI":"10.1007\/978-3-319-55753-3_22","type":"book-chapter","created":{"date-parts":[[2017,3,21]],"date-time":"2017-03-21T03:38:10Z","timestamp":1490067490000},"page":"343-360","source":"Crossref","is-referenced-by-count":2,"title":["Optimizing Window Aggregate Functions in Relational Database Systems"],"prefix":"10.1007","author":[{"given":"Guangxuan","family":"Song","sequence":"first","affiliation":[]},{"given":"Jiansong","family":"Ma","sequence":"additional","affiliation":[]},{"given":"Xiaoling","family":"Wang","sequence":"additional","affiliation":[]},{"given":"Cheqing","family":"Jin","sequence":"additional","affiliation":[]},{"given":"Yu","family":"Cao","sequence":"additional","affiliation":[]}],"member":"297","published-online":{"date-parts":[[2017,3,22]]},"reference":[{"key":"22_CR1","doi-asserted-by":"crossref","unstructured":"Zuzarte, C., Pirahesh, H., Ma, W., Cheng, Q., Liu, L., Wong, K.: Winmagic: subquery elimination using window aggregation. In: Proceedings of the ACM SIGMOD International Conference on Management of Data, SIGMOD 2003, pp. 652\u2013656. ACM, New York (2003)","DOI":"10.1145\/872757.872840"},{"key":"22_CR2","doi-asserted-by":"crossref","unstructured":"Bellamkonda, S., Ahmed, R., Witkowski, A., Amor, A., Zait, M., Lin, C.-C.: Enhanced subquery optimizations in oracle. Proc. VLDB Endow. 2(2), 1366\u20131377 (2009)","DOI":"10.14778\/1687553.1687563"},{"key":"22_CR3","unstructured":"Ben-Gan, I.: Microsoft SQL Server High-Performance T-SQL Using Window Functions. Microsoft Press (2012)"},{"key":"22_CR4","doi-asserted-by":"crossref","unstructured":"Cao, Y., Bramandia, R., Chan, C.Y., Tan, K.-L.: Optimized query evaluation using cooperative sorts. In: Proceedings of the 26th International Conference on Data Engineering, ICDE, Long Beach, California, USA, pp. 601\u2013612. IEEE (2010)","DOI":"10.1109\/ICDE.2010.5447894"},{"issue":"11","key":"22_CR5","doi-asserted-by":"crossref","first-page":"1244","DOI":"10.14778\/2350229.2350243","volume":"5","author":"Y Cao","year":"2012","unstructured":"Cao, Y., Chan, C.-Y., Li, J., Tan, K.-L.: Optimization of analytic window functions. Proc. VLDB Endow. 5(11), 1244\u20131255 (2012)","journal-title":"Proc. VLDB Endow."},{"issue":"3","key":"22_CR6","doi-asserted-by":"crossref","first-page":"411","DOI":"10.1007\/s00778-011-0251-9","volume":"21","author":"Y Cao","year":"2012","unstructured":"Cao, Y., Bramandia, R., Chan, C.-Y., Tan, K.-L.: Sort-sharing-aware query processing. VLDB J. 21(3), 411\u2013436 (2012)","journal-title":"VLDB J."},{"key":"22_CR7","unstructured":"Window functions for postgresql desgin overview (2008). http:\/\/www.umitanuki.net\/pgsql\/wfv08\/design.html"},{"key":"22_CR8","unstructured":"Bellamkonda, S., Bozkaya, T., Ghosh, B., Gupta, A., Haydu, J., Subramanian, S., Witkowski, A.: Analytic functions in oracle 8i. Technical report (2000)"},{"issue":"3","key":"22_CR9","doi-asserted-by":"crossref","first-page":"411","DOI":"10.1007\/s00778-009-0171-0","volume":"19","author":"CQ Jin","year":"2010","unstructured":"Jin, C.Q., Yi, K., Chen, L., Yu, J.X., Lin, X.M.: Sliding-window top-k queries on uncertain streams. VLDB J. 19(3), 411\u2013435 (2010)","journal-title":"VLDB J."},{"key":"22_CR10","doi-asserted-by":"crossref","unstructured":"Li, J., Maier, D., Tufte, K., Papadimos, V., Tucker, P.A.: Semantics and evaluation techniques for window aggregates in data streams. In: Proceedings of the ACM SIGMOD International Conference on Management of Data, SIGMOD 2005, pp. 311\u2013322. ACM, New York (2005)","DOI":"10.1145\/1066157.1066193"},{"issue":"1","key":"22_CR11","doi-asserted-by":"crossref","first-page":"39","DOI":"10.1145\/1058150.1058158","volume":"34","author":"J Li","year":"2005","unstructured":"Li, J., Maier, D., Tufte, K., Papadimos, V., Tucker, P.A.: No pain, no gain:efficient evaluation og sliding-window aggregates over data streams. SIGMOD Rec. 34(1), 39\u201344 (2005)","journal-title":"SIGMOD Rec."},{"key":"22_CR12","doi-asserted-by":"crossref","unstructured":"Neumann, T., Moerkotte, G.: A combined framework for grouping, order optimization. In: Proceedings of the 30st International Conference on Very Large Data Bases, VLDB 2004, pp. 960\u2013971. VLDB Endowment (2004)","DOI":"10.1016\/B978-012088469-8.50084-X"},{"key":"22_CR13","doi-asserted-by":"crossref","unstructured":"Simmen, D., Shekita, E., Malkemus, T.: Fundamental techniques for order optimization. In: Proceedings of the 1996 ACM SIGMOD International Conference on Management of Data, SIGMOD 1996, pp. 57\u201367. ACM, NY (1996)","DOI":"10.1145\/233269.233320"},{"key":"22_CR14","doi-asserted-by":"crossref","unstructured":"Wang, X.Y., Chernicak, M.: Avoiding sorting, grouping in processing queries. In: Proceedings of the 29th International Conference on Very Large Data Bases, VLDB 2003, pp. 826\u2013837. VLDB Endowment (2003)","DOI":"10.1016\/B978-012722442-8\/50078-1"},{"issue":"10","key":"22_CR15","doi-asserted-by":"crossref","first-page":"1058","DOI":"10.14778\/2794367.2794375","volume":"8","author":"V Leis","year":"2015","unstructured":"Leis, V., Kan, K., Kemper, A., et al.: Efficient processing of window functions in analytical SQL queries. Proc. VLDB Endow. 8(10), 1058\u20131069 (2015)","journal-title":"Proc. VLDB Endow."},{"issue":"12","key":"22_CR16","doi-asserted-by":"crossref","first-page":"1221","DOI":"10.14778\/2994509.2994537","volume":"9","author":"R Wesley","year":"2016","unstructured":"Wesley, R., Xu, F.: Incremental computation of common windowed holistic aggregates. Proc. VLDB Endow. 9(12), 1221\u20131232 (2016)","journal-title":"Proc. VLDB Endow."}],"container-title":["Lecture Notes in Computer Science","Database Systems for Advanced Applications"],"original-title":[],"link":[{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/978-3-319-55753-3_22","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2017,6,25]],"date-time":"2017-06-25T13:05:09Z","timestamp":1498395909000},"score":1,"resource":{"primary":{"URL":"http:\/\/link.springer.com\/10.1007\/978-3-319-55753-3_22"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2017]]},"ISBN":["9783319557526","9783319557533"],"references-count":16,"URL":"https:\/\/doi.org\/10.1007\/978-3-319-55753-3_22","relation":{},"ISSN":["0302-9743","1611-3349"],"issn-type":[{"type":"print","value":"0302-9743"},{"type":"electronic","value":"1611-3349"}],"subject":[],"published":{"date-parts":[[2017]]}}}