An overview of data warehousing and OLAP technology
ACM SIGMOD Record
Communications of the ACM
A methodological framework for data warehouse design
Proceedings of the 1st ACM international workshop on Data warehousing and OLAP
A framework for object-oriented on-line analytic processing
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
Decision Support Systems - Special issue on WITS '97
A survey of logical models for OLAP databases
ACM SIGMOD Record
Designing data marts for data warehouses
ACM Transactions on Software Engineering and Methodology (TOSEM)
Constructing OLAP cubes based on queries
Proceedings of the 4th ACM international workshop on Data warehousing and OLAP
Fundamentals of Data Warehouses
Fundamentals of Data Warehouses
Oracle Express Olap
Past, present, and future of decision support technology
Decision Support Systems - Special issue: Decision support systems: Directions for the next decade
A Logical Approach to Multidimensional Databases
EDBT '98 Proceedings of the 6th International Conference on Extending Database Technology: Advances in Database Technology
Modeling Multidimensional Databases
ICDE '97 Proceedings of the Thirteenth International Conference on Data Engineering
Summarizability in OLAP and Statistical Data Bases
SSDBM '97 Proceedings of the Ninth International Conference on Scientific and Statistical Database Management
Normal Forms for Multidimensional Databases
SSDBM '98 Proceedings of the 10th International Conference on Scientific and Statistical Database Management
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
Dimension Hierarchies Design from UML Generalizations and Aggregations
ER '01 Proceedings of the 20th International Conference on Conceptual Modeling: Conceptual Modeling
Finding Your Way through Multidimensional Data Models
DEXA '98 Proceedings of the 9th International Workshop on Database and Expert Systems Applications
Multidimensional Data Modeling for Complex Data
ICDE '99 Proceedings of the 15th International Conference on Data Engineering
Data warehouse governance: best practices at blue cross and blue shield of North Carolina
Decision Support Systems
Proposal of a logical model for statistical data base
SSDBM'83 Proceedings of the 2nd international workshop on Proceedings of the Second International Workshop on Statistical Database Management
An empirical investigation of the effects of data warehousing on decision performance
Information and Management
MSMiner-a developing platform for OLAP
Decision Support Systems
Research in data warehouse modeling and design: dead or alive?
DOLAP '06 Proceedings of the 9th ACM international workshop on Data warehousing and OLAP
Proceedings of the ACM tenth international workshop on Data warehousing and OLAP
A case study on process modelling - Three questions and three techniques
Decision Support Systems
Applying UML 2.0 to design a botanical document warehouse
MUSP'08 Proceedings of the 8th WSEAS International Conference on Multimedia systems and signal processing
Towards the Automatic Generation of Analytical End-User Tools Metadata for Data Warehouses
BNCOD '08 Proceedings of the 25th British national conference on Databases: Sharing Data, Information and Knowledge
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
A survey on summarizability issues in multidimensional modeling
Data & Knowledge Engineering
Extending OCL for OLAP querying on conceptual multidimensional models of data warehouses
Information Sciences: an International Journal
ODBIS: towards a platform for on-demand business intelligence services
Proceedings of the 2010 EDBT/ICDT Workshops
Modeling data federations in ORM
OTM'07 Proceedings of the 2007 OTM confederated international conference on On the move to meaningful internet systems - Volume Part I
Automatic validation of requirements to support multidimensional design
Data & Knowledge Engineering
A framework for multidimensional design of data warehouses from ontologies
Data & Knowledge Engineering
Model driven data warehouse using MDA and 2TUP
Journal of Computational Methods in Sciences and Engineering - Special Supplement Issue in Section A and B: Selected Papers from the ISCA International Conference on Software Engineering and Data Engineering, 2009
Specifying aggregation functions in multidimensional models with OCL
ER'10 Proceedings of the 29th international conference on Conceptual modeling
On the requirements for user-centric spatial data warehousing and SOLAP
DASFAA'11 Proceedings of the 16th international conference on Database systems for advanced applications
Combining objects with rules to represent aggregation knowledge in data warehouse and OLAP systems
Data & Knowledge Engineering
Extending the dimensional templates approach to integrate complex multidimensional design concepts
DaWaK'11 Proceedings of the 13th international conference on Data warehousing and knowledge discovery
Multidimensional database design from document-centric XML documents
DaWaK'11 Proceedings of the 13th international conference on Data warehousing and knowledge discovery
Modern software engineering methodologies meet data warehouse design: 4WD
DaWaK'11 Proceedings of the 13th international conference on Data warehousing and knowledge discovery
An easy-to-implement fuzzy expert package with applications using existing Java classes
Expert Systems with Applications: An International Journal
MDA compliant approach for data mart schemas generation
MEDI'11 Proceedings of the First international conference on Model and data engineering
RETRACTED: Model-driven development of OLAP metadata for relational data warehouses
Computer Standards & Interfaces
A comprehensive framework on multidimensional modeling
ER'11 Proceedings of the 30th international conference on Advances in conceptual modeling: recent developments and new directions
A practical application of our MDD approach for modeling secure XML data warehouses
Decision Support Systems
A unified object constraint model for designing and implementing multidimensional systems
Journal on Data Semantics XIII
Modeling data warehouse schema evolution over extended hierarchy semantics
Journal on Data Semantics XIII
An MDA approach to knowledge engineering
Expert Systems with Applications: An International Journal
Multidimensional models meet the semantic web: defining and reasoning on OWL-DL ontologies for OLAP
Proceedings of the fifteenth international workshop on Data warehousing and OLAP
FedDW global schema architect: UML-based design tool for the integration of data mart schemas
Proceedings of the fifteenth international workshop on Data warehousing and OLAP
Using OCL for automatically producing multidimensional models and ETL processes
DaWaK'12 Proceedings of the 14th international conference on Data Warehousing and Knowledge Discovery
Information and Software Technology
Extending ER models to capture database transformations to build data sets for data mining
Data & Knowledge Engineering
Hi-index | 0.00 |
Data warehouses are a major component of data-driven decision support systems (DSS). They rely on multidimensional models. The latter provide decision makers with a business-oriented view to data, thereby easing data navigation and analysis via On-Line Analytical Processing (OLAP) tools. They also determine how the data are stored in the data warehouse for subsequent use, not only by OLAP tools, but also by other decision support tools. Data warehouse design is a complex task, which requires a systematic method. Few such methods have been proposed to date. This paper presents a UML-based data warehouse design method that spans the three design phases (conceptual, logical and physical). Our method comprises a set of metamodels used at each phase, as well as a set of transformations that can be semi-automated. Following our object orientation, we represent all the metamodels using UML, and illustrate the formal specification of the transformations based on OMG's Object Constraint Language (OCL). Throughout the paper, we illustrate the application of our method to a case study.