HiLog as a platform for database languages
Proceedings of the second international workshop on Database programming languages
Research problems in data warehousing
CIKM '95 Proceedings of the fourth international conference on Information and knowledge management
Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP
The TSQL2 Temporal Query Language
The TSQL2 Temporal Query Language
Modelling Large Scale OLAP Scenarios
EDBT '98 Proceedings of the 6th International Conference on Extending Database Technology: Advances in Database Technology
A Logical Approach to Multidimensional Databases
EDBT '98 Proceedings of the 6th International Conference on Extending Database Technology: Advances in Database Technology
Point-Based Temporal Extension of Temporal SQL
DOOD '97 Proceedings of the 5th International Conference on Deductive and Object-Oriented Databases
VLDB '00 Proceedings of the 26th International Conference on Very Large Data Bases
Universal Temporal Extensions for Database Languages
ICDE '99 Proceedings of the 15th International Conference on Data Engineering
Multidimensional Data Modeling for Complex Data
ICDE '99 Proceedings of the 15th International Conference on Data Engineering
Maintaining Data Cubes under Dimension Updates
ICDE '99 Proceedings of the 15th International Conference on Data Engineering
The Data Warehouse Lifecycle Toolkit
The Data Warehouse Lifecycle Toolkit
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
Time in multidimensional databases
Multidimensional databases
Supporting mobile decision making with association rules and multi-layered caching
Decision Support Systems
Multiversion join index for multiversion data warehouse
Information and Software Technology
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
Towards an Algebraic foundation for business planning
Proceedings of the 2009 EDBT/ICDT Workshops
Metadata management in a multiversion data warehouse
Journal on data semantics VIII
OLAP operators for complex object data cubes
ADBIS'10 Proceedings of the 14th east European conference on Advances in databases and information systems
A multiversion-based multidimensional model
DaWaK'06 Proceedings of the 8th international conference on Data Warehousing and Knowledge Discovery
Hi-index | 0.00 |
Commercial OLAP systems usually treat OLAP dimensions as static entities. In practice, dimension updates are often necessary in order to adapt the multidimensional database to changing requirements. In earlier work we proposed a temporal multidimensional model and TOLAP, a query language supporting it, accounting for dimension updates and schema evolution at a high level of abstraction. In this paper we present our implementation of the model and the query language. We show how to translate a TOLAP program to SQL, and present a real-life case study, a medical center in Buenos Aires. We apply our implementation to this case study in order to show how our approach can address problems that occur in real situations and that current nontemporal commercial systems cannot deal with. We present results on query and dimension update performance, and briefly describe a visualization tool that allows editing and running TOLAP queries, performing dimension updates, and browsing dimensions across time.