{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,8,30]],"date-time":"2025-08-30T16:56:27Z","timestamp":1756572987294,"version":"3.37.3"},"reference-count":23,"publisher":"Springer Science and Business Media LLC","issue":"2","license":[{"start":{"date-parts":[[2022,4,15]],"date-time":"2022-04-15T00:00:00Z","timestamp":1649980800000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.springer.com\/tdm"},{"start":{"date-parts":[[2022,4,15]],"date-time":"2022-04-15T00:00:00Z","timestamp":1649980800000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.springer.com\/tdm"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":["J Intell Inf Syst"],"published-print":{"date-parts":[[2022,10]]},"DOI":"10.1007\/s10844-022-00700-0","type":"journal-article","created":{"date-parts":[[2022,4,15]],"date-time":"2022-04-15T00:02:43Z","timestamp":1649980963000},"page":"285-317","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":4,"title":["Handling inconsistencies in tables with nulls and functional dependencies"],"prefix":"10.1007","volume":"59","author":[{"ORCID":"https:\/\/orcid.org\/0000-0002-7264-9576","authenticated-orcid":false,"given":"Dominique","family":"Laurent","sequence":"first","affiliation":[]},{"given":"Nicolas","family":"Spyratos","sequence":"additional","affiliation":[]}],"member":"297","published-online":{"date-parts":[[2022,4,15]]},"reference":[{"key":"700_CR1","doi-asserted-by":"crossref","unstructured":"Afrati, F.N., & Kolaitis, P.G. (2009). Repair checking in inconsistent databases: algorithms and complexity. In R. Fagin (Ed.) Database Theory - ICDT 2009, 12th International Conference, Proceedings, volume 361 of ACM International Conference Proceeding Series, pp. 31\u201341. ACM.","DOI":"10.1145\/1514894.1514899"},{"key":"700_CR2","doi-asserted-by":"crossref","unstructured":"Arenas, M., Bertossi, L.E., & Chomicki, J. (1999). Consistent query answers in inconsistent databases. In V. Vianu C.H. Papadimitriou (Eds.) Proceedings of the Eighteenth ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems, Pennsylvania, USA, pages 68\u201379. ACM Press.","DOI":"10.1145\/303976.303983"},{"issue":"1-2","key":"700_CR3","doi-asserted-by":"publisher","first-page":"4","DOI":"10.1007\/s10472-005-9012-z","volume":"46","author":"O Arieli","year":"2006","unstructured":"Arieli, O., Denecker, M., Van Nuffelen, B., & Bruynooghe, M. (2006). Computational methods for database repair by signed formulae. Annals of Mathematics and Artificial Intelligence, 46(1-2), 4\u201337.","journal-title":"Annals of Mathematics and Artificial Intelligence"},{"issue":"2","key":"700_CR4","doi-asserted-by":"publisher","first-page":"212","DOI":"10.1145\/63500.63520","volume":"14","author":"P Atzeni","year":"1989","unstructured":"Atzeni, P., & Chan, E.P.F. (1989). Efficient optimization of simple chase join expressions. ACM Transactions on Database Systems, 14(2), 212\u2013230.","journal-title":"ACM Transactions on Database Systems"},{"key":"700_CR5","doi-asserted-by":"crossref","unstructured":"Belnap, N.D. (1977). A useful four-valued logic. In J.M. Dunn G. Epstein (Eds.) Modern Uses of Multiple-Valued Logic, pages 5\u201337\u201d, isbn=\u201d978\u201394\u2013010\u20131161\u20137, Dordrecht. Springer Netherlands.","DOI":"10.1007\/978-94-010-1161-7_2"},{"key":"700_CR6","doi-asserted-by":"crossref","unstructured":"Bertossi, L.E. (2011). Database Repairing and Consistent Query Answering. Synthesis Lectures on Data Management Morgan & Claypool Publishers.","DOI":"10.1007\/978-3-031-01883-1"},{"key":"700_CR7","doi-asserted-by":"crossref","unstructured":"Bravo, L., & Bertossi, L.E. (2006). Semantically correct query answers in the presence of null values. In T. Grust, H. H\u00f6pfner, A. Illarramendi, S. Jablonski, M. Mesiti, S. M\u00fcller, P.-L. Patranjan, K.-U. Sattler, M. Spiliopoulou, & J. Wijsen (Eds.) Current Trends in Database Technology - EDBT 2006, EDBT 2006 Workshops PhD, DataX, IIDB, IIHA, ICSNW, QLQP, PIM, paRMA, and Reactivity on the Web, Munich, Germany, March 26-31 Revised Selected Papers, volume 4254 of Lecture Notes in Computer Science, pages 336\u2013357, Springer, 2006.","DOI":"10.1007\/11896548_27"},{"key":"700_CR8","doi-asserted-by":"crossref","unstructured":"Bry, F. (1997). Query answering in information systems with integrity constraints. In S. Jajodia, W. List, G.W. McGregor, & L. Strous (Eds.) Integrity and Internal Control in Information Systems, volume 109 of IFIP Conference Proceedings, pages 113\u2013130. Chapman Hall.","DOI":"10.1007\/978-0-387-35317-3_6"},{"key":"700_CR9","doi-asserted-by":"crossref","unstructured":"Cal\u00ec, A., Lembo, D., & Rosati, R. (2003). On the decidability and complexity of query answering over inconsistent and incomplete databases. In F. Neven, C. Beeri, & T. Milo (Eds.) Proceedings of the Twenty-Second ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems, June 9-12, 2003, San Diego, CA, USA, pages 260\u2013271. ACM.","DOI":"10.1145\/773153.773179"},{"issue":"2","key":"700_CR10","doi-asserted-by":"publisher","first-page":"203","DOI":"10.1016\/0022-0000(86)90019-X","volume":"33","author":"SS Cosmadakis","year":"1986","unstructured":"Cosmadakis, S.S., Kanellakis, P.C., & Spyratos, N. (1986). Partition semantics for relations. Journal of Computer and System Sciences, 33(2), 203\u2013233.","journal-title":"Journal of Computer and System Sciences"},{"issue":"3","key":"700_CR11","doi-asserted-by":"publisher","first-page":"343","DOI":"10.1145\/319732.319735","volume":"7","author":"R Fagin","year":"1982","unstructured":"Fagin, R., Mendelzon, A.O., & Ullman, J.D. (1982). A simplified universal relation assumption and its properties. ACM Transactions on Database Systems, 7(3), 343\u2013360.","journal-title":"ACM Transactions on Database Systems"},{"issue":"2","key":"700_CR12","first-page":"9:1","volume":"42","author":"P Koutris","year":"2017","unstructured":"Koutris, P., & Wijsen, J. (2017). Consistent query answering for self-join-free conjunctive queries under primary key constraints ACM Trans. Database Systems, 42(2), 9:1\u20139:45.","journal-title":"Database Systems"},{"issue":"1","key":"700_CR13","first-page":"4:1","volume":"45","author":"E Livshits","year":"2020","unstructured":"Livshits, E., Kimelfeld, B., & Roy, S. (2020). Computing optimal repairs for functional dependencies ACM Trans. Database Systems, 45(1), 4:1\u20134:46.","journal-title":"Database Systems"},{"key":"700_CR14","doi-asserted-by":"crossref","unstructured":"Madera, C., & Laurent, A. (2016). The next information architecture evolution: The data lake wave. Inproceedings of the 8th International Conference on Management of Digital EcoSystems, MEDES, pages 174\u2013180, New York, NY, USA. ACM.","DOI":"10.1145\/3012071.3012077"},{"key":"700_CR15","unstructured":"Parisi, F., & Grant, J. (2019). Inconsistency measures for relational databases. CoRR, abs\/1904.03403."},{"issue":"4","key":"700_CR16","first-page":"3","volume":"23","author":"E Rahm","year":"2000","unstructured":"Rahm, E., & Do, H.H. (2000). Data cleaning: Problems and current approaches. IEEE Data Eng. Bull., 23(4), 3\u201313.","journal-title":"IEEE Data Eng. Bull."},{"key":"700_CR17","doi-asserted-by":"crossref","unstructured":"Reiter, R. (1977). On closed world data bases. In H. Gallaire J. Minker (Eds.) Logic and Data Bases, Symposium on Logic and Data Bases, Centre d\u2019\u00e9tudes et de recherches de Toulouse, France, 1977, Advances in Data Base Theory, pages 55\u201376, New York. Plemum Press.","DOI":"10.1007\/978-1-4684-3384-5_3"},{"issue":"1","key":"700_CR18","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1145\/12047.22718","volume":"12","author":"N Spyratos","year":"1987","unstructured":"Spyratos, N. (1987). The partition model: A deductive database model. ACM Transactions Database Systems, 12(1), 1\u201337.","journal-title":"ACM Transactions Database Systems"},{"key":"700_CR19","doi-asserted-by":"crossref","unstructured":"Spyratos, N., & L\u00e9cluse, C. (1987). Incorporating functional dependencies in deductive query answering. Inproceedings of the Third International Conference on Data Engineering, February 3-5, 1987, Los Angeles, California, USA, pages 658\u2013664. IEEE Computer Society.","DOI":"10.1109\/ICDE.1987.7272436"},{"key":"700_CR20","unstructured":"Ullman, J.D. (1988). Principles of Databases and Knowledge-Base Systems, volume 1-2 Computer Science Press."},{"issue":"2","key":"700_CR21","doi-asserted-by":"publisher","first-page":"80","DOI":"10.1109\/52.2015","volume":"5","author":"MY Vardi","year":"1988","unstructured":"Vardi, M.Y. (1988). The universal-relation data model for logical independence. IEEE Software, 5(2), 80\u201385.","journal-title":"IEEE Software"},{"issue":"3","key":"700_CR22","doi-asserted-by":"publisher","first-page":"722","DOI":"10.1145\/1093382.1093385","volume":"30","author":"J Wijsen","year":"2005","unstructured":"Wijsen, J. (2005). Database repairing using updates. ACM Transactions on Database Systems, 30(3), 722\u2013768.","journal-title":"ACM Transactions on Database Systems"},{"issue":"7","key":"700_CR23","doi-asserted-by":"publisher","first-page":"578","DOI":"10.1016\/j.is.2009.03.011","volume":"34","author":"J Wijsen","year":"2009","unstructured":"Wijsen, J. (2009). On the consistent rewriting of conjunctive queries under primary key constraints. Information Systems, 34(7), 578\u2013601.","journal-title":"Information Systems"}],"container-title":["Journal of Intelligent Information Systems"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/s10844-022-00700-0.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/article\/10.1007\/s10844-022-00700-0\/fulltext.html","content-type":"text\/html","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/s10844-022-00700-0.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,9,8]],"date-time":"2022-09-08T17:25:25Z","timestamp":1662657925000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/s10844-022-00700-0"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2022,4,15]]},"references-count":23,"journal-issue":{"issue":"2","published-print":{"date-parts":[[2022,10]]}},"alternative-id":["700"],"URL":"https:\/\/doi.org\/10.1007\/s10844-022-00700-0","relation":{},"ISSN":["0925-9902","1573-7675"],"issn-type":[{"type":"print","value":"0925-9902"},{"type":"electronic","value":"1573-7675"}],"subject":[],"published":{"date-parts":[[2022,4,15]]},"assertion":[{"value":"24 November 2021","order":1,"name":"received","label":"Received","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"3 March 2022","order":2,"name":"revised","label":"Revised","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"3 March 2022","order":3,"name":"accepted","label":"Accepted","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"15 April 2022","order":4,"name":"first_online","label":"First Online","group":{"name":"ArticleHistory","label":"Article History"}},{"order":1,"name":"Ethics","group":{"name":"EthicsHeading","label":"Declarations"}},{"value":"The authors declare they have no financial interests.","order":2,"name":"Ethics","group":{"name":"EthicsHeading","label":"Financial interests"}},{"value":"The second author is a member of the editorial board of the journal.","order":3,"name":"Ethics","group":{"name":"EthicsHeading","label":"Non-financial interests"}}]}}