{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2024,9,8]],"date-time":"2024-09-08T21:42:56Z","timestamp":1725831776738},"publisher-location":"Cham","reference-count":17,"publisher":"Springer International Publishing","isbn-type":[{"type":"print","value":"9783319252636"},{"type":"electronic","value":"9783319252643"}],"license":[{"start":{"date-parts":[[2015,1,1]],"date-time":"2015-01-01T00:00:00Z","timestamp":1420070400000},"content-version":"unspecified","delay-in-days":0,"URL":"http:\/\/www.springer.com\/tdm"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2015]]},"DOI":"10.1007\/978-3-319-25264-3_17","type":"book-chapter","created":{"date-parts":[[2015,10,9]],"date-time":"2015-10-09T03:50:16Z","timestamp":1444362616000},"page":"229-243","source":"Crossref","is-referenced-by-count":7,"title":["SQL Data Profiling of Foreign Keys"],"prefix":"10.1007","author":[{"given":"Mozhgan","family":"Memari","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Sebastian","family":"Link","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Gillian","family":"Dobbie","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"297","published-online":{"date-parts":[[2015,12,8]]},"reference":[{"key":"17_CR1","unstructured":"Bauckmann, J., Abedjan, Z., Leser, U., M\u00fcller, H., Naumann, F.: Discovering conditional inclusion dependencies. In: Chen, X., Lebanon, G., Wang, H., Zaki, M.J. (eds.) 21st ACM International Conference on Information and Knowledge Management, CIKM 2012, Maui, HI, USA, October 29\u2013November 02, 2012, pp. 2094\u20132098. ACM (2012)"},{"key":"17_CR2","doi-asserted-by":"crossref","unstructured":"Bauckmann, J., Leser, U., Naumann, F., Tietz, V.: Efficiently detecting inclusion dependencies. In: Chirkova, R., Dogac, A., \u00d6zsu, M.T., Sellis, T.K. (eds.) Proceedings of the 23rd International Conference on Data Engineering, ICDE 2007, The Marmara Hotel, Istanbul, Turkey, 15\u201320 April 2007, pp. 1448\u20131450. IEEE (2007)","DOI":"10.1109\/ICDE.2007.369032"},{"issue":"1","key":"17_CR3","doi-asserted-by":"publisher","first-page":"29","DOI":"10.1016\/0022-0000(84)90075-8","volume":"28","author":"MA Casanova","year":"1984","unstructured":"Casanova, M.A., Fagin, R., Papadimitriou, C.H.: Inclusion dependencies and their interaction with functional dependencies. J. Comput. Syst. Sci. 28(1), 29\u201359 (1984)","journal-title":"J. Comput. Syst. Sci."},{"issue":"13","key":"17_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.: Fast foreign-key detection in Microsoft SQL server PowerPivot for Excel. Proc. VLDB 7(13), 1417\u20131428 (2014)","journal-title":"Proc. VLDB"},{"issue":"6","key":"17_CR5","doi-asserted-by":"publisher","first-page":"377","DOI":"10.1145\/362384.362685","volume":"13","author":"E Codd","year":"1970","unstructured":"Codd, E.: A relational model of data for large shared data banks. Commun. ACM 13(6), 377\u2013387 (1970)","journal-title":"Commun. ACM"},{"issue":"1","key":"17_CR6","doi-asserted-by":"publisher","first-page":"53","DOI":"10.1007\/s10844-007-0048-x","volume":"32","author":"F Marchi De","year":"2009","unstructured":"De Marchi, F., Lopes, S., Petit, J.M.: Unary and n-ary inclusion dependency discovery in relational databases. Int. J. Intell. Syst. 32(1), 53\u201373 (2009)","journal-title":"Int. J. Intell. Syst."},{"issue":"4","key":"17_CR7","doi-asserted-by":"publisher","first-page":"301","DOI":"10.14778\/2732240.2732248","volume":"7","author":"A Heise","year":"2013","unstructured":"Heise, A., Quian\u00e9-Ruiz, J., Abedjan, Z., Jentzsch, A., Naumann, F.: Scalable discovery of unique column combinations. Proc. VLDB 7(4), 301\u2013312 (2013)","journal-title":"Proc. VLDB"},{"issue":"7","key":"17_CR8","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.J., Siirtola, H.: Discovering functional and inclusion dependencies in relational databases. Int. J. Intell. Syst. 7(7), 591\u2013607 (1992)","journal-title":"Int. J. Intell. Syst."},{"key":"17_CR9","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"185","DOI":"10.1007\/11617808_7","volume-title":"Journal on Data Semantics V","author":"A Koeller","year":"2006","unstructured":"Koeller, A., Rundensteiner, E.A.: Heuristic strategies for the discovery of inclusion dependencies and other patterns. In: Spaccapietra, S., Atzeni, P., Chu, W.W., Catarci, T., Sycara, K. (eds.) Journal on Data Semantics V. LNCS, vol. 3870, pp. 185\u2013210. Springer, Heidelberg (2006)"},{"issue":"1","key":"17_CR10","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.: Discovering interesting inclusion dependencies: application to logical database tuning. Inf. Syst. 27(1), 1\u201319 (2002)","journal-title":"Inf. Syst."},{"issue":"3","key":"17_CR11","doi-asserted-by":"publisher","first-page":"241","DOI":"10.1023\/A:1009796218281","volume":"1","author":"H Mannila","year":"1997","unstructured":"Mannila, H., Toivonen, H.: Levelwise search and borders of theories in knowledge discovery. Data Min. Knowl. Disc. 1(3), 241\u2013258 (1997)","journal-title":"Data Min. Knowl. Disc."},{"key":"17_CR12","volume-title":"SQL:1999: Understanding Relational Language Components","author":"J Melton","year":"2001","unstructured":"Melton, J., Simon, A.R.: SQL:1999: Understanding Relational Language Components. Morgan Kaufmann, Boston (2001)"},{"issue":"4","key":"17_CR13","doi-asserted-by":"publisher","first-page":"40","DOI":"10.1145\/2590989.2590995","volume":"42","author":"F Naumann","year":"2013","unstructured":"Naumann, F.: Data profiling revisited. SIGMOD Rec. 42(4), 40\u201349 (2013)","journal-title":"SIGMOD Rec."},{"key":"17_CR14","unstructured":"Rostin, A., Albrecht, O., Bauckmann, J., Naumann, F., Leser, U.: A machine learning approach to foreign key discovery. In: 12th International Workshop on the Web and Databases, WebDB 2009, Providence, RI, USA, 28 June 2009 (2009)"},{"key":"17_CR15","doi-asserted-by":"crossref","unstructured":"Saha, B., Srivastava, D.: Data quality: the other face of big data. In: Cruz, I.F., Ferrari, E., Tao, Y., Bertino, E., Trajcevski, G. (eds.) 30th International Conference on Data Engineering, ICDE 2014, Chicago, IL, USA, 31 March\u20134 April 2014, pp. 1294\u20131297. IEEE (2014)","DOI":"10.1109\/ICDE.2014.6816764"},{"key":"17_CR16","unstructured":"Sismanis, Y., Brown, P., Haas, P.J., Reinwald, B.: GORDIAN: efficient and scalable discovery of composite keys. In: Dayal, U., Whang, K., Lomet, D.B., Alonso, G., Lohman, G.M., Kersten, M.L., Cha, S.K., Kim, Y. (eds.) Proceedings of the 32nd International Conference on Very Large Data Bases, Seoul, Korea, 12\u201315 September 2006, pp. 691\u2013702. ACM (2006)"},{"issue":"1","key":"17_CR17","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.: On multi-column foreign key discovery. Proc. VLDB 3(1), 805\u2013814 (2010)","journal-title":"Proc. VLDB"}],"container-title":["Lecture Notes in Computer Science","Conceptual Modeling"],"original-title":[],"link":[{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/978-3-319-25264-3_17","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2019,5,31]],"date-time":"2019-05-31T05:13:06Z","timestamp":1559279586000},"score":1,"resource":{"primary":{"URL":"http:\/\/link.springer.com\/10.1007\/978-3-319-25264-3_17"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2015]]},"ISBN":["9783319252636","9783319252643"],"references-count":17,"URL":"https:\/\/doi.org\/10.1007\/978-3-319-25264-3_17","relation":{},"ISSN":["0302-9743","1611-3349"],"issn-type":[{"type":"print","value":"0302-9743"},{"type":"electronic","value":"1611-3349"}],"subject":[],"published":{"date-parts":[[2015]]}}}