{"id":"https://openalex.org/W4283715869","doi":"https://doi.org/10.1142/s0219649222500502","title":"Query Execution Time Analysis Using Apache Spark Framework for Big Data: A CRM Approach","display_name":"Query Execution Time Analysis Using Apache Spark Framework for Big Data: A CRM Approach","publication_year":2022,"publication_date":"2022-06-29","ids":{"openalex":"https://openalex.org/W4283715869","doi":"https://doi.org/10.1142/s0219649222500502"},"language":"en","primary_location":{"id":"doi:10.1142/s0219649222500502","is_oa":false,"landing_page_url":"https://doi.org/10.1142/s0219649222500502","pdf_url":null,"source":{"id":"https://openalex.org/S30163770","display_name":"Journal of Information & Knowledge Management","issn_l":"0219-6492","issn":["0219-6492","1793-6926"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319815","host_organization_name":"World Scientific","host_organization_lineage":["https://openalex.org/P4310319815"],"host_organization_lineage_names":["World Scientific"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Information & Knowledge Management","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5012892639","display_name":"Madan Lal Yadav","orcid":"https://orcid.org/0000-0003-1322-3767"},"institutions":[{"id":"https://openalex.org/I4400600926","display_name":"Indian Institute of Management Bodh Gaya","ror":"https://ror.org/01jx6h585","country_code":null,"type":"education","lineage":["https://openalex.org/I4400600926"]}],"countries":["IN"],"is_corresponding":true,"raw_author_name":"Madan Lal Yadav","raw_affiliation_strings":["Indian Institute of Management Bodh Gaya, Bihar, India"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Indian Institute of Management Bodh Gaya, Bihar, India","institution_ids":["https://openalex.org/I4400600926"]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5012892639"],"corresponding_institution_ids":["https://openalex.org/I4400600926"],"apc_list":null,"apc_paid":null,"fwci":1.858,"has_fulltext":false,"cited_by_count":9,"citation_normalized_percentile":{"value":0.87036447,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":97,"max":98},"biblio":{"volume":"21","issue":"04","first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.9983000159263611,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.9983000159263611,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T12384","display_name":"Customer churn and segmentation","score":0.9937999844551086,"subfield":{"id":"https://openalex.org/subfields/1406","display_name":"Marketing"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9919000267982483,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8822386264801025},{"id":"https://openalex.org/keywords/spark","display_name":"SPARK (programming language)","score":0.8726106882095337},{"id":"https://openalex.org/keywords/big-data","display_name":"Big data","score":0.8077824115753174},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7490503191947937},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.5169333815574646},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4893733859062195},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.42549845576286316},{"id":"https://openalex.org/keywords/in-memory-processing","display_name":"In-Memory Processing","score":0.4119728207588196},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.31773173809051514},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.2976447641849518},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.21116238832473755},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.15000668168067932},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.12736839056015015},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.09819456934928894}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8822386264801025},{"id":"https://openalex.org/C2781215313","wikidata":"https://www.wikidata.org/wiki/Q3493345","display_name":"SPARK (programming language)","level":2,"score":0.8726106882095337},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.8077824115753174},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7490503191947937},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.5169333815574646},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4893733859062195},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.42549845576286316},{"id":"https://openalex.org/C123593499","wikidata":"https://www.wikidata.org/wiki/Q6008583","display_name":"In-Memory Processing","level":5,"score":0.4119728207588196},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.31773173809051514},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.2976447641849518},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.21116238832473755},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.15000668168067932},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.12736839056015015},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.09819456934928894},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1142/s0219649222500502","is_oa":false,"landing_page_url":"https://doi.org/10.1142/s0219649222500502","pdf_url":null,"source":{"id":"https://openalex.org/S30163770","display_name":"Journal of Information & Knowledge Management","issn_l":"0219-6492","issn":["0219-6492","1793-6926"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319815","host_organization_name":"World Scientific","host_organization_lineage":["https://openalex.org/P4310319815"],"host_organization_lineage_names":["World Scientific"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Information & Knowledge Management","raw_type":"journal-article"},{"id":"pmh:oai:RePEc:wsi:jikmxx:v:21:y:2022:i:04:n:s0219649222500502","is_oa":false,"landing_page_url":"http://www.worldscientific.com/doi/abs/10.1142/S0219649222500502","pdf_url":null,"source":{"id":"https://openalex.org/S4306401271","display_name":"RePEc: Research Papers in Economics","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I77793887","host_organization_name":"Federal Reserve Bank of St. Louis","host_organization_lineage":["https://openalex.org/I77793887"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/12","score":0.5,"display_name":"Responsible consumption and production"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":45,"referenced_works":["https://openalex.org/W1972240185","https://openalex.org/W1976064898","https://openalex.org/W1982819851","https://openalex.org/W2003958732","https://openalex.org/W2010462324","https://openalex.org/W2011716962","https://openalex.org/W2013146628","https://openalex.org/W2017928163","https://openalex.org/W2029125750","https://openalex.org/W2037518952","https://openalex.org/W2038412523","https://openalex.org/W2044124763","https://openalex.org/W2056596884","https://openalex.org/W2061556416","https://openalex.org/W2063734355","https://openalex.org/W2070917020","https://openalex.org/W2074410942","https://openalex.org/W2074780813","https://openalex.org/W2076663617","https://openalex.org/W2138854216","https://openalex.org/W2139921829","https://openalex.org/W2141575637","https://openalex.org/W2530058011","https://openalex.org/W2538056999","https://openalex.org/W2546027901","https://openalex.org/W2607201658","https://openalex.org/W2802877479","https://openalex.org/W2803483156","https://openalex.org/W2804359319","https://openalex.org/W2899789861","https://openalex.org/W2912285856","https://openalex.org/W2914607545","https://openalex.org/W2916878795","https://openalex.org/W2935674156","https://openalex.org/W2967231844","https://openalex.org/W2975266026","https://openalex.org/W2995630456","https://openalex.org/W3000241400","https://openalex.org/W3038976147","https://openalex.org/W3094843711","https://openalex.org/W3100552002","https://openalex.org/W3120786329","https://openalex.org/W3170768354","https://openalex.org/W4249618410","https://openalex.org/W4377043424"],"related_works":["https://openalex.org/W2766461310","https://openalex.org/W4247566972","https://openalex.org/W3202731209","https://openalex.org/W4240326769","https://openalex.org/W3211874991","https://openalex.org/W3012518171","https://openalex.org/W4241605045","https://openalex.org/W4379407450","https://openalex.org/W2558523485","https://openalex.org/W2895375519"],"abstract_inverted_index":{"Customer":[0],"Relationship":[1],"Management":[2],"(CRM)":[3],"is":[4,49,105,149],"a":[5,31,101,150,159],"systematic":[6],"way":[7],"of":[8,35,71,89,128,138,194],"working":[9],"with":[10,55,158,177],"current":[11],"and":[12,19,24,44,47,60,77,111,117,186],"prospective":[13],"customers":[14],"to":[15,51,67,74,124,182,191],"manage":[16],"long-term":[17],"relationships":[18],"interactions":[20],"between":[21],"the":[22,69,126,132,139,195],"company":[23],"customers.":[25],"Recently,":[26],"Big":[27,72,108,142,154,198],"Data":[28,73,109,143,155,199],"has":[29,169],"become":[30],"buzzword.":[32],"It":[33,148,168],"consists":[34],"huge":[36],"data":[37,57,129],"repositories,":[38],"having":[39],"information":[40],"collected":[41],"from":[42],"online":[43],"offline":[45],"resources,":[46],"it":[48],"hard":[50],"process":[52],"such":[53],"datasets":[54,90,180,185],"traditional":[56],"processing":[58,110,156],"tools":[59],"techniques.":[61],"The":[62],"presented":[63],"research":[64,99,122],"work":[65],"tries":[66,123],"explore":[68],"potential":[70],"create,":[75],"optimise":[76],"transform":[78],"an":[79],"insightful":[80],"customer":[81,93],"relationship":[82],"management":[83],"system":[84],"by":[85],"analysing":[86],"large":[87,178],"amount":[88],"for":[91,107,115,136,163],"enhancing":[92],"life":[94],"cycle":[95],"profitability.":[96],"In":[97],"this":[98],"work,":[100],"dataset,":[102],"\u201cBook":[103],"Crossing\u201d":[104],"used":[106,141,197],"execution":[112,134],"time":[113,135],"analysis":[114],"simple":[116],"complex":[118],"SQL":[119,161,165],"queries.":[120],"This":[121],"analyse":[125],"impact":[127],"size":[130,179,184],"on":[131,202],"query":[133,166],"one":[137,193],"majorly":[140,196],"frameworks,":[144],"namely":[145],"Apache":[146],"Spark.":[147],"recently":[151],"developed":[152],"in-memory":[153],"framework":[157],"SPARK":[160],"module":[162],"efficient":[164],"execution.":[167],"been":[170],"found":[171],"that":[172],"Apache-Spark":[173],"gives":[174],"better":[175,188],"results":[176],"compare":[181],"small":[183],"fares":[187],"as":[189],"compared":[190],"Hadoop,":[192],"Frameworks":[200],"(based":[201],"qualitative":[203],"analysis).":[204]},"counts_by_year":[{"year":2025,"cited_by_count":5},{"year":2023,"cited_by_count":4}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}