Evaluation of load scheduling strategies for real-time data warehouse environments
Publikation: Beitrag in Buch/Konferenzbericht/Sammelband/Gutachten › Beitrag in Konferenzband › Beigetragen › Begutachtung
Beitragende
Abstract
The demand for so-called living or real-time data warehouses is increasing in many application areas, including manufacturing, event monitoring and telecommunications. In fields like these, users normally expect short response times for their queries and high freshness for the requested data. However, it is truly challenging to meet both requirements at the same time because of the continuous flow of write-only updates and read-only queries as well as the latency caused by arbitrarily complex ETL processes. To optimize the update flow in terms of data freshness maximization and load minimization, we propose two algorithms - local and global scheduling - that operate on the basis of different system information. We want to discuss the benefits and drawbacks of both approaches in detail and derive recommendations regarding the optimal scheduling strategy for any given system setup and workload.
Details
| Originalsprache | Englisch |
|---|---|
| Titel | Enabling Real-Time Business Intelligence - Third International Workshop, BIRTE 2009, Held at the 35th International Conference on Very Large Databases, VLDB 2009, Revised Selected Papers |
| Herausgeber (Verlag) | Springer-Verlag |
| Seiten | 84-99 |
| Seitenumfang | 16 |
| ISBN (Print) | 3642145582, 9783642145582 |
| Publikationsstatus | Veröffentlicht - 2010 |
| Peer-Review-Status | Ja |
Publikationsreihe
| Reihe | Lecture Notes in Business Information Processing |
|---|---|
| Band | 41 LNBI |
| ISSN | 1865-1348 |
Konferenz
| Titel | 3rd International Workshop Enabling Real-Time Business Intelligence, BIRTE 2009, Held at the 35th International Conference on Very Large Databases, VLDB 2009 |
|---|---|
| Dauer | 24 August 2009 |
| Stadt | Lyon |
| Land | Frankreich |
Externe IDs
| ORCID | /0000-0001-8107-2775/work/200630394 |
|---|
Schlagworte
Forschungsprofillinien der TU Dresden
DFG-Fachsystematik nach Fachkollegium
Fächergruppen, Lehr- und Forschungsbereiche, Fachgebiete nach Destatis
ASJC Scopus Sachgebiete
Schlagwörter
- ETL, Real-Time Data Warehouse, Scheduling