{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,6,10]],"date-time":"2026-06-10T14:59:50Z","timestamp":1781103590260,"version":"3.54.1"},"reference-count":0,"publisher":"IGI Global Scientific Publishing","issue":"4","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2020,10,1]]},"abstract":"<p>Usually, data in data warehouses (DWs) are stored using the notion of the multidimensional (MD) model. Often, DWs change in content and structure due to several reasons, like, for instance, changes in a business scenario or technology. For accurate decision-making, a DW model must allow storing and analyzing time-varying data. This paper addresses the problem of keeping track of the history of the data in a DW. For this, first, a formalization of the traditional MD model is proposed and then extended as a generalized temporal MD model. The model comes equipped with a collection of typical online analytical processing (OLAP) operations with temporal semantics, which is formalized for the four classic operations, namely roll-up, dice, project, and drill-across. Finally, the mapping from the generalized temporal model into a relational schema is presented together with an implementation of the temporal OLAP operations in standard SQL.<\/p>","DOI":"10.4018\/ijdwm.2020100107","type":"journal-article","created":{"date-parts":[[2020,10,23]],"date-time":"2020-10-23T10:39:31Z","timestamp":1603449571000},"page":"112-143","source":"Crossref","is-referenced-by-count":4,"title":["A Temporal Multidimensional Model and OLAP Operators"],"prefix":"10.4018","volume":"16","author":[{"given":"Waqas","family":"Ahmed","sequence":"first","affiliation":[{"name":"CODE WIT, Universit\u00e9 Libre de Bruxelles, Belgium"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-1843-5099","authenticated-orcid":true,"given":"Esteban","family":"Zim\u00e1nyi","sequence":"additional","affiliation":[{"name":"CODE WIT, Universit\u00e9 Libre de Bruxelles, Brussels, Belgium"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-3945-4187","authenticated-orcid":true,"given":"Alejandro Ariel","family":"Vaisman","sequence":"additional","affiliation":[{"name":"Department of Information Engineering, Instituto Tecnol\u00f3gico de Buenos Aires, Argentina"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0001-6037-5718","authenticated-orcid":true,"given":"Robert","family":"Wrembel","sequence":"additional","affiliation":[{"name":"Faculty of Computing and Telecommunications, Poznan University of Technology, Poznan, Poland"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"2432","container-title":["International Journal of Data Warehousing and Mining"],"original-title":[],"language":"ng","link":[{"URL":"https:\/\/www.igi-global.com\/viewtitle.aspx?TitleId=265260","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,5,6]],"date-time":"2022-05-06T19:47:15Z","timestamp":1651866435000},"score":1,"resource":{"primary":{"URL":"https:\/\/services.igi-global.com\/resolvedoi\/resolve.aspx?doi=10.4018\/IJDWM.2020100107"}},"subtitle":[""],"short-title":[],"issued":{"date-parts":[[2020,10,1]]},"references-count":0,"journal-issue":{"issue":"4","published-print":{"date-parts":[[2020,10]]}},"URL":"https:\/\/doi.org\/10.4018\/ijdwm.2020100107","relation":{},"ISSN":["1548-3924","1548-3932"],"issn-type":[{"value":"1548-3924","type":"print"},{"value":"1548-3932","type":"electronic"}],"subject":[],"published":{"date-parts":[[2020,10,1]]}}}