{"id":"https://openalex.org/W2791059415","doi":"https://doi.org/10.1145/3186549.3186551","title":"Provenance and Probabilities in Relational Databases","display_name":"Provenance and Probabilities in Relational Databases","publication_year":2018,"publication_date":"2018-02-22","ids":{"openalex":"https://openalex.org/W2791059415","doi":"https://doi.org/10.1145/3186549.3186551","mag":"2791059415"},"language":"en","primary_location":{"id":"doi:10.1145/3186549.3186551","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3186549.3186551","pdf_url":null,"source":{"id":"https://openalex.org/S47508943","display_name":"ACM SIGMOD Record","issn_l":"0163-5808","issn":["0163-5808","1943-5835"],"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":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM SIGMOD Record","raw_type":"journal-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/A5035414136","display_name":"Pierre Senellart","orcid":"https://orcid.org/0000-0002-7909-5369"},"institutions":[{"id":"https://openalex.org/I12356871","display_name":"T\u00e9l\u00e9com Paris","ror":"https://ror.org/01naq7912","country_code":"FR","type":"education","lineage":["https://openalex.org/I12356871","https://openalex.org/I205703379","https://openalex.org/I4210145102"]},{"id":"https://openalex.org/I1294671590","display_name":"Centre National de la Recherche Scientifique","ror":"https://ror.org/02feahw73","country_code":"FR","type":"government","lineage":["https://openalex.org/I1294671590"]},{"id":"https://openalex.org/I2746051580","display_name":"Universit\u00e9 Paris Sciences et Lettres","ror":"https://ror.org/013cjyk83","country_code":"FR","type":"education","lineage":["https://openalex.org/I2746051580"]},{"id":"https://openalex.org/I29607241","display_name":"\u00c9cole Normale Sup\u00e9rieure - PSL","ror":"https://ror.org/05a0dhs15","country_code":"FR","type":"other","lineage":["https://openalex.org/I2746051580","https://openalex.org/I29607241"]},{"id":"https://openalex.org/I4210161954","display_name":"D\u00e9partement d'Informatique","ror":"https://ror.org/05y6rqs46","country_code":"FR","type":"facility","lineage":["https://openalex.org/I1294671590","https://openalex.org/I1294671590","https://openalex.org/I1326498283","https://openalex.org/I2746051580","https://openalex.org/I29607241","https://openalex.org/I4210159245","https://openalex.org/I4210161954"]},{"id":"https://openalex.org/I4210165912","display_name":"Laboratoire Traitement et Communication de l\u2019Information","ror":"https://ror.org/057er4c39","country_code":"FR","type":"facility","lineage":["https://openalex.org/I12356871","https://openalex.org/I205703379","https://openalex.org/I4210145102","https://openalex.org/I4210165912"]}],"countries":["FR"],"is_corresponding":true,"raw_author_name":"Pierre Senellart","raw_affiliation_strings":["DI ENS, ENS, CNRS, PSL Research University & Inria Paris&LTCI, T\u00e9l\u00e9com ParisTech, Paris, France"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"DI ENS, ENS, CNRS, PSL Research University & Inria Paris&LTCI, T\u00e9l\u00e9com ParisTech, Paris, France","institution_ids":["https://openalex.org/I12356871","https://openalex.org/I1294671590","https://openalex.org/I2746051580","https://openalex.org/I29607241","https://openalex.org/I4210161954","https://openalex.org/I4210165912"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5035414136"],"corresponding_institution_ids":["https://openalex.org/I12356871","https://openalex.org/I1294671590","https://openalex.org/I2746051580","https://openalex.org/I29607241","https://openalex.org/I4210161954","https://openalex.org/I4210165912"],"apc_list":null,"apc_paid":null,"fwci":9.1093,"has_fulltext":false,"cited_by_count":36,"citation_normalized_percentile":{"value":0.97637566,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":"46","issue":"4","first_page":"5","last_page":"15"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.9998999834060669,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"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/T11986","display_name":"Scientific Computing and Data Management","score":0.9998999834060669,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9958000183105469,"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/T10715","display_name":"Distributed and Parallel Computing Systems","score":0.9918000102043152,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8230772018432617},{"id":"https://openalex.org/keywords/provenance","display_name":"Provenance","score":0.789291262626648},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.692144513130188},{"id":"https://openalex.org/keywords/probabilistic-database","display_name":"Probabilistic database","score":0.6492372751235962},{"id":"https://openalex.org/keywords/probabilistic-logic","display_name":"Probabilistic logic","score":0.5965726971626282},{"id":"https://openalex.org/keywords/relational-calculus","display_name":"Relational calculus","score":0.577603816986084},{"id":"https://openalex.org/keywords/relational-algebra","display_name":"Relational algebra","score":0.5694149732589722},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5643099546432495},{"id":"https://openalex.org/keywords/variety","display_name":"Variety (cybernetics)","score":0.5149660706520081},{"id":"https://openalex.org/keywords/focus","display_name":"Focus (optics)","score":0.5000088214874268},{"id":"https://openalex.org/keywords/rotation-formalisms-in-three-dimensions","display_name":"Rotation formalisms in three dimensions","score":0.4943821430206299},{"id":"https://openalex.org/keywords/representation","display_name":"Representation (politics)","score":0.48310208320617676},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.45491835474967957},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.45442700386047363},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.37418171763420105},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.3739323019981384},{"id":"https://openalex.org/keywords/database-theory","display_name":"Database theory","score":0.3665388226509094},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.09442776441574097},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.08436593413352966}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8230772018432617},{"id":"https://openalex.org/C2780049196","wikidata":"https://www.wikidata.org/wiki/Q23582628","display_name":"Provenance","level":2,"score":0.789291262626648},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.692144513130188},{"id":"https://openalex.org/C174539288","wikidata":"https://www.wikidata.org/wiki/Q7246853","display_name":"Probabilistic database","level":4,"score":0.6492372751235962},{"id":"https://openalex.org/C49937458","wikidata":"https://www.wikidata.org/wiki/Q2599292","display_name":"Probabilistic logic","level":2,"score":0.5965726971626282},{"id":"https://openalex.org/C99436015","wikidata":"https://www.wikidata.org/wiki/Q1722436","display_name":"Relational calculus","level":4,"score":0.577603816986084},{"id":"https://openalex.org/C95916125","wikidata":"https://www.wikidata.org/wiki/Q840540","display_name":"Relational algebra","level":3,"score":0.5694149732589722},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5643099546432495},{"id":"https://openalex.org/C136197465","wikidata":"https://www.wikidata.org/wiki/Q1729295","display_name":"Variety (cybernetics)","level":2,"score":0.5149660706520081},{"id":"https://openalex.org/C192209626","wikidata":"https://www.wikidata.org/wiki/Q190909","display_name":"Focus (optics)","level":2,"score":0.5000088214874268},{"id":"https://openalex.org/C171018156","wikidata":"https://www.wikidata.org/wiki/Q7370306","display_name":"Rotation formalisms in three dimensions","level":2,"score":0.4943821430206299},{"id":"https://openalex.org/C2776359362","wikidata":"https://www.wikidata.org/wiki/Q2145286","display_name":"Representation (politics)","level":3,"score":0.48310208320617676},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.45491835474967957},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.45442700386047363},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.37418171763420105},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3739323019981384},{"id":"https://openalex.org/C12439846","wikidata":"https://www.wikidata.org/wiki/Q4809258","display_name":"Database theory","level":3,"score":0.3665388226509094},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.09442776441574097},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.08436593413352966},{"id":"https://openalex.org/C120665830","wikidata":"https://www.wikidata.org/wiki/Q14620","display_name":"Optics","level":1,"score":0.0},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","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},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0},{"id":"https://openalex.org/C127313418","wikidata":"https://www.wikidata.org/wiki/Q1069","display_name":"Geology","level":0,"score":0.0},{"id":"https://openalex.org/C94625758","wikidata":"https://www.wikidata.org/wiki/Q7163","display_name":"Politics","level":2,"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/C5900021","wikidata":"https://www.wikidata.org/wiki/Q163082","display_name":"Petrology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3186549.3186551","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3186549.3186551","pdf_url":null,"source":{"id":"https://openalex.org/S47508943","display_name":"ACM SIGMOD Record","issn_l":"0163-5808","issn":["0163-5808","1943-5835"],"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":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM SIGMOD Record","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":56,"referenced_works":["https://openalex.org/W5450866","https://openalex.org/W143102102","https://openalex.org/W1517585663","https://openalex.org/W1552694902","https://openalex.org/W1575260591","https://openalex.org/W1575674182","https://openalex.org/W1643571618","https://openalex.org/W1742907402","https://openalex.org/W1899647947","https://openalex.org/W1968875243","https://openalex.org/W1988545508","https://openalex.org/W1990391007","https://openalex.org/W1992609556","https://openalex.org/W1996545223","https://openalex.org/W2010438070","https://openalex.org/W2017329944","https://openalex.org/W2023076960","https://openalex.org/W2024400846","https://openalex.org/W2024642328","https://openalex.org/W2029138494","https://openalex.org/W2030224590","https://openalex.org/W2040228039","https://openalex.org/W2049199200","https://openalex.org/W2058560220","https://openalex.org/W2078686663","https://openalex.org/W2079785597","https://openalex.org/W2110635115","https://openalex.org/W2115373755","https://openalex.org/W2125528794","https://openalex.org/W2133527541","https://openalex.org/W2143102052","https://openalex.org/W2163032274","https://openalex.org/W2166916904","https://openalex.org/W2167541073","https://openalex.org/W2170353829","https://openalex.org/W2186752618","https://openalex.org/W2293299776","https://openalex.org/W2295651644","https://openalex.org/W2338322935","https://openalex.org/W2341999675","https://openalex.org/W2442875144","https://openalex.org/W2613925147","https://openalex.org/W2733688566","https://openalex.org/W2741061345","https://openalex.org/W3099451540","https://openalex.org/W3103492182","https://openalex.org/W4206031975","https://openalex.org/W4206794571","https://openalex.org/W4298687135","https://openalex.org/W4300564796","https://openalex.org/W4375944001","https://openalex.org/W6633513001","https://openalex.org/W6660736801","https://openalex.org/W6684648153","https://openalex.org/W6697405692","https://openalex.org/W6785305666"],"related_works":["https://openalex.org/W2089781037","https://openalex.org/W2056340443","https://openalex.org/W2005835473","https://openalex.org/W1516375613","https://openalex.org/W2085988990","https://openalex.org/W1983413912","https://openalex.org/W1606829490","https://openalex.org/W3013843243","https://openalex.org/W2397160827","https://openalex.org/W2260630802"],"abstract_inverted_index":{"We":[0,10,43],"review":[1],"the":[2,38],"basics":[3],"of":[4,31,40],"data":[5,48],"provenance":[6,13,17,19,63],"in":[7,51,71],"relational":[8],"databases.":[9,73],"describe":[11],"different":[12],"formalisms,":[14],"from":[15],"Boolean":[16],"to":[18,33],"semirings":[20],"and":[21],"beyond,":[22],"that":[23],"can":[24],"be":[25],"used":[26,66],"for":[27,47,67],"a":[28,41,54],"wide":[29],"variety":[30],"purposes,":[32],"obtain":[34],"additional":[35],"information":[36],"on":[37,56],"output":[39],"query.":[42],"discuss":[44],"representation":[45],"systems":[46],"provenance,":[49],"circuits":[50],"particular,":[52],"with":[53],"focus":[55],"practical":[57],"implementation.":[58],"Finally,":[59],"we":[60],"explain":[61],"how":[62],"is":[64],"practically":[65],"probabilistic":[68,72],"query":[69],"evaluation":[70]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":3},{"year":2024,"cited_by_count":4},{"year":2023,"cited_by_count":3},{"year":2022,"cited_by_count":7},{"year":2021,"cited_by_count":5},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":5},{"year":2018,"cited_by_count":7}],"updated_date":"2026-07-22T07:51:19.307946","created_date":"2025-10-10T00:00:00"}