{"id":"https://openalex.org/W1964312191","doi":"https://doi.org/10.1016/s0306-4379(01)00027-8","title":"Discovering interesting inclusion dependencies: application to logical database tuning","display_name":"Discovering interesting inclusion dependencies: application to logical database tuning","publication_year":2002,"publication_date":"2002-03-01","ids":{"openalex":"https://openalex.org/W1964312191","doi":"https://doi.org/10.1016/s0306-4379(01)00027-8","mag":"1964312191"},"language":"en","primary_location":{"id":"doi:10.1016/s0306-4379(01)00027-8","is_oa":false,"landing_page_url":"https://doi.org/10.1016/s0306-4379(01)00027-8","pdf_url":null,"source":{"id":"https://openalex.org/S193006928","display_name":"Information Systems","issn_l":"0306-4379","issn":["0306-4379","1873-6076"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Information 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/A5103586768","display_name":"St\u00e9phane Lopes","orcid":null},"institutions":[{"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/I198244214","display_name":"Universit\u00e9 Clermont Auvergne","ror":"https://ror.org/01a8ajp46","country_code":"FR","type":"education","lineage":["https://openalex.org/I198244214"]},{"id":"https://openalex.org/I4210099416","display_name":"Laboratoire d'Informatique, de Mod\u00e9lisation et d'Optimisation des Syst\u00e8mes","ror":"https://ror.org/00t3fpp34","country_code":"FR","type":"facility","lineage":["https://openalex.org/I1294671590","https://openalex.org/I1294671590","https://openalex.org/I198244214","https://openalex.org/I198244214","https://openalex.org/I203339264","https://openalex.org/I205703379","https://openalex.org/I3019848993","https://openalex.org/I4210099416","https://openalex.org/I4210123221","https://openalex.org/I4210159245","https://openalex.org/I4387154249"]}],"countries":["FR"],"is_corresponding":false,"raw_author_name":"St\u00e9phane Lopes","raw_affiliation_strings":["Laboratoire LIMOS, FRE CNRS 2239, Universit\u00e9 Blaise Pascal, Campus Universitaire des C\u00e9zeaux, 24 Avenue des Landais, 63 177 Aubi\u00e8re cedex, France","Laboratoire LIMOS, FRE CNRS 2239, Universit\u00e9 Blaise Pascal, Campus Universitaire des C\u00e9zeaux, 24 Avenue des Landais, Aubi\u00e8re cedex, France#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Laboratoire LIMOS, FRE CNRS 2239, Universit\u00e9 Blaise Pascal, Campus Universitaire des C\u00e9zeaux, 24 Avenue des Landais, 63 177 Aubi\u00e8re cedex, France","institution_ids":["https://openalex.org/I1294671590","https://openalex.org/I198244214","https://openalex.org/I4210099416"]},{"raw_affiliation_string":"Laboratoire LIMOS, FRE CNRS 2239, Universit\u00e9 Blaise Pascal, Campus Universitaire des C\u00e9zeaux, 24 Avenue des Landais, Aubi\u00e8re cedex, France#TAB#","institution_ids":["https://openalex.org/I1294671590","https://openalex.org/I198244214"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5064659680","display_name":"Jean-Marc Petit","orcid":"https://orcid.org/0000-0002-0015-745X"},"institutions":[{"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/I198244214","display_name":"Universit\u00e9 Clermont Auvergne","ror":"https://ror.org/01a8ajp46","country_code":"FR","type":"education","lineage":["https://openalex.org/I198244214"]},{"id":"https://openalex.org/I4210099416","display_name":"Laboratoire d'Informatique, de Mod\u00e9lisation et d'Optimisation des Syst\u00e8mes","ror":"https://ror.org/00t3fpp34","country_code":"FR","type":"facility","lineage":["https://openalex.org/I1294671590","https://openalex.org/I1294671590","https://openalex.org/I198244214","https://openalex.org/I198244214","https://openalex.org/I203339264","https://openalex.org/I205703379","https://openalex.org/I3019848993","https://openalex.org/I4210099416","https://openalex.org/I4210123221","https://openalex.org/I4210159245","https://openalex.org/I4387154249"]}],"countries":["FR"],"is_corresponding":true,"raw_author_name":"Jean-Marc Petit","raw_affiliation_strings":["Laboratoire LIMOS, FRE CNRS 2239, Universit\u00e9 Blaise Pascal, Campus Universitaire des C\u00e9zeaux, 24 Avenue des Landais, 63 177 Aubi\u00e8re cedex, France","Laboratoire LIMOS, FRE CNRS 2239, Universit\u00e9 Blaise Pascal, Campus Universitaire des C\u00e9zeaux, 24 Avenue des Landais, Aubi\u00e8re cedex, France#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Laboratoire LIMOS, FRE CNRS 2239, Universit\u00e9 Blaise Pascal, Campus Universitaire des C\u00e9zeaux, 24 Avenue des Landais, 63 177 Aubi\u00e8re cedex, France","institution_ids":["https://openalex.org/I1294671590","https://openalex.org/I198244214","https://openalex.org/I4210099416"]},{"raw_affiliation_string":"Laboratoire LIMOS, FRE CNRS 2239, Universit\u00e9 Blaise Pascal, Campus Universitaire des C\u00e9zeaux, 24 Avenue des Landais, Aubi\u00e8re cedex, France#TAB#","institution_ids":["https://openalex.org/I1294671590","https://openalex.org/I198244214"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5051532575","display_name":"Farouk Toumani","orcid":"https://orcid.org/0000-0002-5086-3301"},"institutions":[{"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/I198244214","display_name":"Universit\u00e9 Clermont Auvergne","ror":"https://ror.org/01a8ajp46","country_code":"FR","type":"education","lineage":["https://openalex.org/I198244214"]},{"id":"https://openalex.org/I4210099416","display_name":"Laboratoire d'Informatique, de Mod\u00e9lisation et d'Optimisation des Syst\u00e8mes","ror":"https://ror.org/00t3fpp34","country_code":"FR","type":"facility","lineage":["https://openalex.org/I1294671590","https://openalex.org/I1294671590","https://openalex.org/I198244214","https://openalex.org/I198244214","https://openalex.org/I203339264","https://openalex.org/I205703379","https://openalex.org/I3019848993","https://openalex.org/I4210099416","https://openalex.org/I4210123221","https://openalex.org/I4210159245","https://openalex.org/I4387154249"]}],"countries":["FR"],"is_corresponding":false,"raw_author_name":"Farouk Toumani","raw_affiliation_strings":["Laboratoire LIMOS, FRE CNRS 2239, Universit\u00e9 Blaise Pascal, Campus Universitaire des C\u00e9zeaux, 24 Avenue des Landais, 63 177 Aubi\u00e8re cedex, France","Laboratoire LIMOS, FRE CNRS 2239, Universit\u00e9 Blaise Pascal, Campus Universitaire des C\u00e9zeaux, 24 Avenue des Landais, Aubi\u00e8re cedex, France#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Laboratoire LIMOS, FRE CNRS 2239, Universit\u00e9 Blaise Pascal, Campus Universitaire des C\u00e9zeaux, 24 Avenue des Landais, 63 177 Aubi\u00e8re cedex, France","institution_ids":["https://openalex.org/I1294671590","https://openalex.org/I198244214","https://openalex.org/I4210099416"]},{"raw_affiliation_string":"Laboratoire LIMOS, FRE CNRS 2239, Universit\u00e9 Blaise Pascal, Campus Universitaire des C\u00e9zeaux, 24 Avenue des Landais, Aubi\u00e8re cedex, France#TAB#","institution_ids":["https://openalex.org/I1294671590","https://openalex.org/I198244214"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5064659680"],"corresponding_institution_ids":["https://openalex.org/I1294671590","https://openalex.org/I198244214","https://openalex.org/I4210099416"],"apc_list":{"value":2840,"currency":"USD","value_usd":2840},"apc_paid":null,"fwci":2.5669,"has_fulltext":false,"cited_by_count":51,"citation_normalized_percentile":{"value":0.8929121,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":93,"max":99},"biblio":{"volume":"27","issue":"1","first_page":"1","last_page":"19"},"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9991999864578247,"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.9957000017166138,"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.8386774659156799},{"id":"https://openalex.org/keywords/functional-dependency","display_name":"Functional dependency","score":0.8221573829650879},{"id":"https://openalex.org/keywords/dependency-theory","display_name":"Dependency theory (database theory)","score":0.5929071307182312},{"id":"https://openalex.org/keywords/inclusion","display_name":"Inclusion (mineral)","score":0.5610891580581665},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.553169846534729},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5519315004348755},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5175013542175293},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.4932231307029724},{"id":"https://openalex.org/keywords/exploit","display_name":"Exploit","score":0.47572091221809387},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.45520877838134766},{"id":"https://openalex.org/keywords/task","display_name":"Task (project management)","score":0.4311717748641968},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.41522645950317383},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.35153865814208984},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.18386578559875488}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8386774659156799},{"id":"https://openalex.org/C26320393","wikidata":"https://www.wikidata.org/wiki/Q597053","display_name":"Functional dependency","level":3,"score":0.8221573829650879},{"id":"https://openalex.org/C40683218","wikidata":"https://www.wikidata.org/wiki/Q5260625","display_name":"Dependency theory (database theory)","level":4,"score":0.5929071307182312},{"id":"https://openalex.org/C109359841","wikidata":"https://www.wikidata.org/wiki/Q728944","display_name":"Inclusion (mineral)","level":2,"score":0.5610891580581665},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.553169846534729},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5519315004348755},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5175013542175293},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.4932231307029724},{"id":"https://openalex.org/C165696696","wikidata":"https://www.wikidata.org/wiki/Q11287","display_name":"Exploit","level":2,"score":0.47572091221809387},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.45520877838134766},{"id":"https://openalex.org/C2780451532","wikidata":"https://www.wikidata.org/wiki/Q759676","display_name":"Task (project management)","level":2,"score":0.4311717748641968},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.41522645950317383},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.35153865814208984},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.18386578559875488},{"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/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","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/C144024400","wikidata":"https://www.wikidata.org/wiki/Q21201","display_name":"Sociology","level":0,"score":0.0},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1016/s0306-4379(01)00027-8","is_oa":false,"landing_page_url":"https://doi.org/10.1016/s0306-4379(01)00027-8","pdf_url":null,"source":{"id":"https://openalex.org/S193006928","display_name":"Information Systems","issn_l":"0306-4379","issn":["0306-4379","1873-6076"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Information Systems","raw_type":"journal-article"},{"id":"pmh:oai:HAL:hal-00286638v1","is_oa":false,"landing_page_url":"https://hal.science/hal-00286638","pdf_url":null,"source":{"id":"https://openalex.org/S4306402512","display_name":"HAL (Le Centre pour la Communication Scientifique Directe)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1294671590","host_organization_name":"Centre National de la Recherche Scientifique","host_organization_lineage":["https://openalex.org/I1294671590"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Information Systems, 2002, 27 (1), pp.1-19. ⟨10.1016/S0306-4379(01)00027-8⟩","raw_type":"info:eu-repo/semantics/article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/10","display_name":"Reduced inequalities","score":0.7900000214576721}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":53,"referenced_works":["https://openalex.org/W23860297","https://openalex.org/W145159521","https://openalex.org/W198128062","https://openalex.org/W204601728","https://openalex.org/W1482752581","https://openalex.org/W1493938990","https://openalex.org/W1517231072","https://openalex.org/W1536166128","https://openalex.org/W1542880907","https://openalex.org/W1562478345","https://openalex.org/W1565494300","https://openalex.org/W1571341547","https://openalex.org/W1572276977","https://openalex.org/W1594555416","https://openalex.org/W1598358745","https://openalex.org/W1819449330","https://openalex.org/W1977683474","https://openalex.org/W1983428002","https://openalex.org/W1989650131","https://openalex.org/W1992764659","https://openalex.org/W1994962776","https://openalex.org/W1998046157","https://openalex.org/W2010499454","https://openalex.org/W2043885422","https://openalex.org/W2047085757","https://openalex.org/W2050480346","https://openalex.org/W2055255408","https://openalex.org/W2055958975","https://openalex.org/W2056168203","https://openalex.org/W2079992169","https://openalex.org/W2098932141","https://openalex.org/W2103914162","https://openalex.org/W2109464129","https://openalex.org/W2118676972","https://openalex.org/W2125227861","https://openalex.org/W2125467710","https://openalex.org/W2125552274","https://openalex.org/W2127972622","https://openalex.org/W2140190241","https://openalex.org/W2142550009","https://openalex.org/W2148291485","https://openalex.org/W2150817871","https://openalex.org/W2160825121","https://openalex.org/W2211823484","https://openalex.org/W2295944566","https://openalex.org/W2489748212","https://openalex.org/W2788164529","https://openalex.org/W2912102406","https://openalex.org/W4301073899","https://openalex.org/W6631194406","https://openalex.org/W6632541229","https://openalex.org/W6681914700","https://openalex.org/W6697199873"],"related_works":["https://openalex.org/W2039445786","https://openalex.org/W2884840983","https://openalex.org/W2185054849","https://openalex.org/W2274317205","https://openalex.org/W2273673275","https://openalex.org/W2361244046","https://openalex.org/W2126493028","https://openalex.org/W2098412524","https://openalex.org/W2582695666","https://openalex.org/W2807313188"],"abstract_inverted_index":null,"counts_by_year":[{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":2},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":3},{"year":2019,"cited_by_count":4},{"year":2018,"cited_by_count":6},{"year":2017,"cited_by_count":3},{"year":2015,"cited_by_count":2},{"year":2014,"cited_by_count":4},{"year":2013,"cited_by_count":3},{"year":2012,"cited_by_count":2}],"updated_date":"2026-08-08T01:25:22.217667","created_date":"2025-10-10T00:00:00"}