skip to main content
10.1145/1871940.1871946acmconferencesArticle/Chapter ViewAbstractPublication PagescikmConference Proceedingsconference-collections
research-article

A methodology and tool for conceptual designing a data warehouse from ontology-based sources

Published: 30 October 2010 Publication History

Abstract

Ontologies become more popular in various domains. In database, they contribute largely in designing operational databases, that we call ontology-based databases (OBDB). An OBDB stores ontology and their instances in the same repository. Several DBMS propose solutions to manipulate and query this type of databases. As consequence, these operational OBDB become a candidate to feed data warehouses (DW). In this paper, we propose a new conceptual design methodology of DW from data residing in various OBDB that takes into account sources and decision maker requirements. As the result, a semantic DW model is generated. The presence of ontology within a DW facilitates its querying in semantic level and its future integration with other DW built using our methodology. Finally, we present a case tool, called S2RWC, supporting our proposal.

References

[1]
L. Bellatreche, Y. Ait Ameur, and C. Chakroun. A design methodology of ontology based database applications. Logic Journal of the IGPL, Oxford University Press, 2010.
[2]
L. Bellatreche, D. Nguyen Xuan, G. Pierra, and H. Dehainsala. Contribution of ontology-based data modeling to automatic integration of electronic catalogues within engineering databases. Computers in Industry Journal, Elsevier, 57(8-9):711--724, December 2006.
[3]
M. Boehnlein and A. Ulbrich vom Ende. Deriving initial data warehouse structures from the conceptual data models of the underlying operational information systems. In DOLAP'99, 1999.
[4]
A. Bonifati, F. Cattaneo, S. Ceri, A. Fuggetta, and S. Paraboschi. Designing data marts for data warehouses. ACM Trans. Softw. Eng. Methodol., 10(4):452--483, 2001.
[5]
H. Dehainsala, G. Pierra, and L. Bellatreche. Ontodb: An ontology-based database for data intensive applications. In DASFAA'07, pages 497--508, April 2007.
[6]
A. Y. Halevy et al. Enterprise information integration: successes, challenges and controversies. In Proceedings of the ACM SIGMOD International Conference on Management of Data, pages 778--787, 2005.
[7]
E. Franconi and G. Ng. The i.com tool for intelligent conceptual modeling. In KRDB, pages 45--53, 2000.
[8]
P. Giorgini, S. Rizzi, and M. Garzetti. Grand: A goal-oriented approach to requirement analysis in data warehouses. Decision Support Systems, 45(1):4--21, 2008.
[9]
M. Golfarelli and S. Rizzi. Wand: A case tool for data warehouse design. In ICDE Demo Sessions, pages 7--9, 2001.
[10]
S. Jean, Y. Ait Ameur, and G. Pierra. Querying ontology based databases - the ontoql proposal. In Proceedings of SEKE'2006, pages 166--171, 2006.
[11]
M. R. Jensen, T. Holmgren, and T. B. Pedersen. Discovering multidimensional structure in relational data. In DaWaK, pages 138--148, 2004.
[12]
S. Luján-Mora and J. Trujillo. A comprehensive method for data warehouse design. In DMDW, 2003.
[13]
S. Luján-Mora, J. Trujillo, and I.Y. Song. Extending the uml for multidimensional modeling. In UML, pages 290--304, 2002.
[14]
D. L. Moody and M. A. R. Kortink. From enterprise models to dimensional models: a methodology for data warehouse and data mart design. In DMDW, page 5, 2000.
[15]
V. Nebot, R. Berlanga, J. M. Perez, M. J. Aramburu, and T. B. Pedersen. Multidimensional integrated ontologies: A framework for designing semantic data warehouses. Journal on Data Semantics (JoDS), 13:1--36, 2009.
[16]
O. Romero and A. Abell´o. Automating multidimensional design from ontologies. In DOLAP, pages 1--8, 2007.
[17]
J. Trujillo, S. Luján-Mora, and E. Medina. The gold model case tool: An environment for designing olap applications. In ICEIS, pages 699--707, 2002.

Cited By

View all
  • (2022)Incorporation of Ontologies in Data Warehouse/Business Intelligence Systems - A Systematic Literature ReviewInternational Journal of Information Management Data Insights10.1016/j.jjimei.2022.1001312:2(100131)Online publication date: Nov-2022
  • (2019)On the Application of Ontological Patterns for Conceptual Modeling in Multidimensional ModelsAdvances in Databases and Information Systems10.1007/978-3-030-28730-6_14(215-231)Online publication date: 13-Aug-2019
  • (2018)Consolidation of BI efforts in the LOD era for african contextProceedings of the 2018 International Conference on Software Engineering in Africa10.1145/3195528.3195529(1-10)Online publication date: 27-May-2018
  • Show More Cited By

Recommendations

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences
DOLAP '10: Proceedings of the ACM 13th international workshop on Data warehousing and OLAP
October 2010
112 pages
ISBN:9781450303835
DOI:10.1145/1871940
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Sponsors

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 30 October 2010

Permissions

Request permissions for this article.

Check for updates

Qualifiers

  • Research-article

Conference

CIKM '10

Acceptance Rates

Overall Acceptance Rate 29 of 79 submissions, 37%

Upcoming Conference

CIKM '25

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)6
  • Downloads (Last 6 weeks)0
Reflects downloads up to 10 Feb 2025

Other Metrics

Citations

Cited By

View all
  • (2022)Incorporation of Ontologies in Data Warehouse/Business Intelligence Systems - A Systematic Literature ReviewInternational Journal of Information Management Data Insights10.1016/j.jjimei.2022.1001312:2(100131)Online publication date: Nov-2022
  • (2019)On the Application of Ontological Patterns for Conceptual Modeling in Multidimensional ModelsAdvances in Databases and Information Systems10.1007/978-3-030-28730-6_14(215-231)Online publication date: 13-Aug-2019
  • (2018)Consolidation of BI efforts in the LOD era for african contextProceedings of the 2018 International Conference on Software Engineering in Africa10.1145/3195528.3195529(1-10)Online publication date: 27-May-2018
  • (2018)Simplification of OWL Ontology Sources for Data WarehousingProceedings of the 2018 International Conference on Software Engineering and Information Management10.1145/3178461.3178483(77-81)Online publication date: 4-Jan-2018
  • (2018)Using Semantic Web technologies in the development of data warehouses: A systematic mappingWIREs Data Mining and Knowledge Discovery10.1002/widm.12939:3Online publication date: 7-Dec-2018
  • (2017)Tracing data warehouse design lifecycle semanticallyComputer Standards & Interfaces10.1016/j.csi.2016.12.00251:C(132-151)Online publication date: 1-Mar-2017
  • (2017)Creating Multidimensional Views from RDF SourcesAdvanced Information Technology, Services and Systems10.1007/978-3-319-69137-4_12(119-128)Online publication date: 12-Nov-2017
  • (2015)DWARM: An Ontology of Data Warehouse Architecture Reference ModelBeyond Databases, Architectures and Structures10.1007/978-3-319-18422-7_20(222-232)Online publication date: 2015
  • (2014)Ontology-Driven Business Intelligence for Comparative Data AnalysisBusiness Intelligence10.1007/978-3-319-05461-2_3(77-120)Online publication date: 2014
  • (2013)Semantic Data Warehouse Design: From ETL to Deployment à la CarteDatabase Systems for Advanced Applications10.1007/978-3-642-37450-0_5(64-83)Online publication date: 2013
  • Show More Cited By

View Options

Login options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Figures

Tables

Media

Share

Share

Share this Publication link

Share on social media