Show simple item record

dc.contributor.authorMahlknecht G
dc.contributor.authorDignös A
dc.contributor.authorKozmina N
dc.date.accessioned2019-05-24T07:25:16Z
dc.date.available2019-05-24T07:25:16Z
dc.date.issued2019
dc.identifier.issn1641-876X
dc.identifier.urihttp://dx.doi.org/10.2478/amcs-2019-0003
dc.identifier.urihttps://www.amcs.uz.zgora.pl/?action=paper&paper=1473
dc.identifier.urihttp://hdl.handle.net/10863/9834
dc.description.abstractIn this paper, we study different ways of representing and querying fact data that is time-stamped with a time period in a data warehouse. The main focus is on how to represent the time periods that are associated with the facts in order to support convenient and efficient aggregations over time. We propose three distinct logical models that represent time periods, respectively, as sets of all time points in a period (instant model), as pairs of start and end time points of a period (period model), and as atomic units that are explicitly stored in a new period dimension (period*model). The period dimension is enriched with information about the days of each period, thereby combining the two former models. We use four different classes of aggregation queries to analyze query formulation, query execution, and query performance over the three models. An extensive empirical evaluation on synthetic and real-world datasets and the analysis of the query execution plans reveals that the period model is the best choice in terms of runtime and space for all four query classes.en_US
dc.description.sponsorshipunibz OA funden_US
dc.languageEnglish
dc.language.isoenen_US
dc.relation
dc.rights
dc.titleModeling and Querying Facts with Period Timestamps in Data Warehousesen_US
dc.typeArticleen_US
dc.date.updated2019-05-24T03:00:14Z
dc.language.isiEN-GB
dc.journal.titleInternational Journal of Applied Mathematics and Computer Science
dc.description.fulltextopenen_US


Files in this item

Thumbnail

This item appears in the following Collection(s)

Show simple item record