Reference Hub

This research has been cited in:

Chapter
The Use of a Cloud Computing and the CUDA Architecture in Zero-Latency Data WarehousesComputer Networks10.1007/978-3-642-38865-1_32
Article
DOD-ETL: distributed on-demand ETL for near real-time business intelligenceJournal of Internet Services and Applications10.1186/s13174-019-0121-z
Article
The Enhancing Quality of Prescribing Practices for Older Veterans Discharged From the Emergency Department (EQUIPPED) Potentially Inappropriate Medication Dashboard: A Suitable Alternative to the In-person Academic Detailing and Standardized Feedback Reports of Traditional EQUIPPED?Clinical Therapeutics10.1016/j.clinthera.2020.02.013
Article
SMART: a service-oriented architecture for monitoring and assessing Brazil’s Telehealth outcomesResearch on Biomedical Engineering10.1590/2446-4740.18004
Article
Development of a specialty medication clinical dashboard to improve tumor necrosis factor-α inhibitor safety and adherence monitoringAmerican Journal of Health-System Pharmacy10.1093/ajhp/zxab454
Chapter
Scalability and Realtime on Big Data, MapReduce, NoSQL and SparkBusiness Intelligence10.1007/978-3-319-61164-8_4
Conference
Query Processing for Heterogeneous Data Sources in SQL Generator2020 International Multi-Conference on Industrial Engineering and Modern Technologies (FarEastCon)10.1109/FarEastCon50210.2020.9271101
Article
A Model for Enhancing Unstructured Big Data Warehouse Execution TimeBig Data and Cognitive Computing10.3390/bdcc8020017
Chapter
New Approaches in Supporting to SMEs CompetitivenessBenchmarking Collaborative Networks10.1007/978-3-319-16736-7_2
Conference
A Comparative Review of Data Warehousing ETL Tools with New Trends and Industry Insight2017 IEEE 7th International Advance Computing Conference (IACC)10.1109/IACC.2017.0192
Chapter
An Approachable Analytical Study on Big Educational Data MiningComputational Science and Its Applications – ICCSA 201410.1007/978-3-319-09156-3_50
Chapter
Evaluation and Development Perspectives of Stream Data Processing SystemsComputer Networks10.1007/978-3-642-38865-1_31
Conference
Online and Offline Analysis of Streaming Data2018 IEEE International Conference on Software Architecture Companion (ICSA-C)10.1109/ICSA-C.2018.00026
Article
ELTA: New Approach in Designing Business Intelligence Solutions in Era of Big DataProcedia Technology10.1016/j.protcy.2014.10.015
Chapter
Research on the Stream ETL ProcessBeyond Databases, Architectures, and Structures10.1007/978-3-319-06932-6_7
Conference
Heterogeneous Data Integration with ELT and Analytical MPP Database for Data Analysis Application2021 Innovations in Power and Advanced Computing Technologies (i-PACT)10.1109/i-PACT52855.2021.9696841
Chapter
Challenges and Solutions of Real-Time Data Integration Techniques by ETL ApplicationBig Data Analytics Techniques for Market Intelligence10.4018/979-8-3693-0413-6.ch014

On-Demand ELT Architecture for Right-Time BI: Extending the Vision

Florian Waas, Robert Wrembel, Tobias Freudenreich, Maik Thiele, Christian Koncilia, Pedro Furtado

Source Title: International Journal of Data Warehousing and Mining (IJDWM)9(2)

ISSN: 1548-3924|EISSN: 1548-3932|EISBN13: 9781466633087|DOI: 10.4018/jdwm.2013040102

Cite Article Cite Article

MLA

Waas, Florian, et al. "On-Demand ELT Architecture for Right-Time BI: Extending the Vision." IJDWM vol.9, no.2 2013: pp.21-38. http://doi.org/10.4018/jdwm.2013040102

APA

Waas, F., Wrembel, R., Freudenreich, T., Thiele, M., Koncilia, C., & Furtado, P. (2013). On-Demand ELT Architecture for Right-Time BI: Extending the Vision. International Journal of Data Warehousing and Mining (IJDWM), 9(2), 21-38. http://doi.org/10.4018/jdwm.2013040102

Chicago

Waas, Florian, et al. "On-Demand ELT Architecture for Right-Time BI: Extending the Vision," International Journal of Data Warehousing and Mining (IJDWM) 9, no.2: 21-38. http://doi.org/10.4018/jdwm.2013040102

Export Reference

Favorite Full-Issue Download

View Full Text HTML

View Full Text PDF

Abstract

In a typical BI infrastructure, data, extracted from operational data sources, is transformed, cleansed, and loaded into a data warehouse by a periodic ETL process, typically executed on a nightly basis, i.e., a full day’s worth of data is processed and loaded during off-hours. However, it is desirable to have fresher data for business insights at near real-time. To this end, the authors propose to leverage a data warehouse’s capability to directly import raw, unprocessed records and defer the transformation and data cleaning until needed by pending reports. At that time, the database’s own processing mechanisms can be deployed to process the data on-demand. Event-processing capabilities are seamlessly woven into our proposed architecture. Besides outlining an overall architecture, the authors also developed a roadmap for implementing a complete prototype using conventional database technology in the form of hierarchical materialized views.

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.

Username or email: *

Password: *

Forgot individual login password?

Create individual account

On-Demand ELT Architecture for Right-Time BI: Extending the Vision

MLA

APA

Chicago

Export Reference

Abstract

Request Access