{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,7,30]],"date-time":"2025-07-30T13:08:43Z","timestamp":1753880923130,"version":"3.41.2"},"reference-count":51,"publisher":"World Scientific Pub Co Pte Ltd","issue":"04","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["J. Info. Know. Mgmt."],"published-print":{"date-parts":[[2022,12]]},"abstract":"<jats:p> Customer Relationship Management (CRM) is a systematic way of working with current and prospective customers to manage long-term relationships and interactions between the company and customers. Recently, Big Data has become a buzzword. It consists of huge data repositories, having information collected from online and offline resources, and it is hard to process such datasets with traditional data processing tools and techniques. The presented research work tries to explore the potential of Big Data to create, optimise and transform an insightful customer relationship management system by analysing large amount of datasets for enhancing customer life cycle profitability. In this research work, a dataset, \u201cBook Crossing\u201d is used for Big Data processing and execution time analysis for simple and complex SQL queries. This research tries to analyse the impact of data size on the query execution time for one of the majorly used Big Data frameworks, namely Apache Spark. It is a recently developed in-memory Big Data processing framework with a SPARK SQL module for efficient SQL query execution. It has been found that Apache-Spark gives better results with large size datasets compare to small size datasets and fares better as compared to Hadoop, one of the majorly used Big Data Frameworks (based on qualitative analysis). <\/jats:p>","DOI":"10.1142\/s0219649222500502","type":"journal-article","created":{"date-parts":[[2022,6,30]],"date-time":"2022-06-30T07:49:25Z","timestamp":1656575365000},"source":"Crossref","is-referenced-by-count":8,"title":["Query Execution Time Analysis Using Apache Spark Framework for Big Data: A CRM Approach"],"prefix":"10.1142","volume":"21","author":[{"given":"Madan Lal","family":"Yadav","sequence":"first","affiliation":[{"name":"Indian Institute of Management Bodh Gaya, Bihar, India"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"219","published-online":{"date-parts":[[2022,6,29]]},"reference":[{"key":"S0219649222500502BIB001","doi-asserted-by":"publisher","DOI":"10.1016\/j.eswa.2018.05.010"},{"key":"S0219649222500502BIB002","doi-asserted-by":"publisher","DOI":"10.1142\/S0219649218500454"},{"key":"S0219649222500502BIB003","doi-asserted-by":"publisher","DOI":"10.1145\/2723372.2742797"},{"key":"S0219649222500502BIB004","doi-asserted-by":"publisher","DOI":"10.1109\/ICCIC.2013.6724280"},{"issue":"2","key":"S0219649222500502BIB005","first-page":"171","volume":"36","author":"Bolton RN","year":"1999","journal-title":"Journal of Marketing Research"},{"key":"S0219649222500502BIB006","doi-asserted-by":"publisher","DOI":"10.1287\/mksc.17.1.45"},{"key":"S0219649222500502BIB007","doi-asserted-by":"publisher","DOI":"10.1109\/CICT.2013.6558123"},{"key":"S0219649222500502BIB008","first-page":"37","volume-title":"Handbook of Big Data Analytics","author":"Chunduri RK","year":"2021"},{"key":"S0219649222500502BIB009","doi-asserted-by":"publisher","DOI":"10.1007\/s00500-021-05844-9"},{"key":"S0219649222500502BIB010","doi-asserted-by":"publisher","DOI":"10.1016\/j.dss.2019.113232"},{"key":"S0219649222500502BIB011","doi-asserted-by":"publisher","DOI":"10.1109\/ICDMW.2012.121"},{"key":"S0219649222500502BIB012","first-page":"455","volume-title":"Proc. - 4th IEEE Int. Conf. Big Data and Cloud Computing, BDCloud 2014 with the 7th IEEE Int. Conf. Social Computing and Networking, SocialCom 2014 and the 4th Int. Conf. Sustainable Computing and Communications, SustainCom 2014","author":"Dehkordi YH","year":"2015"},{"key":"S0219649222500502BIB013","doi-asserted-by":"publisher","DOI":"10.1016\/j.knosys.2021.106740"},{"key":"S0219649222500502BIB014","doi-asserted-by":"publisher","DOI":"10.1109\/BigData.2014.7004462"},{"key":"S0219649222500502BIB015","first-page":"3748","volume-title":"Proceedings of the Annual Hawaii International Conference on System Sciences","author":"Ebner K","year":"2014"},{"key":"S0219649222500502BIB016","doi-asserted-by":"publisher","DOI":"10.1142\/S0219649219500369"},{"key":"S0219649222500502BIB018","doi-asserted-by":"publisher","DOI":"10.1016\/j.asoc.2014.01.031"},{"key":"S0219649222500502BIB019","doi-asserted-by":"publisher","DOI":"10.1016\/j.dss.2019.03.008"},{"key":"S0219649222500502BIB020","doi-asserted-by":"publisher","DOI":"10.1016\/j.knosys.2018.05.006"},{"key":"S0219649222500502BIB021","doi-asserted-by":"publisher","DOI":"10.1142\/S0219649214500154"},{"key":"S0219649222500502BIB022","doi-asserted-by":"publisher","DOI":"10.1109\/IISWC.2014.6983036"},{"key":"S0219649222500502BIB025","doi-asserted-by":"publisher","DOI":"10.1109\/BigData.Congress.2014.83"},{"issue":"12","key":"S0219649222500502BIB026","first-page":"1194","volume":"3","author":"Lakshmi D","year":"2013","journal-title":"ARPN Journal of Science and Technology"},{"key":"S0219649222500502BIB027","doi-asserted-by":"publisher","DOI":"10.1109\/IEEM.2014.7058772"},{"key":"S0219649222500502BIB028","doi-asserted-by":"publisher","DOI":"10.1109\/BigData.2013.6691790"},{"key":"S0219649222500502BIB029","doi-asserted-by":"publisher","DOI":"10.1109\/SNPD.2014.6888697"},{"key":"S0219649222500502BIB030","doi-asserted-by":"publisher","DOI":"10.1109\/GCIS.2013.22"},{"key":"S0219649222500502BIB031","doi-asserted-by":"publisher","DOI":"10.17950\/ijer\/v3s2\/208"},{"key":"S0219649222500502BIB032","doi-asserted-by":"publisher","DOI":"10.1016\/j.ijinfomgt.2020.102190"},{"key":"S0219649222500502BIB033","doi-asserted-by":"publisher","DOI":"10.1109\/BigData.2013.6691571"},{"key":"S0219649222500502BIB034","doi-asserted-by":"publisher","DOI":"10.1109\/IIAI-AAI.2014.123"},{"key":"S0219649222500502BIB035","doi-asserted-by":"publisher","DOI":"10.1109\/CSIBIG.2014.7056974"},{"key":"S0219649222500502BIB036","doi-asserted-by":"publisher","DOI":"10.1109\/CICN.2014.126"},{"key":"S0219649222500502BIB037","first-page":"968","volume-title":"Proc. IEEE Int. Conf. Software Engineering and Service Sciences, ICSESS, (2012)","author":"Rong Z","year":"2013"},{"key":"S0219649222500502BIB038","doi-asserted-by":"publisher","DOI":"10.1142\/S0219649218500193"},{"key":"S0219649222500502BIB039","doi-asserted-by":"publisher","DOI":"10.1109\/ACCT.2015.121"},{"key":"S0219649222500502BIB040","doi-asserted-by":"publisher","DOI":"10.1109\/ICMLC.2011.6016866"},{"key":"S0219649222500502BIB041","doi-asserted-by":"publisher","DOI":"10.1016\/j.knosys.2020.106598"},{"key":"S0219649222500502BIB042","first-page":"126","volume-title":"Handbook of Big Data Analytics","author":"Sristy NB","year":"2021"},{"key":"S0219649222500502BIB043","doi-asserted-by":"publisher","DOI":"10.1145\/2588555.2612183"},{"key":"S0219649222500502BIB044","doi-asserted-by":"publisher","DOI":"10.1109\/SMC.2013.258"},{"issue":"12","key":"S0219649222500502BIB045","first-page":"279","volume":"4","author":"Thangavel SK","year":"2013","journal-title":"International Journal of Scientific & Engineering Research"},{"key":"S0219649222500502BIB046","doi-asserted-by":"publisher","DOI":"10.1016\/j.simpat.2015.03.003"},{"key":"S0219649222500502BIB047","doi-asserted-by":"publisher","DOI":"10.1142\/S0219649219500096"},{"key":"S0219649222500502BIB048","doi-asserted-by":"publisher","DOI":"10.1016\/j.ijhm.2019.02.002"},{"key":"S0219649222500502BIB049","doi-asserted-by":"publisher","DOI":"10.1142\/S0219649219500333"},{"key":"S0219649222500502BIB050","doi-asserted-by":"publisher","DOI":"10.1016\/j.knosys.2020.106582"},{"issue":"4","key":"S0219649222500502BIB051","first-page":"45","volume":"37","author":"Zaharia M","year":"2012","journal-title":"Usenix"},{"key":"S0219649222500502BIB052","doi-asserted-by":"publisher","DOI":"10.1016\/j.dss.2020.113246"},{"key":"S0219649222500502BIB053","first-page":"10","volume-title":"HotCloud\u201910 Proc. 2nd USENIX Conf. Hot Topics in Cloud Computing","author":"Zaharia M","year":"2010"},{"key":"S0219649222500502BIB056","doi-asserted-by":"publisher","DOI":"10.1109\/BigData.2014.7004327"}],"container-title":["Journal of Information &amp; Knowledge Management"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/www.worldscientific.com\/doi\/pdf\/10.1142\/S0219649222500502","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,10,17]],"date-time":"2022-10-17T08:40:13Z","timestamp":1665996013000},"score":1,"resource":{"primary":{"URL":"https:\/\/www.worldscientific.com\/doi\/10.1142\/S0219649222500502"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2022,6,29]]},"references-count":51,"journal-issue":{"issue":"04","published-print":{"date-parts":[[2022,12]]}},"alternative-id":["10.1142\/S0219649222500502"],"URL":"https:\/\/doi.org\/10.1142\/s0219649222500502","relation":{},"ISSN":["0219-6492","1793-6926"],"issn-type":[{"type":"print","value":"0219-6492"},{"type":"electronic","value":"1793-6926"}],"subject":[],"published":{"date-parts":[[2022,6,29]]},"article-number":"2250050"}}