{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,5,26]],"date-time":"2026-05-26T20:02:49Z","timestamp":1779825769295,"version":"3.53.1"},"publisher-location":"New York, NY, USA","reference-count":51,"publisher":"ACM","content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":[],"published-print":{"date-parts":[[2026,5,31]]},"DOI":"10.1145\/3788853.3803096","type":"proceedings-article","created":{"date-parts":[[2026,5,26]],"date-time":"2026-05-26T19:14:47Z","timestamp":1779822887000},"page":"307-319","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":0,"title":["From JSON to Duality: Automated Application Migration from Document to Relational Databases"],"prefix":"10.1145","author":[{"ORCID":"https:\/\/orcid.org\/0000-0002-7385-5769","authenticated-orcid":false,"given":"Shashank","family":"Gugnani","sequence":"first","affiliation":[{"name":"Oracle, Redwood City, California, USA"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0009-0002-3533-840X","authenticated-orcid":false,"given":"Shadab","family":"Ahmed","sequence":"additional","affiliation":[{"name":"Oracle, Bengaluru, Karnataka, India"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0009-0009-7904-4789","authenticated-orcid":false,"given":"Shubham","family":"Pednekar","sequence":"additional","affiliation":[{"name":"Oracle, Bengaluru, Karnataka, India"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0009-0001-9986-5666","authenticated-orcid":false,"given":"Sanju","family":"Gowda","sequence":"additional","affiliation":[{"name":"Oracle, Redwood City, California, USA"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0009-0002-3673-8261","authenticated-orcid":false,"given":"Sarvesh","family":"Tandon","sequence":"additional","affiliation":[{"name":"Oracle, Redwood City, California, USA"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0009-0007-6894-4250","authenticated-orcid":false,"given":"Sukhada","family":"Pendse","sequence":"additional","affiliation":[{"name":"Oracle, Redwood City, California, USA"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"320","published-online":{"date-parts":[[2026,5,30]]},"reference":[{"key":"e_1_3_2_1_1_1","unstructured":"Daniel J. Abadi. 2007. Column Stores for Wide and Sparse Data. In CIDR."},{"key":"e_1_3_2_1_2_1","volume-title":"Faisal Bukhari, and Muhammad Abdullah.","author":"Aftab Zain","year":"2020","unstructured":"Zain Aftab, Waheed Iqbal, Khaled Mohamad Almustafa, Faisal Bukhari, and Muhammad Abdullah. 2020. Automatic NoSQL to Relational Database Transformation with Dynamic Schema Mapping. Sci. Program., Vol. 2020 (2020), 8813350:1-8813350:13."},{"key":"e_1_3_2_1_3_1","unstructured":"Rakesh Agrawal Amit Somani and Yirong Xu. 2001. Storage and Querying of E-Commerce Data. In VLDB."},{"key":"e_1_3_2_1_4_1","first-page":"2025","article-title":"AWS Database Migration Service. https:\/\/aws.amazon.com\/dms\/","year":"2016","unstructured":"Amazon. 2016. AWS Database Migration Service. https:\/\/aws.amazon.com\/dms\/. Accessed: 2025-11.","journal-title":"Accessed"},{"key":"e_1_3_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.1145\/320493.320489"},{"key":"e_1_3_2_1_6_1","unstructured":"Philip Bohannon Juliana Freire Prasan Roy and Jerome Simeon. 2002. From XML Schema to Relations: A Cost-Based Approach to XML Storage. In ICDE."},{"key":"e_1_3_2_1_7_1","first-page":"4804","article-title":"Towards Principled","volume":"18","author":"Carey Michael","year":"2025","unstructured":"Michael Carey, Wail Alkowaileet, Nick DiGeronimo, Peeyush Gupta, Sachin Smotra, and Till Westmann. 2025. Towards Principled, Practical Document Database Design. VLDB, Vol. 18, 12 (2025), 4804-4816.","journal-title":"Practical Document Database Design. VLDB"},{"key":"e_1_3_2_1_8_1","volume-title":"Patel","author":"Chasseur Christophe","year":"2013","unstructured":"Christophe Chasseur, Yinan Li, and Jignesh M. Patel. 2013a. Enabling JSON Document Stores in Relational Systems. In WebDB."},{"key":"e_1_3_2_1_9_1","volume-title":"Proceedings of the 16th International Workshop on the Web and Databases 2013","author":"Chasseur Craig","year":"2013","unstructured":"Craig Chasseur, Yinan Li, and Jignesh M. Patel. 2013b. Enabling JSON Document Stores in Relational Systems. In Proceedings of the 16th International Workshop on the Web and Databases 2013, WebDB 2013, New York, NY, USA, June 23, 2013, Angela Bonifati and Cong Yu (Eds.). 1-6. http:\/\/webdb2013.lille.inria.fr\/Paper%2010.pdf"},{"key":"e_1_3_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.1145\/362384.362685"},{"key":"e_1_3_2_1_11_1","volume-title":"Further Normalization of the Data Base Relational Model. Data base systems","author":"Codd Edgar F","year":"1972","unstructured":"Edgar F Codd. 1972. Further Normalization of the Data Base Relational Model. Data base systems, Vol. 6, 1972 (1972), 33-64."},{"key":"e_1_3_2_1_12_1","doi-asserted-by":"crossref","unstructured":"Alin Deutsch Mary Fernandez and Dan Suciu. 1999. Storing Semistructured Data with STORED. In SIGMOD.","DOI":"10.1145\/304182.304220"},{"key":"e_1_3_2_1_13_1","volume-title":"Abadi","author":"DiScala Michael","year":"2016","unstructured":"Michael DiScala and Daniel J. Abadi. 2016a. Automatic Generation of Normalized Relational Schemas from Nested Key-Value Data. SIGMOD (2016)."},{"key":"e_1_3_2_1_14_1","first-page":"2025","article-title":"Datasets used for Automatic Generation of Normalized Relational Schemas from Nested Key-Value Data. https:\/\/s3.amazonaws.com\/discala-abadi-2016\/index.html","author":"DiScala Michael","year":"2016","unstructured":"Michael DiScala and Daniel J. Abadi. 2016b. Datasets used for Automatic Generation of Normalized Relational Schemas from Nested Key-Value Data. https:\/\/s3.amazonaws.com\/discala-abadi-2016\/index.html. Accessed: 2025-11.","journal-title":"Accessed"},{"key":"e_1_3_2_1_15_1","doi-asserted-by":"crossref","unstructured":"Fan Du Sihem Amer-Yahia and Juliana Freire. 2004. ShreX: Managing XML Documents in Relational Databases. In VLDB.","DOI":"10.1016\/B978-012088469-8.50131-5"},{"key":"e_1_3_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.1145\/3448016.3452809"},{"key":"e_1_3_2_1_17_1","first-page":"2025","article-title":"Estuary Flow. https:\/\/github.com\/estuary\/flow","year":"2022","unstructured":"Estuary. 2022. Estuary Flow. https:\/\/github.com\/estuary\/flow. Accessed: 2025-11.","journal-title":"Accessed"},{"key":"e_1_3_2_1_18_1","first-page":"2025","article-title":"Fivetran MongoDB Connector. https:\/\/www.fivetran.com\/connectors\/mongodb","year":"2012","unstructured":"Fivetran. 2012. Fivetran MongoDB Connector. https:\/\/www.fivetran.com\/connectors\/mongodb. Accessed: 2025-11.","journal-title":"Accessed"},{"key":"e_1_3_2_1_19_1","doi-asserted-by":"publisher","DOI":"10.14778\/2367502.2367511"},{"key":"e_1_3_2_1_20_1","unstructured":"Daniela Florescu and Donald Kossmann. 1999. A Performance Evaluation of Alternative Mapping Schemes for Storing XML Data in a Relational Database. Technical Report. INRIA."},{"key":"e_1_3_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.1109\/MSR.2013.6624034"},{"key":"e_1_3_2_1_22_1","volume-title":"Hui Chang, Beda Christoph Hammerschmidt, Srinivas Kareenhalli, Kishy Kumar, Tirthankar Lahiri, Ying Lu, Douglas Mcmahon, Ajit Mylavarapu, Sukhada Pendse, and Ananth Raghavan.","author":"Gugnani Shashank","year":"2025","unstructured":"Shashank Gugnani, Zhen Hua Liu, Hui Chang, Beda Christoph Hammerschmidt, Srinivas Kareenhalli, Kishy Kumar, Tirthankar Lahiri, Ying Lu, Douglas Mcmahon, Ajit Mylavarapu, Sukhada Pendse, and Ananth Raghavan. 2025. JSON Relational Duality: A Revolutionary Combination of Document, Object, and Relational Models. SIGMOD (2025)."},{"key":"e_1_3_2_1_23_1","first-page":"2025","article-title":"I Migrated 847 Million Records from MongoDB to PostgreSQL\u2014Here's What I Learned about Web Scale. https:\/\/medium.com\/@jholt1055\/i-migrated-847-million-records-from-mongodb-to-postgresql-heres-what-i-learned-about-web-scale-84ceeceb87ab","author":"Holt J.","year":"2022","unstructured":"J. Holt. 2022. I Migrated 847 Million Records from MongoDB to PostgreSQL\u2014Here's What I Learned about Web Scale. https:\/\/medium.com\/@jholt1055\/i-migrated-847-million-records-from-mongodb-to-postgresql-heres-what-i-learned-about-web-scale-84ceeceb87ab. Accessed: 2025-11.","journal-title":"Accessed"},{"key":"e_1_3_2_1_24_1","first-page":"647","article-title":"CORDS: Automatic discovery of correlations and soft functional dependencies","author":"Ilyas Ihab F","year":"2004","unstructured":"Ihab F Ilyas, Volker Markl, Peter Haas, Paul Brown, and Ashraf Aboulnaga. 2004. CORDS: Automatic discovery of correlations and soft functional dependencies. In SIGMOD. 647-658.","journal-title":"SIGMOD."},{"key":"e_1_3_2_1_25_1","first-page":"2025","article-title":"Couchbase Documentation. https:\/\/docs.couchbase.com\/home\/index.html","author":"Couchbase Inc.","year":"2012","unstructured":"Couchbase Inc., 2012. Couchbase Documentation. https:\/\/docs.couchbase.com\/home\/index.html. Accessed: 2025-11.","journal-title":"Accessed"},{"key":"e_1_3_2_1_26_1","first-page":"2025","article-title":"Stitch MongoDB Integration. https:\/\/www.stitchdata.com\/integrations\/mongodb\/postgresql\/","author":"Talend Inc.","year":"2005","unstructured":"Talend Inc., 2005. Stitch MongoDB Integration. https:\/\/www.stitchdata.com\/integrations\/mongodb\/postgresql\/. Accessed: 2025-11.","journal-title":"Accessed"},{"key":"e_1_3_2_1_27_1","first-page":"2025","article-title":"PostgreSQL Migration Technical. https:\/\/infisical.com\/blog\/postgresql-migration-technical","year":"2024","unstructured":"Infisical. 2024. PostgreSQL Migration Technical. https:\/\/infisical.com\/blog\/postgresql-migration-technical. Accessed: 2025-11.","journal-title":"Accessed"},{"key":"e_1_3_2_1_28_1","volume-title":"Tagger: A Tool for the Discovery of Tagged Unions in JSON Schema Extraction. In International Conference on Extending Database Technology.","author":"Klessinger Stefan","year":"2023","unstructured":"Stefan Klessinger, Michael Fruth, Valentin Gittinger, Meike Klettke, Uta St\u00f6rl, and Stefanie Scherzinger. 2023. Tagger: A Tool for the Discovery of Tagged Unions in JSON Schema Extraction. In International Conference on Extending Database Technology."},{"key":"e_1_3_2_1_29_1","first-page":"3059","article-title":"Native JSON Datatype Support: Maturing SQL and NoSQL Convergence in Oracle Database","volume":"13","author":"Liu Zhen Hua","year":"2020","unstructured":"Zhen Hua Liu, Beda Christoph Hammerschmidt, Douglas Mcmahon, Hui J. Chang, Ying Lu, Joshua Spiegel, Alfonso Colunga Sosa, Srikrishnan Suresh, Geeta Arora, and Vikas Arora. 2020. Native JSON Datatype Support: Maturing SQL and NoSQL Convergence in Oracle Database. VLDB, Vol. 13, 12 (2020), 3059-3071.","journal-title":"VLDB"},{"key":"e_1_3_2_1_30_1","first-page":"227","article-title":"Closing the Functional and Performance Gap between SQL and NoSQL","author":"Liu Zhen Hua","year":"2016","unstructured":"Zhen Hua Liu, Beda Christoph Hammerschmidt, Douglas Mcmahon, Ying Liu, and Hui Joe Chang. 2016. Closing the Functional and Performance Gap between SQL and NoSQL. In SIGMOD. 227-238.","journal-title":"SIGMOD."},{"key":"e_1_3_2_1_31_1","doi-asserted-by":"publisher","DOI":"10.1145\/3265007.3265011"},{"key":"e_1_3_2_1_32_1","doi-asserted-by":"publisher","DOI":"10.18653\/v1\/2023.emnlp-main.557"},{"key":"e_1_3_2_1_33_1","volume-title":"Fast Discovery of Nested Dependencies on JSON Data. CoRR","author":"Mior Michael J.","year":"2021","unstructured":"Michael J. Mior. 2021. Fast Discovery of Nested Dependencies on JSON Data. CoRR (2021)."},{"key":"e_1_3_2_1_34_1","doi-asserted-by":"publisher","DOI":"10.1109\/TKDE.2017.2722412"},{"key":"e_1_3_2_1_35_1","unstructured":"MongoDB Inc. 2009. MongoDB. https:\/\/www.mongodb.com\/."},{"key":"e_1_3_2_1_36_1","unstructured":"Niels M\u00fcndler Jingxuan He Slobodan Jenko and Martin Vechev. 2024. Self-contradictory Hallucinations of Large Language Models: Evaluation Detection and Mitigation. In ICLR."},{"key":"e_1_3_2_1_37_1","first-page":"2025","article-title":"Bureau of Transportation Statistics. https:\/\/www.bts.gov\/","author":"U.S. Department of Transportation.","year":"2025","unstructured":"U.S. Department of Transportation. 2025. Bureau of Transportation Statistics. https:\/\/www.bts.gov\/. Accessed: 2025-11.","journal-title":"Accessed"},{"key":"e_1_3_2_1_38_1","first-page":"2025","article-title":"Oracle GoldenGate. https:\/\/www.oracle.com\/integration\/goldengate\/","year":"2012","unstructured":"Oracle. 2012. Oracle GoldenGate. https:\/\/www.oracle.com\/integration\/goldengate\/. Accessed: 2025-11.","journal-title":"Accessed"},{"key":"e_1_3_2_1_39_1","first-page":"2025","article-title":"Partoo Migrates from MongoDB to PostgreSQL. http:\/\/medium.com\/partoo\/partoo-migrates-from-mongodb-to-postgresql-43c60854bebb","year":"2023","unstructured":"Partoo. 2023. Partoo Migrates from MongoDB to PostgreSQL. http:\/\/medium.com\/partoo\/partoo-migrates-from-mongodb-to-postgresql-43c60854bebb. Accessed: 2025-11.","journal-title":"Accessed"},{"key":"e_1_3_2_1_40_1","doi-asserted-by":"publisher","DOI":"10.1109\/ACCESS.2020.2982472"},{"key":"e_1_3_2_1_41_1","doi-asserted-by":"crossref","unstructured":"Albrecht Schmidt Martin Kersten Menzo Windhouwer and Florian Waas. 2000. Efficient Relational Storage and Retrieval of XML Documents. In WebDB.","DOI":"10.1007\/3-540-45271-0_9"},{"key":"e_1_3_2_1_42_1","volume-title":"A General Technique for Querying XML Documents Using a Relational Database System. SIGMOD Record","author":"Shanmugasundaram Jayavel","year":"2001","unstructured":"Jayavel Shanmugasundaram, Eugene Shekita, Jim Kiernan, Ravi Krishnamurthy, Stratis Viglas, Jeff Naughton, and Igor Tatarinov. 2001. A General Technique for Querying XML Documents Using a Relational Database System. SIGMOD Record (2001), 20-26."},{"key":"e_1_3_2_1_43_1","first-page":"302","article-title":"Relational Databases for Querying XML Documents","author":"Shanmugasundaram Jayavel","year":"1999","unstructured":"Jayavel Shanmugasundaram, Kristin Tufte, Gang He, Chun Zhang, David DeWitt, and Jeff Naughton. 1999. Relational Databases for Querying XML Documents: Limitations and Opportunities. In VLDB. 302-314.","journal-title":"Limitations and Opportunities. In VLDB."},{"key":"e_1_3_2_1_44_1","first-page":"2025","article-title":"Seamless Transition from MongoDB to a Relational Database Management System. https:\/\/gartsolutions.com\/case-studies\/seamless-transition-from-mongodb-to-a-relational-database-management-system\/","author":"Solutions Gart","year":"2023","unstructured":"Gart Solutions. 2023. Seamless Transition from MongoDB to a Relational Database Management System. https:\/\/gartsolutions.com\/case-studies\/seamless-transition-from-mongodb-to-a-relational-database-management-system\/. Accessed: 2025-11.","journal-title":"Accessed"},{"key":"e_1_3_2_1_45_1","doi-asserted-by":"publisher","DOI":"10.1145\/3209900.3209908"},{"key":"e_1_3_2_1_46_1","volume-title":"Abadi","author":"Tahara Debbie","year":"2014","unstructured":"Debbie Tahara, Tyrone Diamond, and Daniel J. Abadi. 2014. Sinew: A SQL System for Multi-Structured Data. In SIGMOD."},{"key":"e_1_3_2_1_47_1","first-page":"2025","article-title":"Upchieve Case Study. https:\/\/mongotosqlmigration.com\/case-studies\/upchieve\/","author":"Migration DB","year":"2024","unstructured":"MongoDB to SQL Migration. 2024. Upchieve Case Study. https:\/\/mongotosqlmigration.com\/case-studies\/upchieve\/. Accessed: 2025-11.","journal-title":"Accessed"},{"key":"e_1_3_2_1_48_1","first-page":"2025","article-title":"Stampede. https:\/\/github.com\/torodb\/stampede","author":"DB.","year":"2017","unstructured":"ToroDB. 2017. Stampede. https:\/\/github.com\/torodb\/stampede. Accessed: 2025-11.","journal-title":"Accessed"},{"key":"e_1_3_2_1_49_1","unstructured":"William E Winkler. 1990. String comparator metrics and enhanced decision rules in the fellegi-sunter model of record linkage. (1990)."},{"key":"e_1_3_2_1_50_1","first-page":"580","article-title":"Automated Migration of Hierarchical Data to Relational Tables using Programming-by-Example","volume":"11","author":"Yaghmazadeh Navid","year":"2017","unstructured":"Navid Yaghmazadeh, Xinyu Wang, and I??l Dillig. 2017. Automated Migration of Hierarchical Data to Relational Tables using Programming-by-Example. VLDB, Vol. 11 (2017), 580-593.","journal-title":"VLDB"},{"key":"e_1_3_2_1_51_1","doi-asserted-by":"crossref","unstructured":"Haixun Zhang and Frank Wm. Tompa. 2004. Querying XML Documents by Dynamic Shredding. In DocEng.","DOI":"10.1145\/1030397.1030401"}],"event":{"name":"SIGMOD\/PODS '26: International Conference on Management of Data","location":"Bengaluru India","sponsor":["SIGMOD ACM Special Interest Group on Management of Data"]},"container-title":["Companion of the International Conference on Management of Data"],"original-title":[],"deposited":{"date-parts":[[2026,5,26]],"date-time":"2026-05-26T19:16:59Z","timestamp":1779823019000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3788853.3803096"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2026,5,30]]},"references-count":51,"alternative-id":["10.1145\/3788853.3803096","10.1145\/3788853"],"URL":"https:\/\/doi.org\/10.1145\/3788853.3803096","relation":{},"subject":[],"published":{"date-parts":[[2026,5,30]]},"assertion":[{"value":"2026-05-30","order":3,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}