Combining objects with rules to represent aggregation knowledge in data warehouse and OLAP systems

Data and Knowledge Engineering

Volumn 70, Issue 8, 2011, Pages 732-752

  Prat, Nicolas ^a   Comyn Wattiau, Isabelle ^a   Akoka, Jacky ^b  

^a ESSEC BUSINESS SCHOOL   (France)

^b CEDRIC CNAM   (France)

Author keywords

Aggregation; Conceptual multidimensional model; Data warehouse; On line Analytical Processing (OLAP); OO modeling; Production rule; UML

Indexed keywords

MULTI-DIMENSIONAL MODEL; ON-LINE ANALYTICAL PROCESSING (OLAP); OO MODELING; PRODUCTION RULE; UML;

EXPERT SYSTEMS; KNOWLEDGE REPRESENTATION; MODELS;

DATA WAREHOUSES;

EID: 79958831596     PISSN: 0169023X     EISSN: None     Source Type: Journal    
DOI: 10.1016/j.datak.2011.03.004     Document Type: Conference Paper

References (35)

1. S. March, and A. Hevner Integrated decision support systems: a data warehousing perspective Decision Support Systems 43 3 2007 1031 1043 (Pubitemid 46466979)
2. P.A. Bonatti, and D. Olmedilla Rule-based policy representation and reasoning for the semantic Web Proc. of Reasoning Web 2007, Dresden, Germany, September 2007, LNCS 4636 2007 Springer-Verlag 240 268
3. 2: a multidimensional conceptual model extending UML Information Systems 31 6 2006 541 567 (Pubitemid 43737166)
4. R. Torlone Conceptual multidimensional models M. Rafanelli, Multidimensional Databases: Problems and Solutions 2003 Idea Group Hershey, PA 69 90
5. S. Lujan-Mora, J. Trujillo, and I.-Y. Song A UML profile for multidimensional modeling in data warehouses Data & Knowledge Engineering 59 3 2006 725 769 (Pubitemid 44485258)
6. N. Prat, J. Akoka, and I. Comyn-Wattiau A UML-based data warehouse design method Decision Support Systems 42 3 2006 1449 1473 (Pubitemid 44648435)
7. N. Prat, I. Comyn-Wattiau, and J. Akoka Representation of aggregation knowledge in OLAP systems Proc. of ECIS 2010 (18th European Conference on Information Systems), Pretoria, South Africa, June 2010
8. Object Management Group, Common Warehouse Metamodel (CWM) specification, document number formal/2003-03-02, http://www.omg.org/spec/CWM/1.1/PDF/ (visited January 6, 2010), 2003.
9. Object Management Group, Production Rule Representation (PRR) version 1.0 specification, document number formal/2009-12-01, http://www.omg.org/spec/PRR/ 1.0/PDF/ (visited July 22, 2010), 2009.
10. M. Rafanelli, and A. Shoshani STORM: a statistical object representation model Proc. of the 5th International Conference on Scientific and Statistical Database Management (SSDBM 1990), Charlotte, North Carolina, USA April 1990 Springer-Verlag 14 29 LNCS 420
11. R. Kimball, and M. Ross The Data Warehouse Toolkit The Complete Guide to Dimensional Modeling 2nd Edition 2002 John Wiley and Sons
12. H.J. Lenz, and A. Shoshani Summarizability in OLAP and statistical data bases Proc. of the Ninth International Conference on Scientific and Statistical Database Management (SSDBM 1997), Olympia, Washington, USA, August 1997 1997 IEEE 132 143
13. J. Horner, and I.-Y. Song A taxonomy of inaccurate summaries and their management in OLAP systems Proc. of the 24th International Conference on Conceptual Modeling (ER 2005), Klagenfurt, Austria October 2005 Springer-Verlag 433 448 LNCS 3716
14. J. Horner, I.-Y. Song, and P. Chen An analysis of additivity in OLAP systems Proc. of the 7th ACM International Workshop on Data warehousing and OLAP (DOLAP'04), Washington, DC, USA November 2004 83 91 (Pubitemid 40737098)
15. J.-N. Mazón, J. Lechtenbörger, and J. Trujillo Solving summarizability problems in fact-dimension relationships for multidimensional models Proc. of the ACM 11th International Workshop on Data Warehousing and OLAP (DOLAP'08), Napa Valley, California, USA October 2008 57 64
16. J.-N. Mazón, J. Lechtenbörger, and J. Trujillo A survey on summarizability issues in multidimensional modeling Data & Knowledge Engineering 68 12 2009 1452 1469
17. B. Hüsemann, J. Lechtenbörger, and G. Vossen Conceptual data warehouse modeling Proc. of the Second International Workshop on Design and Management of Data Warehouses (DMDW 2000), Stockholm, Sweden June 2000 http://sunsite.informatik.rwth-aachen.de/Publications/CEUR-WS/Vol-28/
18. J. Lechtenbörger, and G. Vossen Multidimensional normal forms for data warehouse design Information Systems 28 5 2003 415 434
19. T. Pedersen, and C. Jensen Multidimensional data modeling for complex data Proc. of the 15th International Conference on Data Engineering (ICDE 1999), Sydney, Australia, March 1999 1999 IEEE 336 345
20. M.M. Espil, and A. Vaisman Revising aggregation hierarchies in OLAP: a rule-based approach Data & Knowledge Engineering 45 2 2003 225 256
21. D. DeHaan, D. Toman, and G. Weddell Rewriting aggregate queries using description logic Proc. of the International Workshop on Description Logics (DL 2003), Rome, Italy September 2003 http://sunsite.informatik.rwth-aachen.de/ Publications/CEUR-WS/Vol-81/
22. Object Management Group, Unified Modeling Language (UML) version 2.2. Superstructure specification, document number formal/2009-02-02, http://www.omg.org/spec/UML/2.2/Superstructure/PDF (visited January 6, 2010), 2009.
23. J. Akoka, I. Comyn-Wattiau, and N. Prat Dimension hierarchies design from UML generalizations and aggregations Proc. of the 20th International Conference on Conceptual Modeling (ER 2001), Yokohama, Japan, November 2001, LNCS 2224 2001 Springer-Verlag 442 455 (Pubitemid 33370422)
24. E. Malinowski, and E. Zimanyi Hierarchies in a multidimensional model: from conceptual modeling to logical representation Data & Knowledge Engineering 59 2 2006 348 377 (Pubitemid 44311223)
25. W. Lehner Modeling large scale OLAP scenarios Proc. of the 6th International Conference on Extending Database Technology (EDBT '98), Valencia, Spain, March 1998, LNCS 1377 1998 Springer-Verlag 153 167 (Pubitemid 128044748)
26. T. Pedersen, J. Gu, A. Shoshani, and C. Jensen Object-extended OLAP querying Data & Knowledge Engineering 68 5 2009 453 480
27. A. Datta, and H. Thomas The cube data model: a conceptual model and algebra for on-line analytical processing in data warehouses Decision Support Systems 27 3 1999 289 301 (Pubitemid 30522904)
28. H.J. Lenz, and B. Thalheim OLAP databases and aggregation functions Proc. of the 13th International Conference on Scientific and Statistical Database Management (SSDBM 2001), Fairfax, Virginia, USA, July 2001 2001 IEEE 91 100 (Pubitemid 32825422)
29. J. Gray, S. Chaudhuri, A. Bosworth, A. Layman, D. Reichart, M. Venkatrao, F. Pellow, and H. Pirahesh Data cube: a relational aggregation operator generalizing group-by, cross-tab, and sub-totals Data Mining and Knowledge Discovery 1 1 1997 29 53 (Pubitemid 127721235)
30. C. Hurtado, C. Gutierrez, and A. Mendelzon Capturing summarizability with integrity constraints in OLAP ACM Transactions on Database Systems 30 3 2005 854 886 (Pubitemid 43906385)
31. S. Rizzi OLAP preferences: a research agenda Proc. of the ACM 10th International Workshop on Data Warehousing and OLAP (DOLAP'07), Lisbon, Portugal November 2007 99 100
32. H. Jerbi, F. Ravat, O. Teste, and G. Zurfluh Preference-based recommendations for OLAP analysis Proc. of the 11th International Conference on Data Warehousing and Knowledge Discovery (DaWaK 2009), Linz, Austria August 31-September 2 2009 Springer-Verlag 467 478 LNCS 5961
33. C. Forgy Rete: a fast algorithm for the many pattern/many object pattern match problem Artificial Intelligence 19 1 1982 17 37 (Pubitemid 13465076)
34. Object Management Group, Object Constraint Language (OCL) specification, document number formal/2010-02-01, http://www.omg.org/spec/OCL/2.2/PDF (visited November 25, 2010), 2010.
35. M. Abdullah, I. Benest, R. Paige, and C. Kimble Using Unified Modeling Language for conceptual modeling of knowledge-based systems Proc. of the 26th International Conference on Conceptual Modeling (ER 2007), Auckland, New Zealand, November 2007, LNCS 4801 2007 Springer-Verlag 438 453