{"id":"https://openalex.org/W3113323589","doi":"https://doi.org/10.1109/icccs49678.2020.9276824","title":"Proposed Techniques to Optimize the DW and ETL Query for Enhancing data warehouse efficiency","display_name":"Proposed Techniques to Optimize the DW and ETL Query for Enhancing data warehouse efficiency","publication_year":2020,"publication_date":"2020-10-14","ids":{"openalex":"https://openalex.org/W3113323589","doi":"https://doi.org/10.1109/icccs49678.2020.9276824","mag":"3113323589"},"language":"en","primary_location":{"id":"doi:10.1109/icccs49678.2020.9276824","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icccs49678.2020.9276824","pdf_url":null,"source":{"id":"https://openalex.org/S4306498618","display_name":"2020 5th International Conference on Computing, Communication and Security (ICCCS)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2020 5th International Conference on Computing, Communication and Security (ICCCS)","raw_type":"proceedings-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/A5100769066","display_name":"Abhishek Gupta","orcid":"https://orcid.org/0000-0001-8559-0510"},"institutions":[{"id":"https://openalex.org/I138876546","display_name":"Vels University","ror":"https://ror.org/00tscx035","country_code":"IN","type":"education","lineage":["https://openalex.org/I138876546"]}],"countries":["IN"],"is_corresponding":true,"raw_author_name":"Abhishek Gupta","raw_affiliation_strings":["Dept of Computer Science and Engineering, Application Development Senior Analyst, Vels Institute of Science, Technology and Advanced Studies, Accenture Services Pvt Ltd, Chennai, India"],"affiliations":[{"raw_affiliation_string":"Dept of Computer Science and Engineering, Application Development Senior Analyst, Vels Institute of Science, Technology and Advanced Studies, Accenture Services Pvt Ltd, Chennai, India","institution_ids":["https://openalex.org/I138876546"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5022659445","display_name":"Arun Sahayadhas","orcid":"https://orcid.org/0000-0003-1230-4362"},"institutions":[{"id":"https://openalex.org/I138876546","display_name":"Vels University","ror":"https://ror.org/00tscx035","country_code":"IN","type":"education","lineage":["https://openalex.org/I138876546"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Arun Sahayadhas","raw_affiliation_strings":["Dept of Computer Science and Engineering, Vels Institute of Science, Technology and Advanced Studies, Chennai, India"],"affiliations":[{"raw_affiliation_string":"Dept of Computer Science and Engineering, Vels Institute of Science, Technology and Advanced Studies, Chennai, India","institution_ids":["https://openalex.org/I138876546"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5100769066"],"corresponding_institution_ids":["https://openalex.org/I138876546"],"apc_list":null,"apc_paid":null,"fwci":1.6226,"has_fulltext":false,"cited_by_count":7,"citation_normalized_percentile":{"value":0.86561775,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"5"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9997000098228455,"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"}},"topics":[{"id":"https://openalex.org/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9997000098228455,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9990000128746033,"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/T11719","display_name":"Data Quality and Management","score":0.9980000257492065,"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.887410581111908},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8134019374847412},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6841729879379272},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6101722121238708},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5517487525939941},{"id":"https://openalex.org/keywords/data-quality","display_name":"Data quality","score":0.5331926345825195},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.48577454686164856},{"id":"https://openalex.org/keywords/quality","display_name":"Quality (philosophy)","score":0.46527525782585144},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.42614713311195374},{"id":"https://openalex.org/keywords/data-modeling","display_name":"Data modeling","score":0.42474985122680664},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.32056328654289246},{"id":"https://openalex.org/keywords/metric","display_name":"Metric (unit)","score":0.1121126115322113},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.1059725284576416}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.887410581111908},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8134019374847412},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6841729879379272},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6101722121238708},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5517487525939941},{"id":"https://openalex.org/C24756922","wikidata":"https://www.wikidata.org/wiki/Q1757694","display_name":"Data quality","level":3,"score":0.5331926345825195},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.48577454686164856},{"id":"https://openalex.org/C2779530757","wikidata":"https://www.wikidata.org/wiki/Q1207505","display_name":"Quality (philosophy)","level":2,"score":0.46527525782585144},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.42614713311195374},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.42474985122680664},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.32056328654289246},{"id":"https://openalex.org/C176217482","wikidata":"https://www.wikidata.org/wiki/Q860554","display_name":"Metric (unit)","level":2,"score":0.1121126115322113},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.1059725284576416},{"id":"https://openalex.org/C21547014","wikidata":"https://www.wikidata.org/wiki/Q1423657","display_name":"Operations management","level":1,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/icccs49678.2020.9276824","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icccs49678.2020.9276824","pdf_url":null,"source":{"id":"https://openalex.org/S4306498618","display_name":"2020 5th International Conference on Computing, Communication and Security (ICCCS)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2020 5th International Conference on Computing, Communication and Security (ICCCS)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/9","score":0.46000000834465027,"display_name":"Industry, innovation and infrastructure"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":5,"referenced_works":["https://openalex.org/W1557303104","https://openalex.org/W2122315596","https://openalex.org/W2187727352","https://openalex.org/W2239081428","https://openalex.org/W6690187157"],"related_works":["https://openalex.org/W2556786504","https://openalex.org/W4244527061","https://openalex.org/W2152149667","https://openalex.org/W2901826185","https://openalex.org/W2742521120","https://openalex.org/W2469357693","https://openalex.org/W3119296476","https://openalex.org/W2159392828","https://openalex.org/W2353586736","https://openalex.org/W3125756434"],"abstract_inverted_index":{"To":[0],"improve":[1,169],"time-bound":[2],"decision":[3],"capability":[4],"of":[5,71,85,105,112,122,261],"any":[6,79,271],"business":[7],"corporates,":[8],"they":[9],"have":[10,184,213,235,251],"to":[11,48,65,101,108,168,257,278,284],"perform":[12,66],"data-analysis":[13,152,180],"based":[14,77,91],"on":[15,78,92,156,199],"historical":[16,44],"and":[17,58,69,115,127,140,189,202,228,232,243],"current":[18],"data.":[19,72],"For":[20],"handling":[21],"this":[22,116,129,187],"data,":[23],"data":[24,36,42,45,123,130,144,159,162,171,203,245,255,262,283],"warehouse":[25,43,124,256],"(DWH)":[26],"plays":[27],"a":[28],"crucial":[29],"role.":[30],"Further-more":[31],"as":[32,151],"time":[33],"passes,":[34],"the":[35,103,110,120,157,170,217,282,286],"also":[37,46,132,147,226],"grows":[38],"exponentially,":[39],"because":[40],"in":[41,83,135,186,222,254,270],"needs":[47],"be":[49,133,154,268],"maintained.":[50],"If":[51],"we":[52,183,212,234,250],"further":[53],"drill":[54],"now-a-days":[55],"Extract":[56],"Transform":[57],"Load":[59],"(ETL)":[60],"tools":[61,75,114],"are":[62,76,196,275],"being":[63,276],"used":[64,277],"extract,":[67],"transform":[68],"loading":[70],"These":[73,264],"ETL":[74,87,113,125],"specific":[80],"language":[81],"like":[82],"case":[84],"Informatica":[86],"tool,":[88],"which":[89,195,249],"is":[90,146],"Structured":[93],"Query":[94],"Language":[95],"(SQL)":[96],"language.":[97],"So,":[98,164,182],"it's":[99,165],"imperative":[100],"enhance":[102,109,258,285],"efficiency":[104],"these":[106,223],"languages":[107],"capacity":[111],"will":[117,153],"significantly":[118],"impact":[119],"performance":[121,218,260],"work,":[126],"by":[128,161,173],"can":[131,267],"provided":[134],"faster":[136],"manner":[137],"for":[138,179,240],"analysis":[139],"reporting":[141],"purposes.":[142],"Additionally,":[143],"quality":[145,172,204,246],"an":[148],"important":[149],"factor,":[150],"performed":[155],"same":[158],"supplied":[160],"warehouse.":[163,263],"highly":[166],"concerned":[167],"applying":[174],"data-quality":[175],"checks":[176],"before":[177],"supplying":[178],"purpose.":[181],"worked":[185,227],"direction":[188],"gone":[190],"through":[191,208],"various":[192,230],"research":[193,210],"papers":[194,224],"mainly":[197],"focused":[198],"query":[200,241],"optimization":[201,242],"improvements.":[205],"After":[206,248],"going":[207],"all":[209],"papers,":[211],"not":[214],"only":[215],"summarized":[216],"tuning":[219],"tips":[220],"given":[221],"but":[225],"experimented":[229],"things,":[231],"then":[233],"proposed":[236,265],"some":[237],"unique":[238],"techniques":[239,266],"improved":[244],"techniques.":[247],"incorporated":[252],"it":[253],"overall":[259],"applied":[269],"place":[272],"wherever":[273],"queries":[274],"extract/transform":[279],"and/or":[280],"load":[281],"performance.":[287]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}