An overview of data warehousing and OLAP technology
ACM SIGMOD Record
UML distilled: applying the standard object modeling language
UML distilled: applying the standard object modeling language
The Unified Modeling Language user guide
The Unified Modeling Language user guide
The object constraint language: precise modeling with UML
The object constraint language: precise modeling with UML
starER: a conceptual model for data warehouse design
Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP
Building Web applications with UML
Building Web applications with UML
Object-oriented data warehouse design: building a star schema
Object-oriented data warehouse design: building a star schema
UML for Database Design
Uml and the Unified Process: Practical Object-Oriented Analysis and Design
Uml and the Unified Process: Practical Object-Oriented Analysis and Design
Building the Data Warehouse,3rd Edition
Building the Data Warehouse,3rd Edition
Modelling Large Scale OLAP Scenarios
EDBT '98 Proceedings of the 6th International Conference on Extending Database Technology: Advances in Database Technology
YAM2 (Yet Another Multidimensional Model): An Extension of UML
IDEAS '02 Proceedings of the 2002 International Symposium on Database Engineering & Applications
Extending the UML for Multidimensional Modeling
UML '02 Proceedings of the 5th International Conference on The Unified Modeling Language
Multidimensional Modeling with UML Package Diagrams
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
Finding Your Way through Multidimensional Data Models
DEXA '98 Proceedings of the 9th International Workshop on Database and Expert Systems Applications
Multi-View Software Evolution: A UML-based Framework for Evolving Object-Oriented Software
ICSM '01 Proceedings of the IEEE International Conference on Software Maintenance (ICSM'01)
Physical modeling of data warehouses using UML
Proceedings of the 7th ACM international workshop on Data warehousing and OLAP
A data warehouse engineering process
ADVIS'04 Proceedings of the Third international conference on Advances in Information 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
Reconciling requirement-driven data warehouses with data sources via multidimensional normal forms
Data & Knowledge Engineering
An MDA approach for the development of data warehouses
Decision Support Systems
Building a secure star schema in data warehouses by an extension of the relational package from CWM
Computer Standards & Interfaces
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
UML-Based Modeling for What-If Analysis
DaWaK '08 Proceedings of the 10th international conference on Data Warehousing and Knowledge Discovery
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
An MDA Approach for the Development of Spatial Data Warehouses
DaWaK '08 Proceedings of the 10th international conference on Data Warehousing and Knowledge Discovery
Solving summarizability problems in fact-dimension relationships for multidimensional models
Proceedings of the ACM 11th international workshop on Data warehousing and OLAP
Bridging the semantic gap in OLAP models: platform-independent queries
Proceedings of the ACM 11th international workshop on Data warehousing and OLAP
Integrated Model-Driven Development of Goal-Oriented Data Warehouses and Data Marts
ER '08 Proceedings of the 27th International Conference on Conceptual Modeling
Automatic Generation of Secure Multidimensional Code for Data Warehouses: An MDA Approach
OTM '08 Proceedings of the OTM 2008 Confederated International Conferences, CoopIS, DOA, GADA, IS, and ODBASE 2008. Part II on On the Move to Meaningful Internet Systems
Editorial: Model-Driven Development for secure information systems
Information and Software Technology
A UML profile for the conceptual modelling of data-mining with time-series in data warehouses
Information and Software Technology
An engineering process for developing Secure Data Warehouses
Information and Software Technology
Data & Knowledge Engineering
A UML 2.0 profile to define security requirements for Data Warehouses
Computer Standards & Interfaces
Model-Driven Development for Enabling the Feadback from Warehouses and OLAP to Operational Systems
Proceedings of the 2007 conference on Databases and Information Systems IV: Selected Papers from the Seventh International Baltic Conference DB&IS'2006
Designing Data Warehouses for Geographic OLAP Querying by Using MDA
ICCSA '09 Proceedings of the International Conference on Computational Science and Its Applications: Part I
Visual Modelling of Data Warehousing Flows with UML Profiles
DaWaK '09 Proceedings of the 11th International Conference on Data Warehousing and Knowledge Discovery
A survey on summarizability issues in multidimensional modeling
Data & Knowledge Engineering
Defining ETL worfklows using BPMN and BPEL
Proceedings of the ACM twelfth international workshop on Data warehousing and OLAP
Extending OCL for OLAP querying on conceptual multidimensional models of data warehouses
Information Sciences: an International Journal
A Conceptual Modeling Approach for OLAP Personalization
ER '09 Proceedings of the 28th International Conference on Conceptual Modeling
Using web-based personalization on spatial data warehouses
Proceedings of the 2010 EDBT/ICDT Workshops
The benefits of the interaction between data warehouses and question answering
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
ER'07 Proceedings of the 26th international conference on Conceptual modeling
A UML profile for modeling data warehouse usage
ER'07 Proceedings of the 2007 conference on Advances in conceptual modeling: foundations and applications
A model-driven goal-oriented requirement engineering approach for data warehouses
ER'07 Proceedings of the 2007 conference on Advances in conceptual modeling: foundations and applications
Towards readable layouts for modeling data warehouses
DOLAP '10 Proceedings of the ACM 13th international workshop on Data warehousing and OLAP
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
Domain-specific language modelling with UML profiles by decoupling abstract and concrete syntaxes
Journal of Systems and Software
Development of a business intelligence environment for e-gov using open source technologies
DaWaK'10 Proceedings of the 12th international conference on Data warehousing and knowledge discovery
Improving the development of data warehouses by enriching dimension hierarchies with WordNet
ODBIS'05/06 Proceedings of the First and Second VLDB conference on Ontologies-based databases and information systems
Model-driven development of multidimensional models from web log files
ER'10 Proceedings of the 2010 international conference on Advances in conceptual modeling: applications and challenges
Specifying aggregation functions in multidimensional models with OCL
ER'10 Proceedings of the 29th international conference on Conceptual modeling
A synergistic model-driven approach for persistence modeling with UML
Journal of Systems and Software
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
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
CAiSE'11 Proceedings of the 23rd international conference on Advanced information systems engineering
DEXA'11 Proceedings of the 22nd international conference on Database and expert systems applications - Volume Part II
Transforming statistical linked data for use in OLAP systems
Proceedings of the 7th International Conference on Semantic Systems
RETRACTED: Model-driven development of OLAP metadata for relational data warehouses
Computer Standards & Interfaces
A modularization proposal for goal-oriented analysis of data warehouses using i-star
ER'11 Proceedings of the 30th international conference on Conceptual modeling
Incorporating traceability in conceptual models for data warehouses by using MDA
ER'11 Proceedings of the 30th international conference on Conceptual modeling
A model-driven approach for enforcing summarizability in multidimensional modeling
ER'11 Proceedings of the 30th international conference on Advances in conceptual modeling: recent developments and new directions
Hybrid methodology for data warehouse conceptual design by UML schemas
Information and Software Technology
Applying transformations to model driven data warehouses
DaWaK'06 Proceedings of the 8th international conference on Data Warehousing and Knowledge Discovery
Conceptual modeling for classification mining in data warehouses
DaWaK'06 Proceedings of the 8th international conference on Data Warehousing and Knowledge Discovery
A personalization process for spatial data warehouse development
Decision Support Systems
A practical application of our MDD approach for modeling secure XML data warehouses
Decision Support Systems
Entity-relationship and object-oriented formalisms for modeling spatial environmental data
Environmental Modelling & Software
Enriching data warehouse dimension hierarchies by using semantic relations
BNCOD'06 Proceedings of the 23rd British National Conference on Databases, conference on Flexible and Efficient Information Handling
ER'06 Proceedings of the 25th international conference on Conceptual Modeling
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
A model driven process for spatial data sources and spatial data warehouses reconcilation
ICCSA'10 Proceedings of the 2010 international conference on Computational Science and Its Applications - Volume Part I
Monitoring strategic goals in data warehouses with awareness requirements
Proceedings of the 27th Annual ACM Symposium on Applied Computing
Evaluation of approaches for designing secure data warehouse
Proceedings of the International Conference on Advances in Computing, Communications and Informatics
Repairing inconsistent dimensions in data warehouses
Data & Knowledge Engineering
Discovering OLAP dimensions in semi-structured data
Proceedings of the fifteenth international workshop on Data warehousing and 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
DaWaK'07 Proceedings of the 9th international conference on Data Warehousing and Knowledge Discovery
A UML profile for representing business object states in a data warehouse
DaWaK'07 Proceedings of the 9th international conference on Data Warehousing and Knowledge Discovery
Conceptualizing and specifying key performance indicators in business strategy models
CASCON '12 Proceedings of the 2012 Conference of the Center for Advanced Studies on Collaborative Research
A case study on model-driven data warehouse development
DaWaK'12 Proceedings of the 14th international conference on Data Warehousing and Knowledge Discovery
Differentiated multiple aggregations in multidimensional databases
DaWaK'12 Proceedings of the 14th international conference on Data Warehousing and Knowledge Discovery
ER'12 Proceedings of the 2012 international conference on Advances in Conceptual Modeling
Conceptualizing and specifying key performance indicators in business strategy models
ER'12 Proceedings of the 31st international conference on Conceptual Modeling
When Spatial Analysis Meets OLAP: Multidimensional Model and Operators
International Journal of Data Warehousing and Mining
Journal of Database Management
Adding semantic modules to improve goal-oriented analysis of data warehouses using I-star
Journal of Systems and Software
Information and Software Technology
Tracing conceptual models' evolution in data warehouses by using the model driven architecture
Computer Standards & Interfaces
Actors' misaligned interests to explain the low impact of an information system - A case study
International Journal of Information Management: The Journal for Information Professionals
Hi-index | 0.00 |
The multidimensional (MD) modeling, which is the foundation of data warehouses (DWs), MD databases, and On-Line Analytical Processing (OLAP) applications, is based on several properties different from those in traditional database modeling. In the past few years, there have been some proposals, providing their own formal and graphical notations, for representing the main MD properties at the conceptual level. However, unfortunately none of them has been accepted as a standard for conceptual MD modeling.In this paper, we present an extension of the Unified Modeling Language (UML) using a UML profile. This profile is defined by a set of stereotypes, constraints and tagged values to elegantly represent main MD properties at the conceptual level. We make use of the Object Constraint Language (OCL) to specify the constraints attached to the defined stereotypes, thereby avoiding an arbitrary use of these stereotypes. We have based our proposal in UML for two main reasons: (i) UML is a well known standard modeling language known by most database designers, thereby designers can avoid learning a new notation, and (ii) UML can be easily extended so that it can be tailored for a specific domain with concrete peculiarities such as the multidimensional modeling for data warehouses. Moreover, our proposal is Model Driven Architecture (MDA) compliant and we use the Query View Transformation (QVT) approach for an automatic generation of the implementation in a target platform. Throughout the paper, we will describe how to easily accomplish the MD modeling of DWs at the conceptual level. Finally, we show how to use our extension in Rational Rose for MD modeling.