{"id":"https://openalex.org/W2741470040","doi":"https://doi.org/10.1145/3105959","title":"Detecting Inclusion Dependencies on Very Many Tables","display_name":"Detecting Inclusion Dependencies on Very Many Tables","publication_year":2017,"publication_date":"2017-07-31","ids":{"openalex":"https://openalex.org/W2741470040","doi":"https://doi.org/10.1145/3105959","mag":"2741470040"},"language":"en","primary_location":{"id":"doi:10.1145/3105959","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3105959","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"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 Transactions on Database Systems","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/A5053398740","display_name":"Fabian Tschirschnitz","orcid":null},"institutions":[{"id":"https://openalex.org/I143288331","display_name":"Hasso Plattner Institute","ror":"https://ror.org/058rn5r42","country_code":"DE","type":"facility","lineage":["https://openalex.org/I143288331","https://openalex.org/I176453806"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Fabian Tschirschnitz","raw_affiliation_strings":["Hasso Plattner Institute, Potsdam, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Hasso Plattner Institute, Potsdam, Germany","institution_ids":["https://openalex.org/I143288331"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5047144042","display_name":"Thorsten Papenbrock","orcid":"https://orcid.org/0000-0002-4019-8221"},"institutions":[{"id":"https://openalex.org/I143288331","display_name":"Hasso Plattner Institute","ror":"https://ror.org/058rn5r42","country_code":"DE","type":"facility","lineage":["https://openalex.org/I143288331","https://openalex.org/I176453806"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Thorsten Papenbrock","raw_affiliation_strings":["Hasso Plattner Institute, Potsdam, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Hasso Plattner Institute, Potsdam, Germany","institution_ids":["https://openalex.org/I143288331"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5053028480","display_name":"Felix Naumann","orcid":"https://orcid.org/0000-0002-4483-1389"},"institutions":[{"id":"https://openalex.org/I143288331","display_name":"Hasso Plattner Institute","ror":"https://ror.org/058rn5r42","country_code":"DE","type":"facility","lineage":["https://openalex.org/I143288331","https://openalex.org/I176453806"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Felix Naumann","raw_affiliation_strings":["Hasso Plattner Institute, Potsdam, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Hasso Plattner Institute, Potsdam, Germany","institution_ids":["https://openalex.org/I143288331"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I143288331"],"apc_list":null,"apc_paid":null,"fwci":2.594,"has_fulltext":false,"cited_by_count":27,"citation_normalized_percentile":{"value":0.90132144,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":"42","issue":"3","first_page":"1","last_page":"29"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9995999932289124,"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.9995999932289124,"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/T12016","display_name":"Web Data Mining and Analysis","score":0.9995999932289124,"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"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9957000017166138,"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.901380181312561},{"id":"https://openalex.org/keywords/bloom-filter","display_name":"Bloom filter","score":0.6676343679428101},{"id":"https://openalex.org/keywords/dependency","display_name":"Dependency (UML)","score":0.5463119745254517},{"id":"https://openalex.org/keywords/task","display_name":"Task (project management)","score":0.543216347694397},{"id":"https://openalex.org/keywords/dependency-theory","display_name":"Dependency theory (database theory)","score":0.487999826669693},{"id":"https://openalex.org/keywords/inclusion","display_name":"Inclusion (mineral)","score":0.47923544049263},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.47661057114601135},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.46811407804489136},{"id":"https://openalex.org/keywords/web-application","display_name":"Web application","score":0.42638295888900757},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.39685705304145813},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.373653769493103},{"id":"https://openalex.org/keywords/functional-dependency","display_name":"Functional dependency","score":0.353360652923584},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.23224028944969177},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.19498738646507263},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.17706188559532166}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.901380181312561},{"id":"https://openalex.org/C147224247","wikidata":"https://www.wikidata.org/wiki/Q885373","display_name":"Bloom filter","level":2,"score":0.6676343679428101},{"id":"https://openalex.org/C19768560","wikidata":"https://www.wikidata.org/wiki/Q320727","display_name":"Dependency (UML)","level":2,"score":0.5463119745254517},{"id":"https://openalex.org/C2780451532","wikidata":"https://www.wikidata.org/wiki/Q759676","display_name":"Task (project management)","level":2,"score":0.543216347694397},{"id":"https://openalex.org/C40683218","wikidata":"https://www.wikidata.org/wiki/Q5260625","display_name":"Dependency theory (database theory)","level":4,"score":0.487999826669693},{"id":"https://openalex.org/C109359841","wikidata":"https://www.wikidata.org/wiki/Q728944","display_name":"Inclusion (mineral)","level":2,"score":0.47923544049263},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.47661057114601135},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.46811407804489136},{"id":"https://openalex.org/C118643609","wikidata":"https://www.wikidata.org/wiki/Q189210","display_name":"Web application","level":2,"score":0.42638295888900757},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.39685705304145813},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.373653769493103},{"id":"https://openalex.org/C26320393","wikidata":"https://www.wikidata.org/wiki/Q597053","display_name":"Functional dependency","level":3,"score":0.353360652923584},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.23224028944969177},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.19498738646507263},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.17706188559532166},{"id":"https://openalex.org/C107993555","wikidata":"https://www.wikidata.org/wiki/Q1662673","display_name":"Gender studies","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},{"id":"https://openalex.org/C187736073","wikidata":"https://www.wikidata.org/wiki/Q2920921","display_name":"Management","level":1,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3105959","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3105959","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"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 Transactions on Database Systems","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/10","score":0.8199999928474426,"display_name":"Reduced inequalities"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":17,"referenced_works":["https://openalex.org/W204601728","https://openalex.org/W1549531352","https://openalex.org/W1964312191","https://openalex.org/W1996505782","https://openalex.org/W2012833704","https://openalex.org/W2027420911","https://openalex.org/W2089711563","https://openalex.org/W2108223890","https://openalex.org/W2112129552","https://openalex.org/W2123845384","https://openalex.org/W2140313762","https://openalex.org/W2140523882","https://openalex.org/W2162020046","https://openalex.org/W2182148130","https://openalex.org/W2232417456","https://openalex.org/W2295659583","https://openalex.org/W2593628691"],"related_works":["https://openalex.org/W2072918301","https://openalex.org/W2392606101","https://openalex.org/W2039445786","https://openalex.org/W3162070149","https://openalex.org/W2489943546","https://openalex.org/W2362842011","https://openalex.org/W2884840983","https://openalex.org/W2185054849","https://openalex.org/W2274317205","https://openalex.org/W2273673275"],"abstract_inverted_index":{"Detecting":[0,15],"inclusion":[1,34,62],"dependencies,":[2],"the":[3,18,28,44,53,68,75,88,116],"prerequisite":[4],"of":[5,20,25,41,80,90,98],"foreign":[6],"keys,":[7],"in":[8],"relational":[9],"data":[10],"is":[11,30],"a":[12,60,102],"challenging":[13],"task.":[14],"them":[16],"among":[17,50],"hundreds":[19],"thousands":[21],"or":[22],"even":[23],"millions":[24],"tables":[26,100],"on":[27,43,74,95,115],"web":[29],"daunting.":[31],"Still,":[32],"such":[33],"dependencies":[35],"can":[36],"help":[37],"connect":[38],"disparate":[39],"pieces":[40],"information":[42],"Web":[45,99],"and":[46,83,108],"reveal":[47,112],"unknown":[48],"relationships":[49],"tables.":[51],"With":[52],"algorithm":[54],"M":[55],"any":[56],",":[57],"we":[58],"present":[59],"novel":[61],"dependency":[63],"detection":[64],"algorithm,":[65],"specialized":[66],"for":[67],"very":[69],"many\u2014but":[70],"typically":[71],"small\u2014tables":[72],"found":[73],"Web.":[76,117],"We":[77],"make":[78],"use":[79],"Bloom":[81],"filters":[82],"indexed":[84],"bit-vectors":[85],"to":[86,111],"show":[87],"feasibility":[89],"our":[91],"approach.":[92],"Our":[93],"evaluation":[94],"two":[96],"corpora":[97],"shows":[101],"superior":[103],"runtime":[104],"over":[105],"known":[106],"approaches":[107],"its":[109],"usefulness":[110],"hidden":[113],"structures":[114]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":7},{"year":2023,"cited_by_count":6},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":6},{"year":2018,"cited_by_count":2},{"year":2017,"cited_by_count":1}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}