{"id":"https://openalex.org/W2972941956","doi":"https://doi.org/10.1109/tkde.2019.2940019","title":"Bayesian Networks for Data Integration in the Absence of Foreign Keys","display_name":"Bayesian Networks for Data Integration in the Absence of Foreign Keys","publication_year":2019,"publication_date":"2019-09-11","ids":{"openalex":"https://openalex.org/W2972941956","doi":"https://doi.org/10.1109/tkde.2019.2940019","mag":"2972941956"},"language":"en","primary_location":{"id":"doi:10.1109/tkde.2019.2940019","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tkde.2019.2940019","pdf_url":null,"source":{"id":"https://openalex.org/S30698027","display_name":"IEEE Transactions on Knowledge and Data Engineering","issn_l":"1041-4347","issn":["1041-4347","1558-2191","2326-3865"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Knowledge and Data Engineering","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://figshare.com/articles/journal_contribution/Bayesian_Networks_for_Data_Integration_in_the_Absence_of_Foreign_Keys/20733262","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5052057696","display_name":"Bohan Zhang","orcid":"https://orcid.org/0000-0001-8477-0149"},"institutions":[{"id":"https://openalex.org/I106938459","display_name":"University of New Brunswick","ror":"https://ror.org/05nkf0n29","country_code":"CA","type":"education","lineage":["https://openalex.org/I106938459"]},{"id":"https://openalex.org/I2801862477","display_name":"Canada Research Chairs","ror":"https://ror.org/0517h6h17","country_code":"CA","type":"government","lineage":["https://openalex.org/I2801862477","https://openalex.org/I2802286613"]}],"countries":["CA"],"is_corresponding":true,"raw_author_name":"Bohan Zhang","raw_affiliation_strings":["Department of Mechanical and Industrial Engineering, 27 King's College Cir., Toronto, ON, Canada","Department of Mechanical and Industrial Engineering, 27 King's College Cir., Toronto, Canada"],"affiliations":[{"raw_affiliation_string":"Department of Mechanical and Industrial Engineering, 27 King's College Cir., Toronto, ON, Canada","institution_ids":["https://openalex.org/I2801862477"]},{"raw_affiliation_string":"Department of Mechanical and Industrial Engineering, 27 King's College Cir., Toronto, Canada","institution_ids":["https://openalex.org/I106938459"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5028174137","display_name":"Scott Sanner","orcid":"https://orcid.org/0000-0001-7984-8394"},"institutions":[{"id":"https://openalex.org/I106938459","display_name":"University of New Brunswick","ror":"https://ror.org/05nkf0n29","country_code":"CA","type":"education","lineage":["https://openalex.org/I106938459"]},{"id":"https://openalex.org/I2801862477","display_name":"Canada Research Chairs","ror":"https://ror.org/0517h6h17","country_code":"CA","type":"government","lineage":["https://openalex.org/I2801862477","https://openalex.org/I2802286613"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Scott Sanner","raw_affiliation_strings":["Department of Mechanical and Industrial Engineering, 27 King's College Cir., Toronto, ON, Canada","Department of Mechanical and Industrial Engineering, 27 King's College Cir., Toronto, Canada"],"affiliations":[{"raw_affiliation_string":"Department of Mechanical and Industrial Engineering, 27 King's College Cir., Toronto, ON, Canada","institution_ids":["https://openalex.org/I2801862477"]},{"raw_affiliation_string":"Department of Mechanical and Industrial Engineering, 27 King's College Cir., Toronto, Canada","institution_ids":["https://openalex.org/I106938459"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5018899731","display_name":"Mohamed Reda Bouadjenek","orcid":"https://orcid.org/0000-0003-1807-430X"},"institutions":[{"id":"https://openalex.org/I106938459","display_name":"University of New Brunswick","ror":"https://ror.org/05nkf0n29","country_code":"CA","type":"education","lineage":["https://openalex.org/I106938459"]},{"id":"https://openalex.org/I2801862477","display_name":"Canada Research Chairs","ror":"https://ror.org/0517h6h17","country_code":"CA","type":"government","lineage":["https://openalex.org/I2801862477","https://openalex.org/I2802286613"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Mohamed Reda Bouadjenek","raw_affiliation_strings":["Department of Mechanical and Industrial Engineering, 27 King's College Cir., Toronto, ON, Canada","Department of Mechanical and Industrial Engineering, 27 King's College Cir., Toronto, Canada"],"affiliations":[{"raw_affiliation_string":"Department of Mechanical and Industrial Engineering, 27 King's College Cir., Toronto, ON, Canada","institution_ids":["https://openalex.org/I2801862477"]},{"raw_affiliation_string":"Department of Mechanical and Industrial Engineering, 27 King's College Cir., Toronto, Canada","institution_ids":["https://openalex.org/I106938459"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5103059507","display_name":"Shagun Gupta","orcid":"https://orcid.org/0000-0003-4012-9522"},"institutions":[{"id":"https://openalex.org/I106938459","display_name":"University of New Brunswick","ror":"https://ror.org/05nkf0n29","country_code":"CA","type":"education","lineage":["https://openalex.org/I106938459"]},{"id":"https://openalex.org/I2801862477","display_name":"Canada Research Chairs","ror":"https://ror.org/0517h6h17","country_code":"CA","type":"government","lineage":["https://openalex.org/I2801862477","https://openalex.org/I2802286613"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Shagun Gupta","raw_affiliation_strings":["Department of Mechanical and Industrial Engineering, 27 King's College Cir., Toronto, ON, Canada","Department of Mechanical and Industrial Engineering, 27 King's College Cir., Toronto, Canada"],"affiliations":[{"raw_affiliation_string":"Department of Mechanical and Industrial Engineering, 27 King's College Cir., Toronto, ON, Canada","institution_ids":["https://openalex.org/I2801862477"]},{"raw_affiliation_string":"Department of Mechanical and Industrial Engineering, 27 King's College Cir., Toronto, Canada","institution_ids":["https://openalex.org/I106938459"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5052057696"],"corresponding_institution_ids":["https://openalex.org/I106938459","https://openalex.org/I2801862477"],"apc_list":null,"apc_paid":null,"fwci":0.6186,"has_fulltext":false,"cited_by_count":5,"citation_normalized_percentile":{"value":0.73650821,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":"32","issue":"4","first_page":"803","last_page":"808"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9984999895095825,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9984999895095825,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9983999729156494,"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"}},{"id":"https://openalex.org/T11303","display_name":"Bayesian Modeling and Causal Inference","score":0.9980999827384949,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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.8150331377983093},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.7034778594970703},{"id":"https://openalex.org/keywords/probabilistic-logic","display_name":"Probabilistic logic","score":0.6737419962882996},{"id":"https://openalex.org/keywords/inference","display_name":"Inference","score":0.6343285441398621},{"id":"https://openalex.org/keywords/data-integration","display_name":"Data integration","score":0.5999993085861206},{"id":"https://openalex.org/keywords/bayesian-network","display_name":"Bayesian network","score":0.5571900606155396},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.5519416928291321},{"id":"https://openalex.org/keywords/cardinality","display_name":"Cardinality (data modeling)","score":0.4805615246295929},{"id":"https://openalex.org/keywords/relation","display_name":"Relation (database)","score":0.44095680117607117},{"id":"https://openalex.org/keywords/population","display_name":"Population","score":0.41590142250061035},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.3755633234977722},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.3423804044723511},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3227250277996063},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.2748236060142517},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.19627845287322998}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8150331377983093},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.7034778594970703},{"id":"https://openalex.org/C49937458","wikidata":"https://www.wikidata.org/wiki/Q2599292","display_name":"Probabilistic logic","level":2,"score":0.6737419962882996},{"id":"https://openalex.org/C2776214188","wikidata":"https://www.wikidata.org/wiki/Q408386","display_name":"Inference","level":2,"score":0.6343285441398621},{"id":"https://openalex.org/C72634772","wikidata":"https://www.wikidata.org/wiki/Q386824","display_name":"Data integration","level":2,"score":0.5999993085861206},{"id":"https://openalex.org/C33724603","wikidata":"https://www.wikidata.org/wiki/Q812540","display_name":"Bayesian network","level":2,"score":0.5571900606155396},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.5519416928291321},{"id":"https://openalex.org/C87117476","wikidata":"https://www.wikidata.org/wiki/Q362383","display_name":"Cardinality (data modeling)","level":2,"score":0.4805615246295929},{"id":"https://openalex.org/C25343380","wikidata":"https://www.wikidata.org/wiki/Q277521","display_name":"Relation (database)","level":2,"score":0.44095680117607117},{"id":"https://openalex.org/C2908647359","wikidata":"https://www.wikidata.org/wiki/Q2625603","display_name":"Population","level":2,"score":0.41590142250061035},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3755633234977722},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.3423804044723511},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3227250277996063},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.2748236060142517},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.19627845287322998},{"id":"https://openalex.org/C149923435","wikidata":"https://www.wikidata.org/wiki/Q37732","display_name":"Demography","level":1,"score":0.0},{"id":"https://openalex.org/C144024400","wikidata":"https://www.wikidata.org/wiki/Q21201","display_name":"Sociology","level":0,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1109/tkde.2019.2940019","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tkde.2019.2940019","pdf_url":null,"source":{"id":"https://openalex.org/S30698027","display_name":"IEEE Transactions on Knowledge and Data Engineering","issn_l":"1041-4347","issn":["1041-4347","1558-2191","2326-3865"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Knowledge and Data Engineering","raw_type":"journal-article"},{"id":"pmh:oai:dro.deakin.edu.au:DU:30131224","is_oa":false,"landing_page_url":null,"pdf_url":null,"source":{"id":"https://openalex.org/S4306401102","display_name":"Own your potential (DEAKIN)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I149704539","host_organization_name":"Deakin University","host_organization_lineage":["https://openalex.org/I149704539"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Journal Article"},{"id":"pmh:oai:figshare.com:article/20733262","is_oa":true,"landing_page_url":"https://figshare.com/articles/journal_contribution/Bayesian_Networks_for_Data_Integration_in_the_Absence_of_Foreign_Keys/20733262","pdf_url":null,"source":{"id":"https://openalex.org/S4377196282","display_name":"Figshare","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I4210132348","host_organization_name":"Figshare (United Kingdom)","host_organization_lineage":["https://openalex.org/I4210132348"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Text"}],"best_oa_location":{"id":"pmh:oai:figshare.com:article/20733262","is_oa":true,"landing_page_url":"https://figshare.com/articles/journal_contribution/Bayesian_Networks_for_Data_Integration_in_the_Absence_of_Foreign_Keys/20733262","pdf_url":null,"source":{"id":"https://openalex.org/S4377196282","display_name":"Figshare","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I4210132348","host_organization_name":"Figshare (United Kingdom)","host_organization_lineage":["https://openalex.org/I4210132348"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Text"},"sustainable_development_goals":[{"display_name":"Gender equality","id":"https://metadata.un.org/sdg/5","score":0.6000000238418579}],"awards":[],"funders":[{"id":"https://openalex.org/F4320310942","display_name":"Ontario Centres of Excellence","ror":"https://ror.org/01t8nk565"},{"id":"https://openalex.org/F4320334593","display_name":"Natural Sciences and Engineering Research Council of Canada","ror":"https://ror.org/01h531d29"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":18,"referenced_works":["https://openalex.org/W1511986666","https://openalex.org/W1604794355","https://openalex.org/W1879587332","https://openalex.org/W1987094625","https://openalex.org/W1992673035","https://openalex.org/W2002826893","https://openalex.org/W2093149131","https://openalex.org/W2094394144","https://openalex.org/W2164545070","https://openalex.org/W2182148130","https://openalex.org/W2244913846","https://openalex.org/W2295944566","https://openalex.org/W2741470040","https://openalex.org/W2895423403","https://openalex.org/W4299881428","https://openalex.org/W6636453528","https://openalex.org/W6639422628","https://openalex.org/W6697199873"],"related_works":["https://openalex.org/W2002177687","https://openalex.org/W2058438338","https://openalex.org/W2019471580","https://openalex.org/W2941284322","https://openalex.org/W4224920876","https://openalex.org/W2168299207","https://openalex.org/W4308671316","https://openalex.org/W2920945101","https://openalex.org/W2124475651","https://openalex.org/W2977818562"],"abstract_inverted_index":{"In":[0,53],"the":[1,14,142,198,215,243,257],"era":[2],"of":[3,13,41,61,144,192,200,217,238,245,259],"open":[4],"data,":[5],"a":[6,25,45,123,218,223],"single":[7,224],"data":[8,34,38,67,71,79,89,124,189,203],"source":[9,80],"rarely":[10],"contains":[11],"all":[12],"attributes":[15,97,103,199,247],"we":[16,56,74,92,128,179],"need":[17],"for":[18,39,65,188],"inference":[19,130,216],"in":[20,122,138],"specific":[21],"applications.":[22],"For":[23],"example,":[24],"marketing":[26],"department":[27],"may":[28],"aim":[29],"to":[30,98,131,134,171,184,212,251],"integrate":[31],"retailer-specific":[32],"purchase":[33],"with":[35,49,86],"separate":[36],"demographic":[37],"purposes":[40],"targeted":[42],"advertising":[43],"-":[44],"capability":[46],"not":[47,94,112,118,161],"possible":[48],"either":[50],"dataset":[51],"alone.":[52],"this":[54],"work,":[55],"address":[57,156,162],"two":[58],"key":[59],"desiderata":[60,177],"an":[62,181],"automated":[63,182],"framework":[64,183,209],"probabilistic":[66,133,195],"integration":[68,190],"over":[69,222],"multiple":[70,201,231],"sources:":[72],"(1)":[73,164],"require":[75,95,129],"that":[76,207,226],"each":[77],"relational":[78,88,202],"share":[81],"at":[82],"least":[83],"one":[84],"attribute":[85],"another":[87],"source,":[90],"but":[91],"do":[93,117,160],"these":[96,254],"be":[99,132],"foreign":[100,113,145,169],"keys":[101,114,170],"(e.g.,":[102],"such":[104,150,241],"as":[105,151,242],"gender,":[106],"age,":[107],"and":[108,126,234,248],"postal":[109],"code":[110],"are":[111],"because":[115],"they":[116,159,166],"uniquely":[119],"identify":[120],"individuals":[121],"source)":[125],"(2)":[127],"reflect":[135],"inherent":[136],"uncertainty":[137],"population-level":[139],"predictions":[140],"given":[141],"absence":[143],"keys.":[146],"While":[147],"some":[148],"frameworks":[149],"Probabilistic":[152],"Relational":[153],"Models":[154],"(PRMs)":[155],"point":[157,163],"(2),":[158],"since":[165],"rely":[167],"on":[168],"link":[172],"tables.":[173],"To":[174],"achieve":[175],"both":[176],"simultaneously,":[178],"develop":[180],"construct":[185],"Bayesian":[186,220],"networks":[187],"capable":[191],"answering":[193],"any":[194],"query":[196],"spanning":[197],"sources.":[204],"We":[205],"demonstrate":[206],"our":[208],"is":[210],"able":[211],"closely":[213],"approximate":[214],"global":[219],"network":[221],"relation":[225],"has":[227],"been":[228],"projected":[229],"onto":[230],"local":[232,239],"relations":[233,240],"further":[235],"investigate":[236],"properties":[237,255],"number":[244],"shared":[246],"their":[249],"cardinality":[250],"understand":[252],"how":[253],"affect":[256],"quality":[258],"inference.":[260]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":2},{"year":2020,"cited_by_count":1}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}