STORM: a statistical object representation model
SSDBM V Proceedings of the fifth international conference on Statistical and scientific database management
Decision Support Systems - Special issue on WITS '97
Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals
Data Mining and Knowledge Discovery
Modelling Large Scale OLAP Scenarios
EDBT '98 Proceedings of the 6th International Conference on Extending Database Technology: Advances in Database Technology
Summarizability in OLAP and Statistical Data Bases
SSDBM '97 Proceedings of the Ninth 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
Revising aggregation hierarchies in OLAP: a rule-based approach
Data & Knowledge Engineering - Special issue: Advances in OLAP
Multidimensional normal forms for data warehouse design
Information Systems
Multidimensional Data Modeling for Complex Data
ICDE '99 Proceedings of the 15th International Conference on Data Engineering
OLAP Databases and Aggregation Functions
SSDBM '01 Proceedings of the 13th International Conference on Scientific and Statistical Database Management
Conceptual multidimensional models
Multidimensional databases
An analysis of additivity in OLAP systems
Proceedings of the 7th ACM international workshop on Data warehousing and OLAP
Capturing summarizability with integrity constraints in OLAP
ACM Transactions on Database Systems (TODS)
YAM2: a multidimensional conceptual model extending UML
Information Systems
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
Integrated decision support systems: A data warehousing perspective
Decision Support Systems
OLAP preferences: a research agenda
Proceedings of the ACM tenth international workshop on Data warehousing and OLAP
Solving summarizability problems in fact-dimension relationships for multidimensional models
Proceedings of the ACM 11th international workshop on Data warehousing and OLAP
Data & Knowledge Engineering
Preference-Based Recommendations for OLAP Analysis
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
Using unified modeling language for conceptual modelling of knowledge-based systems
ER'07 Proceedings of the 26th international conference on Conceptual modeling
A taxonomy of inaccurate summaries and their management in OLAP systems
ER'05 Proceedings of the 24th international conference on Conceptual Modeling
Rule-based policy representation and reasoning for the semantic web
RW'07 Proceedings of the Third international summer school conference on Reasoning Web
An MDA approach to knowledge engineering
Expert Systems with Applications: An International Journal
Repairing inconsistent dimensions in data warehouses
Data & Knowledge Engineering
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
Extended dimensions for cleaning and querying inconsistent data warehouses
Proceedings of the sixteenth international workshop on Data warehousing and OLAP
Detecting summarizability in OLAP
Data & Knowledge Engineering
Hi-index | 0.00 |
Data warehouses are based on multidimensional modeling. Using On-Line Analytical Processing (OLAP) tools, decision makers navigate through and analyze multidimensional data. Typically, users need to analyze data at different aggregation levels (using roll-up and drill-down functions). Therefore, aggregation knowledge should be adequately represented in conceptual multidimensional models, and mapped in subsequent logical and physical models. However, current conceptual multidimensional models poorly represent aggregation knowledge, which (1) has a complex structure and dynamics and (2) is highly contextual. In order to account for the characteristics of this knowledge, we propose to represent it with objects (UML class diagrams) and rules in the Production Rule Representation language (PRR). Static aggregation knowledge is represented in the class diagrams, while rules represent the dynamics (i.e. how aggregation may be performed depending on context). We present the class diagrams, and a typology and examples of associated rules. We argue that this representation of aggregation knowledge enables an early modeling of user requirements in a data warehouse project. A prototype has been developed based on the Java Expert System Shell (Jess).