{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,3,25]],"date-time":"2025-03-25T14:27:01Z","timestamp":1742912821095,"version":"3.40.3"},"publisher-location":"Cham","reference-count":27,"publisher":"Springer International Publishing","isbn-type":[{"type":"print","value":"9783030731960"},{"type":"electronic","value":"9783030731977"}],"license":[{"start":{"date-parts":[[2021,1,1]],"date-time":"2021-01-01T00:00:00Z","timestamp":1609459200000},"content-version":"tdm","delay-in-days":0,"URL":"http:\/\/www.springer.com\/tdm"},{"start":{"date-parts":[[2021,1,1]],"date-time":"2021-01-01T00:00:00Z","timestamp":1609459200000},"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":[],"published-print":{"date-parts":[[2021]]},"DOI":"10.1007\/978-3-030-73197-7_53","type":"book-chapter","created":{"date-parts":[[2021,4,6]],"date-time":"2021-04-06T19:03:01Z","timestamp":1617735781000},"page":"778-794","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":0,"title":["Towards Expectation-Maximization by SQL in RDBMS"],"prefix":"10.1007","author":[{"given":"Kangfei","family":"Zhao","sequence":"first","affiliation":[]},{"given":"Jeffrey Xu","family":"Yu","sequence":"additional","affiliation":[]},{"given":"Yu","family":"Rong","sequence":"additional","affiliation":[]},{"given":"Ming","family":"Liao","sequence":"additional","affiliation":[]},{"given":"Junzhou","family":"Huang","sequence":"additional","affiliation":[]}],"member":"297","published-online":{"date-parts":[[2021,4,6]]},"reference":[{"key":"53_CR1","unstructured":"http:\/\/initd.org\/psycopg\/docs\/index.html"},{"key":"53_CR2","unstructured":"Microsoft SQL documentation. https:\/\/docs.microsoft.com\/en-us\/sql\/"},{"key":"53_CR3","unstructured":"Postgresql. https:\/\/www.postgresql.org"},{"key":"53_CR4","doi-asserted-by":"crossref","unstructured":"Arni, F., Ong, K., Tsur, S., Wang, H., Zaniolo, C.: The deductive database system LDL++. TPLP 3(1) (2003)","DOI":"10.1017\/S1471068402001515"},{"key":"53_CR5","unstructured":"Bishop, C.M.: Pattern Recognition and Machine Learning. Information Science and Statistics, 5th edn. Springer, Heidelberg (2007)"},{"key":"53_CR6","unstructured":"Bradley, P.S., Fayyad, U.M., Reina, C.: Scaling clustering algorithms to large databases. In Proceedings of KDD 1998, pp. 9\u201315 (1998)"},{"key":"53_CR7","unstructured":"Dempster, A.P.: Maximum likelihood estimation from incomplete data via the em algorithm. J. Roy. Stat. Soc. Ser. B (Stat. Methodol) 39, 1\u201338 (1977)"},{"key":"53_CR8","doi-asserted-by":"crossref","unstructured":"Deshpande, A., Madden, S.: Mauvedb: supporting model-based user views in database systems. In Proceedings of SIGMOD 2006, pp. 73\u201384 (2006)","DOI":"10.1145\/1142473.1142483"},{"key":"53_CR9","volume-title":"Pattern Classification and Scene Analysis","author":"RO Duda","year":"1973","unstructured":"Duda, R.O., Hart, P.E.: Pattern Classification and Scene Analysis. A Wiley-Interscience publication, Hoboken (1973)"},{"key":"53_CR10","volume-title":"Pattern Classification","author":"RO Duda","year":"2001","unstructured":"Duda, R.O., Hart, P.E., Stork, D.G.: Pattern Classification, 2nd edn. Wiley, New York (2001)","edition":"2"},{"key":"53_CR11","unstructured":"Finkelstein, S.J., Mattos, N., Mumick, I., Pirahesh, H.: Expressing recursive queries in SQL. ISO-IEC JTC1\/SC21 WG3 DBL MCI, (X3H2-96-075) (1996)"},{"issue":"12","key":"53_CR12","first-page":"1700","volume":"5","author":"JM Hellerstein","year":"2012","unstructured":"Hellerstein, J.M., et al.: The madlib analytics library or MAD skills, the SQL. PVLDB 5(12), 1700\u20131711 (2012)","journal-title":"PVLDB"},{"issue":"5","key":"53_CR13","first-page":"302","volume":"4","author":"ML Koc","year":"2011","unstructured":"Koc, M.L., R\u00e9, C.: Incrementally maintaining classification using an RDBMS. PVLDB 4(5), 302\u2013313 (2011)","journal-title":"PVLDB"},{"key":"53_CR14","doi-asserted-by":"crossref","unstructured":"Liang, P., Klein, D.: Online EM for unsupervised models. In: Proceedings of NAACL 2009, pp. 611\u2013619 (2009)","DOI":"10.3115\/1620754.1620843"},{"key":"53_CR15","volume-title":"The EM Algorithm and Extensions","author":"G McLachlan","year":"2007","unstructured":"McLachlan, G., Krishnan, T.: The EM Algorithm and Extensions, vol. 382. John Wiley & Sons, Hoboken (2007)"},{"key":"53_CR16","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, Burlington (2001)"},{"key":"53_CR17","series-title":"NATO ASI Series (Series D: Behavioural and Social Sciences)","doi-asserted-by":"publisher","first-page":"355","DOI":"10.1007\/978-94-011-5014-9_12","volume-title":"Learning in Graphical Models","author":"RM Neal","year":"1998","unstructured":"Neal, R.M., Hinton, G.E.: A view of the EM algorithm that justifies incremental, sparse, and other variants. In: Jordan, M.I. (ed.) Learning in Graphical Models. NATO ASI Series (Series D: Behavioural and Social Sciences), vol. 89, pp. 355\u2013368. Springer, Heidelberg (1998). https:\/\/doi.org\/10.1007\/978-94-011-5014-9_12"},{"issue":"2","key":"53_CR18","doi-asserted-by":"publisher","first-page":"264","DOI":"10.1109\/TKDE.2009.83","volume":"22","author":"C Ordonez","year":"2010","unstructured":"Ordonez, C.: Optimization of linear recursive queries in SQL. IEEE Trans. Knowl. Data Eng. 22(2), 264\u2013277 (2010)","journal-title":"IEEE Trans. Knowl. Data Eng."},{"key":"53_CR19","doi-asserted-by":"crossref","unstructured":"Ordonez, C., Cereghini, P.:SQLEM: fast clustering in SQL using the EM algorithm. In: Proceedings of SIGMOD, pp. 559\u2013570 (2000)","DOI":"10.1145\/335191.335468"},{"key":"53_CR20","doi-asserted-by":"crossref","unstructured":"Tamayo, P., et\u00a0al.: Oracle data mining - data mining in the database environment. In: The Data Mining and Knowledge Discovery Handbook, pp. 1315\u20131329 (2005)","DOI":"10.1007\/0-387-25465-X_63"},{"issue":"2","key":"53_CR21","doi-asserted-by":"crossref","first-page":"257","DOI":"10.1111\/j.2517-6161.1984.tb01296.x","volume":"46","author":"DM Titterington","year":"1984","unstructured":"Titterington, D.M.: Recursive parameter estimation using incomplete data. J. Roy. Stat. Soc. Ser. B (Methodol.) 46(2), 257\u2013267 (1984)","journal-title":"J. Roy. Stat. Soc. Ser. B (Methodol.)"},{"issue":"4","key":"53_CR22","doi-asserted-by":"publisher","first-page":"315","DOI":"10.1023\/A:1020779827503","volume":"12","author":"K Viele","year":"2002","unstructured":"Viele, K., Tong, B.: Modeling with mixtures of linear regressions. Stat. Comput. 12(4), 315\u2013330 (2002)","journal-title":"Stat. Comput."},{"key":"53_CR23","doi-asserted-by":"crossref","unstructured":"Yang, Y., Ma, J.: A single loop EM algorithm for the mixture of experts architecture. In Advances in Neural Networks - ISNN 2009, 6th International Symposium on Neural Networks, Proceedings, Part II, pp. 959\u2013968 (2009)","DOI":"10.1007\/978-3-642-01510-6_109"},{"issue":"8","key":"53_CR24","doi-asserted-by":"publisher","first-page":"1177","DOI":"10.1109\/TNNLS.2012.2200299","volume":"23","author":"SE Yuksel","year":"2012","unstructured":"Yuksel, S.E., Wilson, J.N., Gader, P.D.: Twenty years of mixture of experts. IEEE Trans. Neural Netw. Learn. Syst. 23(8), 1177\u20131193 (2012)","journal-title":"IEEE Trans. Neural Netw. Learn. Syst."},{"key":"53_CR25","doi-asserted-by":"crossref","unstructured":"Zaniolo, C., Arni, N., Ong, K.:Negation and aggregates in recursive rules: the LDL++ approach. In: Proceedings of DOOD (1993)","DOI":"10.1007\/3-540-57530-8_13"},{"key":"53_CR26","volume-title":"Advanced Database Systems","author":"C Zaniolo","year":"1997","unstructured":"Zaniolo, C., et al.: Advanced Database Systems. Morgan Kaufmann, Burlington (1997)"},{"key":"53_CR27","doi-asserted-by":"crossref","unstructured":"Zhao, K., Yu, J.X.: All-in-one: graph processing in RDBMSS revisited. In: Proceedings of SIGMOD 2017 (2017)","DOI":"10.1145\/3035918.3035943"}],"container-title":["Lecture Notes in Computer Science","Database Systems for Advanced Applications"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/978-3-030-73197-7_53","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2024,8,27]],"date-time":"2024-08-27T18:32:17Z","timestamp":1724783537000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/978-3-030-73197-7_53"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2021]]},"ISBN":["9783030731960","9783030731977"],"references-count":27,"URL":"https:\/\/doi.org\/10.1007\/978-3-030-73197-7_53","relation":{},"ISSN":["0302-9743","1611-3349"],"issn-type":[{"type":"print","value":"0302-9743"},{"type":"electronic","value":"1611-3349"}],"subject":[],"published":{"date-parts":[[2021]]},"assertion":[{"value":"6 April 2021","order":1,"name":"first_online","label":"First Online","group":{"name":"ChapterHistory","label":"Chapter History"}},{"value":"DASFAA","order":1,"name":"conference_acronym","label":"Conference Acronym","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"International Conference on Database Systems for Advanced Applications","order":2,"name":"conference_name","label":"Conference Name","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Taipei","order":3,"name":"conference_city","label":"Conference City","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Taiwan","order":4,"name":"conference_country","label":"Conference Country","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"2021","order":5,"name":"conference_year","label":"Conference Year","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"11 April 2021","order":7,"name":"conference_start_date","label":"Conference Start Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"14 April 2021","order":8,"name":"conference_end_date","label":"Conference End Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"26","order":9,"name":"conference_number","label":"Conference Number","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"dasfaa2021","order":10,"name":"conference_id","label":"Conference ID","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"http:\/\/dm.iis.sinica.edu.tw\/DASFAA2021\/index.html","order":11,"name":"conference_url","label":"Conference URL","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Double-blind","order":1,"name":"type","label":"Type","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"CMT","order":2,"name":"conference_management_system","label":"Conference Management System","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"490","order":3,"name":"number_of_submissions_sent_for_review","label":"Number of Submissions Sent for Review","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"98","order":4,"name":"number_of_full_papers_accepted","label":"Number of Full Papers Accepted","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"33","order":5,"name":"number_of_short_papers_accepted","label":"Number of Short Papers Accepted","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"20% - The value is computed by the equation \"Number of Full Papers Accepted \/ Number of Submissions Sent for Review * 100\" and then rounded to a whole number.","order":6,"name":"acceptance_rate_of_full_papers","label":"Acceptance Rate of Full Papers","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"4","order":7,"name":"average_number_of_reviews_per_paper","label":"Average Number of Reviews per Paper","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"7","order":8,"name":"average_number_of_papers_per_reviewer","label":"Average Number of Papers per Reviewer","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"Yes","order":9,"name":"external_reviewers_involved","label":"External Reviewers Involved","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"Due to the Corona pandemic this event was held virtually.","order":10,"name":"additional_info_on_review_process","label":"Additional Info on Review Process","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}}]}}