{"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":{"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":null,"is_accepted":false,"is_published":false},"type":"article","type_crossref":"proceedings-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":false,"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"]}]}],"institution_assertions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.152,"has_fulltext":false,"cited_by_count":4,"citation_normalized_percentile":{"value":0.370512,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":76,"max":79},"biblio":{"volume":null,"issue":null,"first_page":"000179","last_page":"000184"},"is_retracted":false,"is_paratext":false,"primary_topic":{"id":"https://openalex.org/T13062","display_name":"Cognitive Computing and Networks","score":0.9966,"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.9966,"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.9877,"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.9868,"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/data-transformation","display_name":"Data transformation","score":0.62581205},{"id":"https://openalex.org/keywords/data-pre-processing","display_name":"Data pre-processing","score":0.55864894},{"id":"https://openalex.org/keywords/python","display_name":"Python","score":0.47560224},{"id":"https://openalex.org/keywords/heuristics","display_name":"Heuristics","score":0.41172332}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.82701325},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.8046825},{"id":"https://openalex.org/C89198739","wikidata":"https://www.wikidata.org/wiki/Q3079880","display_name":"Data stream mining","level":2,"score":0.6743232},{"id":"https://openalex.org/C150670458","wikidata":"https://www.wikidata.org/wiki/Q4272815","display_name":"Data transformation","level":3,"score":0.62581205},{"id":"https://openalex.org/C10551718","wikidata":"https://www.wikidata.org/wiki/Q5227332","display_name":"Data pre-processing","level":2,"score":0.55864894},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.4960278},{"id":"https://openalex.org/C519991488","wikidata":"https://www.wikidata.org/wiki/Q28865","display_name":"Python (programming language)","level":2,"score":0.47560224},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.4742155},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.444168},{"id":"https://openalex.org/C127705205","wikidata":"https://www.wikidata.org/wiki/Q5748245","display_name":"Heuristics","level":2,"score":0.41172332},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.38887638},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.35397345},{"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":[{"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":null,"is_accepted":false,"is_published":false}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/9","score":0.65,"display_name":"Industry, innovation and infrastructure"}],"grants":[],"datasets":[],"versions":[],"referenced_works_count":20,"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"],"related_works":["https://openalex.org/W4211040133","https://openalex.org/W3022239989","https://openalex.org/W3015205082","https://openalex.org/W2390710026","https://openalex.org/W2364425891","https://openalex.org/W2364409751","https://openalex.org/W2348093825","https://openalex.org/W2347601812","https://openalex.org/W2181836431","https://openalex.org/W1505247071"],"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]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W3097876809","counts_by_year":[{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":2}],"updated_date":"2025-01-18T10:22:03.049983","created_date":"2020-11-09"}