{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,2,21]],"date-time":"2025-02-21T03:41:54Z","timestamp":1740109314547,"version":"3.37.3"},"reference-count":33,"publisher":"Springer Science and Business Media LLC","issue":"12","license":[{"start":{"date-parts":[[2020,8,11]],"date-time":"2020-08-11T00:00:00Z","timestamp":1597104000000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.springer.com\/tdm"},{"start":{"date-parts":[[2020,8,11]],"date-time":"2020-08-11T00:00:00Z","timestamp":1597104000000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.springer.com\/tdm"}],"funder":[{"name":"This work is supported in part by the Ministries of Europe and Foreign Affairs (MEFA) and of Higher Education, Research and Innovation (MHERI). Amadeus Program 2020","award":["44086TD"],"award-info":[{"award-number":["44086TD"]}]}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":["Knowl Inf Syst"],"published-print":{"date-parts":[[2020,12]]},"DOI":"10.1007\/s10115-020-01501-z","type":"journal-article","created":{"date-parts":[[2020,8,11]],"date-time":"2020-08-11T18:04:01Z","timestamp":1597169041000},"page":"4653-4680","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":0,"title":["SLA-driven resource re-allocation for SQL-like queries in the cloud"],"prefix":"10.1007","volume":"62","author":[{"ORCID":"https:\/\/orcid.org\/0000-0002-7056-1175","authenticated-orcid":false,"given":"Mohamed Mehdi","family":"Kandi","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Shaoyi","family":"Yin","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Abdelkader","family":"Hameurlain","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"297","published-online":{"date-parts":[[2020,8,11]]},"reference":[{"unstructured":"Agarwal S, Kandula S, Bruno N, Wu MC, Stoica I, Zhou J (2012) Reoptimizing data parallel computing. In: Presented as part of the 9th $$\\{$$USENIX$$\\}$$ symposium on networked systems design and implementation ($$\\{$$NSDI$$\\}$$ 12), pp 281\u2013294","key":"1501_CR1"},{"doi-asserted-by":"crossref","unstructured":"Armbrust M, Xin RS, Lian C, Huai Y, Liu D, Bradley JK, Meng X, Kaftan T, Franklin MJ, Ghodsi A et\u00a0al (2015) Spark sql: Relational data processing in spark. In: Proceedings of the 2015 ACM SIGMOD international conference on management of data. ACM, pp 1383\u20131394","key":"1501_CR2","DOI":"10.1145\/2723372.2742797"},{"unstructured":"AWS (2020) Aws database. https:\/\/aws.amazon.com\/fr\/products\/databases\/. Accessed 15 Apr 2020","key":"1501_CR3"},{"unstructured":"AWS (2020) Aws elastic map reduce. https:\/\/aws.amazon.com\/emr\/. Accessed 15 Apr 2020","key":"1501_CR4"},{"unstructured":"Azure (2020) Azure database. https:\/\/azure.microsoft.com\/en-gb\/services\/ sql-database\/. Accessed 15 Apr 2020","key":"1501_CR5"},{"unstructured":"Azure (2020) Azure hdinsight. https:\/\/azure.microsoft.com\/en-gb\/services\/ hdinsight\/. Accessed 05 Apr 2020","key":"1501_CR6"},{"issue":"2","key":"1501_CR7","doi-asserted-by":"publisher","first-page":"1172","DOI":"10.1109\/TASE.2015.2503325","volume":"14","author":"J Bi","year":"2015","unstructured":"Bi J, Yuan H, Tan W, Zhou M, Fan Y, Zhang J, Li J (2015) Application-aware dynamic fine-grained resource provisioning in a virtualized cloud data center. IEEE Trans Autom Sci Eng 14(2):1172\u20131184","journal-title":"IEEE Trans Autom Sci Eng"},{"issue":"7","key":"1501_CR8","doi-asserted-by":"publisher","first-page":"743","DOI":"10.1080\/17517575.2013.830342","volume":"9","author":"J Bi","year":"2015","unstructured":"Bi J, Yuan H, Tie M, Tan W (2015) Sla-based optimisation of virtualised resource for multi-tier web applications in cloud data centres. Enterp Inf Syst 9(7):743\u2013767","journal-title":"Enterp Inf Syst"},{"doi-asserted-by":"crossref","unstructured":"Bouganim L, Kapitskaia O, Valduriez P (1998) Memory-adaptive scheduling for large query execution. In: Proceedings of the seventh international conference on information and knowledge management. ACM, pp 105\u2013115","key":"1501_CR9","DOI":"10.1145\/288627.288646"},{"issue":"11","key":"1501_CR10","doi-asserted-by":"publisher","first-page":"961","DOI":"10.14778\/2536222.2536223","volume":"6","author":"N Bruno","year":"2013","unstructured":"Bruno N, Jain S, Zhou J (2013) Continuous cloud-scale query optimization and processing. Proc VLDB Endow 6(11):961\u2013972","journal-title":"Proc VLDB Endow"},{"key":"1501_CR11","volume-title":"A guide to the SQL standard","author":"CJ Date","year":"1987","unstructured":"Date CJ, Darwen H (1987) A guide to the SQL standard, vol 3. Addison-Wesley, New York"},{"issue":"12","key":"1501_CR12","doi-asserted-by":"publisher","first-page":"1295","DOI":"10.14778\/2732977.2733002","volume":"7","author":"A Floratou","year":"2014","unstructured":"Floratou A, Minhas UF, \u00d6zcan F (2014) Sql-on-hadoop: full circle back to shared-nothing database architectures. Proc VLDB Endow 7(12):1295\u20131306","journal-title":"Proc VLDB Endow"},{"key":"1501_CR13","volume-title":"Database systems: the complete book","author":"H Garcia-Molina","year":"2008","unstructured":"Garcia-Molina H (2008) Database systems: the complete book. Pearson Education India, Noida"},{"unstructured":"Hive (2020) Hive testbench. https:\/\/github.com\/hortonworks\/hive-testbench. Accessed 15 Apr 2020","key":"1501_CR14"},{"key":"1501_CR15","volume-title":"On the propagation of errors in the size of join results","author":"YE Ioannidis","year":"1991","unstructured":"Ioannidis YE, Christodoulakis S (1991) On the propagation of errors in the size of join results, vol 20. ACM, New York"},{"key":"1501_CR16","doi-asserted-by":"publisher","first-page":"106","DOI":"10.1145\/276305.276315","volume":"27","author":"N Kabra","year":"1998","unstructured":"Kabra N, DeWitt DJ (1998) Efficient mid-query re-optimization of sub-optimal query execution plans. ACM SIGMOD Record ACM 27:106\u2013117","journal-title":"ACM SIGMOD Record ACM"},{"doi-asserted-by":"crossref","unstructured":"Kandi MM, Yin S, Hameurlain A (2018) An integer linear-programming based resource allocation method for sql-like queries in the cloud. In: Proceedings of the 33rd annual ACM symposium on applied computing. ACM, pp 161\u2013166","key":"1501_CR17","DOI":"10.1145\/3167132.3167148"},{"issue":"6","key":"1501_CR18","doi-asserted-by":"publisher","first-page":"654","DOI":"10.1504\/IJGUC.2019.102748","volume":"10","author":"MM Kandi","year":"2019","unstructured":"Kandi MM, Yin S, Hameurlain A (2019) Resource auto-scaling for sql-like queries in the cloud based on parallel reinforcement learning. Int J Grid Util Comput 10(6):654\u2013671","journal-title":"Int J Grid Util Comput"},{"doi-asserted-by":"crossref","unstructured":"Kllapi H, Sitaridi E, Tsangaris MM, Ioannidis Y (2011) Schedule optimization for data processing flows on the cloud. In: Proceedings of the 2011 ACM SIGMOD international conference on management of data. ACM, pp 289\u2013300","key":"1501_CR19","DOI":"10.1145\/1989323.1989355"},{"doi-asserted-by":"crossref","unstructured":"Nag B, DeWitt DJ (1998) Memory allocation strategies for complex decision support queries. In: Proceedings of the seventh international conference on information and knowledge management (CIKM), Citeseer, vol\u00a02. pp 116\u2013123","key":"1501_CR20","DOI":"10.1145\/288627.288647"},{"unstructured":"Notebookcheck (2020) The performance of the core i7-3630qm. https:\/\/www.notebookcheck.net\/Intel-Core-i7-3630QM-Notebook-Processor.80051.0.html. Accessed 15 Apr 2020","key":"1501_CR21"},{"unstructured":"Oracle (2020) Database reference db\\_block\\_size. https:\/\/docs.oracle.com\/ cd\/B19306_01\/server.102\/b14237\/initparams041.ht m#REFRN10031. Accessed 15 Apr 2020","key":"1501_CR22"},{"unstructured":"OSIRIM (2020) Osirim. https:\/\/osirim.irit.fr\/site\/fr\/articles\/description-slurm. Accessed 15 Apr 2020","key":"1501_CR23"},{"key":"1501_CR24","doi-asserted-by":"publisher","first-page":"118","DOI":"10.1016\/j.is.2019.03.003","volume":"83","author":"I Pietri","year":"2019","unstructured":"Pietri I, Chronis Y, Ioannidis Y (2019) Fairness in dataflow scheduling in the cloud. Inf Syst 83:118\u2013125. https:\/\/doi.org\/10.1016\/j.is.2019.03.003","journal-title":"Inf Syst"},{"doi-asserted-by":"crossref","unstructured":"Thusoo A, Sarma JS, Jain N, Shao Z, Chakka P, Zhang N, Antony S, Liu H, Murthy R (2010) Hive-a petabyte scale data warehouse using hadoop. In: 2010 IEEE 26th international conference on data engineering (ICDE). IEEE, pp 996\u20131005","key":"1501_CR25","DOI":"10.1109\/ICDE.2010.5447738"},{"unstructured":"TPC-H (2020) Tpc-h. http:\/\/www.tpc.org\/tpch\/. Accessed 15 Apr 2020","key":"1501_CR26"},{"doi-asserted-by":"crossref","unstructured":"Vavilapalli VK, Murthy AC, Douglas C, Agarwal S, Konar M, Evans R, Graves T, Lowe J, Shah H, Seth S et\u00a0al (2013) Apache hadoop yarn: yet another resource negotiator. In: Proceedings of the 4th annual symposium on cloud computing. ACM, p\u00a05","key":"1501_CR27","DOI":"10.1145\/2523616.2523633"},{"issue":"11","key":"1501_CR28","first-page":"2213","volume":"30","author":"S Yin","year":"2018","unstructured":"Yin S, Hameurlain A, Morvan F (2018) SLA definition for multi-tenant dbms and its impact on query optimization. IEEE Trans Knowl Data Eng 30(11):2213\u20132226","journal-title":"IEEE Trans Knowl Data Eng"},{"issue":"1","key":"1501_CR29","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1007\/BF01231797","volume":"2","author":"PS Yu","year":"1993","unstructured":"Yu PS, Cornell DW (1993) Buffer management based on return on consumption in a multi-query environment. VLDB J 2(1):1\u201338","journal-title":"VLDB J"},{"issue":"1","key":"1501_CR30","doi-asserted-by":"publisher","first-page":"337","DOI":"10.1109\/TASE.2016.2526781","volume":"14","author":"H Yuan","year":"2016","unstructured":"Yuan H, Bi J, Tan W, Li BH (2016) Temporal task scheduling with constrained service delay for profit maximization in hybrid clouds. IEEE Trans Autom Sci Eng 14(1):337\u2013348","journal-title":"IEEE Trans Autom Sci Eng"},{"issue":"3","key":"1501_CR31","doi-asserted-by":"publisher","first-page":"1138","DOI":"10.1109\/TASE.2017.2741965","volume":"15","author":"H Yuan","year":"2017","unstructured":"Yuan H, Bi J, Zhou M, Ammari AC (2017) Time-aware multi-application task scheduling with guaranteed delay constraints in green data center. IEEE Trans Autom Sci Eng 15(3):1138\u20131151","journal-title":"IEEE Trans Autom Sci Eng"},{"issue":"2","key":"1501_CR32","doi-asserted-by":"publisher","first-page":"729","DOI":"10.1109\/TASE.2018.2857206","volume":"16","author":"H Yuan","year":"2018","unstructured":"Yuan H, Bi J, Zhou M (2018) Spatial task scheduling for cost minimization in distributed green cloud data centers. IEEE Trans Autom Sci Eng 16(2):729\u2013740","journal-title":"IEEE Trans Autom Sci Eng"},{"doi-asserted-by":"publisher","unstructured":"Yuan H, Bi J, Zhou M (2019) Profit-sensitive spatial scheduling of multi-application tasks in distributed green clouds. IEEE Trans Autom Sci Eng PP(99):1\u201310. https:\/\/doi.org\/10.1109\/TASE.2019.2909866","key":"1501_CR33","DOI":"10.1109\/TASE.2019.2909866"}],"container-title":["Knowledge and Information Systems"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/s10115-020-01501-z.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/article\/10.1007\/s10115-020-01501-z\/fulltext.html","content-type":"text\/html","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/s10115-020-01501-z.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,11,6]],"date-time":"2022-11-06T15:13:42Z","timestamp":1667747622000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/s10115-020-01501-z"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2020,8,11]]},"references-count":33,"journal-issue":{"issue":"12","published-print":{"date-parts":[[2020,12]]}},"alternative-id":["1501"],"URL":"https:\/\/doi.org\/10.1007\/s10115-020-01501-z","relation":{},"ISSN":["0219-1377","0219-3116"],"issn-type":[{"type":"print","value":"0219-1377"},{"type":"electronic","value":"0219-3116"}],"subject":[],"published":{"date-parts":[[2020,8,11]]},"assertion":[{"value":"22 July 2019","order":1,"name":"received","label":"Received","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"21 July 2020","order":2,"name":"revised","label":"Revised","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"25 July 2020","order":3,"name":"accepted","label":"Accepted","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"11 August 2020","order":4,"name":"first_online","label":"First Online","group":{"name":"ArticleHistory","label":"Article History"}}]}}