Towards a general theory of action and time
Artificial Intelligence
The TSQL2 Temporal Query Language
The TSQL2 Temporal Query Language
A foundation for capturing and querying complex multidimensional data
Information Systems - Data warehousing
Fundamentals of Data Warehouses
Fundamentals of Data Warehouses
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
Capturing Delays and Valid Times in Data Warehouses—Towards Timely Consistent Analyses
Journal of Intelligent Information Systems - Special issue on data warehousing and knowledge discovery
Maintaining Temporal Views over Non-Temporal Information Sources for Data Warehousing
EDBT '98 Proceedings of the 6th International Conference on Extending Database Technology: Advances in Database Technology
A Temporal Model and Query Language for ER Databases
Proceedings of the Sixth International Conference on Data Engineering
VLDB '00 Proceedings of the 26th International Conference on Very Large Data Bases
The COMET Metamodel for Temporal Data Warehouses
CAiSE '02 Proceedings of the 14th International Conference on Advanced Information Systems Engineering
Maintaining Data Cubes under Dimension Updates
ICDE '99 Proceedings of the 15th International Conference on Data Engineering
Time in multidimensional databases
Multidimensional databases
Fundamentals of Database Systems, Fourth Edition
Fundamentals of Database Systems, Fourth Edition
Building the Data Warehouse
Hierarchies in a multidimensional model: from conceptual modeling to logical representation
Data & Knowledge Engineering - Special issue: WIDM 2004
Data & Knowledge Engineering
Modeling Transformations between Versions of a Temporal Data Warehouse
ER '08 Proceedings of the ER 2008 Workshops (CMLSA, ECDM, FP-UML, M2AS, RIGiM, SeCoGIS, WISM) on Advances in Conceptual Modeling: Challenges and Opportunities
Queries on dates: fast yet not blind
Proceedings of the 14th International Conference on Extending Database Technology
Object-relational representation of a conceptual model for temporal data warehouses
CAiSE'06 Proceedings of the 18th international conference on Advanced Information Systems Engineering
Hi-index | 0.00 |
Data Warehouses (DWs) use an omnipresent time dimension for keeping track of changes in measure values. However, this dimension cannot be used to model changes in other dimensions. On the other hand, Temporal Databases (TDBs) have been successfully used for modelling time-varying information. Bringing together these two research areas, leading to Temporal Data Warehouses (TDWs), provides the necessary solutions for managing time-varying data in dimensions. In this paper, we introduce temporal extensions for the MultiDimER model, a conceptual multidimensional model. In our model we allow the inclusion of valid and transaction time, which are obtained from source systems, in addition to the data warehouse loading time. Our model allows a conceptual representation of time-varying levels, attributes, and hierarchies. For the latter, we discuss different cases depending on whether the changes in levels affect the relationships between them.