{"id":"https://openalex.org/W3193062130","doi":"https://doi.org/10.1007/s10844-022-00700-0","title":"Handling inconsistencies in tables with nulls and functional dependencies","display_name":"Handling inconsistencies in tables with nulls and functional dependencies","publication_year":2022,"publication_date":"2022-04-15","ids":{"openalex":"https://openalex.org/W3193062130","doi":"https://doi.org/10.1007/s10844-022-00700-0","mag":"3193062130"},"language":"en","primary_location":{"id":"doi:10.1007/s10844-022-00700-0","is_oa":false,"landing_page_url":"https://doi.org/10.1007/s10844-022-00700-0","pdf_url":null,"source":{"id":"https://openalex.org/S36033921","display_name":"Journal of Intelligent Information Systems","issn_l":"0925-9902","issn":["0925-9902","1573-7675"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Intelligent Information Systems","raw_type":"journal-article"},"type":"article","indexed_in":["arxiv","crossref","datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"http://arxiv.org/pdf/2108.02581","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5050019723","display_name":"Dominique Laurent","orcid":"https://orcid.org/0000-0002-7264-9576"},"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/I4210142324","display_name":"CY Cergy Paris Universit\u00e9","ror":"https://ror.org/043htjv09","country_code":"FR","type":"education","lineage":["https://openalex.org/I4210142324"]},{"id":"https://openalex.org/I4210148552","display_name":"Equipes Traitement de l'Information et Syst\u00e8mes","ror":"https://ror.org/0592ata02","country_code":"FR","type":"facility","lineage":["https://openalex.org/I1294671590","https://openalex.org/I1294671590","https://openalex.org/I4210142324","https://openalex.org/I4210148552","https://openalex.org/I4210159245","https://openalex.org/I86175216"]},{"id":"https://openalex.org/I86175216","display_name":"\u00c9cole Nationale Sup\u00e9rieure de l'\u00c9lectronique et de ses Applications","ror":"https://ror.org/03qeacd72","country_code":"FR","type":"education","lineage":["https://openalex.org/I86175216"]}],"countries":["FR"],"is_corresponding":true,"raw_author_name":"Dominique Laurent","raw_affiliation_strings":["ETIS Laboratory, CY Cergy Paris University, ENSEA, CNRS, F-95000, Cergy-Pontoise, France","Equipes Traitement de l'Information et Syst\u00e8mes"],"raw_orcid":"https://orcid.org/0000-0002-7264-9576","affiliations":[{"raw_affiliation_string":"ETIS Laboratory, CY Cergy Paris University, ENSEA, CNRS, F-95000, Cergy-Pontoise, France","institution_ids":["https://openalex.org/I1294671590","https://openalex.org/I4210142324","https://openalex.org/I4210148552","https://openalex.org/I86175216"]},{"raw_affiliation_string":"Equipes Traitement de l'Information et Syst\u00e8mes","institution_ids":["https://openalex.org/I4210148552"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5034372518","display_name":"Nicolas Spyratos","orcid":"https://orcid.org/0000-0002-3432-8608"},"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/I277688954","display_name":"Universit\u00e9 Paris-Saclay","ror":"https://ror.org/03xjwb503","country_code":"FR","type":"education","lineage":["https://openalex.org/I277688954"]},{"id":"https://openalex.org/I4210113150","display_name":"Laboratoire Interdisciplinaire de Physique","ror":"https://ror.org/023n9q531","country_code":"FR","type":"facility","lineage":["https://openalex.org/I1294671590","https://openalex.org/I4210113150","https://openalex.org/I899635006"]},{"id":"https://openalex.org/I4387152856","display_name":"Laboratoire Interdisciplinaire des Sciences du Num\u00e9rique","ror":"https://ror.org/00rd81916","country_code":"FR","type":"facility","lineage":["https://openalex.org/I1294671590","https://openalex.org/I277688954","https://openalex.org/I4387152856"]}],"countries":["FR"],"is_corresponding":false,"raw_author_name":"Nicolas Spyratos","raw_affiliation_strings":["LISN Laboratory, University Paris-Saclay, CNRS, F-91405, Orsay, France","Laboratoire Interdisciplinaire des Sciences du Num\u00e9rique"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"LISN Laboratory, University Paris-Saclay, CNRS, F-91405, Orsay, France","institution_ids":["https://openalex.org/I1294671590","https://openalex.org/I277688954","https://openalex.org/I4387152856"]},{"raw_affiliation_string":"Laboratoire Interdisciplinaire des Sciences du Num\u00e9rique","institution_ids":["https://openalex.org/I4210113150","https://openalex.org/I4387152856"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":7,"corresponding_author_ids":["https://openalex.org/A5050019723"],"corresponding_institution_ids":["https://openalex.org/I1294671590","https://openalex.org/I4210142324","https://openalex.org/I4210148552","https://openalex.org/I86175216"],"apc_list":{"value":3090,"currency":"USD","value_usd":3090},"apc_paid":null,"fwci":0.0,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":{"value":0.00602155,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"59","issue":"2","first_page":"285","last_page":"317"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9120000004768372,"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.9120000004768372,"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.06469999998807907,"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.008200000040233135,"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.626377284526825},{"id":"https://openalex.org/keywords/functional-dependency","display_name":"Functional dependency","score":0.4418447017669678},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.32467585802078247},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.05591690540313721}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.626377284526825},{"id":"https://openalex.org/C26320393","wikidata":"https://www.wikidata.org/wiki/Q597053","display_name":"Functional dependency","level":3,"score":0.4418447017669678},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.32467585802078247},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.05591690540313721}],"mesh":[],"locations_count":5,"locations":[{"id":"doi:10.1007/s10844-022-00700-0","is_oa":false,"landing_page_url":"https://doi.org/10.1007/s10844-022-00700-0","pdf_url":null,"source":{"id":"https://openalex.org/S36033921","display_name":"Journal of Intelligent Information Systems","issn_l":"0925-9902","issn":["0925-9902","1573-7675"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Intelligent Information Systems","raw_type":"journal-article"},{"id":"pmh:oai:HAL:hal-04321475v1","is_oa":true,"landing_page_url":"https://hal.science/hal-04321475","pdf_url":"http://arxiv.org/pdf/2108.02581","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":"2023","raw_type":"info:eu-repo/semantics/preprint"},{"id":"pmh:oai:arXiv.org:2108.02581","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2108.02581","pdf_url":"https://arxiv.org/pdf/2108.02581","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},{"id":"pmh:oai:HAL:hal-03314808v1","is_oa":true,"landing_page_url":"https://hal.archives-ouvertes.fr/hal-03314808","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":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"https://hal.archives-ouvertes.fr/hal-03314808","raw_type":"info:eu-repo/semantics/preprint"},{"id":"doi:10.48550/arxiv.2108.02581","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2108.02581","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"Preprint"}],"best_oa_location":{"id":"pmh:oai:HAL:hal-04321475v1","is_oa":true,"landing_page_url":"https://hal.science/hal-04321475","pdf_url":"http://arxiv.org/pdf/2108.02581","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":"2023","raw_type":"info:eu-repo/semantics/preprint"},"sustainable_development_goals":[{"score":0.6399999856948853,"display_name":"Peace, Justice and strong institutions","id":"https://metadata.un.org/sdg/16"}],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W3193062130.pdf","grobid_xml":"https://content.openalex.org/works/W3193062130.grobid-xml"},"referenced_works_count":30,"referenced_works":["https://openalex.org/W1487409515","https://openalex.org/W1501162367","https://openalex.org/W1509428113","https://openalex.org/W1603863631","https://openalex.org/W1610496399","https://openalex.org/W1978460233","https://openalex.org/W1985239372","https://openalex.org/W1991408691","https://openalex.org/W1995375207","https://openalex.org/W2001805670","https://openalex.org/W2015200168","https://openalex.org/W2017293469","https://openalex.org/W2039610696","https://openalex.org/W2045054164","https://openalex.org/W2051200809","https://openalex.org/W2062180302","https://openalex.org/W2062796915","https://openalex.org/W2077518845","https://openalex.org/W2100908575","https://openalex.org/W2105486835","https://openalex.org/W2118866086","https://openalex.org/W2125366406","https://openalex.org/W2162621793","https://openalex.org/W2563015575","https://openalex.org/W2925535579","https://openalex.org/W2968918513","https://openalex.org/W3008589870","https://openalex.org/W3013461785","https://openalex.org/W6636177537","https://openalex.org/W6760474155"],"related_works":["https://openalex.org/W2347219288","https://openalex.org/W2354822586","https://openalex.org/W2366221835","https://openalex.org/W2308380777","https://openalex.org/W2605122768","https://openalex.org/W2390190248","https://openalex.org/W3033934107","https://openalex.org/W2261055457","https://openalex.org/W107081620","https://openalex.org/W2247690851"],"abstract_inverted_index":null,"counts_by_year":[],"updated_date":"2026-08-05T07:39:15.569665","created_date":"2022-07-25T00:00:00"}