<div class="csl-bib-body">
<div class="csl-entry">Nguyen, M. T., Tjoa, A. M., Nemec, J., & Windisch, M. (2007). An approach towards an event-fed solution for slowly changing dimensions in data warehouses with a detailed case study. <i>Data and Knowledge Engineering</i>, <i>63</i>(1), 26–43. https://doi.org/10.1016/j.datak.2006.10.004</div>
</div>
-
dc.identifier.issn
0169-023X
-
dc.identifier.uri
http://hdl.handle.net/20.500.12708/169705
-
dc.description.abstract
From the point of view of a data warehouse system, collecting and receiving information from source system is crucial for all subsequent business intelligence applications. Incoming information can generally be classified into two types (1) the state-oriented data and (2) event-oriented data or transactional data, which contains information about the change performed by processes on the instances of information objects. On the way towards achieving the goal of a full-fledged active data warehouse it becomes more and more important to proviede data with minimal latency. In this paper we focus messages containing the change of information on the dimension instances. The proposed approach is able to validate the even-manages, reconstruct the complete history of the dimension and proviede a well applicalbe "comprehensive slowly changing dimension" (cSCD) interface for queries on the historical and current state of the dimension. A description of the prototype implementation for this kind of an "active integration" in a data warehouse and a case study at T-Mobile conclude the paper.
en
dc.language.iso
en
-
dc.publisher
ELSEVIER
-
dc.relation.ispartof
Data and Knowledge Engineering
-
dc.subject
Information Systems and Management
-
dc.subject
Active Data Warehousing
-
dc.subject
Slowly Changing Dimension
-
dc.subject
Event-based data integration
-
dc.subject
Data refesh
-
dc.title
An approach towards an event-fed solution for slowly changing dimensions in data warehouses with a detailed case study
en
dc.type
Artikel
de
dc.type
Article
en
dc.description.startpage
26
-
dc.description.endpage
43
-
dc.type.category
Original Research Article
-
tuw.container.volume
63
-
tuw.container.issue
1
-
tuw.journal.peerreviewed
true
-
tuw.peerreviewed
true
-
tuw.researchTopic.id
I6
-
tuw.researchTopic.name
Business Informatics
-
tuw.researchTopic.value
100
-
dcterms.isPartOf.title
Data and Knowledge Engineering
-
tuw.publication.orgunit
E194-01 - Forschungsbereich Software Engineering
-
tuw.publisher.doi
10.1016/j.datak.2006.10.004
-
dc.identifier.eissn
1872-6933
-
dc.description.numberOfPages
18
-
tuw.author.orcid
0000-0002-8295-9252
-
wb.sci
true
-
wb.sciencebranch
Mathematik, Informatik
-
wb.sciencebranch.oefos
11
-
item.languageiso639-1
en
-
item.openairecristype
http://purl.org/coar/resource_type/c_2df8fbb1
-
item.fulltext
no Fulltext
-
item.openairetype
research article
-
item.grantfulltext
restricted
-
item.cerifentitytype
Publications
-
crisitem.author.dept
E188 - Institut für Softwaretechnik und Interaktive Systeme
-
crisitem.author.dept
E194-04 - Forschungsbereich E-Commerce
-
crisitem.author.orcid
0000-0002-8295-9252
-
crisitem.author.parentorg
E180 - Fakultät für Informatik
-
crisitem.author.parentorg
E194 - Institut für Information Systems Engineering