Automating multidimensional design from ontologies

ABSTRACT

This paper presents a new approach to automate the multidimensional design of Data Warehouses. In our approach we propose a semi-automatable method aimed to find the business multidimensional concepts from a domain ontology representing different and potentially heterogeneous data sources of our business domain.

In short, our method identifies business multidimensional concepts from heterogeneous data sources having nothing in common but that they are all described by an ontology.

REFERENCES

• 1: Alberto Abelló , José Samos , Fèlix Saltor, YAM²: a multidimensional conceptual model extending UML, Information Systems, v.31 n.6, p.541-567, September 2006 [doi>10.1016/j.is.2004.12.002]
• 2: Franz Baader , Diego Calvanese , Deborah L. McGuinness , Daniele Nardi , Peter F. Patel-Schneider, The description logic handbook: theory, implementation, and applications, Cambridge University Press, New York, NY, 2003
• 3: F. Baader and R. Küsters. Matching Concept Descriptions with Existential Restrictions. In Proc. of 7th Conf. on Principles of Knowledge Representation and Reasoning, pages 261--272. M. Kaufmann, 2000.
• 4: Sourav S. Bhowmick , Sanjay Kumar Madria , Wee Keong Ng , Ee-Peng Lim, Web Warehousing: Design and Issues, Proceedings of the Workshops on Data Warehousing and Data Mining: Advances in Database Technologies, p.93-104, November 19-20, 1998
• 5: Luca Cabibbo , Riccardo Torlone, A Logical Approach to Multidimensional Databases, Proceedings of the 6th International Conference on Extending Database Technology: Advances in Database Technology, p.183-197, March 23-27, 1998
• 6: Paolo Giorgini , Stefano Rizzi , Maddalena Garzetti, Goal-oriented requirement analysis for data warehouse design, Proceedings of the 8th ACM international workshop on Data warehousing and OLAP, November 04-05, 2005, Bremen, Germany [doi>10.1145/1097002.1097011]
• 7: M. Golfarelli, D. Maio, and S. Rizzi. The Dimensional Fact Model: A Conceptual Model for Data Warehouses. Int. Journal of Cooperative Information Systems, 7(2--3):215--247, 1998.
• 8: I. Horrocks, O. Kutz, and U. Sattler. The Even More Irresistible SROIQ. In Proc. of 10th Int. Conf. on Principles of Knowledge Representation and Reasoning, pages 57--67. AAAI Press, 2006.
• 9: B. Hüsemann, J. Lechtenbörger, and G. Vossen. Conceptual Data Warehouse Modeling. In Proc. of 3rd Int. Workshop on Design and Management of Data Warehouses. CEUR--WS.org, 2000.
• 10: M. R. Jensen, T. Holmgren, and T. B. Pedersen. Discovering Multidimensional Structure in Relational Data. In 6th Int. Conf. on Data Warehousing and Knowledge Discovery, volume 3181 of LNCS, pages 138--148. Springer, 2004.
• 11: Ralph Kimball , Laura Reeves , Warren Thornthwaite , Margy Ross , Warren Thornwaite, The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses with CD Rom, John Wiley & Sons, Inc., New York, NY, 1998
• 12: Hans-Joachim Lenz , Arie Shoshani, Summarizability in OLAP and Statistical Data Bases, Proceedings of the Ninth International Conference on Scientific and Statistical Database Management, p.132-143, August 11-13, 1997 [doi>10.1109/SSDM.1997.621175]
• 13: C. Phipps and K. C. Davis. Automating Data Warehouse Conceptual Schema Design and Evaluation. In Proc. of 4th Int. Workshop on Design and Management of Data Warehouses, volume 58, pages 23--32. CEUR-WS.org, 2002.
• 14: O. Romero and A. Abelló. Generating multidimensional Schemas from the Semantic Web. In Proc. of CAiSE Forum'07, Poster, volume 247, pages 69--72. CEUR-WS.org, 2007.
• 15: O. Romero and A. Abelló. Multidimensional Design by Examples. In Proc. of 8th Int. Conf. on Data Warehousing and Knowledge Discovery, volume 4081 of LNCS, pages 85--94. Springer, 2006.
• 16: T. Berners Lee and J. Hendler and O. Lassila. The Semantic Web. Scientific American, 284(5), 2001.
• 17: B. Vrdoljak, M. Banek, and S. Rizzi. Designing Web Warehouses from XML Schemas. In Proc. of 5th Int. Conf. on Data Warehousing and Knowledge Discovery (DaWaK 2003), volume 2737 of LNCS, pages 89--98. Springer, 2003.
• 18: Robert Winter , Bernhard Strauch, A Method for Demand-Driven Information Requirements Analysis in Data Warehousing Projects, Proceedings of the 36th Annual Hawaii International Conference on System Sciences (HICSS'03) - Track 8, p.231.1, January 06-09, 2003

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.4 INFORMATION SYSTEMS APPLICATIONS
      H.4.2 Types of Systems
          Subjects: Decision support (e.g., MIS)

Additional Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.1 Logical Design

General Terms:
Algorithms, Design, Theory

Keywords:
OLAP, multidimensional design, ontologies