{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,9,17]],"date-time":"2025-09-17T16:55:34Z","timestamp":1758128134544,"version":"3.41.0"},"publisher-location":"New York, NY, USA","reference-count":38,"publisher":"ACM","license":[{"start":{"date-parts":[[2022,6,10]],"date-time":"2022-06-10T00:00:00Z","timestamp":1654819200000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.acm.org\/publications\/policies\/copyright_policy#Background"}],"content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":[],"published-print":{"date-parts":[[2022,6,10]]},"DOI":"10.1145\/3514221.3526050","type":"proceedings-article","created":{"date-parts":[[2022,6,12]],"date-time":"2022-06-12T02:33:49Z","timestamp":1655001229000},"page":"2273-2285","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":5,"title":["Intelligent Automated Workload Analysis for Database Replatforming"],"prefix":"10.1145","author":[{"given":"Amirhossein","family":"Aleyasen","sequence":"first","affiliation":[{"name":"Datometry Inc. & University of Illinois at Urbana-Champaign, San Francisco, CA, USA"}]},{"given":"Mark","family":"Morcos","sequence":"additional","affiliation":[{"name":"Datometry Inc., San Francisco, CA, USA"}]},{"given":"Lyublena","family":"Antova","sequence":"additional","affiliation":[{"name":"Datometry Inc., San Francisco, CA, USA"}]},{"given":"Marc","family":"Sugiyama","sequence":"additional","affiliation":[{"name":"Datometry Inc., San Francisco, CA, USA"}]},{"given":"Dmitri","family":"Korablev","sequence":"additional","affiliation":[{"name":"Datometry Inc., San Francisco, CA, USA"}]},{"given":"Jozsef","family":"Patvarczki","sequence":"additional","affiliation":[{"name":"Datometry Inc., San Francisco, CA, USA"}]},{"given":"Rima","family":"Mutreja","sequence":"additional","affiliation":[{"name":"Datometry Inc., San Francisco, CA, USA"}]},{"given":"Michael","family":"Duller","sequence":"additional","affiliation":[{"name":"Datometry Inc., San Francisco, CA, USA"}]},{"given":"Florian M.","family":"Waas","sequence":"additional","affiliation":[{"name":"Datometry Inc., San Francisco, CA, USA"}]},{"given":"Marianne","family":"Winslett","sequence":"additional","affiliation":[{"name":"University of Illinois at Urbana-Champaign, Urbana, IL, USA"}]}],"member":"320","published-online":{"date-parts":[[2022,6,11]]},"reference":[{"key":"e_1_3_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.1016\/B978-012088469--8.50097--8"},{"key":"e_1_3_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2012.64"},{"volume-title":"Retrieved","year":"2021","key":"e_1_3_2_1_3_1","unstructured":"Amazon. 2021. Amazon Redshift - Correlated subqueries. Retrieved February, 2021 from https:\/\/docs.aws.amazon.com\/redshift\/latest\/dg\/r_correlated_subqueries.html"},{"volume-title":"Retrieved","year":"2021","key":"e_1_3_2_1_4_1","unstructured":"Amazon. 2021. Amazon Redshift - Defining table constraints. Retrieved February, 2021 from https:\/\/docs.aws.amazon.com\/redshift\/latest\/dg\/t_Defining_constraints.html"},{"volume-title":"Retrieved","year":"2021","key":"e_1_3_2_1_5_1","unstructured":"Amazon. 2021. AWS Schema Conversion Tool. Retrieved February, 2021 from https:\/\/docs.aws.amazon.com\/SchemaConversionTool\/index.html"},{"key":"e_1_3_2_1_6_1","doi-asserted-by":"crossref","unstructured":"Lyublena Antova Derrick Bryant Tuan Cao Michael Duller Mohamed A Soliman and F Michael Waas. 2018. Rapid Adoption of Cloud Data Warehouse Technology Using Datometry Hyper-Q. In SIGMOD.","DOI":"10.1145\/3183713.3190652"},{"key":"e_1_3_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.14778\/1920841.1920853"},{"key":"e_1_3_2_1_8_1","doi-asserted-by":"crossref","unstructured":"Beno\u00eet Dageville Thierry Cruanes Marcin Zukowski Vadim Antonov Artin Avanes Jon Bock Jonathan Claybaugh Daniel Engovatov Martin Hentschel Jiansheng Huang Allison W. Lee Ashish Motivala Abdul Q. Munir Steven Pelley Peter Povinec Greg Rahn Spyridon Triantafyllis and Philipp Unterbrunner. 2016. The Snowflake Elastic Data Warehouse. In SIGMOD.","DOI":"10.1145\/2882903.2903741"},{"volume-title":"Retrieved","year":"2021","key":"e_1_3_2_1_9_1","unstructured":"Datametica. 2021. Datametica migration documentation. Retrieved February, 2021 from https:\/\/www.datametica.com\/migration-to-gcp\/"},{"volume-title":"Retrieved","year":"2021","key":"e_1_3_2_1_10_1","unstructured":"Datametica. 2021. Raven. Retrieved February, 2021 from https:\/\/www.datametica.com\/raven"},{"key":"e_1_3_2_1_11_1","volume-title":"Software portability: J Henderson Gower Technical Press","author":"de Groote C","year":"1988","unstructured":"C de Groote. 1989. Software portability: J Henderson Gower Technical Press, Aldershot, UK (1988) 151 (+ xix) pp\u00a3 22.50 hardback."},{"volume-title":"Software Science Revisited: Rationalizing Halstead's System Using Dimensionless Units. US Department of Commerce","author":"Flater David","key":"e_1_3_2_1_12_1","unstructured":"David Flater. 2018. Software Science Revisited: Rationalizing Halstead's System Using Dimensionless Units. US Department of Commerce, National Institute of Standards and Technology."},{"key":"e_1_3_2_1_13_1","unstructured":"Andre Freitas Juliano Sales Siegfried Handschuh and Edward Curry. 2015. How hard is this query? Measuring the Semantic Complexity of Schema-agnostic Queries."},{"key":"e_1_3_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.1145\/3384544.3384569"},{"volume-title":"Retrieved","year":"2021","key":"e_1_3_2_1_15_1","unstructured":"Google. 2021. Bigquery Data Transfer Service. Retrieved February, 2021 from https:\/\/cloud.google.com\/bigquery-transfer\/docs\/data-warehouse-migration-overview"},{"volume-title":"Retrieved","year":"2021","key":"e_1_3_2_1_16_1","unstructured":"Google. 2021. Google BigQuery. Retrieved February, 2021 from https:\/\/cloud.google.com\/bigquery\/"},{"key":"e_1_3_2_1_17_1","doi-asserted-by":"crossref","unstructured":"Anurag Gupta Deepak Agarwal Derek Tan Jakub Kulesza Rahul Pathak Stefano Stefani and Vidhya Srinivasan. 2015. Amazon Redshift and the Case for Simpler Data Warehouses. In SIGMOD.","DOI":"10.1145\/2723372.2742795"},{"key":"e_1_3_2_1_18_1","doi-asserted-by":"publisher","DOI":"10.1016\/S0164-1212(96)00118-5"},{"volume-title":"Elements of Software Science","author":"Halstead Maurice Howard","key":"e_1_3_2_1_19_1","unstructured":"Maurice Howard Halstead. 1977. Elements of Software Science. Elsevier."},{"volume-title":"Retrieved","year":"2021","key":"e_1_3_2_1_20_1","unstructured":"Impetus. 2021. ETL, EDW and Analytics Conversion to Cloud. Retrieved February, 2021 from https:\/\/www.impetus.com\/data-warehouse-modernization\/automated-workload-transformation"},{"volume-title":"Retrieved","year":"2021","key":"e_1_3_2_1_21_1","unstructured":"Ispirer. 2021. Ispirer Database Migration. Retrieved February, 2021 from https:\/\/www.ispirer.com\/products\/database-migration"},{"volume-title":"Retrieved","year":"2021","key":"e_1_3_2_1_22_1","unstructured":"Ispirer. 2021. Ispirer MnMTK Customization Case Study. Retrieved February, 2021 from https:\/\/bit.ly\/3pOyTYR"},{"key":"e_1_3_2_1_23_1","doi-asserted-by":"publisher","DOI":"10.1145\/2882903.2882957"},{"key":"e_1_3_2_1_24_1","volume-title":"CIDR","author":"Jain Shrainik","year":"2019","unstructured":"Shrainik Jain, Jiaqi Yan, Thierry Cruanes, and Bill Howe. 2019. Database-Agnostic Workload Management. In CIDR 2019, 9th Biennial Conference on Innovative Data Systems Research, Asilomar, CA, USA, January 13--16, 2019, Online Proceedings. www.cidrdb.org. http:\/\/cidrdb.org\/cidr2019\/papers\/p110-jain-cidr19.pdf"},{"key":"e_1_3_2_1_25_1","volume-title":"Measuring the Portability of Executable Service-Oriented Processes. In 2013 17th IEEE International Enterprise Distributed Object Computing Conference. 117--126","author":"Lenhard J","year":"2013","unstructured":"J Lenhard and G Wirtz. 2013. Measuring the Portability of Executable Service-Oriented Processes. In 2013 17th IEEE International Enterprise Distributed Object Computing Conference. 117--126."},{"key":"e_1_3_2_1_26_1","volume-title":"Vivek Narasayya, and Surajit Chaudhuri.","author":"Li Jiexing","year":"2012","unstructured":"Jiexing Li, Arnd Christian K\u00f6nig, Vivek Narasayya, and Surajit Chaudhuri. 2012. Robust Estimation of Resource Consumption for SQL Queries using Statistical Techniques. arXiv:1208.0278 [cs.DB]"},{"key":"e_1_3_2_1_27_1","doi-asserted-by":"publisher","DOI":"10.1145\/3183713.3196908"},{"key":"e_1_3_2_1_28_1","doi-asserted-by":"publisher","DOI":"10.1109\/TSE.1976.233837"},{"volume-title":"Retrieved","year":"2021","key":"e_1_3_2_1_29_1","unstructured":"Microsoft. 2021. Azure Database Migration Service. Retrieved February, 2021 from https:\/\/azure.microsoft.com\/en-us\/services\/database-migration"},{"volume-title":"Microsoft Azure Synapse Analytics. Retrieved","year":"2021","key":"e_1_3_2_1_30_1","unstructured":"Microsoft. 2021. Microsoft Azure Synapse Analytics. Retrieved February 2021 from https:\/\/docs.microsoft.com\/en-us\/azure\/sql-data-warehouse\/massively-parallel-processing-mpp-architecture"},{"volume-title":"Retrieved","year":"2021","key":"e_1_3_2_1_31_1","unstructured":"Microsoft. 2021. Primary key, foreign key, and unique key using dedicated SQL pool in Azure Synapse Analytics. Retrieved February, 2021 from https:\/\/docs.microsoft.com\/en-us\/azure\/synapse-analytics\/sql-data-warehouse\/sql-data-warehouse-table-constraints"},{"key":"e_1_3_2_1_32_1","doi-asserted-by":"publisher","DOI":"10.14778\/3407790.3407834"},{"key":"e_1_3_2_1_33_1","doi-asserted-by":"crossref","unstructured":"Youcef Remil Anes Bendimerad Romain Mathonat Philippe Chaleat and Mehdi Kaytoue. 2021. \"What makes my queries slow?\": Subgroup Discovery for SQL Workload Analysis.","DOI":"10.1109\/ASE51524.2021.9678915"},{"key":"e_1_3_2_1_34_1","volume-title":"Waas","author":"Soliman Mohamed A.","year":"2020","unstructured":"Mohamed A. Soliman, Lyublena Antova, Marc Sugiyama, Michael Duller, Amirhossein Aleyasen, Gourab Mitra, Ehab Abdelhamid, Mark Morcos, Michele Gage, Dmitri Korablev, and Florian M. Waas. 2020. A Framework for Emulating Database Operations in Cloud Data Warehouses. In SIGMOD."},{"key":"e_1_3_2_1_35_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2014.6816725"},{"key":"e_1_3_2_1_36_1","volume-title":"Proceedings of the 2019 international conference on management of data.","author":"Vashistha Aditya","year":"2016","unstructured":"Aditya Vashistha and Shrainik Jain. 2016. Measuring query complexity in SQL- Share workload. In Proceedings of the 2019 international conference on management of data."},{"key":"e_1_3_2_1_37_1","doi-asserted-by":"publisher","DOI":"10.14778\/2536206.2536219"},{"key":"e_1_3_2_1_38_1","doi-asserted-by":"publisher","DOI":"10.1145\/3318464.3380602"}],"event":{"name":"SIGMOD\/PODS '22: International Conference on Management of Data","sponsor":["SIGMOD ACM Special Interest Group on Management of Data"],"location":"Philadelphia PA USA","acronym":"SIGMOD\/PODS '22"},"container-title":["Proceedings of the 2022 International Conference on Management of Data"],"original-title":[],"link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3514221.3526050","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/3514221.3526050","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,17]],"date-time":"2025-06-17T18:10:07Z","timestamp":1750183807000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3514221.3526050"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2022,6,10]]},"references-count":38,"alternative-id":["10.1145\/3514221.3526050","10.1145\/3514221"],"URL":"https:\/\/doi.org\/10.1145\/3514221.3526050","relation":{},"subject":[],"published":{"date-parts":[[2022,6,10]]},"assertion":[{"value":"2022-06-11","order":3,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}