{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,4,8]],"date-time":"2026-04-08T08:54:42Z","timestamp":1775638482961,"version":"3.50.1"},"reference-count":40,"publisher":"Association for Computing Machinery (ACM)","issue":"2","license":[{"start":{"date-parts":[[2010,4,1]],"date-time":"2010-04-01T00:00:00Z","timestamp":1270080000000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.acm.org\/publications\/policies\/copyright_policy#Background"}],"content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":["ACM Trans. Database Syst."],"published-print":{"date-parts":[[2010,4]]},"abstract":"<jats:p>The problem of extracting consistent information from relational databases violating integrity constraints on numerical data is addressed. In particular, aggregate constraints defined as linear inequalities on aggregate-sum queries on input data are considered. The notion of repair as consistent set of updates at attribute-value level is exploited, and the characterization of several data-complexity issues related to repairing data and computing consistent query answers is provided. Moreover, a method for computing \u201creasonable\u201d repairs of inconsistent numerical databases is provided, for a restricted but expressive class of aggregate constraints. Several experiments are presented which assess the effectiveness of the proposed approach in real-life application scenarios.<\/jats:p>","DOI":"10.1145\/1735886.1735893","type":"journal-article","created":{"date-parts":[[2010,5,4]],"date-time":"2010-05-04T14:14:06Z","timestamp":1272982446000},"page":"1-50","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":39,"title":["Querying and repairing inconsistent numerical databases"],"prefix":"10.1145","volume":"35","author":[{"given":"Sergio","family":"Flesca","sequence":"first","affiliation":[{"name":"DEIS - Universit\u00e0 della Calabria, Rende (CS), Italy"}]},{"given":"Filippo","family":"Furfaro","sequence":"additional","affiliation":[{"name":"DEIS - Universit\u00e0 della Calabria, Rende (CS), Italy"}]},{"given":"Francesco","family":"Parisi","sequence":"additional","affiliation":[{"name":"DEIS - Universit\u00e0 della Calabria, Rende (CS), Italy"}]}],"member":"320","published-online":{"date-parts":[[2010,5,3]]},"reference":[{"key":"e_1_2_2_1_1","doi-asserted-by":"publisher","DOI":"10.1145\/1514894.1514899"},{"key":"e_1_2_2_2_1","volume-title":"Proceedings of the 11th International Conference on Data Engineering (ICDE). 495--504","author":"Agarwal S."},{"key":"e_1_2_2_3_1","doi-asserted-by":"publisher","DOI":"10.1145\/303976.303983"},{"key":"e_1_2_2_4_1","volume-title":"Proceedings of the 4th International Conference on Flexible Query Answering Systems (FQAS). 27--41","author":"Arenas M."},{"key":"e_1_2_2_5_1","doi-asserted-by":"publisher","DOI":"10.1017\/S1471068403001832"},{"key":"e_1_2_2_6_1","doi-asserted-by":"publisher","DOI":"10.1016\/S0304-3975(02)00737-5"},{"key":"e_1_2_2_7_1","volume-title":"Proceedings of the 1st International Conference on Computing Logic (CL). 926--941","author":"Arenas M."},{"key":"e_1_2_2_8_1","volume-title":"Proceedings of the 9th International Workshop on Non-Monotonic Reasoning (NMR). 160--170","author":"Barcel\u00f3 P."},{"key":"e_1_2_2_9_1","volume-title":"Proceedings of the 5th International Symposium on Practical Aspects of Declarative Languages (PADL). 208--222","author":"Barcel\u00f3 P."},{"key":"e_1_2_2_10_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.is.2008.01.005"},{"key":"e_1_2_2_11_1","doi-asserted-by":"publisher","DOI":"10.1145\/1066157.1066175"},{"key":"e_1_2_2_12_1","doi-asserted-by":"publisher","DOI":"10.5555\/646997.711427"},{"key":"e_1_2_2_13_1","doi-asserted-by":"publisher","DOI":"10.1145\/773153.773179"},{"key":"e_1_2_2_14_1","volume-title":"Proceedings of the 1st International Conference on Computing Logic (CL). 942--956","author":"Celle A."},{"key":"e_1_2_2_15_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.ic.2004.04.007"},{"key":"e_1_2_2_16_1","doi-asserted-by":"publisher","DOI":"10.1145\/1031171.1031254"},{"key":"e_1_2_2_17_1","doi-asserted-by":"publisher","DOI":"10.1016\/0004-3702(92)90018-S"},{"key":"e_1_2_2_18_1","doi-asserted-by":"publisher","DOI":"10.1007\/11896548_25"},{"key":"e_1_2_2_19_1","doi-asserted-by":"publisher","DOI":"10.1007\/11601524_18"},{"key":"e_1_2_2_20_1","volume-title":"Proceedings of the 8th International Conference on Logic for Programming, Artificial Intelligence, and Reasoning (LPAR). 561--578","author":"Franconi E."},{"key":"e_1_2_2_21_1","doi-asserted-by":"publisher","DOI":"10.1145\/1066157.1066176"},{"key":"e_1_2_2_22_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.jcss.2006.10.013"},{"key":"e_1_2_2_23_1","doi-asserted-by":"crossref","unstructured":"G\u00e4rdenfors P. and Rott H. 1995. Belief revision. In Handbook of Logic in Artificial Intelligence and Logic Programming (Vol. 4): Epistemic and Temporal Reasoning D. M. Gabbay C. J. Hogger and J. A. Robinson Eds. Oxford University Press Oxford UK 35--132. G\u00e4rdenfors P. and Rott H. 1995. Belief revision. In Handbook of Logic in Artificial Intelligence and Logic Programming (Vol. 4): Epistemic and Temporal Reasoning D. M. Gabbay C. J. Hogger and J. A. Robinson Eds. Oxford University Press Oxford UK 35--132.","DOI":"10.1093\/oso\/9780198537915.003.0002"},{"key":"e_1_2_2_24_1","volume-title":"Linear Programming: Methods and Applications","author":"Gass S. I.","year":"1985","edition":"5"},{"key":"e_1_2_2_25_1","doi-asserted-by":"publisher","DOI":"10.1109\/TKDE.2003.1245280"},{"key":"e_1_2_2_26_1","doi-asserted-by":"publisher","DOI":"10.1145\/1634.1886"},{"key":"e_1_2_2_27_1","doi-asserted-by":"publisher","DOI":"10.1007\/BF02613356"},{"key":"e_1_2_2_28_1","doi-asserted-by":"publisher","DOI":"10.1007\/BF00245460"},{"key":"e_1_2_2_29_1","doi-asserted-by":"publisher","DOI":"10.1007\/11965893_13"},{"key":"e_1_2_2_30_1","doi-asserted-by":"publisher","DOI":"10.1145\/322276.322287"},{"key":"e_1_2_2_31_1","volume-title":"Combinatorial Optimization: Algorithms and Complexity","author":"Papadimitriou C. H.","year":"1998"},{"key":"e_1_2_2_32_1","unstructured":"Papadimitriou C. M. 1994. Computational Complexity. Addison-Wesley Reading MA. Papadimitriou C. M. 1994. Computational Complexity. Addison-Wesley Reading MA."},{"key":"e_1_2_2_33_1","first-page":"3","article-title":"Data cleaning: Problems and current approaches","volume":"23","author":"Rahm E.","year":"2000","journal-title":"IEEE Data Engin. Bull."},{"key":"e_1_2_2_34_1","doi-asserted-by":"publisher","DOI":"10.1016\/S0304-3975(97)00011-X"},{"key":"e_1_2_2_35_1","doi-asserted-by":"publisher","DOI":"10.5555\/645505.656435"},{"key":"e_1_2_2_36_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-540-30204-9_20"},{"key":"e_1_2_2_37_1","doi-asserted-by":"publisher","DOI":"10.1145\/1093382.1093385"},{"key":"e_1_2_2_38_1","volume-title":"Proceedings of the International Workshop on Inconsistency and Incompleteness in Databases (IIDB). Position paper.","author":"Wijsen J.","year":"2006"},{"key":"e_1_2_2_39_1","doi-asserted-by":"publisher","DOI":"10.1145\/1514894.1514900"},{"key":"e_1_2_2_40_1","volume-title":"Proceedings of the 30th International Colloquium on Automata, Languages and Programming (ICALP). 668--680","author":"Xie G."}],"container-title":["ACM Transactions on Database Systems"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/1735886.1735893","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/1735886.1735893","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,18]],"date-time":"2025-06-18T12:45:33Z","timestamp":1750250733000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/1735886.1735893"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2010,4]]},"references-count":40,"journal-issue":{"issue":"2","published-print":{"date-parts":[[2010,4]]}},"alternative-id":["10.1145\/1735886.1735893"],"URL":"https:\/\/doi.org\/10.1145\/1735886.1735893","relation":{},"ISSN":["0362-5915","1557-4644"],"issn-type":[{"value":"0362-5915","type":"print"},{"value":"1557-4644","type":"electronic"}],"subject":[],"published":{"date-parts":[[2010,4]]},"assertion":[{"value":"2008-08-01","order":0,"name":"received","label":"Received","group":{"name":"publication_history","label":"Publication History"}},{"value":"2010-02-01","order":1,"name":"accepted","label":"Accepted","group":{"name":"publication_history","label":"Publication History"}},{"value":"2010-05-03","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}