{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,10,6]],"date-time":"2026-10-06T16:46:03Z","timestamp":1791305163012,"version":"4.3.1"},"reference-count":45,"publisher":"Association for Computing Machinery (ACM)","issue":"4","license":[{"start":{"date-parts":[[2014,2,28]],"date-time":"2014-02-28T00:00:00Z","timestamp":1393545600000},"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":["SIGMOD Rec."],"published-print":{"date-parts":[[2014,2,28]]},"abstract":"<jats:p>Data profiling comprises a broad range of methods to efficiently analyze a given data set. In a typical scenario, which mirrors the capabilities of commercial data profiling tools, tables of a relational database are scanned to derive metadata, such as data types and value patterns, completeness and uniqueness of columns, keys and foreign keys, and occasionally functional dependencies and association rules. Individual research projects have proposed several additional profiling tasks, such as the discovery of inclusion dependencies or conditional functional dependencies.<\/jats:p>\n                  <jats:p>Data profiling deserves a fresh look for two reasons: First, the area itself is neither established nor defined in any principled way, despite significant research activity on individual parts in the past. Second, more and more data beyond the traditional relational databases are being created and beg to be profiled. The article proposes new research directions and challenges, including interactive and incremental profiling and profiling heterogeneous and non-relational data.<\/jats:p>","DOI":"10.1145\/2590989.2590995","type":"journal-article","created":{"date-parts":[[2014,3,4]],"date-time":"2014-03-04T08:24:59Z","timestamp":1393921499000},"page":"40-49","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":129,"title":["Data profiling revisited"],"prefix":"10.1145","volume":"42","author":[{"given":"Felix","family":"Naumann","sequence":"first","affiliation":[{"name":"Qatar Computing Research Institute (QCRI), Doha, Qatar"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"320","published-online":{"date-parts":[[2014,2,28]]},"reference":[{"key":"e_1_2_1_1_1","first-page":"292","volume-title":"Proceedings of the Conference on Innovative Data Systems Research (CIDR)","author":"Abadi D. J.","year":"2007"},{"key":"e_1_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.1145\/2063576.2063801"},{"key":"e_1_2_1_3_1","doi-asserted-by":"crossref","DOI":"10.4018\/jdwm.2013040104","volume-title":"Fusion Cubes: Towards self-service business intelligence. Data Warehousing and Mining (IJDWM), in press","author":"Abell\u00f3 A.","year":"2013"},{"key":"e_1_2_1_4_1","volume-title":"Challenges and opportunities with Big Data. Technical report","author":"Agrawal D.","year":"2012"},{"key":"e_1_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.1145\/2396761.2398580"},{"key":"e_1_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2007.369032"},{"key":"e_1_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.5555\/646090.680403"},{"key":"e_1_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.1145\/2396761.2398718"},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.websem.2011.06.001"},{"key":"e_1_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDEW.2010.5452762"},{"key":"e_1_2_1_11_1","first-page":"243","volume-title":"Proceedings of the International Conference on Very Large Databases (VLDB)","author":"Bravo L.","year":"2007"},{"key":"e_1_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.1145\/1897816.1897839"},{"key":"e_1_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.1016\/S0065-2458(03)62007-3"},{"key":"e_1_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.14778\/1453856.1453980"},{"key":"e_1_2_1_15_1","doi-asserted-by":"crossref","DOI":"10.1007\/978-3-642-31164-2","volume-title":"Data Matching","author":"Christen P.","year":"2012"},{"key":"e_1_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.1561\/1900000004"},{"key":"e_1_2_1_17_1","volume-title":"Proceedings of the International Workshop on Quality in Databases (QDB)","author":"Cur\u00e9 O.","year":"2009"},{"key":"e_1_2_1_18_1","volume-title":"Ontology Matching","author":"Euzenat J.","year":"2007"},{"key":"e_1_2_1_19_1","doi-asserted-by":"publisher","DOI":"10.5555\/1497136.1497142"},{"key":"e_1_2_1_20_1","doi-asserted-by":"publisher","DOI":"10.1145\/1366102.1366103"},{"key":"e_1_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.1109\/TKDE.2010.154"},{"issue":"3","key":"e_1_2_1_22_1","first-page":"26","article-title":"Efficient and effective analysis of data quality using pattern tableaux","volume":"34","author":"Golab L.","year":"2011","journal-title":"IEEE Data Engineering Bulletin"},{"key":"e_1_2_1_23_1","doi-asserted-by":"publisher","DOI":"10.5555\/1855057"},{"key":"e_1_2_1_24_1","volume-title":"Morgan Kaufmann","author":"Han J.","year":"2011"},{"key":"e_1_2_1_25_1","doi-asserted-by":"publisher","DOI":"10.1007\/BF01830689"},{"key":"e_1_2_1_26_1","doi-asserted-by":"publisher","DOI":"10.1093\/comjnl\/42.2.100"},{"key":"e_1_2_1_27_1","doi-asserted-by":"publisher","DOI":"10.1145\/1007568.1007641"},{"key":"e_1_2_1_28_1","doi-asserted-by":"publisher","DOI":"10.1145\/2254556.2254659"},{"key":"e_1_2_1_29_1","doi-asserted-by":"publisher","DOI":"10.1109\/VAST.2007.4389004"},{"key":"e_1_2_1_30_1","doi-asserted-by":"publisher","DOI":"10.1016\/S0306-4379(01)00027-8"},{"key":"e_1_2_1_31_1","first-page":"1","volume-title":"Proceedings Business Intelligence for the Real-Time Enterprise (BIRTE)","author":"L\u00f6ser A.","year":"2008"},{"key":"e_1_2_1_32_1","doi-asserted-by":"publisher","DOI":"10.1145\/62061.62063"},{"key":"e_1_2_1_33_1","doi-asserted-by":"publisher","DOI":"10.5555\/645340.650245"},{"key":"e_1_2_1_34_1","doi-asserted-by":"publisher","DOI":"10.1007\/s10844-007-0048-x"},{"key":"e_1_2_1_35_1","doi-asserted-by":"publisher","DOI":"10.1109\/32.57618"},{"key":"e_1_2_1_36_1","volume-title":"Principles of Distributed Database Systems","author":"\u00d6zsu T.","year":"1999","edition":"2"},{"key":"e_1_2_1_37_1","doi-asserted-by":"publisher","DOI":"10.1145\/233269.233342"},{"key":"e_1_2_1_38_1","volume-title":"Morgan Kaufmann","author":"Pyle D.","year":"1999"},{"issue":"4","key":"e_1_2_1_39_1","first-page":"3","article-title":"Problems and current approaches","volume":"23","author":"Rahm E.","year":"2000","journal-title":"IEEE Data Engineering Bulletin"},{"key":"e_1_2_1_40_1","first-page":"381","volume-title":"Proceedings of the International Conference on Very Large Databases (VLDB)","author":"Raman V.","year":"2001"},{"key":"e_1_2_1_41_1","volume-title":"Proceedings of the ACM SIGMOD Workshop on the Web and Databases (WebDB)","author":"Rostin A.","year":"2009"},{"key":"e_1_2_1_42_1","first-page":"691","volume-title":"Proceedings of the International Conference on Very Large Databases (VLDB)","author":"Sismanis Y.","year":"2006"},{"key":"e_1_2_1_43_1","volume-title":"Proceedings of the Conference on Innovative Data Systems Research (CIDR)","author":"Smith K. P.","year":"2009"},{"key":"e_1_2_1_44_1","doi-asserted-by":"publisher","DOI":"10.1145\/1376616.1376717"},{"key":"e_1_2_1_45_1","doi-asserted-by":"publisher","DOI":"10.1007\/s10618-007-0083-9"}],"container-title":["ACM SIGMOD Record"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/2590989.2590995","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/2590989.2590995","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,18]],"date-time":"2025-06-18T16:13:52Z","timestamp":1750263232000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/2590989.2590995"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2014,2,28]]},"references-count":45,"journal-issue":{"issue":"4","published-print":{"date-parts":[[2014,2,28]]}},"alternative-id":["10.1145\/2590989.2590995"],"URL":"https:\/\/doi.org\/10.1145\/2590989.2590995","relation":{},"ISSN":["0163-5808"],"issn-type":[{"value":"0163-5808","type":"print"}],"subject":[],"published":{"date-parts":[[2014,2,28]]},"assertion":[{"value":"2014-02-28","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}