A data model for supporting on-line analytical processing
CIKM '96 Proceedings of the fifth international conference on Information and knowledge management
An overview of data warehousing and OLAP technology
ACM SIGMOD Record
A methodological framework for data warehouse design
Proceedings of the 1st ACM international workshop on Data warehousing and OLAP
starER: a conceptual model for data warehouse design
Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP
Event-entity-relationship modeling in data warehouse environments
Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP
Automatically generating OLAP schemata from conceptual graphical models
Proceedings of the 3rd ACM international workshop on Data warehousing and OLAP
A foundation for capturing and querying complex multidimensional data
Information Systems - Data warehousing
Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals
Data Mining and Knowledge Discovery
Modeling Multidimensional Databases
ICDE '97 Proceedings of the Thirteenth International Conference on Data Engineering
Reasoning about Summarizability in Heterogeneous Multidimensional Schemas
ICDT '01 Proceedings of the 8th International Conference on Database Theory
A Foundation for Multi-dimensional Databases
VLDB '97 Proceedings of the 23rd International Conference on Very Large Data Bases
On Schema Evolution in Multidimensional Databases
DaWaK '99 Proceedings of the First International Conference on Data Warehousing and Knowledge Discovery
A Logical Model for Data Warehouse Design and Evolution
DaWaK 2000 Proceedings of the Second International Conference on Data Warehousing and Knowledge Discovery
A Decathlon in Multidimensional Modeling: Open Issues and Some Solutions
DaWaK 2000 Proceedings of the 4th International Conference on Data Warehousing and Knowledge Discovery
Evolving the Software of a Schema Evolution System
FoMLaDO/DEMM 2000 Selected papers from the 9th International Workshop on Foundations of Models and Languages for Data and Objects, Database Schema Evolution and Meta-Modeling
YAM2 (Yet Another Multidimensional Model): An Extension of UML
IDEAS '02 Proceedings of the 2002 International Symposium on Database Engineering & Applications
Optimizing Performance of Schema Evolution Sequences
Proceedings of the International Symposium on Objects and Databases
STORM: A Statistical Object Representation Model
Proceedings of the 5th International Conference SSDBM on Statistical and Scientific Database Management
Research Issues in Clinical Data Warehousing
SSDBM '98 Proceedings of the 10th International Conference on Scientific and Statistical Database Management
Modeling Multidimensional Databases, Cubes and Cube Operations
SSDBM '98 Proceedings of the 10th International Conference on Scientific and Statistical Database Management
A Transactional Model for Data Warehouse Maintenance
ER '02 Proceedings of the 21st International Conference on Conceptual Modeling
Extending the E/R Model for the Multidimensional Paradigm
ER '98 Proceedings of the Workshops on Data Warehousing and Data Mining: Advances in Database Technologies
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
Multidimensional data modeling for location-based services
The VLDB Journal — The International Journal on Very Large Data Bases
Using the uni-level description (ULD) to support data-model interoperability
Data & Knowledge Engineering - Special issue: ER 2003
A UML profile for multidimensional modeling in data warehouses
Data & Knowledge Engineering - Special issue: ER 2003
A UML-based data warehouse design method
Decision Support Systems
An MDA approach for the development of data warehouses
Decision Support Systems
Model-Driven Metadata for OLAP Cubes from the Conceptual Modelling of Data Warehouses
DaWaK '08 Proceedings of the 10th international conference on Data Warehousing and Knowledge Discovery
The Data Warehouse Lifecycle Toolkit
The Data Warehouse Lifecycle Toolkit
A generic and customizable framework for the design of ETL scenarios
Information Systems - Special issue: The 15th international conference on advanced information systems engineering (CAiSE 2003)
Managing and querying versions of multiversion data warehouse
EDBT'06 Proceedings of the 10th international conference on Advances in Database Technology
A multilevel dictionary for model management
ER'05 Proceedings of the 24th international conference on Conceptual Modeling
Searching semantic data warehouses: models, issues, architectures
Proceedings of the 2nd International Workshop on Semantic Search over the Web
Proceedings of the sixteenth international workshop on Data warehousing and OLAP
Hi-index | 0.00 |
Models for conceptual design of data warehouse schemas have been proposed, but few researchers have addressed schema evolution in a formal way and none have presented software tools for enforcing the correctness of multidimensional schema evolution operators. We generalize the core features typically found in data warehouse data models, along with modeling extended hierarchy semantics. The advanced features include multiple hierarchies, non-covering hierarchies, non-onto hierarchies, and non-strict hierarchies. We model the constructs in the Uni-level Description Language (ULD) as well as using a multilevel dictionary definition (MDD) approach. The ULD representation provides a formal foundation to specify transformation rules for the semantics of schema evolution operators. The MDD gives a basis for direct implementation in a relational database system; we define model constraints and then use the constraints to maintain integrity when schema evolution operators are applied. This paper contributes a formalism for representing data warehouse schemas and determining the validity of schema evolution operators applied to a schema. We describe a software tool that allows for visualization of the impact of schema evolution through the use of triggers and stored procedures.