{"id":"https://openalex.org/W4309862425","doi":"https://doi.org/10.1002/cpe.7459","title":"Automated heuristic based context dependent ETL process to generate multi\u2010dimensional model for tabular data","display_name":"Automated heuristic based context dependent ETL process to generate multi\u2010dimensional model for tabular data","publication_year":2022,"publication_date":"2022-11-23","ids":{"openalex":"https://openalex.org/W4309862425","doi":"https://doi.org/10.1002/cpe.7459"},"language":"en","primary_location":{"id":"doi:10.1002/cpe.7459","doi":"https://doi.org/10.1002/cpe.7459","is_oa":false,"landing_page_url":"https://doi.org/10.1002/cpe.7459","pdf_url":null,"source":{"id":"https://openalex.org/S11065456","display_name":"Concurrency and Computation Practice and Experience","issn_l":"1532-0626","issn":["1532-0626","1532-0634"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["anvur-scientific","ccf-c","cwts-core","dongbi-d","jufo-1","norway-1","poland-100","russia-white-list-2"],"host_organization":"https://openalex.org/P4310320595","host_organization_name":"Wiley","host_organization_lineage":["https://openalex.org/P4310320595"],"host_organization_lineage_names":["Wiley"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Concurrency and Computation: Practice and Experience","raw_type":"journal-article"},"volume":null,"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/A5079233694","display_name":"Swati Hira","orcid":"https://orcid.org/0000-0003-3312-0044","observed_orcids":["https://orcid.org/0000-0003-3312-0044"]},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Swati Hira","raw_affiliation_strings":["Department of Computer Science & Engineering Shri Ramdeobaba College of Engineering and Management Nagpur India"],"raw_orcid":"https://orcid.org/0000-0003-3312-0044","affiliations":[{"raw_affiliation_string":"Department of Computer Science & Engineering Shri Ramdeobaba College of Engineering and Management Nagpur India","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5053173905","display_name":"Parag S Deshpande","orcid":"https://orcid.org/0000-0003-4051-4666","observed_orcids":["https://orcid.org/0000-0003-4051-4666"]},"institutions":[{"id":"https://openalex.org/I167153416","display_name":"Visvesvaraya National Institute of Technology","ror":"https://ror.org/02zrtpp84","country_code":"IN","type":"education","lineage":["https://openalex.org/I167153416"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Parag S. Deshpande","raw_affiliation_strings":["Department of Computer Science & Engineering Visvesvaraya National Institute of Technology Nagpur India"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Science & Engineering Visvesvaraya National Institute of Technology Nagpur India","institution_ids":["https://openalex.org/I167153416"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5079233694"],"corresponding_institution_ids":[],"apc_list":{"value":4600,"currency":"USD","value_usd":4600},"apc_paid":null,"fwci":0.2405,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.63345719,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":"35","issue":"2","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.9477999806404114,"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.9477999806404114,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.03269999846816063,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.003700000001117587,"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/etl-automation","display_name":"ETL automation","score":0.7670000195503235},{"id":"https://openalex.org/keywords/data-warehousing","display_name":"data warehousing","score":0.7670000195503235},{"id":"https://openalex.org/keywords/tabular-data","display_name":"tabular data","score":0.8870000243186951},{"id":"https://openalex.org/keywords/data-heterogeneity","display_name":"data heterogeneity","score":0.6349999904632568},{"id":"https://openalex.org/keywords/business-intelligence","display_name":"business intelligence","score":0.6359999775886536},{"id":"https://openalex.org/keywords/decision-support","display_name":"decision support","score":0.5130000114440918}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8155903220176697},{"id":"https://openalex.org/C55439883","wikidata":"https://www.wikidata.org/wiki/Q360812","display_name":"Correctness","level":2,"score":0.790777325630188},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.6052227020263672},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.5945349335670471},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.5855627059936523},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.5821094512939453},{"id":"https://openalex.org/C173801870","wikidata":"https://www.wikidata.org/wiki/Q201413","display_name":"Heuristic","level":2,"score":0.46109381318092346},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.45112553238868713},{"id":"https://openalex.org/C20556612","wikidata":"https://www.wikidata.org/wiki/Q4469374","display_name":"Volume (thermodynamics)","level":2,"score":0.4397948086261749},{"id":"https://openalex.org/C204241405","wikidata":"https://www.wikidata.org/wiki/Q461499","display_name":"Transformation (genetics)","level":3,"score":0.4314176142215729},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.14319497346878052},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.1387188732624054},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.08167770504951477},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","level":1,"score":0.0},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0},{"id":"https://openalex.org/C62520636","wikidata":"https://www.wikidata.org/wiki/Q944","display_name":"Quantum mechanics","level":1,"score":0.0},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1002/cpe.7459","doi":"https://doi.org/10.1002/cpe.7459","is_oa":false,"landing_page_url":"https://doi.org/10.1002/cpe.7459","pdf_url":null,"source":{"id":"https://openalex.org/S11065456","display_name":"Concurrency and Computation Practice and Experience","issn_l":"1532-0626","issn":["1532-0626","1532-0634"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["anvur-scientific","ccf-c","cwts-core","dongbi-d","jufo-1","norway-1","poland-100","russia-white-list-2"],"host_organization":"https://openalex.org/P4310320595","host_organization_name":"Wiley","host_organization_lineage":["https://openalex.org/P4310320595"],"host_organization_lineage_names":["Wiley"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Concurrency and Computation: Practice and Experience","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":35,"referenced_works":["https://openalex.org/W27547836","https://openalex.org/W208128215","https://openalex.org/W1481313366","https://openalex.org/W1508288884","https://openalex.org/W1508412218","https://openalex.org/W1759446372","https://openalex.org/W1792735297","https://openalex.org/W1955600018","https://openalex.org/W2066806792","https://openalex.org/W2092772700","https://openalex.org/W2106952837","https://openalex.org/W2108223890","https://openalex.org/W2108971776","https://openalex.org/W2124281878","https://openalex.org/W2136379584","https://openalex.org/W2157735936","https://openalex.org/W2174529133","https://openalex.org/W2296533043","https://openalex.org/W2302378120","https://openalex.org/W2527885946","https://openalex.org/W2575118467","https://openalex.org/W2582967064","https://openalex.org/W2589209642","https://openalex.org/W2803678638","https://openalex.org/W2920901101","https://openalex.org/W2972908700","https://openalex.org/W3015899388","https://openalex.org/W3087912616","https://openalex.org/W3128828942","https://openalex.org/W3146974869","https://openalex.org/W3157257697","https://openalex.org/W3192876105","https://openalex.org/W3215678666","https://openalex.org/W4200034645","https://openalex.org/W4251485414"],"related_works":["https://openalex.org/W2589209642","https://openalex.org/W4233488159","https://openalex.org/W2186258383","https://openalex.org/W1493232818","https://openalex.org/W1592728322","https://openalex.org/W26926119","https://openalex.org/W1969722313","https://openalex.org/W4395958335","https://openalex.org/W2786867111","https://openalex.org/W7064834919"],"abstract_inverted_index":{"Summary":[0],"Over":[1],"the":[2,22,57,88,141,145,166,186,197],"past":[3],"decade,":[4],"enterprises":[5],"have":[6],"broadly":[7],"adopted":[8],"data":[9,32,64,92],"warehousing":[10],"in":[11,21,132,138,178],"various":[12,182],"activities.":[13],"Today,":[14],"abundant":[15],"information":[16,175],"is":[17,53,72,163,176],"available":[18],"on":[19,87,135],"websites":[20,173],"form":[23],"of":[24,31,38,61,91,149,160,171,196],"tables":[25],"or":[26],"spreadsheets.":[27],"This":[28,102],"huge":[29],"amount":[30],"cannot":[33],"be":[34],"processed":[35],"directly":[36],"because":[37],"its":[39],"complexity,":[40],"heterogeneity,":[41],"and":[42,80,118,121,147,168,181],"gap":[43],"between":[44],"user":[45],"requirements.":[46],"In":[47],"this":[48],"work,":[49],"an":[50],"automatic":[51],"approach":[52,104],"proposed":[54,70,103,142,161,187],"to":[55,123,153,192],"build":[56],"multi\u2010dimensional":[58,108,151],"structure":[59],"(MDS)":[60],"heterogeneous":[62,183],"tabular":[63,179],"format":[65],"for":[66,110],"intelligent":[67],"decision\u2010making.":[68],"The":[69,158],"MDS":[71],"generated":[73],"by":[74],"identifying":[75],"components":[76],"such":[77],"as":[78,97,99],"dimensions":[79,93],"hierarchies.":[81,101],"It":[82],"automatically":[83,105],"extracts":[84],"measures":[85],"based":[86,134],"spatial":[89],"characteristics":[90],"like":[94,128],"region,":[95],"time":[96,146],"well":[98],"their":[100],"generates":[106],"a":[107,154],"model":[109],"BI":[111],"tools":[112],"without":[113],"complicated":[114],"ETL":[115,198],"(Extraction,":[116],"Transformation":[117],"Loading)":[119],"process":[120],"helps":[122],"solve":[124],"several":[125],"business":[126],"queries,":[127],"\u201cTop":[129],"5":[130],"states":[131],"India":[133],"Irrigated":[136],"area":[137],"2009\u201d.":[139],"Moreover,":[140],"method":[143,162,188],"reduces":[144],"cost":[148],"building":[150],"models":[152],"very":[155],"large":[156],"extent.":[157],"correctness":[159],"tested":[164],"with":[165],"synthetic":[167],"economic":[169],"datasets":[170],"Government":[172],"where":[174,185],"stored":[177],"formats":[180],"setups":[184],"saved":[189],"approximately":[190],"4000":[191],"5000":[193],"computing":[194],"hours":[195],"process.":[199]},"counts_by_year":[{"year":2024,"cited_by_count":1}],"updated_date":"2026-10-30T12:39:25.321706","created_date":"2022-11-29T00:00:00"}