{"id":"https://openalex.org/W4303984359","doi":"https://doi.org/10.1145/3567444","title":"A Survey on Mapping Semi-Structured Data and Graph Data to Relational Data","display_name":"A Survey on Mapping Semi-Structured Data and Graph Data to Relational Data","publication_year":2022,"publication_date":"2022-10-10","ids":{"openalex":"https://openalex.org/W4303984359","doi":"https://doi.org/10.1145/3567444"},"language":"en","primary_location":{"id":"doi:10.1145/3567444","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3567444","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3567444","source":{"id":"https://openalex.org/S157921468","display_name":"ACM Computing Surveys","issn_l":"0360-0300","issn":["0360-0300","1557-7341"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Computing Surveys","raw_type":"journal-article"},"type":"review","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://dl.acm.org/doi/pdf/10.1145/3567444","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5014098250","display_name":"Gongsheng Yuan","orcid":"https://orcid.org/0000-0002-7992-3179"},"institutions":[{"id":"https://openalex.org/I133731052","display_name":"University of Helsinki","ror":"https://ror.org/040af2s02","country_code":"FI","type":"education","lineage":["https://openalex.org/I133731052"]},{"id":"https://openalex.org/I76130692","display_name":"Zhejiang University","ror":"https://ror.org/00a2xv884","country_code":"CN","type":"education","lineage":["https://openalex.org/I76130692"]}],"countries":["CN","FI"],"is_corresponding":true,"raw_author_name":"Gongsheng Yuan","raw_affiliation_strings":["Zhejiang University, China and University of Helsinki, Helsinki, Finland"],"raw_orcid":"https://orcid.org/0000-0002-7992-3179","affiliations":[{"raw_affiliation_string":"Zhejiang University, China and University of Helsinki, Helsinki, Finland","institution_ids":["https://openalex.org/I133731052","https://openalex.org/I76130692"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5018627557","display_name":"Jiaheng Lu","orcid":"https://orcid.org/0000-0003-2067-454X"},"institutions":[{"id":"https://openalex.org/I133731052","display_name":"University of Helsinki","ror":"https://ror.org/040af2s02","country_code":"FI","type":"education","lineage":["https://openalex.org/I133731052"]}],"countries":["FI"],"is_corresponding":false,"raw_author_name":"Jiaheng Lu","raw_affiliation_strings":["University of Helsinki, Helsinki, Finland"],"raw_orcid":"https://orcid.org/0000-0003-2067-454X","affiliations":[{"raw_affiliation_string":"University of Helsinki, Helsinki, Finland","institution_ids":["https://openalex.org/I133731052"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5045326184","display_name":"Zhengtong Yan","orcid":"https://orcid.org/0000-0003-2383-5193"},"institutions":[{"id":"https://openalex.org/I133731052","display_name":"University of Helsinki","ror":"https://ror.org/040af2s02","country_code":"FI","type":"education","lineage":["https://openalex.org/I133731052"]}],"countries":["FI"],"is_corresponding":false,"raw_author_name":"Zhengtong Yan","raw_affiliation_strings":["University of Helsinki, Helsinki, Finland"],"raw_orcid":"https://orcid.org/0000-0003-2383-5193","affiliations":[{"raw_affiliation_string":"University of Helsinki, Helsinki, Finland","institution_ids":["https://openalex.org/I133731052"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5064646829","display_name":"Sai Wu","orcid":"https://orcid.org/0000-0002-1866-9197"},"institutions":[{"id":"https://openalex.org/I76130692","display_name":"Zhejiang University","ror":"https://ror.org/00a2xv884","country_code":"CN","type":"education","lineage":["https://openalex.org/I76130692"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Sai Wu","raw_affiliation_strings":["Zhejiang University, Hangzhou, China"],"raw_orcid":"https://orcid.org/0000-0002-1866-9197","affiliations":[{"raw_affiliation_string":"Zhejiang University, Hangzhou, China","institution_ids":["https://openalex.org/I76130692"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5014098250"],"corresponding_institution_ids":["https://openalex.org/I133731052","https://openalex.org/I76130692"],"apc_list":null,"apc_paid":null,"fwci":1.1225,"has_fulltext":true,"cited_by_count":14,"citation_normalized_percentile":{"value":0.7903102,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":94,"max":99},"biblio":{"volume":"55","issue":"10","first_page":"1","last_page":"38"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12292","display_name":"Graph Theory and Algorithms","score":0.9997000098228455,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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/T12292","display_name":"Graph Theory and Algorithms","score":0.9997000098228455,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9994000196456909,"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/T11106","display_name":"Data Management and Algorithms","score":0.9990000128746033,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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/computer-science","display_name":"Computer science","score":0.843269944190979},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.7538508176803589},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.6715604066848755},{"id":"https://openalex.org/keywords/semi-structured-data","display_name":"Semi-structured data","score":0.6391527056694031},{"id":"https://openalex.org/keywords/graph-database","display_name":"Graph database","score":0.5180961489677429},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.5119601488113403},{"id":"https://openalex.org/keywords/graph","display_name":"Graph","score":0.4957941472530365},{"id":"https://openalex.org/keywords/relational-calculus","display_name":"Relational calculus","score":0.4529399871826172},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3815496563911438},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.36609095335006714},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.23232069611549377}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.843269944190979},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.7538508176803589},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.6715604066848755},{"id":"https://openalex.org/C40077939","wikidata":"https://www.wikidata.org/wiki/Q2336004","display_name":"Semi-structured data","level":3,"score":0.6391527056694031},{"id":"https://openalex.org/C176225458","wikidata":"https://www.wikidata.org/wiki/Q595971","display_name":"Graph database","level":3,"score":0.5180961489677429},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.5119601488113403},{"id":"https://openalex.org/C132525143","wikidata":"https://www.wikidata.org/wiki/Q141488","display_name":"Graph","level":2,"score":0.4957941472530365},{"id":"https://openalex.org/C99436015","wikidata":"https://www.wikidata.org/wiki/Q1722436","display_name":"Relational calculus","level":4,"score":0.4529399871826172},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3815496563911438},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.36609095335006714},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.23232069611549377}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/3567444","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3567444","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3567444","source":{"id":"https://openalex.org/S157921468","display_name":"ACM Computing Surveys","issn_l":"0360-0300","issn":["0360-0300","1557-7341"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Computing Surveys","raw_type":"journal-article"},{"id":"pmh:oai:helda.helsinki.fi:10138/354263","is_oa":true,"landing_page_url":"http://hdl.handle.net/10138/354263","pdf_url":null,"source":{"id":"https://openalex.org/S4210213322","display_name":"Ty\u00f6v\u00e4entutkimus Vuosikirja","issn_l":"0784-1272","issn":["0784-1272","1459-7780"],"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Review Article"}],"best_oa_location":{"id":"doi:10.1145/3567444","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3567444","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3567444","source":{"id":"https://openalex.org/S157921468","display_name":"ACM Computing Surveys","issn_l":"0360-0300","issn":["0360-0300","1557-7341"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Computing Surveys","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G3705684834","display_name":null,"funder_award_id":"LZ21F020007","funder_id":"https://openalex.org/F4320338464","funder_display_name":"Natural Science Foundation of Zhejiang Province"},{"id":"https://openalex.org/G4199845722","display_name":null,"funder_award_id":"61872315","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"}],"funders":[{"id":"https://openalex.org/F4320321001","display_name":"National Natural Science Foundation of China","ror":"https://ror.org/01h0zpd94"},{"id":"https://openalex.org/F4320322725","display_name":"China Scholarship Council","ror":"https://ror.org/04atp4p48"},{"id":"https://openalex.org/F4320338464","display_name":"Natural Science Foundation of Zhejiang Province","ror":"https://ror.org/01h0zpd94"}],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4303984359.pdf","grobid_xml":"https://content.openalex.org/works/W4303984359.grobid-xml"},"referenced_works_count":99,"referenced_works":["https://openalex.org/W86589886","https://openalex.org/W1494981128","https://openalex.org/W1501096522","https://openalex.org/W1517852344","https://openalex.org/W1541742946","https://openalex.org/W1541750352","https://openalex.org/W1565595968","https://openalex.org/W1579323613","https://openalex.org/W1583928033","https://openalex.org/W1586198805","https://openalex.org/W1626923679","https://openalex.org/W1894510259","https://openalex.org/W1899101461","https://openalex.org/W1965139442","https://openalex.org/W1968112249","https://openalex.org/W1973440079","https://openalex.org/W1983969182","https://openalex.org/W1987367337","https://openalex.org/W2000656232","https://openalex.org/W2003398206","https://openalex.org/W2011094172","https://openalex.org/W2011716962","https://openalex.org/W2021651899","https://openalex.org/W2022679230","https://openalex.org/W2026894458","https://openalex.org/W2028716971","https://openalex.org/W2033523472","https://openalex.org/W2033971127","https://openalex.org/W2045988182","https://openalex.org/W2058480078","https://openalex.org/W2062451233","https://openalex.org/W2066223946","https://openalex.org/W2068266200","https://openalex.org/W2082425356","https://openalex.org/W2085882535","https://openalex.org/W2090330503","https://openalex.org/W2093608958","https://openalex.org/W2099711139","https://openalex.org/W2101942345","https://openalex.org/W2104476081","https://openalex.org/W2108072325","https://openalex.org/W2108658605","https://openalex.org/W2109464129","https://openalex.org/W2109843835","https://openalex.org/W2110982271","https://openalex.org/W2111087864","https://openalex.org/W2115478919","https://openalex.org/W2118791211","https://openalex.org/W2123686039","https://openalex.org/W2133491514","https://openalex.org/W2133640934","https://openalex.org/W2134532199","https://openalex.org/W2136679228","https://openalex.org/W2137152505","https://openalex.org/W2138489156","https://openalex.org/W2139114892","https://openalex.org/W2141449497","https://openalex.org/W2142234917","https://openalex.org/W2158763191","https://openalex.org/W2188212329","https://openalex.org/W2252034896","https://openalex.org/W2334529288","https://openalex.org/W2401139123","https://openalex.org/W2434390175","https://openalex.org/W2492101152","https://openalex.org/W2525609995","https://openalex.org/W2529935843","https://openalex.org/W2555280106","https://openalex.org/W2574472735","https://openalex.org/W2626449734","https://openalex.org/W2726307782","https://openalex.org/W2800277550","https://openalex.org/W2887418847","https://openalex.org/W2890036314","https://openalex.org/W2907544011","https://openalex.org/W2941208251","https://openalex.org/W2944053120","https://openalex.org/W2948974967","https://openalex.org/W2953028579","https://openalex.org/W2963114528","https://openalex.org/W2988119170","https://openalex.org/W2999206792","https://openalex.org/W3008286750","https://openalex.org/W3122240221","https://openalex.org/W3129285589","https://openalex.org/W3189317405","https://openalex.org/W3190137174","https://openalex.org/W3190214659","https://openalex.org/W3208159733","https://openalex.org/W4229614829","https://openalex.org/W4230872208","https://openalex.org/W4233419801","https://openalex.org/W4243649771","https://openalex.org/W4244180879","https://openalex.org/W4247785564","https://openalex.org/W4250409704","https://openalex.org/W4294638151","https://openalex.org/W6602529823","https://openalex.org/W6730416133"],"related_works":["https://openalex.org/W2085988990","https://openalex.org/W2005835473","https://openalex.org/W2056340443","https://openalex.org/W60748262","https://openalex.org/W1510134535","https://openalex.org/W2378275298","https://openalex.org/W1487241321","https://openalex.org/W2156787493","https://openalex.org/W1482632207","https://openalex.org/W2904587746"],"abstract_inverted_index":{"The":[0],"data":[1,27,49,66,69,99,102,174],"produced":[2],"by":[3],"various":[4,26,87],"services":[5],"should":[6],"be":[7,83],"stored":[8],"and":[9,32,35,63,67,76,100,110,123,132,144],"managed":[10],"in":[11,54,61,70],"an":[12],"appropriate":[13],"format":[14],"for":[15],"gaining":[16],"valuable":[17],"knowledge":[18],"conveniently.":[19],"This":[20],"leads":[21],"to":[22,85],"the":[23,39,42,121],"emergence":[24],"of":[25,115,125,141],"models,":[28,34],"including":[29],"relational,":[30],"semi-structured,":[31],"graph":[33,68,101],"so":[36,73],"on.":[37],"Considering":[38],"fact":[40],"that":[41,74],"mature":[43,75],"relational":[44,48,71,78,104,176],"databases":[45,72],"established":[46],"on":[47,96],"models":[50],"are":[51],"still":[52],"predominant":[53],"today\u2019s":[55],"market,":[56],"it":[57],"has":[58],"fueled":[59],"interest":[60],"storing":[62],"processing":[64],"semi-structured":[65,98],"powerful":[77],"databases\u2019":[79],"capabilities":[80],"can":[81,151],"all":[82],"applied":[84],"these":[86],"data.":[88],"In":[89],"this":[90,138,149],"survey,":[91],"we":[92,147],"review":[93],"existing":[94,142],"methods":[95,143],"mapping":[97,154,162,172],"into":[103,175],"tables,":[105],"analyze":[106],"their":[107],"major":[108],"features,":[109],"give":[111],"a":[112,167],"detailed":[113],"classification":[114],"those":[116],"methods.":[117],"We":[118],"also":[119],"summarize":[120],"merits":[122],"demerits":[124],"each":[126,160],"method,":[127],"introduce":[128],"open":[129,145],"research":[130,135,169],"challenges,":[131],"present":[133],"future":[134],"directions.":[136],"With":[137],"comprehensive":[139],"investigation":[140],"problems,":[146],"hope":[148],"survey":[150],"motivate":[152],"new":[153,168],"approaches":[155],"through":[156],"drawing":[157],"lessons":[158],"from":[159],"model\u2019s":[161],"strategies,":[163],"as":[164,166],"well":[165],"topic":[170],"-":[171],"multi-model":[173],"tables.":[177]},"counts_by_year":[{"year":2026,"cited_by_count":3},{"year":2025,"cited_by_count":5},{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":4}],"updated_date":"2026-03-27T05:58:40.876381","created_date":"2025-10-10T00:00:00"}