On completeness of historical relational query languages
ACM Transactions on Database Systems (TODS)
Valid-time indeterminacy
Logical design for temporal databases with multiple granularities
ACM Transactions on Database Systems (TODS)
Temporal FDs on complex objects
ACM Transactions on Database Systems (TODS)
Developing time-oriented database applications in SQL
Developing time-oriented database applications in SQL
Maintaining knowledge about temporal intervals
Communications of the ACM
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
Time Granularities in Databases, Data Mining and Temporal Reasoning
Time Granularities in Databases, Data Mining and Temporal Reasoning
A multidimensional and multiversion structure for OLAP applications
Proceedings of the 5th ACM international workshop on Data Warehousing and OLAP
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
Aggregates in the Temporal Query Language TQuel
IEEE Transactions on Knowledge and Data Engineering
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
Operations and the Properties on Non-First-Normal-Form Relational Databases
VLDB '83 Proceedings of the 9th International Conference on Very Large Data Bases
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
Summarizability in OLAP and Statistical Data Bases
SSDBM '97 Proceedings of the Ninth International Conference on Scientific and Statistical Database Management
Design of Temporal Relational Databases Based on Dynamic and Temporal Functional Dependencies
Proceedings of the International Workshop on Temporal Databases: Recent Advances in Temporal Databases
CASE Tool Support for Temporal Database Design
ER '01 Proceedings of the 20th International Conference on Conceptual Modeling: Conceptual Modeling
Efficient Algorithms for Large-Scale Temporal Aggregation
IEEE Transactions on Knowledge and Data Engineering
Advanced SQL 1999: Understanding Object-Relational, and Other Advanced Features
Advanced SQL 1999: Understanding Object-Relational, and Other Advanced Features
Time in multidimensional databases
Multidimensional databases
Creation and management of versions in multiversion data warehouse
Proceedings of the 2004 ACM symposium on Applied computing
ACM SIGMOD Record
On querying versions of multiversion data warehouse
Proceedings of the 7th ACM international workshop on Data warehousing and OLAP
Fundamentals of Database Systems, Fourth Edition
Fundamentals of Database Systems, Fourth Edition
Building the Data Warehouse
Representing and Reasoning about Temporal Granularities
Journal of Logic and Computation
Conceptual Modeling for Traditional and Spatio-Temporal Applications: The MADS Approach
Conceptual Modeling for Traditional and Spatio-Temporal Applications: The MADS Approach
A conceptual solution for representing time in data warehouse dimensions
APCCM '06 Proceedings of the 3rd Asia-Pacific conference on Conceptual modelling - Volume 53
Hierarchies in a multidimensional model: from conceptual modeling to logical representation
Data & Knowledge Engineering - Special issue: WIDM 2004
Schema versioning in data warehouses: enabling cross-version querying via schema augmentation
Data & Knowledge Engineering - Special issue: WIDM 2004
Metadata management in a multiversion data warehouse
Journal on data semantics VIII
Managing and querying versions of multiversion data warehouse
EDBT'06 Proceedings of the 10th international conference on Advances in Database Technology
A multiversion-based multidimensional model
DaWaK'06 Proceedings of the 8th international conference on Data Warehousing and Knowledge Discovery
What time is it in the data warehouse?
DaWaK'06 Proceedings of the 8th international conference on Data Warehousing and Knowledge Discovery
A modular approach to user-defined symbolic periodicities
Data & Knowledge Engineering
Data & Knowledge Engineering
Reference model and perspective schemata inference for enterprise data integration
INAP'09 Proceedings of the 18th international conference on Applications of declarative programming and knowledge management
Temporal aggregation on user-defined granularities
Journal of Intelligent Information Systems
Repairing inconsistent dimensions in data warehouses
Data & Knowledge Engineering
Proceedings of the sixteenth international workshop on Data warehousing and OLAP
Extending ER models to capture database transformations to build data sets for data mining
Data & Knowledge Engineering
Hi-index | 0.00 |
The MultiDim model is a conceptual multidimensional model for data warehouse and OLAP applications. These applications require the presence of a time dimension to track changes in measure values. However, the time dimension cannot be used to represent changes in other dimensions. In this paper we introduce a temporal extension of the MultiDim model. This extension is based on research realized in temporal databases. We allow different temporality types: valid time, transaction time, and lifespan, which are obtained from source systems, and loading time, which is generated in the data warehouse. Our model provides temporal support for levels, attributes, hierarchies, and measures. For hierarchies we discuss different cases depending on whether the changes in levels or in the relationships between them must be kept. For measures, we give different scenarios that show the usefulness of the different temporality types. Further, since measures can be aggregated before being inserted into data warehouses, we discuss the issues related to different time granularities between source systems and data warehouses. We finish the paper presenting a transformation of the MultiDim model into the entity-relationship and the object-relational models.