{"id":"https://openalex.org/W7162413043","doi":"https://doi.org/10.1145/3788853.3803096","title":"From JSON to Duality: Automated Application Migration from Document to Relational Databases","display_name":"From JSON to Duality: Automated Application Migration from Document to Relational Databases","publication_year":2026,"publication_date":"2026-05-26","ids":{"openalex":"https://openalex.org/W7162413043","doi":"https://doi.org/10.1145/3788853.3803096"},"language":null,"primary_location":{"id":"doi:10.1145/3788853.3803096","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3788853.3803096","pdf_url":null,"source":null,"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Companion of the International Conference on Management of Data","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://doi.org/10.1145/3788853.3803096","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5052570522","display_name":"Shashank Gugnani","orcid":"https://orcid.org/0000-0002-7385-5769"},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Shashank Gugnani","raw_affiliation_strings":["Oracle, Redwood City, California, USA"],"raw_orcid":"https://orcid.org/0000-0002-7385-5769","affiliations":[{"raw_affiliation_string":"Oracle, Redwood City, California, USA","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101820927","display_name":"Shadab Ahmed","orcid":"https://orcid.org/0000-0003-0165-296X"},"institutions":[{"id":"https://openalex.org/I4210165642","display_name":"Oracle (India)","ror":"https://ror.org/05dd0pt55","country_code":"IN","type":"company","lineage":["https://openalex.org/I1342911587","https://openalex.org/I4210165642"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Shadab Ahmed","raw_affiliation_strings":["Oracle, Bengaluru, Karnataka, India"],"raw_orcid":"https://orcid.org/0009-0002-3533-840X","affiliations":[{"raw_affiliation_string":"Oracle, Bengaluru, Karnataka, India","institution_ids":["https://openalex.org/I4210165642"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5048092650","display_name":"Shubham Pednekar","orcid":null},"institutions":[{"id":"https://openalex.org/I4210165642","display_name":"Oracle (India)","ror":"https://ror.org/05dd0pt55","country_code":"IN","type":"company","lineage":["https://openalex.org/I1342911587","https://openalex.org/I4210165642"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Shubham Pednekar","raw_affiliation_strings":["Oracle, Bengaluru, Karnataka, India"],"raw_orcid":"https://orcid.org/0009-0009-7904-4789","affiliations":[{"raw_affiliation_string":"Oracle, Bengaluru, Karnataka, India","institution_ids":["https://openalex.org/I4210165642"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5136998011","display_name":"Sanju Gowda","orcid":"https://orcid.org/0009-0001-9986-5666"},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Sanju Gowda","raw_affiliation_strings":["Oracle, Redwood City, California, USA"],"raw_orcid":"https://orcid.org/0009-0001-9986-5666","affiliations":[{"raw_affiliation_string":"Oracle, Redwood City, California, USA","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5064859116","display_name":"Sarvesh Tandon","orcid":null},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Sarvesh Tandon","raw_affiliation_strings":["Oracle, Redwood City, California, USA"],"raw_orcid":"https://orcid.org/0009-0002-3673-8261","affiliations":[{"raw_affiliation_string":"Oracle, Redwood City, California, USA","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5033837350","display_name":"Sukhada Pendse","orcid":null},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Sukhada Pendse","raw_affiliation_strings":["Oracle, Redwood City, California, USA"],"raw_orcid":"https://orcid.org/0009-0007-6894-4250","affiliations":[{"raw_affiliation_string":"Oracle, Redwood City, California, USA","institution_ids":["https://openalex.org/I1342911587"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":6,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.84454665,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"307","last_page":"319"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.3488999903202057,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.3488999903202057,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T12490","display_name":"Software Engineering and Design Patterns","score":0.044599998742341995,"subfield":{"id":"https://openalex.org/subfields/3303","display_name":"Development"},"field":{"id":"https://openalex.org/fields/33","display_name":"Social Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T12601","display_name":"Web Applications and Data Management","score":0.023499999195337296,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/json","display_name":"JSON","score":0.8050000071525574},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.6029000282287598},{"id":"https://openalex.org/keywords/work","display_name":"Work (physics)","score":0.26750001311302185},{"id":"https://openalex.org/keywords/information-system","display_name":"Information system","score":0.26159998774528503},{"id":"https://openalex.org/keywords/entity\u2013relationship-model","display_name":"Entity\u2013relationship model","score":0.25839999318122864}],"concepts":[{"id":"https://openalex.org/C2780416260","wikidata":"https://www.wikidata.org/wiki/Q2063","display_name":"JSON","level":2,"score":0.8050000071525574},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6891000270843506},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.6029000282287598},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5242000222206116},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.40790000557899475},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.3659999966621399},{"id":"https://openalex.org/C18762648","wikidata":"https://www.wikidata.org/wiki/Q42213","display_name":"Work (physics)","level":2,"score":0.26750001311302185},{"id":"https://openalex.org/C180198813","wikidata":"https://www.wikidata.org/wiki/Q121182","display_name":"Information system","level":2,"score":0.26159998774528503},{"id":"https://openalex.org/C103593891","wikidata":"https://www.wikidata.org/wiki/Q624546","display_name":"Entity\u2013relationship model","level":3,"score":0.25839999318122864},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.2538999915122986}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3788853.3803096","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3788853.3803096","pdf_url":null,"source":null,"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Companion of the International Conference on Management of Data","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.1145/3788853.3803096","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3788853.3803096","pdf_url":null,"source":null,"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Companion of the International Conference on Management of Data","raw_type":"proceedings-article"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/10","display_name":"Reduced inequalities","score":0.7919505834579468}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":14,"referenced_works":["https://openalex.org/W1972386298","https://openalex.org/W2015071642","https://openalex.org/W2023663289","https://openalex.org/W2123866731","https://openalex.org/W2161938331","https://openalex.org/W2166194842","https://openalex.org/W2185907055","https://openalex.org/W2730037187","https://openalex.org/W2806779957","https://openalex.org/W2913512110","https://openalex.org/W3013439450","https://openalex.org/W3173993340","https://openalex.org/W4233419801","https://openalex.org/W4389520749"],"related_works":[],"abstract_inverted_index":{"Developers":[0],"like":[1],"the":[2,18,40,86,92,116,151,155,158,183,194,203,210,227],"simplicity":[3],"and":[4,17,28,89,142,147],"flexibility":[5,122],"of":[6,20,71,119,160,170,212],"document":[7,31,50,79],"databases.":[8,32],"However,":[9],"they":[10],"are":[11,164],"left":[12],"frustrated":[13],"with":[14,95],"data":[15,76],"denormalization":[16],"lack":[19],"critical":[21],"features":[22],"(such":[23],"as":[24],"transactions,":[25],"SQL":[26],"access,":[27],"performance)":[29],"in":[30,131,150,176,193],"To":[33],"address":[34],"this":[35],"growing":[36],"problem,":[37],"we":[38,197],"introduce":[39],"JSON-to-Duality":[41,102],"Migrator,":[42],"an":[43,61,68],"automated":[44],"tool":[45],"for":[46,123],"migrating":[47],"applications":[48,217],"from":[49,67,77],"databases":[51],"to":[52,58,81,85,97,109,181,218,221],"Oracle.":[53],"The":[54,101],"migrator":[55,156],"allows":[56,216],"developers":[57],"(1)":[59],"design":[60],"effective":[62],"normalized":[63,134,205],"relational":[64,135,171,206,223],"schema,":[65,88,207],"derived":[66],"existing":[69],"set":[70],"JSON":[72,166,191],"collections,":[73],"(2)":[74],"migrate":[75,220],"a":[78,127,173,199,222],"database":[80,224],"Oracle,":[82],"while":[83,113,225],"transforming":[84],"target":[87],"(3)":[90],"lift-and-shift":[91],"application":[93,229],"transparently":[94,219],"minimal":[96],"no":[98],"code":[99],"changes.":[100],"Migrator":[103],"utilizes":[104,157],"unsupervised":[105],"artificial":[106],"intelligence":[107],"algorithms":[108],"automate":[110],"these":[111],"steps":[112],"simultaneously":[114],"addressing":[115],"non-trivial":[117],"challenge":[118],"supporting":[120],"schema":[121,136],"applications.":[124,188],"It":[125],"derives":[126],"2NF-compliant":[128],"(and":[129],"3NF":[130],"most":[132],"cases)":[133],"by":[137,187],"discovering":[138],"semantically":[139],"overlapping":[140],"attributes":[141],"mining":[143],"functional":[144],"dependencies":[145],"across":[146],"within":[148],"collections":[149],"denormalized":[152,195],"dataset.":[153],"Furthermore,":[154],"concept":[159],"duality":[161,200],"views,":[162],"which":[163,208],"updatable":[165],"views":[167],"on":[168],"top":[169],"data,":[172],"new":[174],"feature":[175],"Oracle":[177],"AI":[178],"Database":[179],"26ai,":[180],"preserve":[182],"object":[184],"model":[185],"desired":[186],"For":[189],"each":[190],"collection":[192],"dataset,":[196],"create":[198],"view":[201],"over":[202],"inferred":[204],"matches":[209],"shape":[211],"that":[213],"collection.":[214],"This":[215],"maintaining":[226],"document-centric":[228],"model.":[230]},"counts_by_year":[],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2026-05-27T00:00:00"}