{"id":"https://openalex.org/W1974688422","doi":"https://doi.org/10.1145/1265530.1265572","title":"Maximally joining probabilistic data","display_name":"Maximally joining probabilistic data","publication_year":2007,"publication_date":"2007-06-11","ids":{"openalex":"https://openalex.org/W1974688422","doi":"https://doi.org/10.1145/1265530.1265572","mag":"1974688422"},"language":"en","primary_location":{"id":"doi:10.1145/1265530.1265572","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1265530.1265572","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the twenty-sixth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5006706357","display_name":"Benny Kimelfeld","orcid":"https://orcid.org/0000-0002-7156-1572"},"institutions":[{"id":"https://openalex.org/I197251160","display_name":"Hebrew University of Jerusalem","ror":"https://ror.org/03qxff017","country_code":"IL","type":"education","lineage":["https://openalex.org/I197251160"]}],"countries":["IL"],"is_corresponding":true,"raw_author_name":"Benny Kimelfeld","raw_affiliation_strings":["The Hebrew University of Jerusalem","the Hebrew University of Jerusalem"],"affiliations":[{"raw_affiliation_string":"The Hebrew University of Jerusalem","institution_ids":["https://openalex.org/I197251160"]},{"raw_affiliation_string":"the Hebrew University of Jerusalem","institution_ids":["https://openalex.org/I197251160"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5014143171","display_name":"Yehoshua Sagiv","orcid":null},"institutions":[{"id":"https://openalex.org/I197251160","display_name":"Hebrew University of Jerusalem","ror":"https://ror.org/03qxff017","country_code":"IL","type":"education","lineage":["https://openalex.org/I197251160"]}],"countries":["IL"],"is_corresponding":false,"raw_author_name":"Yehoshua Sagiv","raw_affiliation_strings":["The Hebrew University of Jerusalem","the Hebrew University of Jerusalem"],"affiliations":[{"raw_affiliation_string":"The Hebrew University of Jerusalem","institution_ids":["https://openalex.org/I197251160"]},{"raw_affiliation_string":"the Hebrew University of Jerusalem","institution_ids":["https://openalex.org/I197251160"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5006706357"],"corresponding_institution_ids":["https://openalex.org/I197251160"],"apc_list":null,"apc_paid":null,"fwci":5.3837,"has_fulltext":false,"cited_by_count":29,"citation_normalized_percentile":{"value":0.96330691,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"303","last_page":"312"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9998999834060669,"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"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9998999834060669,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9998000264167786,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9994000196456909,"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/tuple","display_name":"Tuple","score":0.8132909536361694},{"id":"https://openalex.org/keywords/probabilistic-logic","display_name":"Probabilistic logic","score":0.6645647287368774},{"id":"https://openalex.org/keywords/joins","display_name":"Joins","score":0.6058814525604248},{"id":"https://openalex.org/keywords/constraint","display_name":"Constraint (computer-aided design)","score":0.5567265152931213},{"id":"https://openalex.org/keywords/semantics","display_name":"Semantics (computer science)","score":0.5428817272186279},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.5417658686637878},{"id":"https://openalex.org/keywords/joint-probability-distribution","display_name":"Joint probability distribution","score":0.47932636737823486},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.4636482000350952},{"id":"https://openalex.org/keywords/probability-distribution","display_name":"Probability distribution","score":0.42865610122680664},{"id":"https://openalex.org/keywords/degree","display_name":"Degree (music)","score":0.4103517234325409},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.3704344630241394},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.3481251001358032},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.3388189375400543},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.1448032557964325},{"id":"https://openalex.org/keywords/statistics","display_name":"Statistics","score":0.08944067358970642}],"concepts":[{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.8132909536361694},{"id":"https://openalex.org/C49937458","wikidata":"https://www.wikidata.org/wiki/Q2599292","display_name":"Probabilistic logic","level":2,"score":0.6645647287368774},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.6058814525604248},{"id":"https://openalex.org/C2776036281","wikidata":"https://www.wikidata.org/wiki/Q48769818","display_name":"Constraint (computer-aided design)","level":2,"score":0.5567265152931213},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.5428817272186279},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5417658686637878},{"id":"https://openalex.org/C18653775","wikidata":"https://www.wikidata.org/wiki/Q1333358","display_name":"Joint probability distribution","level":2,"score":0.47932636737823486},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4636482000350952},{"id":"https://openalex.org/C149441793","wikidata":"https://www.wikidata.org/wiki/Q200726","display_name":"Probability distribution","level":2,"score":0.42865610122680664},{"id":"https://openalex.org/C2775997480","wikidata":"https://www.wikidata.org/wiki/Q586277","display_name":"Degree (music)","level":2,"score":0.4103517234325409},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.3704344630241394},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.3481251001358032},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.3388189375400543},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.1448032557964325},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.08944067358970642},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"id":"https://openalex.org/C24890656","wikidata":"https://www.wikidata.org/wiki/Q82811","display_name":"Acoustics","level":1,"score":0.0},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1265530.1265572","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1265530.1265572","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the twenty-sixth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":29,"referenced_works":["https://openalex.org/W52840101","https://openalex.org/W1524541451","https://openalex.org/W1559824408","https://openalex.org/W1716383435","https://openalex.org/W1779256329","https://openalex.org/W1965761777","https://openalex.org/W1966124751","https://openalex.org/W1992609556","https://openalex.org/W1995061822","https://openalex.org/W1998076865","https://openalex.org/W2006912660","https://openalex.org/W2007940874","https://openalex.org/W2018327065","https://openalex.org/W2024400846","https://openalex.org/W2046649829","https://openalex.org/W2057773300","https://openalex.org/W2078686663","https://openalex.org/W2082055368","https://openalex.org/W2085988990","https://openalex.org/W2104498537","https://openalex.org/W2108940005","https://openalex.org/W2125791539","https://openalex.org/W2133457275","https://openalex.org/W2148417962","https://openalex.org/W2165676867","https://openalex.org/W2440178963","https://openalex.org/W6602175484","https://openalex.org/W6651768176","https://openalex.org/W6662062707"],"related_works":["https://openalex.org/W2016456293","https://openalex.org/W2161128265","https://openalex.org/W1997896902","https://openalex.org/W2138101384","https://openalex.org/W2140894225","https://openalex.org/W2125826941","https://openalex.org/W4212828571","https://openalex.org/W1987264987","https://openalex.org/W2951801950","https://openalex.org/W4297670780"],"abstract_inverted_index":{"Conceptually,":[0],"the":[1,16,22,27,30,51,60,69,78,84,90,122,142,161,172,180,197,203],"common":[2],"approach":[3,25,94],"to":[4,9,89,97],"manipulating":[5],"probabilistic":[6],"data":[7,149],"is":[8,71,104,126,200],"evaluate":[10],"relational":[11],"queries":[12],"and":[13,116,137,169],"then":[14,170],"calculate":[15],"probability":[17,70,120,140],"of":[18,32,63,80,109,134],"each":[19],"tuple":[20],"in":[21,53,195],"result.":[23],"This":[24],"ignores":[26],"possibility":[28],"that":[29,68,111,131],"probabilities":[31,178],"complete":[33],"answers":[34,41,55,133,168],"are":[35,56,112,132,146],"too":[36],"low":[37],"and,":[38],"hence,":[39],"partial":[40,135,167],"(with":[42],"sufficiently":[43],"high":[44],"probabilities)":[45],"become":[46],"important.":[47],"Therefore,":[48],"we":[49],"consider":[50,153],"semantics":[52],"which":[54,156],"maximal":[57,107,129,173],"(i.e.,":[58],"have":[59,117,138],"smallest":[61],"degree":[62],"incompleteness),":[64],"subject":[65],"tothe":[66],"constraint":[67],"still":[72],"above":[73,85,121,141,179],"a":[74,118,139],"given":[75],"threshold.We":[76],"investigate":[77],"complexity":[79],"joining":[81],"relations":[82],"under":[83,148],"semantics.":[86],"In":[87],"contrast":[88],"deterministic":[91],"case,":[92],"this":[93],"gives":[95],"rise":[96],"two":[98],"different":[99],"enumeration":[100],"problems.":[101],"The":[102,124],"first":[103,198],"finding":[105],"all":[106,128,166],"sets":[108],"tuples":[110,130],"join":[113],"consistent,":[114],"connected":[115],"joint":[119],"threshold.":[123,143,181],"second":[125],"computing":[127],"joins":[136],"Both":[144],"problems":[145],"tractable":[147],"complexity.":[150],"We":[151,182,191],"also":[152,192],"query-and-data":[154],"complexity,":[155],"rules":[157],"out":[158],"as":[159],"efficient":[160,184],"following":[162],"naive":[163],"algorithm:":[164],"compute":[165],"choose":[171],"ones":[174],"among":[175],"those":[176],"with":[177],"give":[183],"algorithms":[185],"for":[186],"several,":[187],"important":[188],"special":[189],"cases.":[190],"show":[193],"that,":[194],"general,":[196],"problem":[199],"NP-hard":[201],"whereas":[202],"secondis":[204],"#P-hard.":[205]},"counts_by_year":[{"year":2021,"cited_by_count":2},{"year":2014,"cited_by_count":5},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":3}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}