{"id":"https://openalex.org/W2000876233","doi":"https://doi.org/10.4018/jdwm.2013040102","title":"On-Demand ELT Architecture for Right-Time BI","display_name":"On-Demand ELT Architecture for Right-Time BI","publication_year":2013,"publication_date":"2013-04-01","ids":{"openalex":"https://openalex.org/W2000876233","doi":"https://doi.org/10.4018/jdwm.2013040102","mag":"2000876233"},"language":"en","primary_location":{"id":"doi:10.4018/jdwm.2013040102","is_oa":false,"landing_page_url":"https://doi.org/10.4018/jdwm.2013040102","pdf_url":null,"source":{"id":"https://openalex.org/S53932126","display_name":"International Journal of Data Warehousing and Mining","issn_l":"1548-3924","issn":["1548-3924","1548-3932"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Data Warehousing and Mining","raw_type":"journal-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/A5072322247","display_name":"Florian Waas","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Florian Waas","raw_affiliation_strings":["EMC Corporation, Hopkinton, MA, USA","EMC Corporation, Hopkinton, MA, USA#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"EMC Corporation, Hopkinton, MA, USA","institution_ids":[]},{"raw_affiliation_string":"EMC Corporation, Hopkinton, MA, USA#TAB#","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5054888563","display_name":"Robert Wrembel","orcid":"https://orcid.org/0000-0001-6037-5718"},"institutions":[{"id":"https://openalex.org/I46597724","display_name":"Pozna\u0144 University of Technology","ror":"https://ror.org/00p7p3302","country_code":"PL","type":"education","lineage":["https://openalex.org/I46597724"]}],"countries":["PL"],"is_corresponding":false,"raw_author_name":"Robert Wrembel","raw_affiliation_strings":["Faculty of Computing, Poznan University of Technology, Poznan, Poland"],"raw_orcid":"https://orcid.org/0000-0001-6037-5718","affiliations":[{"raw_affiliation_string":"Faculty of Computing, Poznan University of Technology, Poznan, Poland","institution_ids":["https://openalex.org/I46597724"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5066707947","display_name":"Tobias Freudenreich","orcid":null},"institutions":[{"id":"https://openalex.org/I31512782","display_name":"Technische Universit\u00e4t Darmstadt","ror":"https://ror.org/05n911h24","country_code":"DE","type":"education","lineage":["https://openalex.org/I31512782"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Tobias Freudenreich","raw_affiliation_strings":["Department of Computer Science, Technische Universit\u00e4t Darmstadt, Darmstadt, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Science, Technische Universit\u00e4t Darmstadt, Darmstadt, Germany","institution_ids":["https://openalex.org/I31512782"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5000229374","display_name":"Maik Thiele","orcid":"https://orcid.org/0000-0002-1665-977X"},"institutions":[{"id":"https://openalex.org/I78650965","display_name":"Technische Universit\u00e4t Dresden","ror":"https://ror.org/042aqky30","country_code":"DE","type":"education","lineage":["https://openalex.org/I78650965"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Maik Thiele","raw_affiliation_strings":["Database Technology Group, Technische Universit\u00e4t Dresden, Dresden, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Database Technology Group, Technische Universit\u00e4t Dresden, Dresden, Germany","institution_ids":["https://openalex.org/I78650965"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5032563284","display_name":"Christian Koncilia","orcid":null},"institutions":[{"id":"https://openalex.org/I134023368","display_name":"Institute for Interdisciplinary Studies of Austrian Universities","ror":"https://ror.org/001zf8v27","country_code":"AT","type":"education","lineage":["https://openalex.org/I134023368","https://openalex.org/I4210166741"]},{"id":"https://openalex.org/I4210166741","display_name":"University of Klagenfurt","ror":"https://ror.org/05q9m0937","country_code":"AT","type":"education","lineage":["https://openalex.org/I4210166741"]}],"countries":["AT"],"is_corresponding":false,"raw_author_name":"Christian Koncilia","raw_affiliation_strings":["Institute for Information-Systems, University of Klagenfurt, Klagenfurt, Austria","Institute for Information-Systems, University of Klagenfurt, Klagenfurt, Austria#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Institute for Information-Systems, University of Klagenfurt, Klagenfurt, Austria","institution_ids":["https://openalex.org/I4210166741"]},{"raw_affiliation_string":"Institute for Information-Systems, University of Klagenfurt, Klagenfurt, Austria#TAB#","institution_ids":["https://openalex.org/I134023368"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5049382757","display_name":"Pedro Furtado","orcid":"https://orcid.org/0000-0001-6054-637X"},"institutions":[{"id":"https://openalex.org/I76903346","display_name":"University of Coimbra","ror":"https://ror.org/04z8k9a98","country_code":"PT","type":"education","lineage":["https://openalex.org/I76903346"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Pedro Furtado","raw_affiliation_strings":["Department of Informatics Engineering, University of Coimbra, Coimbra, Portugal"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Informatics Engineering, University of Coimbra, Coimbra, Portugal","institution_ids":["https://openalex.org/I76903346"]}]}],"institutions":[],"countries_distinct_count":4,"institutions_distinct_count":6,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":4.9045,"has_fulltext":false,"cited_by_count":34,"citation_normalized_percentile":{"value":0.95330792,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":98},"biblio":{"volume":"9","issue":"2","first_page":"21","last_page":"38"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9998000264167786,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9998000264167786,"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.9968000054359436,"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"}},{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.9968000054359436,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"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/computer-science","display_name":"Computer science","score":0.8443557024002075},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.8000518679618835},{"id":"https://openalex.org/keywords/leverage","display_name":"Leverage (statistics)","score":0.7735180258750916},{"id":"https://openalex.org/keywords/architecture","display_name":"Architecture","score":0.7185918688774109},{"id":"https://openalex.org/keywords/raw-data","display_name":"Raw data","score":0.7109196186065674},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5991952419281006},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.5009033679962158},{"id":"https://openalex.org/keywords/data-transformation","display_name":"Data transformation","score":0.42878901958465576},{"id":"https://openalex.org/keywords/data-architecture","display_name":"Data architecture","score":0.4173579812049866},{"id":"https://openalex.org/keywords/software-architecture","display_name":"Software architecture","score":0.19970625638961792},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.1912539005279541},{"id":"https://openalex.org/keywords/reference-architecture","display_name":"Reference architecture","score":0.19077450037002563},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.1459289789199829},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.07544049620628357}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8443557024002075},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.8000518679618835},{"id":"https://openalex.org/C153083717","wikidata":"https://www.wikidata.org/wiki/Q6535263","display_name":"Leverage (statistics)","level":2,"score":0.7735180258750916},{"id":"https://openalex.org/C123657996","wikidata":"https://www.wikidata.org/wiki/Q12271","display_name":"Architecture","level":2,"score":0.7185918688774109},{"id":"https://openalex.org/C132964779","wikidata":"https://www.wikidata.org/wiki/Q2110223","display_name":"Raw data","level":2,"score":0.7109196186065674},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5991952419281006},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.5009033679962158},{"id":"https://openalex.org/C150670458","wikidata":"https://www.wikidata.org/wiki/Q4272815","display_name":"Data transformation","level":3,"score":0.42878901958465576},{"id":"https://openalex.org/C94070970","wikidata":"https://www.wikidata.org/wiki/Q638422","display_name":"Data architecture","level":5,"score":0.4173579812049866},{"id":"https://openalex.org/C35869016","wikidata":"https://www.wikidata.org/wiki/Q846636","display_name":"Software architecture","level":3,"score":0.19970625638961792},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.1912539005279541},{"id":"https://openalex.org/C55356503","wikidata":"https://www.wikidata.org/wiki/Q2136675","display_name":"Reference architecture","level":4,"score":0.19077450037002563},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.1459289789199829},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.07544049620628357},{"id":"https://openalex.org/C142362112","wikidata":"https://www.wikidata.org/wiki/Q735","display_name":"Art","level":0,"score":0.0},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"id":"https://openalex.org/C153349607","wikidata":"https://www.wikidata.org/wiki/Q36649","display_name":"Visual arts","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.4018/jdwm.2013040102","is_oa":false,"landing_page_url":"https://doi.org/10.4018/jdwm.2013040102","pdf_url":null,"source":{"id":"https://openalex.org/S53932126","display_name":"International Journal of Data Warehousing and Mining","issn_l":"1548-3924","issn":["1548-3924","1548-3932"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Data Warehousing and Mining","raw_type":"journal-article"},{"id":"pmh:oai:RePEc:igg:jdwm00:v:9:y:2013:i:2:p:21-38","is_oa":false,"landing_page_url":"https://services.igi-global.com/resolvedoi/resolve.aspx?doi=10.4018/jdwm.2013040102","pdf_url":null,"source":{"id":"https://openalex.org/S4306401271","display_name":"RePEc: Research Papers in Economics","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I77793887","host_organization_name":"Federal Reserve Bank of St. Louis","host_organization_lineage":["https://openalex.org/I77793887"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.6700000166893005,"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":84,"referenced_works":["https://openalex.org/W1893018","https://openalex.org/W38346608","https://openalex.org/W41964281","https://openalex.org/W49241659","https://openalex.org/W56443290","https://openalex.org/W57116089","https://openalex.org/W61430147","https://openalex.org/W155672256","https://openalex.org/W187887682","https://openalex.org/W197630086","https://openalex.org/W1525425482","https://openalex.org/W1533623471","https://openalex.org/W1537042408","https://openalex.org/W1546663134","https://openalex.org/W1562880585","https://openalex.org/W1575577693","https://openalex.org/W1600616065","https://openalex.org/W1747648942","https://openalex.org/W1771677498","https://openalex.org/W1956112101","https://openalex.org/W1963512005","https://openalex.org/W1976597724","https://openalex.org/W1986795233","https://openalex.org/W1995032158","https://openalex.org/W2000709835","https://openalex.org/W2001474264","https://openalex.org/W2003584736","https://openalex.org/W2006761638","https://openalex.org/W2010031570","https://openalex.org/W2016349588","https://openalex.org/W2017152042","https://openalex.org/W2020829916","https://openalex.org/W2030011908","https://openalex.org/W2053508739","https://openalex.org/W2059603704","https://openalex.org/W2062735494","https://openalex.org/W2070277413","https://openalex.org/W2071916645","https://openalex.org/W2072271542","https://openalex.org/W2073824505","https://openalex.org/W2075451706","https://openalex.org/W2096347930","https://openalex.org/W2097163489","https://openalex.org/W2101942871","https://openalex.org/W2103106131","https://openalex.org/W2107760270","https://openalex.org/W2107928811","https://openalex.org/W2108111045","https://openalex.org/W2110557355","https://openalex.org/W2114712170","https://openalex.org/W2115514503","https://openalex.org/W2118260817","https://openalex.org/W2118336583","https://openalex.org/W2118385974","https://openalex.org/W2120052337","https://openalex.org/W2124033772","https://openalex.org/W2126086366","https://openalex.org/W2126321570","https://openalex.org/W2126666814","https://openalex.org/W2129917572","https://openalex.org/W2134791164","https://openalex.org/W2139276812","https://openalex.org/W2143180374","https://openalex.org/W2149877754","https://openalex.org/W2152389926","https://openalex.org/W2164086463","https://openalex.org/W2166604013","https://openalex.org/W2167234995","https://openalex.org/W2199389590","https://openalex.org/W2252148092","https://openalex.org/W2291557532","https://openalex.org/W2403551065","https://openalex.org/W2631772412","https://openalex.org/W3000682779","https://openalex.org/W3015061971","https://openalex.org/W3150093670","https://openalex.org/W4248563344","https://openalex.org/W4253847348","https://openalex.org/W4254357460","https://openalex.org/W4285719527","https://openalex.org/W4296313435","https://openalex.org/W6606469976","https://openalex.org/W6677702014","https://openalex.org/W6682181530"],"related_works":["https://openalex.org/W2348093825","https://openalex.org/W2390710026","https://openalex.org/W2364425891","https://openalex.org/W2347601812","https://openalex.org/W3015205082","https://openalex.org/W3022239989","https://openalex.org/W1505247071","https://openalex.org/W2364409751","https://openalex.org/W4211040133","https://openalex.org/W2033464728"],"abstract_inverted_index":{"In":[0],"a":[1,17,21,28,32,66,122,126],"typical":[2],"BI":[3],"infrastructure,":[4],"data,":[5],"extracted":[6],"from":[7],"operational":[8],"data":[9,18,37,51,67,81,102],"sources,":[10],"is":[11,38,46],"transformed,":[12],"cleansed,":[13],"and":[14,40,76,80],"loaded":[15,41],"into":[16,109],"warehouse":[19],"by":[20,85],"periodic":[22],"ETL":[23],"process,":[24],"typically":[25],"executed":[26],"on":[27],"nightly":[29],"basis,":[30],"i.e.,":[31],"full":[33],"day\u2019s":[34],"worth":[35],"of":[36,136],"processed":[39],"during":[42],"off-hours.":[43],"However,":[44],"it":[45],"desirable":[47],"to":[48,64,70,99],"have":[49],"fresher":[50],"for":[52,124],"business":[53],"insights":[54],"at":[55],"near":[56],"real-time.":[57],"To":[58],"this":[59],"end,":[60],"the":[61,78,91,101,118,134],"authors":[62,119],"propose":[63],"leverage":[65],"warehouse\u2019s":[68],"capability":[69],"directly":[71],"import":[72],"raw,":[73],"unprocessed":[74],"records":[75],"defer":[77],"transformation":[79],"cleaning":[82],"until":[83],"needed":[84],"pending":[86],"reports.":[87],"At":[88],"that":[89],"time,":[90],"database\u2019s":[92],"own":[93],"processing":[94],"mechanisms":[95],"can":[96],"be":[97],"deployed":[98],"process":[100],"on-demand.":[103],"Event-processing":[104],"capabilities":[105],"are":[106],"seamlessly":[107],"woven":[108],"our":[110],"proposed":[111],"architecture.":[112],"Besides":[113],"outlining":[114],"an":[115],"overall":[116],"architecture,":[117],"also":[120],"developed":[121],"roadmap":[123],"implementing":[125],"complete":[127],"prototype":[128],"using":[129],"conventional":[130],"database":[131],"technology":[132],"in":[133],"form":[135],"hierarchical":[137],"materialized":[138],"views.":[139]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":4},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":4},{"year":2020,"cited_by_count":3},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":4},{"year":2017,"cited_by_count":3},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":4},{"year":2014,"cited_by_count":4},{"year":2013,"cited_by_count":4}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}