{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,9,29]],"date-time":"2026-09-29T20:33:32Z","timestamp":1790714012143,"version":"4.1.0"},"reference-count":18,"publisher":"Springer Science and Business Media LLC","issue":"3","license":[{"start":{"date-parts":[[2019,6,10]],"date-time":"2019-06-10T00:00:00Z","timestamp":1560124800000},"content-version":"tdm","delay-in-days":0,"URL":"http:\/\/www.springer.com\/tdm"},{"start":{"date-parts":[[2019,6,10]],"date-time":"2019-06-10T00:00:00Z","timestamp":1560124800000},"content-version":"vor","delay-in-days":0,"URL":"http:\/\/www.springer.com\/tdm"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":["J Intell Inf Syst"],"published-print":{"date-parts":[[2020,6]]},"DOI":"10.1007\/s10844-019-00562-z","type":"journal-article","created":{"date-parts":[[2019,6,10]],"date-time":"2019-06-10T03:19:12Z","timestamp":1560136752000},"page":"439-461","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":26,"title":["Holistic primary key and foreign key detection"],"prefix":"10.1007","volume":"54","author":[{"ORCID":"https:\/\/orcid.org\/0000-0002-4735-3845","authenticated-orcid":false,"given":"Lan","family":"Jiang","sequence":"first","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Felix","family":"Naumann","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"297","published-online":{"date-parts":[[2019,6,10]]},"reference":[{"issue":"4","key":"562_CR1","doi-asserted-by":"publisher","first-page":"557","DOI":"10.1007\/s00778-015-0389-y","volume":"24","author":"Z Abedjan","year":"2015","unstructured":"Abedjan, Z., Golab, L., Naumann, F. (2015). Profiling relational data: a survey. VLDB Journal, 24(4), 557\u2013581.","journal-title":"VLDB Journal"},{"key":"562_CR2","first-page":"99","volume":"35","author":"A Bhattacharyya","year":"1943","unstructured":"Bhattacharyya, A. (1943). On a measure of divergence between two statistical populations defined by their probability distributions. Bulletin of the Calcutta Mathematical Society, 35, 99\u2013109.","journal-title":"Bulletin of the Calcutta Mathematical Society"},{"key":"562_CR3","doi-asserted-by":"crossref","unstructured":"Chaudhuri, S., Ganjam, K., Ganti, V., Motwani, R. (2003). Robust and efficient fuzzy match for online data cleaning. In Proceedings of the international conference on management of data (SIGMOD) (pp. 313\u2013324).","DOI":"10.1145\/872757.872796"},{"issue":"13","key":"562_CR4","doi-asserted-by":"publisher","first-page":"1417","DOI":"10.14778\/2733004.2733014","volume":"7","author":"Z Chen","year":"2014","unstructured":"Chen, Z., Narasayya, V.R., Chaudhuri, S. (2014). Fast foreign-key detection in microsoft SQL server powerpivot for excel. Proceedings of the VLDB Endowment, 7 (13), 1417\u20131428.","journal-title":"Proceedings of the VLDB Endowment"},{"key":"562_CR5","unstructured":"Faust, M., Schwalb, D., Plattner, H. (2014). Composite group-keys \u2013 space-efficient indexing of multiple columns for compressed in-memory column stores. In Memory data management and analysis - first and second international workshops, revised selected papers (pp. 139\u2013150)."},{"key":"562_CR6","doi-asserted-by":"crossref","unstructured":"Ilyas, I.F., Markl, V., Haas, P.J., Brown, P., Aboulnaga, A. (2004). CORDS: automatic discovery of correlations and soft functional dependencies. In Proceedings of the international conference on management of data (SIGMOD) (pp. 647\u2013658).","DOI":"10.1145\/1007568.1007641"},{"issue":"7","key":"562_CR7","doi-asserted-by":"publisher","first-page":"591","DOI":"10.1002\/int.4550070703","volume":"7","author":"M Kantola","year":"1992","unstructured":"Kantola, M., Mannila, H., R\u00e4ih\u00e4, K., Siirtola, H. (1992). Discovering functional and inclusion dependencies in relational databases. International Journal of Intelligence Systems, 7(7), 591\u2013607.","journal-title":"International Journal of Intelligence Systems"},{"issue":"1","key":"562_CR8","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1016\/S0306-4379(01)00027-8","volume":"27","author":"S Lopes","year":"2002","unstructured":"Lopes, S., Petit, J., Toumani, F. (2002). Discovering interesting inclusion dependencies: application to logical database tuning. Information Systems (IS), 27(1), 1\u201319.","journal-title":"Information Systems (IS)"},{"issue":"2","key":"562_CR9","doi-asserted-by":"publisher","first-page":"270","DOI":"10.1016\/0022-0000(78)90009-0","volume":"17","author":"CL Lucchesi","year":"1978","unstructured":"Lucchesi, C.L., & Osborn, S.L. (1978). Candidate keys for relations. Journal of Computer and System Sciences, 17(2), 270\u2013279.","journal-title":"Journal of Computer and System Sciences"},{"issue":"1","key":"562_CR10","doi-asserted-by":"publisher","first-page":"53","DOI":"10.1007\/s10844-007-0048-x","volume":"32","author":"FD Marchi","year":"2009","unstructured":"Marchi, F.D., Lopes, S., Petit, J. (2009). Unary and n-ary inclusion dependency discovery in relational databases. Journal of Intelligent Information System, 32(1), 53\u201373.","journal-title":"Journal of Intelligent Information System"},{"key":"562_CR11","doi-asserted-by":"crossref","unstructured":"Memari, M., Link, S., Dobbie, G. (2015). SQL data profiling of foreign keys. In Proceedings of the international conference on conceptual modeling (ER) (pp. 229\u2013243).","DOI":"10.1007\/978-3-319-25264-3_17"},{"issue":"12","key":"562_CR12","doi-asserted-by":"publisher","first-page":"1860","DOI":"10.14778\/2824032.2824086","volume":"8","author":"T Papenbrock","year":"2015","unstructured":"Papenbrock, T., Bergmann, T., Finke, M., Zwiener, J., Naumann, F. (2015). Data profiling with metanome. Proceedings of the VLDB Endowment, 8(12), 1860\u20131863.","journal-title":"Proceedings of the VLDB Endowment"},{"key":"562_CR13","unstructured":"Papenbrock, T., & Naumann, F. (2017). Data-driven schema normalization. In Proceedings of the international conference on extending database technology (EDBT) (pp. 342\u2013353)."},{"key":"562_CR14","unstructured":"Rostin, A., Albrecht, O., Bauckmann, J., Naumann, F., Leser, U. (2009). A machine learning approach to foreign key discovery. In Proceedings of the ACM SIGMOD workshop on the web and databases (WebDB)."},{"key":"562_CR15","doi-asserted-by":"crossref","unstructured":"Rubner, Y., Tomasi, C., Guibas, L.J. (1998). A metric for distributions with applications to image databases. In Procedings of the international conference on computer vision (ICCV) (pp. 59\u201366).","DOI":"10.1109\/ICCV.1998.710701"},{"issue":"3","key":"562_CR16","doi-asserted-by":"publisher","first-page":"18:1","DOI":"10.1145\/3105959","volume":"42","author":"F Tschirschnitz","year":"2017","unstructured":"Tschirschnitz, F., Papenbrock, T., Naumann, F. (2017). Detecting inclusion dependencies on very many tables. ACM Transactions on Database Systems (TODS), 42(3), 18:1\u201318,29.","journal-title":"ACM Transactions on Database Systems (TODS)"},{"issue":"9","key":"562_CR17","doi-asserted-by":"publisher","first-page":"528","DOI":"10.14778\/2002938.2002939","volume":"4","author":"P Venetis","year":"2011","unstructured":"Venetis, P., Halevy, A.Y., Madhavan, J., Pasca, M., Shen, W., Wu, F., Miao, G., Wu, C. (2011). Recovering semantics of tables on the web. Proceedings of the VLDB Endowment, 4(9), 528\u2013538.","journal-title":"Proceedings of the VLDB Endowment"},{"issue":"1\u20132","key":"562_CR18","doi-asserted-by":"publisher","first-page":"805","DOI":"10.14778\/1920841.1920944","volume":"3","author":"M Zhang","year":"2010","unstructured":"Zhang, M., Hadjieleftheriou, M., Ooi, B.C., Procopiuc, C.M., Srivastava, D. (2010). On multi-column foreign key discovery. Proceedings of the VLDB Endowment, 3(1\u20132), 805\u2013814.","journal-title":"Proceedings of the VLDB Endowment"}],"container-title":["Journal of Intelligent Information Systems"],"original-title":[],"language":"en","link":[{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/s10844-019-00562-z.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"http:\/\/link.springer.com\/article\/10.1007\/s10844-019-00562-z\/fulltext.html","content-type":"text\/html","content-version":"vor","intended-application":"text-mining"},{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/s10844-019-00562-z.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2020,6,8]],"date-time":"2020-06-08T19:19:59Z","timestamp":1591643999000},"score":1,"resource":{"primary":{"URL":"http:\/\/link.springer.com\/10.1007\/s10844-019-00562-z"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2019,6,10]]},"references-count":18,"journal-issue":{"issue":"3","published-print":{"date-parts":[[2020,6]]}},"alternative-id":["562"],"URL":"https:\/\/doi.org\/10.1007\/s10844-019-00562-z","relation":{},"ISSN":["0925-9902","1573-7675"],"issn-type":[{"value":"0925-9902","type":"print"},{"value":"1573-7675","type":"electronic"}],"subject":[],"published":{"date-parts":[[2019,6,10]]},"assertion":[{"value":"28 February 2019","order":1,"name":"received","label":"Received","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"20 May 2019","order":2,"name":"revised","label":"Revised","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"21 May 2019","order":3,"name":"accepted","label":"Accepted","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"10 June 2019","order":4,"name":"first_online","label":"First Online","group":{"name":"ArticleHistory","label":"Article History"}}]}}