{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,3,28]],"date-time":"2025-03-28T06:31:21Z","timestamp":1743143481362,"version":"3.40.3"},"publisher-location":"Cham","reference-count":23,"publisher":"Springer International Publishing","isbn-type":[{"type":"print","value":"9783319596648"},{"type":"electronic","value":"9783319596655"}],"license":[{"start":{"date-parts":[[2017,1,1]],"date-time":"2017-01-01T00:00:00Z","timestamp":1483228800000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.springer.com\/tdm"},{"start":{"date-parts":[[2017,1,1]],"date-time":"2017-01-01T00:00:00Z","timestamp":1483228800000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.springer.com\/tdm"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2017]]},"DOI":"10.1007\/978-3-319-59665-5_1","type":"book-chapter","created":{"date-parts":[[2017,5,23]],"date-time":"2017-05-23T01:42:54Z","timestamp":1495503774000},"page":"3-18","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":0,"title":["Similarity Aware Shuffling for the Distributed Execution of SQL Window Functions"],"prefix":"10.1007","author":[{"given":"F\u00e1bio","family":"Coelho","sequence":"first","affiliation":[]},{"given":"Miguel","family":"Matos","sequence":"additional","affiliation":[]},{"given":"Jos\u00e9","family":"Pereira","sequence":"additional","affiliation":[]},{"given":"Rui","family":"Oliveira","sequence":"additional","affiliation":[]}],"member":"297","published-online":{"date-parts":[[2017,5,24]]},"reference":[{"key":"1_CR1","unstructured":"ANSI: Information technology - database languages - SQL multimedia and application packages. Technical report, ANSI (2003). http:\/\/webstore.ansi.org\/RecordDetail.aspx?sku=ISO%2fIEC+13249-2%3a2003"},{"key":"1_CR2","unstructured":"Apache: The apache derby project. Technical report, Apache Foundation (2016). https:\/\/db.apache.org\/derby\/derby_charter.html"},{"key":"1_CR3","doi-asserted-by":"crossref","unstructured":"Brown, P.G., Hass, P.J.: BHUNT: automatic discovery of fuzzy algebraic constraints in relational data. In: Proceedings of the 29th International Conference on Very Large Data Bases, vol. 29, pp. 668\u2013679. VLDB Endowment (2003)","DOI":"10.1016\/B978-012722442-8\/50065-3"},{"issue":"11","key":"1_CR4","doi-asserted-by":"publisher","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 Endowment 5(11), 1244\u20131255 (2012)","journal-title":"Proc. VLDB Endowment"},{"key":"1_CR5","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"75","DOI":"10.1007\/978-3-319-39577-7_6","volume-title":"Distributed Applications and Interoperable Systems","author":"F Coelho","year":"2016","unstructured":"Coelho, F., Pereira, J., Vila\u00e7a, R., Oliveira, R.: Holistic shuffler for the parallel processing of SQL window functions. In: Jelasity, M., Kalyvianaki, E. (eds.) DAIS 2016. LNCS, vol. 9687, pp. 75\u201381. Springer, Cham (2016). doi:10.1007\/978-3-319-39577-7_6"},{"key":"1_CR6","unstructured":"Microsoft Corporation: Transact-SQL. Technical report, Microsoft Corporation (2013). https:\/\/msdn.microsoft.com\/library\/ms189461(SQL.130).aspx"},{"key":"1_CR7","unstructured":"Oracle Corporation: SQL analysis and reporting. Technical report, Oracle Corporation (2015). http:\/\/docs.oracle.com\/database\/121\/DWHSG\/analysis.htm#DWHSG8659"},{"key":"1_CR8","unstructured":"Cruz, F., Maia, F., Oliveira, R., Vila\u00e7a, R.: Workload-aware table splitting for NoSQL. In: Proceedings of the 29th Annual ACM Symposium on Applied Computing, SAC 2014, pp. 399\u2013404. ACM, New York (2014). http:\/\/doi.acm.org\/10.1145\/2554850.2555027"},{"issue":"2","key":"1_CR9","doi-asserted-by":"publisher","first-page":"6","DOI":"10.1145\/1366102.1366103","volume":"33","author":"W Fan","year":"2008","unstructured":"Fan, W., Geerts, F., Jia, X., Kementsietsidis, A.: Conditional functional dependencies for capturing data inconsistencies. ACM Trans. Database Syst. (TODS) 33(2), 6 (2008)","journal-title":"ACM Trans. Database Syst. (TODS)"},{"key":"1_CR10","doi-asserted-by":"crossref","unstructured":"Garofalakis, M., Keren, D., Samoladas, V.: Sketch-based geometric monitoring of distributed stream queries. Proc. VLDB Endowment 6(10), 937\u2013948 (2013). http:\/\/dx.doi.org\/10.14778\/2536206.2536220","DOI":"10.14778\/2536206.2536220"},{"key":"1_CR11","unstructured":"George, L.: HBase: The Definitive Guide: Random Access to Your Planet-Size Data. O\u2019Reilly Media, Inc., USA (2011)"},{"key":"1_CR12","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"61","DOI":"10.1007\/978-3-319-39577-7_5","volume-title":"Distributed Applications and Interoperable Systems","author":"RC Gon\u00e7alves","year":"2016","unstructured":"Gon\u00e7alves, R.C., Pereira, J., Jim\u00e9nez-Peris, R.: An RDMA middleware for asynchronous multi-stage shuffling in analytical processing. In: Jelasity, M., Kalyvianaki, E. (eds.) DAIS 2016. LNCS, vol. 9687, pp. 61\u201374. Springer, Cham (2016). doi:10.1007\/978-3-319-39577-7_5"},{"key":"1_CR13","unstructured":"Hadoop Apache: Hadoop (2009)"},{"key":"1_CR14","unstructured":"IBM: OLAP specification. Technical report, IBM (2013). http:\/\/www.ibm.com\/support\/knowledgecenter\/SSEPGG_10.5.0\/com.ibm.db2.luw.sql.ref.doc\/doc\/r0023461.html"},{"key":"1_CR15","doi-asserted-by":"crossref","unstructured":"Ilyas, I.F., Markl, V., Haas, P., Brown, P., Aboulnaga, A.: CORDS: automatic discovery of correlations and soft functional dependencies. In: Proceedings of the 2004 ACM SIGMOD International Conference on Management of Data, pp. 647\u2013658. ACM (2004)","DOI":"10.1145\/1007568.1007641"},{"key":"1_CR16","unstructured":"Jimenez-Peris, R., Pati\u00f1o-Martinez, M., Magoutis, K., Bilas, A., Brondino, I.: Cumulonimbo: a highly-scalable transaction processing platform as a service. ERCIM News 89(null), 34\u201335 (2012)"},{"key":"1_CR17","doi-asserted-by":"crossref","unstructured":"Kornacker, M., Behm, A., Bittorf, V., Bobrovytsky, T., Ching, C., Choi, A., Erickson, J., Grund, M., Hecht, D., Jacobs, M., et al.: Impala: a modern, open-source SQL engine for hadoop. In: CIDR, vol. 1, p. 9 (2015)","DOI":"10.1007\/978-3-658-11589-0_8"},{"key":"1_CR18","doi-asserted-by":"crossref","unstructured":"Leis, V., Kundhikanjana, K., Kemper, A., Neumann, T.: Efficient processing of window functions in analytical SQL queries. Proc. VLDB Endowment 8(10), 1058\u20131069 (2015). http:\/\/dx.doi.org\/10.14778\/2794367.2794375","DOI":"10.14778\/2794367.2794375"},{"key":"1_CR19","doi-asserted-by":"crossref","unstructured":"Liu, H., Xiao, D., Didwania, P., Eltabakh, M.Y.: Exploiting soft and hard correlations in big data query optimization. Proc. VLDB Endowment 9(12), 1005\u20131016 (2016). http:\/\/dx.doi.org\/10.14778\/2994509.2994519","DOI":"10.14778\/2994509.2994519"},{"key":"1_CR20","unstructured":"Postgresql: Advanced features - window functions. Technical report, Postgresql (2015). https:\/\/www.postgresql.org\/docs\/9.4\/static\/tutorial-window.html"},{"key":"1_CR21","unstructured":"SAP: SAP HANA SQL reference (2014). https:\/\/help.sap.com\/hana\/SAP_HANA_SQL_and_System_Views_Reference_en.pdf?original_fqdn=help.sap.de"},{"key":"1_CR22","unstructured":"Transaction Processing Performance Council: TPC Benchmark DS (2012). http:\/\/www.tpc.org\/tpcds\/spec\/tpcds_1.1.0.pdf"},{"key":"1_CR23","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 2003 ACM SIGMOD International Conference on Management of Data, pp. 652\u2013656. ACM (2003)","DOI":"10.1145\/872757.872840"}],"container-title":["Lecture Notes in Computer Science","Distributed Applications and Interoperable Systems"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/978-3-319-59665-5_1","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2021,4,20]],"date-time":"2021-04-20T00:29:23Z","timestamp":1618878563000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/978-3-319-59665-5_1"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2017]]},"ISBN":["9783319596648","9783319596655"],"references-count":23,"URL":"https:\/\/doi.org\/10.1007\/978-3-319-59665-5_1","relation":{},"ISSN":["0302-9743","1611-3349"],"issn-type":[{"type":"print","value":"0302-9743"},{"type":"electronic","value":"1611-3349"}],"subject":[],"published":{"date-parts":[[2017]]},"assertion":[{"value":"24 May 2017","order":1,"name":"first_online","label":"First Online","group":{"name":"ChapterHistory","label":"Chapter History"}},{"value":"DAIS","order":1,"name":"conference_acronym","label":"Conference Acronym","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"IFIP International Conference on Distributed Applications and Interoperable Systems","order":2,"name":"conference_name","label":"Conference Name","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Neuch\u00e2tel","order":3,"name":"conference_city","label":"Conference City","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Switzerland","order":4,"name":"conference_country","label":"Conference Country","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"2017","order":5,"name":"conference_year","label":"Conference Year","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"19 June 2017","order":7,"name":"conference_start_date","label":"Conference Start Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"22 June 2017","order":8,"name":"conference_end_date","label":"Conference End Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"17","order":9,"name":"conference_number","label":"Conference Number","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"dais2017","order":10,"name":"conference_id","label":"Conference ID","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"http:\/\/2017.discotec.org\/calls\/dais-2017","order":11,"name":"conference_url","label":"Conference URL","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"This content has been made available to all.","name":"free","label":"Free to read"}]}}