{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,3,10]],"date-time":"2026-03-10T14:46:18Z","timestamp":1773153978361,"version":"3.50.1"},"reference-count":12,"publisher":"Association for Computing Machinery (ACM)","issue":"2","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2008,8]]},"abstract":"<jats:p>\n            We present Semandaq, a prototype system for improving the quality of relational data. Based on the recently proposed\n            <jats:italic>conditional functional dependencies<\/jats:italic>\n            (CFDs), it detects and repairs errors and inconsistencies that emerge as violations of these constraints. We demonstrate the following functionalities supported by Semandaq: (a) an interface for specifying CFDs; (b) a visual tool for automated detection of CFD violations in relational data, leveraging efficient SQL-based techniques; (c) extensive visual data exploration capabilities that provide the user with various measures of the quality of the data; (d) repair (cleaning) functionality without excess human interaction, built upon CFD-based cleaning algorithms; we show how Semandaq allows for a natural exploration of the quality of the obtained repairs. Semandaq is a promising tool that provides easy access and user-friendly data quality facilities for any relational database system.\n          <\/jats:p>","DOI":"10.14778\/1454159.1454200","type":"journal-article","created":{"date-parts":[[2014,6,24]],"date-time":"2014-06-24T12:17:57Z","timestamp":1403612277000},"page":"1460-1463","source":"Crossref","is-referenced-by-count":24,"title":["Semandaq"],"prefix":"10.14778","volume":"1","author":[{"given":"Wenfei","family":"Fan","sequence":"first","affiliation":[{"name":"University of Edinburgh and Bell Laboratories"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Floris","family":"Geerts","sequence":"additional","affiliation":[{"name":"University of Edinburgh"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Xibei","family":"Jia","sequence":"additional","affiliation":[{"name":"University of Edinburgh"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2008,8]]},"reference":[{"key":"e_1_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.1017\/S1471068403001832"},{"key":"e_1_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.1145\/1066157.1066175"},{"key":"e_1_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.1145\/1366102.1366103"},{"key":"e_1_2_1_4_1","doi-asserted-by":"publisher","DOI":"10.1080\/01621459.1976.10481472"},{"key":"e_1_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.5555\/645710.664461"},{"key":"e_1_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.1145\/1066157.1066176"},{"key":"e_1_2_1_7_1","volume-title":"VLDB","author":"Galhardas H.","year":"2001","unstructured":"H. Galhardas , D. Florescu , D. Shasha , E. Simon , and C.-A. Saita . Declarative data cleaning: Language, model and algorithms . In VLDB , 2001 . H. Galhardas, D. Florescu, D. Shasha, E. Simon, and C.-A. Saita. Declarative data cleaning: Language, model and algorithms. In VLDB, 2001."},{"key":"e_1_2_1_8_1","volume-title":"VLDB","author":"Gao C.","year":"2007","unstructured":"C. Gao , W. Fan , F. Geerts , X. Jia , and S. Ma . Improving data quality: Consistency and accuracy . In VLDB , 2007 . C. Gao, W. Fan, F. Geerts, X. Jia, and S. Ma. Improving data quality: Consistency and accuracy. In VLDB, 2007."},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.1007\/11965893_13"},{"key":"e_1_2_1_10_1","unstructured":"Press release Gartner Inc. February 3 2005 quoting Bill Hostmann Research Director presenting at Gartner Business Intelligence Summit in London UK. http:\/\/www.gartner.com\/press_releases\/asset_119071_11.html.  Press release Gartner Inc. February 3 2005 quoting Bill Hostmann Research Director presenting at Gartner Business Intelligence Summit in London UK. http:\/\/www.gartner.com\/press_releases\/asset_119071_11.html."},{"key":"e_1_2_1_11_1","volume-title":"VLDB","author":"Raman V.","year":"2001","unstructured":"V. Raman and J. M. Hellerstein . Potter's wheel: An interactive data cleaning system . In VLDB , 2001 . V. Raman and J. M. Hellerstein. Potter's wheel: An interactive data cleaning system. In VLDB, 2001."},{"key":"e_1_2_1_12_1","volume-title":"Inc.","author":"Shilakes C. C.","year":"1998","unstructured":"C. C. Shilakes and J. Tylman . Enterprise information portals. Technical report, Merrill Lynch , Inc. , New York, NY , Nov. 1998 . C. C. Shilakes and J. Tylman. Enterprise information portals. Technical report, Merrill Lynch, Inc., New York, NY, Nov. 1998."}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/1454159.1454200","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T09:58:28Z","timestamp":1672221508000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/1454159.1454200"}},"subtitle":["a data quality system based on conditional functional dependencies"],"short-title":[],"issued":{"date-parts":[[2008,8]]},"references-count":12,"journal-issue":{"issue":"2","published-print":{"date-parts":[[2008,8]]}},"alternative-id":["10.14778\/1454159.1454200"],"URL":"https:\/\/doi.org\/10.14778\/1454159.1454200","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2008,8]]}}}