On the complexity of inferring functional dependencies
Discrete Applied Mathematics - Special issue on combinatorial problems in databases
Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP
The entity-relationship model—toward a unified view of data
ACM Transactions on Database Systems (TODS) - Special issue: papers from the international conference on very large data bases: September 22–24, 1975, Framingham, MA
Designing data marts for data warehouses
ACM Transactions on Software Engineering and Methodology (TOSEM)
Data integration: a theoretical perspective
Proceedings of the twenty-first ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems
The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses with CD Rom
Modeling Multidimensional Databases
ICDE '97 Proceedings of the Thirteenth International Conference on Data Engineering
A Formal Framework for Reasoning on UML Class Diagrams
ISMIS '02 Proceedings of the 13th International Symposium on Foundations of Intelligent Systems
Summarizability in OLAP and Statistical Data Bases
SSDBM '97 Proceedings of the Ninth International Conference on Scientific and Statistical Database Management
A Method for Demand-Driven Information Requirements Analysis in Data Warehousing Projects
HICSS '03 Proceedings of the 36th Annual Hawaii International Conference on System Sciences (HICSS'03) - Track 8 - Volume 8
Transforming an Operational System Model to a Data Warehouse Model: A Survey of Techniques
SWSTE '05 Proceedings of the IEEE International Conference on Software - Science, Technology & Engineering
Goal-oriented requirement analysis for data warehouse design
Proceedings of the 8th ACM international workshop on Data warehousing and OLAP
YAM2: a multidimensional conceptual model extending UML
Information Systems
GORDIAN: efficient and scalable discovery of composite keys
VLDB '06 Proceedings of the 32nd international conference on Very large data bases
Research in data warehouse modeling and design: dead or alive?
DOLAP '06 Proceedings of the 9th ACM international workshop on Data warehousing and OLAP
MDA-based Automatic OWL Ontology Development
International Journal on Software Tools for Technology Transfer (STTT) - Special Section on Fundamental Approaches to Software Engineering
A UML-based data warehouse design method
Decision Support Systems
Reconciling requirement-driven data warehouses with data sources via multidimensional normal forms
Data & Knowledge Engineering
Automating multidimensional design from ontologies
Proceedings of the ACM tenth international workshop on Data warehousing and OLAP
Proceedings of the ACM tenth international workshop on Data warehousing and OLAP
Functional dependencies distorted by errors
Discrete Applied Mathematics
Data Warehouse Design: Modern Principles and Methodologies
Data Warehouse Design: Modern Principles and Methodologies
Reasoning on UML class diagrams
Artificial Intelligence
A survey on summarizability issues in multidimensional modeling
Data & Knowledge Engineering
Discovering functional dependencies for multidimensional design
Proceedings of the ACM twelfth international workshop on Data warehousing and OLAP
Towards automatization of domain modeling
Data & Knowledge Engineering
Reasoning over extended ER models
ER'07 Proceedings of the 26th international conference on Conceptual modeling
Journal on data semantics X
Automatic validation of requirements to support multidimensional design
Data & Knowledge Engineering
Editorial: ANEMONE: An environment for modular ontology development
Data & Knowledge Engineering
Multidimensional database design from document-centric XML documents
DaWaK'11 Proceedings of the 13th international conference on Data warehousing and knowledge discovery
GEM: requirement-driven generation of ETL and multidimensional conceptual designs
DaWaK'11 Proceedings of the 13th international conference on Data warehousing and knowledge discovery
ER'11 Proceedings of the 30th international conference on Advances in conceptual modeling: recent developments and new directions
A comprehensive framework on multidimensional modeling
ER'11 Proceedings of the 30th international conference on Advances in conceptual modeling: recent developments and new directions
Proceedings of the fifteenth international workshop on Data warehousing and OLAP
Towards ontology-based OLAP: datalog-based reasoning over multidimensional ontologies
Proceedings of the fifteenth international workshop on Data warehousing and OLAP
Requirement-driven creation and deployment of multidimensional and ETL designs
ER'12 Proceedings of the 2012 international conference on Advances in Conceptual Modeling
Using domain ontologies as semantic dimensions in data warehouses
ER'12 Proceedings of the 31st international conference on Conceptual Modeling
Hi-index | 0.00 |
The data warehouse design task needs to consider both the end-user requirements and the organization data sources. For this reason, the data warehouse design has been traditionally considered a reengineering process, guided by requirements, from the data sources. Most current design methods available demand highly-expressive end-user requirements as input, in order to carry out the exploration and analysis of the data sources. However, the task to elicit the end-user information requirements might result in a thorough task. Importantly, in the data warehousing context, the analysis capabilities of the target data warehouse depend on what kind of data is available in the data sources. Thus, in those scenarios where the analysis capabilities of the data sources are not (fully) known, it is possible to help the data warehouse designer to identify and elicit unknown analysis capabilities. In this paper we introduce a user-centered approach to support the end-user requirements elicitation and the data warehouse multidimensional design tasks. Our proposal is based on a reengineering process that derives the multidimensional schema from a conceptual formalization of the domain. It starts by fully analyzing the data sources to identify, without considering requirements yet, the multidimensional knowledge they capture (i.e., data likely to be analyzed from a multidimensional point of view). Next, we propose to exploit this knowledge in order to support the requirements elicitation task. In this way, we are already conciliating requirements with the data sources, and we are able to fully exploit the analysis capabilities of the sources. Once requirements are clear, we automatically create the data warehouse conceptual schema according to the multidimensional knowledge extracted from the sources.