A foundation for capturing and querying complex multidimensional data
Information Systems - Data warehousing
Fundamentals of Data Warehouses
Fundamentals of Data Warehouses
Extending Practical Pre-Aggregation in On-Line Analytical Processing
VLDB '99 Proceedings of the 25th International Conference on Very Large Data Bases
What can Hierarchies do for Data Warehouses?
VLDB '99 Proceedings of the 25th International Conference on Very Large Data Bases
STORM: A Statistical Object Representation Model
Proceedings of the 5th International Conference SSDBM on Statistical and Scientific Database Management
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
Dimension Hierarchies Design from UML Generalizations and Aggregations
ER '01 Proceedings of the 20th International Conference on Conceptual Modeling: Conceptual Modeling
Should Optional Properties Be Used in Conceptual Modelling? A Theory and Three Empirical Tests
Information Systems Research
Multidimensional normal forms for data warehouse design
Information Systems
Normalising OLAP cubes for controlling sparsity
Data & Knowledge Engineering
Multidimensional data modeling for location-based services
The VLDB Journal — The International Journal on Very Large Data Bases
Capturing summarizability with integrity constraints in OLAP
ACM Transactions on Database Systems (TODS)
YAM2: a multidimensional conceptual model extending UML
Information Systems
OLAP over uncertain and imprecise data
The VLDB Journal — The International Journal 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
Hierarchies in a multidimensional model: from conceptual modeling to logical representation
Data & Knowledge Engineering - Special issue: WIDM 2004
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
Extracting generalization hierarchies from relational databases: A reverse engineering approach
Data & Knowledge Engineering
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
Integrating Data Warehouses with Web Data: A Survey
IEEE Transactions on Knowledge and Data Engineering
Extending visual OLAP for handling irregular dimensional hierarchies
DaWaK'06 Proceedings of the 8th international conference on Data Warehousing and Knowledge Discovery
A taxonomy of inaccurate summaries and their management in OLAP systems
ER'05 Proceedings of the 24th international conference on Conceptual Modeling
Extending OCL for OLAP querying on conceptual multidimensional models of data warehouses
Information Sciences: an International Journal
Finding an application-appropriate model for XML data warehouses
Information Systems
A framework for multidimensional design of data warehouses from ontologies
Data & Knowledge Engineering
Multiversion data warehouse constraints
DOLAP '10 Proceedings of the ACM 13th international workshop on Data warehousing and OLAP
Towards the definition of spatial data warehouses integrity constraints with spatial OCL
DOLAP '10 Proceedings of the ACM 13th international workshop on Data warehousing and OLAP
Inferring aggregation hierarchies for integration of data marts
DEXA'10 Proceedings of the 21st international conference on Database and expert systems applications: Part II
Combining objects with rules to represent aggregation knowledge in data warehouse and OLAP systems
Data & Knowledge Engineering
GEM: requirement-driven generation of ETL and multidimensional conceptual designs
DaWaK'11 Proceedings of the 13th international conference on Data warehousing and knowledge discovery
Enforcing strictness in integration of dimensions: beyond instance matching
Proceedings of the ACM 14th international workshop on Data Warehousing and OLAP
Incremental integration of data warehouses: the hetero-homogeneous approach
Proceedings of the ACM 14th international workshop on Data Warehousing and OLAP
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
Building data warehouses with semantic web data
Decision Support Systems
Repairing inconsistent dimensions in data warehouses
Data & Knowledge Engineering
ORE: an iterative approach to the design and evolution of multi-dimensional schemas
Proceedings of the fifteenth international workshop on Data warehousing and OLAP
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
Towards ontology-based OLAP: datalog-based reasoning over multidimensional ontologies
Proceedings of the fifteenth international workshop on Data warehousing and OLAP
Benchmarking summarizability processing in XML warehouses with complex hierarchies
Proceedings of the fifteenth international workshop on Data warehousing and OLAP
Scalable test data generation from multidimensional models
Proceedings of the ACM SIGSOFT 20th International Symposium on the Foundations of Software Engineering
Differentiated multiple aggregations in multidimensional databases
DaWaK'12 Proceedings of the 14th international conference on Data Warehousing and Knowledge Discovery
Extended dimensions for cleaning and querying inconsistent data warehouses
Proceedings of the sixteenth international workshop on Data warehousing and OLAP
Effective data warehouse for information delivery: a literature survey and classification
International Journal of Networking and Virtual Organisations
Meaningful spatial prediction and aggregation
Environmental Modelling & Software
Detecting summarizability in OLAP
Data & Knowledge Engineering
Hi-index | 0.00 |
The development of a data warehouse (DW) system is based on a conceptual multidimensional model, which provides a high level of abstraction in accurately and expressively describing real-world situations. Once this model is designed, the corresponding logical representation must be obtained as the basis of the implementation of the DW according to one specific technology. However, even though a good conceptual multidimensional model is designed underneath a DW, there is a semantic gap between this model and its logical representation. In particular, this gap complicates an adequate treatment of summarizability issues, which in turn may lead to erroneous results of data analysis tools. Research addressing this topic has produced only partial solutions, and individual terminology used by different parties hinders further progress. Consequently, based on a unifying vocabulary, this survey sheds light on (i) the weak and strong points of current approaches for modeling complex multidimensional structures that reflect real-world situations in a conceptual multidimensional model and (ii) existing mechanisms to avoid summarizability problems when conceptual multidimensional models are being implemented.