{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,3,26]],"date-time":"2026-03-26T15:44:23Z","timestamp":1774539863921,"version":"3.50.1"},"publisher-location":"Cham","reference-count":28,"publisher":"Springer International Publishing","isbn-type":[{"value":"9783030726508","type":"print"},{"value":"9783030726515","type":"electronic"}],"license":[{"start":{"date-parts":[[2021,1,1]],"date-time":"2021-01-01T00:00:00Z","timestamp":1609459200000},"content-version":"tdm","delay-in-days":0,"URL":"http:\/\/www.springer.com\/tdm"},{"start":{"date-parts":[[2021,1,1]],"date-time":"2021-01-01T00:00:00Z","timestamp":1609459200000},"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":[[2021]]},"DOI":"10.1007\/978-3-030-72651-5_46","type":"book-chapter","created":{"date-parts":[[2021,3,28]],"date-time":"2021-03-28T07:02:28Z","timestamp":1616914948000},"page":"481-490","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":7,"title":["Comparing Oracle and PostgreSQL, Performance and Optimization"],"prefix":"10.1007","author":[{"given":"Pedro","family":"Martins","sequence":"first","affiliation":[]},{"given":"Paulo","family":"Tom\u00e9","sequence":"additional","affiliation":[]},{"given":"Cristina","family":"Wanzeller","sequence":"additional","affiliation":[]},{"given":"Filipe","family":"S\u00e1","sequence":"additional","affiliation":[]},{"given":"Maryam","family":"Abbasi","sequence":"additional","affiliation":[]}],"member":"297","published-online":{"date-parts":[[2021,3,29]]},"reference":[{"key":"46_CR1","unstructured":"Burleson, D.K.: Oracle Tuning: the Definitive Reference. Rampant TechPress, North Carolina (2010)"},{"issue":"12","key":"46_CR2","doi-asserted-by":"publisher","first-page":"48","DOI":"10.1109\/2.970575","volume":"34","author":"S Chaudhuri","year":"2001","unstructured":"Chaudhuri, S., Dayal, U., Ganti, V.: Database technology for decision support systems. Computer 34(12), 48\u201355 (2001)","journal-title":"Computer"},{"key":"46_CR3","unstructured":"Chaudhuri, S., Narasayya, V.: Self-tuning database systems: a decade of progress. In: Proceedings of the 33rd International Conference on Very Large Data Bases, pp. 3\u201314 (2007)"},{"key":"46_CR4","doi-asserted-by":"publisher","first-page":"260","DOI":"10.1016\/j.procs.2017.11.036","volume":"121","author":"D Colley","year":"2017","unstructured":"Colley, D., Stanier, C.: Identifying new directions in database performance tuning. Procedia Comput. Sci. 121, 260\u2013265 (2017)","journal-title":"Procedia Comput. Sci."},{"key":"46_CR5","unstructured":"Coronel, C., Morris, S.: Database Systems: Design, Implementation, & Management. Cengage Learning, Boston (2016)"},{"key":"46_CR6","unstructured":"T.P.P. Council. TPC-H Documentation"},{"key":"46_CR7","unstructured":"T.P.P. Council. TPC-H Homepage"},{"issue":"3","key":"46_CR8","first-page":"24","volume":"29","author":"B Dageville","year":"2006","unstructured":"Dageville, B., Dias, K.: Oracle\u2019s self-tuning architecture and solutions. IEEE Data Eng. Bull. 29(3), 24\u201331 (2006)","journal-title":"IEEE Data Eng. Bull."},{"key":"46_CR9","volume-title":"An Introduction to Database Systems","author":"CJ Date","year":"2004","unstructured":"Date, C.J.: An Introduction to Database Systems. Pearson\/Addison Wesley, Boston (2004)"},{"issue":"1","key":"46_CR10","doi-asserted-by":"publisher","first-page":"1246","DOI":"10.14778\/1687627.1687767","volume":"2","author":"S Duan","year":"2009","unstructured":"Duan, S., Thummala, V., Babu, S.: Tuning database configuration parameters with ituned. Proc. VLDB Endow. 2(1), 1246\u20131257 (2009)","journal-title":"Proc. VLDB Endow."},{"key":"46_CR11","doi-asserted-by":"crossref","unstructured":"Graefe, G.: A survey of b-tree locking techniques. ACM Trans. Database Syst. 35(3), 1\u201326 (2010)","DOI":"10.1145\/1806907.1806908"},{"key":"46_CR12","doi-asserted-by":"crossref","unstructured":"Graefe, G., Kuno, H.: Self-selecting, self-tuning, incrementally optimized indexes. In Proceedings of the 13th International Conference on Extending Database Technology, EDBT 2010, pp. 371\u2013381, New York, NY, USA. Association for Computing Machinery (2010)","DOI":"10.1145\/1739041.1739087"},{"key":"46_CR13","unstructured":"Harrison, G.: SQL High-Performance Tuning, Second Edition. Prentice Hall Professional Technical Reference, 2nd edition (2000)"},{"issue":"4","key":"46_CR14","first-page":"28","volume":"34","author":"I Jimenez","year":"2011","unstructured":"Jimenez, I., LeFevre, J., Polyzotis, N., Sanchez, H., Schnaitter, K.: Benchmarking online index-tuning algorithms. IEEE Data Eng. Bull. 34(4), 28\u201335 (2011)","journal-title":"IEEE Data Eng. Bull."},{"key":"46_CR15","doi-asserted-by":"crossref","unstructured":"Kamatkar, S.J., Kamble, A., Viloria, A., Hern\u00e1ndez-Fernandez, L., Cali, E.G.: Database performance tuning and query optimization. In: Tan, Y., Shi, Y., Tang, Q. (eds.) Data Mining and Big Data, pp, pp. 3\u201311. Springer, Cham (2018)","DOI":"10.1007\/978-3-319-93803-5_1"},{"key":"46_CR16","doi-asserted-by":"crossref","unstructured":"Kraska, T., Beutel, A., Chi, E.H., Dean, J., Polyzotis, N.: The case for learned index structures. SIGMOD 2018, pp. 489\u2013504, New York, NY, USA, Association for Computing Machinery (2018)","DOI":"10.1145\/3183713.3196909"},{"key":"46_CR17","doi-asserted-by":"crossref","unstructured":"Li, D., Han, L., Ding, Y.: Sql query optimization methods of relational database system. In: 2010 Second International Conference on Computer Engineering and Applications, vol.\u00a01, pp. 557\u2013560 (2010)","DOI":"10.1109\/ICCEA.2010.113"},{"key":"46_CR18","unstructured":"Mehrotra, S.: Sql performance tuning. GlobalLogic Inc., https:\/\/www.globallogic.com\/wp-content\/uploads\/2016\/02\/SQL-Performance-Tuning.pdf. Accessed 14 Jan 2019"},{"key":"46_CR19","doi-asserted-by":"crossref","unstructured":"Mithani, F., Machchhar, S., Jasdanwala, F.: A novel approach for sql query optimization. In: 2016 IEEE International Conference on Computational Intelligence and Computing Research (ICCIC), pp. 1\u20134 (2016)","DOI":"10.1109\/ICCIC.2016.7919717"},{"key":"46_CR20","unstructured":"Myalapalli, V.K., Shiva, M.B.: An appraisal to optimize sql queries. In: 2015 International Conference on Pervasive Computing (ICPC), pp. 1\u20136. IEEE (2015)"},{"key":"46_CR21","unstructured":"Oracle. SQL*Plus oracle database online documentation, 10g release 2 (10.2)"},{"key":"46_CR22","unstructured":"Pavlo, A., Angulo, G., Arulraj, J., Lin, H., Lin, J., Ma, L., Menon, P., Mowry, T.C., Perron, M., Quah, I. et al. Self-driving database management systems. In: CIDR, vol. 4, p.\u00a01 (2017)"},{"key":"46_CR23","unstructured":"PostgreSQL. PSQL postgresql client application"},{"key":"46_CR24","unstructured":"Rupley Jr, M.L.: Introduction to query processing and optimization. Indiana University at South Bend (2008)"},{"key":"46_CR25","doi-asserted-by":"crossref","unstructured":"Shasha, D., Bonnet, P.: Database tuning: principles, experiments, and troubleshooting techniques. Elsevier (2002)","DOI":"10.1145\/564691.564799"},{"key":"46_CR26","first-page":"205","volume":"1","author":"A Thanopoulou","year":"2012","unstructured":"Thanopoulou, A., Carreira, P., Galhardas, H.: Benchmarking with TPC-h on off-the-shelf hardware. ICEIS 1, 205\u2013208 (2012)","journal-title":"ICEIS"},{"key":"46_CR27","doi-asserted-by":"crossref","unstructured":"Van Aken, D., Pavlo, A., Gordon, G.J. and Zhang, B.: Automatic database management system tuning through large-scale machine learning. In: Proceedings of the 2017 ACM International Conference on Management of Data, SIGMOD 2017, pp. 1009\u20131024, New York, NY, USA. Association for Computing Machinery (2017)","DOI":"10.1145\/3035918.3064029"},{"issue":"1\u20132","key":"46_CR28","doi-asserted-by":"publisher","first-page":"1207","DOI":"10.14778\/1920841.1920991","volume":"3","author":"S Wu","year":"2010","unstructured":"Wu, S., Jiang, D., Ooi, B.C., Wu, K.-L.: Efficient b-tree based indexing for cloud data processing. Proc. VLDB Endow. 3(1\u20132), 1207\u20131218 (2010)","journal-title":"Proc. VLDB Endow."}],"container-title":["Advances in Intelligent Systems and Computing","Trends and Applications in Information Systems and Technologies"],"original-title":[],"language":"en","link":[{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/978-3-030-72651-5_46","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2021,3,28]],"date-time":"2021-03-28T07:13:06Z","timestamp":1616915586000},"score":1,"resource":{"primary":{"URL":"http:\/\/link.springer.com\/10.1007\/978-3-030-72651-5_46"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2021]]},"ISBN":["9783030726508","9783030726515"],"references-count":28,"URL":"https:\/\/doi.org\/10.1007\/978-3-030-72651-5_46","relation":{},"ISSN":["2194-5357","2194-5365"],"issn-type":[{"value":"2194-5357","type":"print"},{"value":"2194-5365","type":"electronic"}],"subject":[],"published":{"date-parts":[[2021]]},"assertion":[{"value":"29 March 2021","order":1,"name":"first_online","label":"First Online","group":{"name":"ChapterHistory","label":"Chapter History"}},{"value":"WorldCIST","order":1,"name":"conference_acronym","label":"Conference Acronym","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"World Conference on Information Systems and Technologies","order":2,"name":"conference_name","label":"Conference Name","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Terceira Island","order":3,"name":"conference_city","label":"Conference City","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Portugal","order":4,"name":"conference_country","label":"Conference Country","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"2021","order":5,"name":"conference_year","label":"Conference Year","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"30 March 2021","order":7,"name":"conference_start_date","label":"Conference Start Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"2 April 2021","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":"worldcist2021","order":10,"name":"conference_id","label":"Conference ID","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"http:\/\/worldcist.org\/","order":11,"name":"conference_url","label":"Conference URL","group":{"name":"ConferenceInfo","label":"Conference Information"}}]}}