Automatically generating OLAP schemata from conceptual graphical models
Proceedings of the 3rd ACM international workshop on Data warehousing and OLAP
Designing data marts for data warehouses
ACM Transactions on Software Engineering and Methodology (TOSEM)
Towards requirements-driven information systems engineering: the Tropos project
Information Systems - The 13th international conference on advanced information systems engineering (CAiSE*01)
Validating Graph Drawing Aesthetics
GD '95 Proceedings of the Symposium on Graph Drawing
Conceptual Design of Data Warehouses from E/R Schema
HICSS '98 Proceedings of the Thirty-First Annual Hawaii International Conference on System Sciences-Volume 7 - Volume 7
Towards Modeling and Reasoning Support for Early-Phase Requirements Engineering
RE '97 Proceedings of the 3rd IEEE International Symposium on Requirements Engineering
Multidimensional normal forms for data warehouse design
Information Systems
Metrics for data warehouse quality
Effective databases for text & document management
A UML profile for multidimensional modeling in data warehouses
Data & Knowledge Engineering - Special issue: ER 2003
Metrics for data warehouse conceptual models understandability
Information and Software Technology
Reconciling requirement-driven data warehouses with data sources via multidimensional normal forms
Data & Knowledge Engineering
GRAnD: A goal-oriented approach to requirement analysis in data warehouses
Decision Support Systems
Data modeling techniques for data warehousing
Data modeling techniques for data warehousing
Model-independent schema translation
The VLDB Journal — The International Journal on Very Large Data Bases
Data Warehouse Design: Modern Principles and Methodologies
Data Warehouse Design: Modern Principles and Methodologies
A UML profile for modeling data warehouse usage
ER'07 Proceedings of the 2007 conference on Advances in conceptual modeling: foundations and applications
Automatic validation of requirements to support multidimensional design
Data & Knowledge Engineering
Logic programming for data warehouse conceptual schema validation
DaWaK'10 Proceedings of the 12th international conference on Data warehousing and knowledge discovery
Multidimensional design by examples
DaWaK'06 Proceedings of the 8th international conference on Data Warehousing and Knowledge Discovery
ER'06 Proceedings of the 25th international conference on Conceptual Modeling
Metadata for approximate query answering systems
Advances in Software Engineering
Effective data warehouse for information delivery: a literature survey and classification
International Journal of Networking and Virtual Organisations
Information and Software Technology
| Hi-index | 0.01 |
Context: Data warehouse conceptual design is based on the metaphor of the cube, which can be derived from either requirement-driven or data-driven methodologies. Each methodology has its own advantages. The first allows designers to obtain a conceptual schema very close to the user needs but it may be not supported by the effective data availability. On the contrary, the second ensures a perfect traceability and consistence with the data sources-in fact, it guarantees the presence of data to be used in analytical processing-but does not preserve from missing business user needs. To face this issue, the necessity emerged in the last years to define hybrid methodologies for conceptual design. Objective: The objective of the paper is to use a hybrid methodology based on different multidimensional models in order to gather all advantages of each of them. Method: The proposed methodology integrates the requirement-driven strategy with the data-driven one, in that order, possibly performing alterations of functional dependencies on UML multidimensional schemas reconciled with data sources. Results: As case study, we illustrate how our methodology can be applied to the university environment. Furthermore, we evaluate quantitatively the benefits of this methodology by comparing it with some popular and conventional methodologies. Conclusion: In conclusion, we highlight how the hybrid methodology improves the conceptual schema quality. Finally, we outline our present work devoted to introduce automatic design techniques in the methodology on the basis of the logical programming.