{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,3,27]],"date-time":"2025-03-27T07:12:47Z","timestamp":1743059567130,"version":"3.40.3"},"publisher-location":"Cham","reference-count":20,"publisher":"Springer International Publishing","isbn-type":[{"type":"print","value":"9783030519643"},{"type":"electronic","value":"9783030519650"}],"license":[{"start":{"date-parts":[[2020,1,1]],"date-time":"2020-01-01T00:00:00Z","timestamp":1577836800000},"content-version":"tdm","delay-in-days":0,"URL":"http:\/\/www.springer.com\/tdm"},{"start":{"date-parts":[[2020,1,1]],"date-time":"2020-01-01T00:00:00Z","timestamp":1577836800000},"content-version":"vor","delay-in-days":0,"URL":"http:\/\/www.springer.com\/tdm"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2020]]},"DOI":"10.1007\/978-3-030-51965-0_21","type":"book-chapter","created":{"date-parts":[[2020,8,8]],"date-time":"2020-08-08T15:04:30Z","timestamp":1596899070000},"page":"248-260","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":1,"title":["PeBAO: A Performance Bottleneck Analysis and Optimization Framework in Concurrent Environments"],"prefix":"10.1007","author":[{"given":"Di","family":"Chen","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Hui","family":"Li","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Mei","family":"Chen","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Zhenyu","family":"Dai","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Huanjun","family":"Li","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Ming","family":"Zhu","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Jian","family":"Zhang","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"297","published-online":{"date-parts":[[2020,8,9]]},"reference":[{"unstructured":"Myalapalli, V.K., Savarapu, P.R.: High performance SQL. In: 11th IEEE International Conference on Emerging Trends in Innovation and Technology, December 2014, Conference 2016, Pune, India. LNCS, vol. 9999, pp. 1\u201313. Springer, Heidelberg (2016)","key":"21_CR1"},{"doi-asserted-by":"crossref","unstructured":"Myalapalli, V.K., Chakravarthy, A.S.N., Reddy, K.P.: Accelerating SQL queries by unravelling performance bottlenecks in DBMS engine. In: 2015 International Conference on Energy Systems and Applications, pp. 7\u201312 (2015)","key":"21_CR2","DOI":"10.1109\/ICESA.2015.7503304"},{"unstructured":"Myalapalli, V.K., Shiva, M.B.: An appraisal to optimize SQL queries. In: International Conference on Pervasive Computing (ICPC), pp. 1\u20136, Pune 2015 (2015)","key":"21_CR3"},{"doi-asserted-by":"crossref","unstructured":"Myalapalli, V.K., Teja, B.L.R.: High performance PL\/SQL programming. In: 2015 International Conference on Pervasive Computing (ICPC), pp. 1\u20135 (2015)","key":"21_CR4","DOI":"10.1109\/PERVASIVE.2015.7087004"},{"doi-asserted-by":"crossref","unstructured":"Myalapalli, V.K., Totakura, T.P., Geloth, S.: Augmenting database performance via SQL tuning. In: 2015 International Conference on Energy Systems and Applications, pp. 13\u201318 (2015)","key":"21_CR5","DOI":"10.1109\/ICESA.2015.7503305"},{"unstructured":"Myalapalli, V.K., Padma, T., Totakura, K.: Overhauling PL\/SQL applications for optimized performance. Int. J. Innov. Res. Sci. Eng. Technol. 4(9) (2015)","key":"21_CR6"},{"key":"21_CR7","volume-title":"Mastering Oracle SQL","author":"S Mishra","year":"2002","unstructured":"Mishra, S., Beaulieu, A.: Mastering Oracle SQL, 1st edn. O\u2019Reilly, Massachusetts (2002)","edition":"1"},{"key":"21_CR8","volume-title":"SQL Demystified","author":"A Oppel","year":"2005","unstructured":"Oppel, A.: SQL Demystified, 1st edn. McGraw-Hill, New York (2005)","edition":"1"},{"unstructured":"Zhang, G., Chen, M., Liu, L.: A model for application-oriented database performance tuning. In: 2012 6th International Conference on New Trends in Information Science, Service Science and Data Mining (ISSDM2012), Taipei, pp. 389\u2013394 (2012)","key":"21_CR9"},{"doi-asserted-by":"crossref","unstructured":"Myalapalli, V.K., Chakravarthy, A.S.N.: Revamping SQL queries for cost based optimization. In: 2016 International Conference on Circuits, Controls, Communications and Computing (I4C), pp. 1\u20136 (2016)","key":"21_CR10","DOI":"10.1109\/CIMCA.2016.8053263"},{"doi-asserted-by":"crossref","unstructured":"Weiner, A.M., H\u00e4rder, T., Oliveira da Silva, R.: Visualizing cost-based XQuery optimization. In: 2010 IEEE 26th International Conference on Data Engineering (ICDE 2010), Long Beach, CA, pp. 1165\u20131168 (2010)","key":"21_CR11","DOI":"10.1109\/ICDE.2010.5447784"},{"unstructured":"Zhou, S., Tomov, N., Williams, H.W., Burger, A., Taylor, H.: Cache modelling in a performance evaluator for parallel database systems. In: Proceedings Fifth International Symposium on Modeling, Analysis, and Simulation of Computer and Telecommunication Systems, Haifa, Israel, pp. 46\u201350 (1997)","key":"21_CR12"},{"issue":"1","key":"21_CR13","doi-asserted-by":"publisher","first-page":"153","DOI":"10.1109\/69.667100","volume":"10","author":"JE Cook","year":"1998","unstructured":"Cook, J.E., Wolf, A.L., Zorn, B.G.: A highly effective partition selection policy for object database garbage collection. IEEE Trans. Knowl. Data Eng. 10(1), 153\u2013172 (1998)","journal-title":"IEEE Trans. Knowl. Data Eng."},{"doi-asserted-by":"crossref","unstructured":"Abul-Basher, Z.: Multiple-query optimization of regular path queries. In: 2017 IEEE 33rd International Conference on Data Engineering (ICDE), San Diego, CA, pp. 1426\u20131430 (2017)","key":"21_CR14","DOI":"10.1109\/ICDE.2017.205"},{"unstructured":"Pt-query-digest. \nhttps:\/\/www.percona.com\/doc\/percona-toolkit\/3.0\/pt-query-digest.html","key":"21_CR15"},{"unstructured":"MyProfi. \nhttps:\/\/github.com\/MarcusSchwarz\/myprofi","key":"21_CR16"},{"unstructured":"Mysqlsla. \nhttps:\/\/github.com\/daniel-nichter\/hackmysql.com\/tree\/master\/mysqlsla","key":"21_CR17"},{"unstructured":"SQLAdvisor. \nhttps:\/\/github.com\/Meituan-Dianping\/SQLAdvisor","key":"21_CR18"},{"unstructured":"SQLautoreview. \nhttps:\/\/github.com\/taobao\/sqlautoreview","key":"21_CR19"},{"unstructured":"SOAR. \nhttps:\/\/github.com\/XiaoMi\/soar","key":"21_CR20"}],"container-title":["Advances in Intelligent Systems and Computing","Intelligent Algorithms in Software Engineering"],"original-title":[],"language":"en","link":[{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/978-3-030-51965-0_21","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2020,8,8]],"date-time":"2020-08-08T15:16:33Z","timestamp":1596899793000},"score":1,"resource":{"primary":{"URL":"http:\/\/link.springer.com\/10.1007\/978-3-030-51965-0_21"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2020]]},"ISBN":["9783030519643","9783030519650"],"references-count":20,"URL":"https:\/\/doi.org\/10.1007\/978-3-030-51965-0_21","relation":{},"ISSN":["2194-5357","2194-5365"],"issn-type":[{"type":"print","value":"2194-5357"},{"type":"electronic","value":"2194-5365"}],"subject":[],"published":{"date-parts":[[2020]]},"assertion":[{"value":"9 August 2020","order":1,"name":"first_online","label":"First Online","group":{"name":"ChapterHistory","label":"Chapter History"}},{"value":"CSOC","order":1,"name":"conference_acronym","label":"Conference Acronym","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Computer Science On-line Conference","order":2,"name":"conference_name","label":"Conference Name","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Zlin","order":3,"name":"conference_city","label":"Conference City","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Czech Republic","order":4,"name":"conference_country","label":"Conference Country","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"2020","order":5,"name":"conference_year","label":"Conference Year","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"15 July 2020","order":7,"name":"conference_start_date","label":"Conference Start Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"15 July 2020","order":8,"name":"conference_end_date","label":"Conference End Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"9","order":9,"name":"conference_number","label":"Conference Number","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"csolc2020","order":10,"name":"conference_id","label":"Conference ID","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"http:\/\/csoc.openpublish.eu","order":11,"name":"conference_url","label":"Conference URL","group":{"name":"ConferenceInfo","label":"Conference Information"}}]}}