Modelagens conceitual e lógica para data warehousing baseadas na integração de ontologia e matriz de barramento
Abstract
Data warehouse is a decision support solution whose technology is well practiced. However, conceptual and logical modeling are not well described in the literature, as they do not address how to use the characteristics of the domain and how they can be applied to generate queries with the user's language. In this sense, this paper presents a new approach to multidimensional modeling, based on the integration of ontology and the bus matrix and, based on a dimensional algebra. The objective was to represent the details of the domain in dimensions and facts, to faithfully represent the business processes in multidimensional consultations. As a result, a roadmap for the construction of an ontology for the conceptual model was presented, linked to a dynamic bus matrix to guide the logical model and, to take advantage of the domain requirements in the language and notion of the user and to mirror business processes in the queries multidimensional.
Keywords:
Banco de Dados e Recuperação de Informação, Engenharia Dirigida por Modelos Simulação
References
Borba, S. D. F. P., & Morales, A. B. T. (2006). Aplicação de Banco de Dados Orientado a Objetos na Modelagem Multidimensional. In SBBD (pp. 132-146).
Fernández-López, M., Gómez-Pérez, A., & Juristo, N. (1997). Methontology: from ontological art towards ontological engineering.
Gruber, T. R. (1993). A translation approach to portable ontology specifications. Knowledge acquisition, 5(2), 199-221.
Kimball, R., & Ross, M. (2013). The data warehouse toolkit: The definitive guide to dimensional modeling. John Wiley & Sons.
Musen, M.A. The Protégé project: A look back and a look forward. AI Matters. Association of Computing Machinery Specific Interest Group in Artificial Intelligence, 1(4), June 2015. DOI: 10.1145/2557001.25757003.
Noy, N. F., & McGuinness, D. L. (2001). Ontology development 101: A guide to creating your first ontology.
Rubin, D. L., Noy, N. F., & Musen, M. A. (2007). Protégé: a tool for managing and using terminology in radiology applications. Journal of digital imaging, 20(1), 3446.
Thomas, H., & Datta, A. (2001). A conceptual model and algebra for on-line analytical processing in decision support databases. Information Systems Research, 12(1), 83-102.
Fernández-López, M., Gómez-Pérez, A., & Juristo, N. (1997). Methontology: from ontological art towards ontological engineering.
Gruber, T. R. (1993). A translation approach to portable ontology specifications. Knowledge acquisition, 5(2), 199-221.
Kimball, R., & Ross, M. (2013). The data warehouse toolkit: The definitive guide to dimensional modeling. John Wiley & Sons.
Musen, M.A. The Protégé project: A look back and a look forward. AI Matters. Association of Computing Machinery Specific Interest Group in Artificial Intelligence, 1(4), June 2015. DOI: 10.1145/2557001.25757003.
Noy, N. F., & McGuinness, D. L. (2001). Ontology development 101: A guide to creating your first ontology.
Rubin, D. L., Noy, N. F., & Musen, M. A. (2007). Protégé: a tool for managing and using terminology in radiology applications. Journal of digital imaging, 20(1), 3446.
Thomas, H., & Datta, A. (2001). A conceptual model and algebra for on-line analytical processing in decision support databases. Information Systems Research, 12(1), 83-102.
Published
2020-10-26
How to Cite
SANTOS, Márcio André; SANTOS, Daniel Lucas; ANDRADE, Sergio Fred.
Modelagens conceitual e lógica para data warehousing baseadas na integração de ontologia e matriz de barramento. In: REGIONAL SCHOOL ON COMPUTING OF BAHIA, ALAGOAS, AND SERGIPE (ERBASE), 20. , 2020, Arapiraca-AL.
Anais [...].
Porto Alegre: Sociedade Brasileira de Computação,
2020
.
p. 1-10.
