{"id":"https://openalex.org/W3097876809","doi":"https://doi.org/10.1109/coginfocom50765.2020.9237814","title":"Case Study of an On-premise Data Warehouse Configuration","display_name":"Case Study of an On-premise Data Warehouse Configuration","publication_year":2020,"publication_date":"2020-09-23","ids":{"openalex":"https://openalex.org/W3097876809","doi":"https://doi.org/10.1109/coginfocom50765.2020.9237814","mag":"3097876809"},"language":"en","primary_location":{"id":"doi:10.1109/coginfocom50765.2020.9237814","is_oa":false,"landing_page_url":"https://doi.org/10.1109/coginfocom50765.2020.9237814","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2020 11th IEEE International Conference on Cognitive Infocommunications (CogInfoCom)","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/A5067788845","display_name":"Bence Bogdandy","orcid":null},"institutions":[{"id":"https://openalex.org/I120832542","display_name":"Eszterhazy Karoly Catholic University","ror":"https://ror.org/004gfgx38","country_code":"HU","type":"education","lineage":["https://openalex.org/I120832542"]}],"countries":["HU"],"is_corresponding":true,"raw_author_name":"Bence Bogdandy","raw_affiliation_strings":["Institute of Computational Science, Eszterh\u00e1zy K\u00e1roly University"],"affiliations":[{"raw_affiliation_string":"Institute of Computational Science, Eszterh\u00e1zy K\u00e1roly University","institution_ids":["https://openalex.org/I120832542"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5017725898","display_name":"Adam Kovacs","orcid":null},"institutions":[{"id":"https://openalex.org/I120832542","display_name":"Eszterhazy Karoly Catholic University","ror":"https://ror.org/004gfgx38","country_code":"HU","type":"education","lineage":["https://openalex.org/I120832542"]}],"countries":["HU"],"is_corresponding":false,"raw_author_name":"Adam Kovacs","raw_affiliation_strings":["Eszterh\u00e1zy K\u00e1roly University"],"affiliations":[{"raw_affiliation_string":"Eszterh\u00e1zy K\u00e1roly University","institution_ids":["https://openalex.org/I120832542"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5101486687","display_name":"Zsolt T\u00f3th","orcid":"https://orcid.org/0000-0001-6228-4262"},"institutions":[{"id":"https://openalex.org/I120832542","display_name":"Eszterhazy Karoly Catholic University","ror":"https://ror.org/004gfgx38","country_code":"HU","type":"education","lineage":["https://openalex.org/I120832542"]}],"countries":["HU"],"is_corresponding":false,"raw_author_name":"Zsolt Toth","raw_affiliation_strings":["Institute of Computational Science, Eszterh\u00e1zy K\u00e1roly University"],"affiliations":[{"raw_affiliation_string":"Institute of Computational Science, Eszterh\u00e1zy K\u00e1roly University","institution_ids":["https://openalex.org/I120832542"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5067788845"],"corresponding_institution_ids":["https://openalex.org/I120832542"],"apc_list":null,"apc_paid":null,"fwci":0.2651,"has_fulltext":false,"cited_by_count":4,"citation_normalized_percentile":{"value":0.64181093,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":94,"max":96},"biblio":{"volume":"26","issue":null,"first_page":"000179","last_page":"000184"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13062","display_name":"Cognitive Computing and Networks","score":0.9965999722480774,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/T13062","display_name":"Cognitive Computing and Networks","score":0.9965999722480774,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9876999855041504,"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/T10273","display_name":"IoT and Edge/Fog Computing","score":0.9868000149726868,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8270132541656494},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.8046824932098389},{"id":"https://openalex.org/keywords/data-stream-mining","display_name":"Data stream mining","score":0.6743232011795044},{"id":"https://openalex.org/keywords/data-transformation","display_name":"Data transformation","score":0.6258120536804199},{"id":"https://openalex.org/keywords/data-pre-processing","display_name":"Data pre-processing","score":0.558648943901062},{"id":"https://openalex.org/keywords/analytics","display_name":"Analytics","score":0.49602779746055603},{"id":"https://openalex.org/keywords/python","display_name":"Python (programming language)","score":0.47560223937034607},{"id":"https://openalex.org/keywords/data-modeling","display_name":"Data modeling","score":0.4742155075073242},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.44416800141334534},{"id":"https://openalex.org/keywords/heuristics","display_name":"Heuristics","score":0.4117233157157898},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.38887637853622437},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3539734482765198}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8270132541656494},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.8046824932098389},{"id":"https://openalex.org/C89198739","wikidata":"https://www.wikidata.org/wiki/Q3079880","display_name":"Data stream mining","level":2,"score":0.6743232011795044},{"id":"https://openalex.org/C150670458","wikidata":"https://www.wikidata.org/wiki/Q4272815","display_name":"Data transformation","level":3,"score":0.6258120536804199},{"id":"https://openalex.org/C10551718","wikidata":"https://www.wikidata.org/wiki/Q5227332","display_name":"Data pre-processing","level":2,"score":0.558648943901062},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.49602779746055603},{"id":"https://openalex.org/C519991488","wikidata":"https://www.wikidata.org/wiki/Q28865","display_name":"Python (programming language)","level":2,"score":0.47560223937034607},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.4742155075073242},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.44416800141334534},{"id":"https://openalex.org/C127705205","wikidata":"https://www.wikidata.org/wiki/Q5748245","display_name":"Heuristics","level":2,"score":0.4117233157157898},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.38887637853622437},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3539734482765198},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/coginfocom50765.2020.9237814","is_oa":false,"landing_page_url":"https://doi.org/10.1109/coginfocom50765.2020.9237814","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2020 11th IEEE International Conference on Cognitive Infocommunications (CogInfoCom)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/9","score":0.6499999761581421,"display_name":"Industry, innovation and infrastructure"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":24,"referenced_works":["https://openalex.org/W1505837402","https://openalex.org/W1544119352","https://openalex.org/W1971415293","https://openalex.org/W2040263621","https://openalex.org/W2080092502","https://openalex.org/W2087133653","https://openalex.org/W2105947650","https://openalex.org/W2119738171","https://openalex.org/W2126623642","https://openalex.org/W2185859000","https://openalex.org/W2538829354","https://openalex.org/W2542459869","https://openalex.org/W2543868530","https://openalex.org/W2568509762","https://openalex.org/W2569815136","https://openalex.org/W2785904638","https://openalex.org/W2786179895","https://openalex.org/W2787334911","https://openalex.org/W2888239145","https://openalex.org/W4245055577","https://openalex.org/W6630303302","https://openalex.org/W6660556005","https://openalex.org/W6686508619","https://openalex.org/W6729022921"],"related_works":["https://openalex.org/W2348093825","https://openalex.org/W2390710026","https://openalex.org/W2364425891","https://openalex.org/W2347601812","https://openalex.org/W3022239989","https://openalex.org/W3015205082","https://openalex.org/W1505247071","https://openalex.org/W2364409751","https://openalex.org/W4211040133","https://openalex.org/W2181836431"],"abstract_inverted_index":{"The":[0,115,245,258],"development":[1],"of":[2,13,24,54,63,67,68,79,89,119,130,143,157,165,222,248],"machine":[3],"learning":[4],"over":[5],"the":[6,10,64,83,87,103,128,140,155,186,197,200,249,271],"years":[7],"has":[8],"facilitated":[9],"joint":[11],"upsurge":[12],"complex":[14,183],"cognitive":[15,26,71],"infocommunication":[16,72],"systems.":[17,73],"Machine":[18,44],"Learning":[19,45],"methods":[20],"are":[21,82,97,151,252],"vital":[22],"elements":[23],"modern":[25],"infocommunications":[27],"systems":[28,60],"because":[29],"they":[30],"can":[31,192,241],"be":[32,108,135,194,242],"used":[33,177,207],"in":[34,230,254,262,270],"various":[35],"ways":[36],"such":[37],"as":[38,123],"behavior":[39],"modeling":[40],"or":[41,199,218],"sentiment":[42],"analysis.":[43],"algorithms":[46],"requires":[47],"a":[48,90,111,124,233,263],"reliable":[49,70],"infrastructure":[50,173],"and":[51,75,117,137,170,181,256],"vast":[52],"amount":[53],"data.":[55,132,144],"Therefore":[56],"building":[57,69],"data":[58,77,91,95,105,113,120,158,167,188,191,205,209,224,235,250,259,265,269],"warehouse":[59,168,266],"is":[61,176,238,260],"one":[62],"essential":[65],"steps":[66,85],"Finding":[74],"preprocessing":[76],"streams":[78,96],"different":[80],"origins":[81],"first":[84],"during":[86,127,154],"creation":[88],"warehouse.":[92],"Unfortunately,":[93],"online":[94],"most":[98],"often":[99,193],"formatted":[100],"uniquely.":[101],"Therefore,":[102,232],"obtained":[104],"sets":[106],"must":[107],"transformed":[109],"into":[110],"unified":[112],"model.":[114],"modelling":[116],"conversion":[118],"sources":[121,206,225,251],"serves":[122],"key":[125],"step":[126,237],"unification":[129],"heterogeneous":[131],"Storage":[133],"should":[134],"persistent,":[136],"optimized":[138],"for":[139,178,214],"analytical":[141],"processing":[142],"These":[145],"requirements":[146],"raise":[147],"technological":[148],"challenges":[149],"that":[150],"not":[152],"common":[153],"design":[156],"sources.":[159],"This":[160],"paper":[161],"gives":[162],"an":[163,172],"overview":[164],"current":[166],"technologies":[169],"suggests":[171],"implementation.":[174],"Hive":[175,264],"accessing,":[179],"modifying,":[180],"running":[182],"analytics":[184],"on":[185],"stored":[187],"sets.":[189],"Economical":[190],"unique":[195,208],"to":[196],"product,":[198],"industry":[201],"it":[202],"covers.":[203],"Different":[204],"formats":[210],"which":[211,240,267],"were":[212],"tailored":[213],"their":[215,228],"application":[216],"area":[217],"needs.":[219],"Moreover,":[220],"some":[221],"these":[223],"may":[226],"change":[227],"format":[229],"time.":[231],"flexible":[234],"transformation":[236],"required":[239],"configured":[243],"easily.":[244],"ETL":[246],"processes":[247],"implemented":[253],"Python,":[255],"Hive.":[257],"loaded":[261],"stores":[268],"distributed":[272],"Hadoop":[273],"File":[274],"System.":[275]},"counts_by_year":[{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}