{"id":"https://openalex.org/W4390663640","doi":"https://doi.org/10.1186/s13677-023-00571-y","title":"An efficient hybrid optimization of ETL process in data warehouse of cloud architecture","display_name":"An efficient hybrid optimization of ETL process in data warehouse of cloud architecture","publication_year":2024,"publication_date":"2024-01-08","ids":{"openalex":"https://openalex.org/W4390663640","doi":"https://doi.org/10.1186/s13677-023-00571-y"},"language":"en","primary_location":{"id":"doi:10.1186/s13677-023-00571-y","is_oa":true,"landing_page_url":"https://doi.org/10.1186/s13677-023-00571-y","pdf_url":"https://journalofcloudcomputing.springeropen.com/counter/pdf/10.1186/s13677-023-00571-y","source":{"id":"https://openalex.org/S2486819371","display_name":"Journal of Cloud Computing Advances Systems and Applications","issn_l":"2192-113X","issn":["2192-113X"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310319965","host_organization_name":"Springer Nature","host_organization_lineage":["https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Cloud Computing","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://journalofcloudcomputing.springeropen.com/counter/pdf/10.1186/s13677-023-00571-y","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5093668303","display_name":"Lina Dinesh","orcid":null},"institutions":[{"id":"https://openalex.org/I4387155381","display_name":"Sri Eshwar College of Engineering","ror":"https://ror.org/02f1z8215","country_code":null,"type":"education","lineage":["https://openalex.org/I4387155381"]}],"countries":["IN"],"is_corresponding":true,"raw_author_name":"Lina Dinesh","raw_affiliation_strings":["Department of Computer Science and Engineering, Sri Eshwar College of Engineering, Coimbatore, 641202, India"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science and Engineering, Sri Eshwar College of Engineering, Coimbatore, 641202, India","institution_ids":["https://openalex.org/I4387155381"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5048973998","display_name":"K. Gayathri Devi","orcid":"https://orcid.org/0000-0001-6308-7615"},"institutions":[{"id":"https://openalex.org/I4210133257","display_name":"KPR Institute of Engineering and Technology","ror":"https://ror.org/02q9f3a53","country_code":"IN","type":"education","lineage":["https://openalex.org/I4210133257"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"K. Gayathri Devi","raw_affiliation_strings":["Department of Electronics and Communication Engineering, Dr.N.G.P.Institute of Technology, Coimbatore, 641048, India"],"affiliations":[{"raw_affiliation_string":"Department of Electronics and Communication Engineering, Dr.N.G.P.Institute of Technology, Coimbatore, 641048, India","institution_ids":["https://openalex.org/I4210133257"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5093668303"],"corresponding_institution_ids":["https://openalex.org/I4387155381"],"apc_list":{"value":990,"currency":"GBP","value_usd":1214},"apc_paid":{"value":990,"currency":"GBP","value_usd":1214},"fwci":12.0547,"has_fulltext":true,"cited_by_count":24,"citation_normalized_percentile":{"value":0.98654843,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":100},"biblio":{"volume":"13","issue":"1","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.9977999925613403,"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.9977999925613403,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9972000122070312,"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"}},{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9923999905586243,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.8670686483383179},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8136876225471497},{"id":"https://openalex.org/keywords/cloud-computing","display_name":"Cloud computing","score":0.6623749732971191},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.5863680839538574},{"id":"https://openalex.org/keywords/cluster-analysis","display_name":"Cluster analysis","score":0.5584335327148438},{"id":"https://openalex.org/keywords/data-transformation","display_name":"Data transformation","score":0.5568543076515198},{"id":"https://openalex.org/keywords/big-data","display_name":"Big data","score":0.5321924686431885},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.494340181350708},{"id":"https://openalex.org/keywords/tabu-search","display_name":"Tabu search","score":0.4752112329006195},{"id":"https://openalex.org/keywords/dimensional-modeling","display_name":"Dimensional modeling","score":0.44382452964782715},{"id":"https://openalex.org/keywords/data-redundancy","display_name":"Data redundancy","score":0.42657727003097534},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.4107814431190491},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.16188928484916687},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.12651988863945007},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.08771014213562012}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.8670686483383179},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8136876225471497},{"id":"https://openalex.org/C79974875","wikidata":"https://www.wikidata.org/wiki/Q483639","display_name":"Cloud computing","level":2,"score":0.6623749732971191},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.5863680839538574},{"id":"https://openalex.org/C73555534","wikidata":"https://www.wikidata.org/wiki/Q622825","display_name":"Cluster analysis","level":2,"score":0.5584335327148438},{"id":"https://openalex.org/C150670458","wikidata":"https://www.wikidata.org/wiki/Q4272815","display_name":"Data transformation","level":3,"score":0.5568543076515198},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.5321924686431885},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.494340181350708},{"id":"https://openalex.org/C123370116","wikidata":"https://www.wikidata.org/wiki/Q1424540","display_name":"Tabu search","level":2,"score":0.4752112329006195},{"id":"https://openalex.org/C143008350","wikidata":"https://www.wikidata.org/wiki/Q3432172","display_name":"Dimensional modeling","level":2,"score":0.44382452964782715},{"id":"https://openalex.org/C7545210","wikidata":"https://www.wikidata.org/wiki/Q838123","display_name":"Data redundancy","level":2,"score":0.42657727003097534},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.4107814431190491},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.16188928484916687},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.12651988863945007},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.08771014213562012}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1186/s13677-023-00571-y","is_oa":true,"landing_page_url":"https://doi.org/10.1186/s13677-023-00571-y","pdf_url":"https://journalofcloudcomputing.springeropen.com/counter/pdf/10.1186/s13677-023-00571-y","source":{"id":"https://openalex.org/S2486819371","display_name":"Journal of Cloud Computing Advances Systems and Applications","issn_l":"2192-113X","issn":["2192-113X"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310319965","host_organization_name":"Springer Nature","host_organization_lineage":["https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Cloud Computing","raw_type":"journal-article"},{"id":"pmh:oai:doaj.org/article:5607b9276f1a4652a0c3a11664fa7999","is_oa":true,"landing_page_url":"https://doaj.org/article/5607b9276f1a4652a0c3a11664fa7999","pdf_url":null,"source":{"id":"https://openalex.org/S112646816","display_name":"SHILAP Revista de lepidopterolog\u00eda","issn_l":"0300-5267","issn":["0300-5267","2340-4078"],"is_oa":true,"is_in_doaj":true,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Journal of Cloud Computing: Advances, Systems and Applications, Vol 13, Iss 1, Pp 1-12 (2024)","raw_type":"article"}],"best_oa_location":{"id":"doi:10.1186/s13677-023-00571-y","is_oa":true,"landing_page_url":"https://doi.org/10.1186/s13677-023-00571-y","pdf_url":"https://journalofcloudcomputing.springeropen.com/counter/pdf/10.1186/s13677-023-00571-y","source":{"id":"https://openalex.org/S2486819371","display_name":"Journal of Cloud Computing Advances Systems and Applications","issn_l":"2192-113X","issn":["2192-113X"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310319965","host_organization_name":"Springer Nature","host_organization_lineage":["https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Cloud Computing","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4390663640.pdf"},"referenced_works_count":49,"referenced_works":["https://openalex.org/W2063753658","https://openalex.org/W2083755493","https://openalex.org/W2189040081","https://openalex.org/W2529590683","https://openalex.org/W2740234477","https://openalex.org/W2888079598","https://openalex.org/W2906700374","https://openalex.org/W2910309215","https://openalex.org/W2911299907","https://openalex.org/W2912274100","https://openalex.org/W2919119516","https://openalex.org/W2930053622","https://openalex.org/W2935674156","https://openalex.org/W2969922297","https://openalex.org/W2980728347","https://openalex.org/W2997309137","https://openalex.org/W2997630374","https://openalex.org/W3003081206","https://openalex.org/W3007341125","https://openalex.org/W3007783271","https://openalex.org/W3008391147","https://openalex.org/W3010930234","https://openalex.org/W3016092890","https://openalex.org/W3046139778","https://openalex.org/W3081885737","https://openalex.org/W3128365411","https://openalex.org/W3135376611","https://openalex.org/W3178252834","https://openalex.org/W3214669781","https://openalex.org/W3217762463","https://openalex.org/W4210683627","https://openalex.org/W4210838854","https://openalex.org/W4210907452","https://openalex.org/W4224271671","https://openalex.org/W4225589992","https://openalex.org/W4225693907","https://openalex.org/W4293056469","https://openalex.org/W4293103018","https://openalex.org/W4293723031","https://openalex.org/W4300641138","https://openalex.org/W4309939033","https://openalex.org/W4310790298","https://openalex.org/W4312732298","https://openalex.org/W4313174306","https://openalex.org/W4317436033","https://openalex.org/W4365801699","https://openalex.org/W4383860586","https://openalex.org/W4385565171","https://openalex.org/W4385949167"],"related_works":["https://openalex.org/W2003588249","https://openalex.org/W2384973249","https://openalex.org/W2946072518","https://openalex.org/W4211040133","https://openalex.org/W2473783532","https://openalex.org/W2364425891","https://openalex.org/W2361366861","https://openalex.org/W2181836431","https://openalex.org/W3176140258","https://openalex.org/W2373884155"],"abstract_inverted_index":{"Abstract":[0],"In":[1,170],"big":[2,69,123],"data,":[3,21,157],"analysis":[4],"data":[5,31,59,70,75,79,82,100,124,140,146,162,200,210,214,235],"is":[6,52,182,194],"collected":[7],"from":[8,98,212],"different":[9],"sources":[10],"in":[11,32,57,68,94,125,144,166,219,236],"various":[12],"formats,":[13],"transforming":[14,36],"into":[15,26],"the":[16,20,39,58,99,106,145,167,174,186,198,206,213,220,227,233,237],"aspect":[17],"of":[18,113,160,189,208,230],"cleansing":[19],"customization,":[22],"and":[23,35,51,76,102,142,163],"loading":[24],"it":[25,37],"a":[27,91,117,126,178,202],"Data":[28],"Warehouse.":[29],"Extracting":[30],"other":[33],"formats":[34],"to":[38,104,138,184],"required":[40],"format":[41],"requires":[42],"transformation":[43,46,168],"algorithms.":[44],"This":[45,108,131],"stage":[47],"has":[48],"redundancy":[49],"issues":[50,67,136],"stored":[53],"across":[54],"any":[55],"location":[56],"warehouse,":[60],"which":[61],"increases":[62],"computation":[63],"costs.":[64],"The":[65,216],"main":[66],"ETL":[71,129,221],"are":[72],"handling":[73,122],"high-dimensional":[74],"maintaining":[77],"similar":[78],"for":[80,121,173,196],"effective":[81],"warehouse":[83,101,238],"usage.":[84],"Therefore,":[85,232],"Extract,":[86],"Transform,":[87],"Load":[88],"(ETL)":[89],"plays":[90],"vital":[92],"role":[93],"extracting":[95],"meaningful":[96],"information":[97],"trying":[103],"retain":[105],"users.":[107],"paper":[109],"proposes":[110],"hybrid":[111],"optimization":[112,165],"Swarm":[114,148],"Intelligence":[115,149],"with":[116],"tabu":[118],"search":[119],"algorithm":[120],"cloud-based":[127],"architecture-based":[128],"process.":[130],"proposed":[132,228],"work":[133,172,229],"overcomes":[134],"many":[135],"related":[137],"complex":[139],"storage":[141],"retrieval":[143],"warehouse.":[147,215],"algorithms":[150],"can":[151,223,239],"overcome":[152],"problems":[153],"like":[154],"high":[155,187],"dimensional":[156],"dynamical":[158],"change":[159],"huge":[161,234],"cost":[164],"stage.":[169],"this":[171],"swarm":[175],"intelligence":[176],"algorithm,":[177],"Grey-Wolf":[179],"Optimizer":[180],"(GWO)":[181],"implemented":[183],"reduce":[185],"dimensionality":[188],"data.":[190],"Tabu":[191],"Search":[192],"(TS)":[193],"used":[195],"clustering":[197],"relevant":[199,209],"as":[201],"group.":[203],"Clustering":[204],"means":[205],"segregation":[207],"accurately":[211],"cluster":[217],"size":[218],"process":[222],"be":[224,240],"optimized":[225],"by":[226],"(GWO-TS).":[231],"processed":[241],"within":[242],"an":[243],"expected":[244],"latency.":[245]},"counts_by_year":[{"year":2026,"cited_by_count":3},{"year":2025,"cited_by_count":14},{"year":2024,"cited_by_count":6},{"year":2023,"cited_by_count":1}],"updated_date":"2026-04-02T15:55:50.835912","created_date":"2025-10-10T00:00:00"}