Data Warehouse Hybrid Modeling Methodology

Authors

  • Viktor László Takács Institute of Applied Informatics and Logistics, Faculty of Economics and Business, University of Debrecen, Debrecen https://orcid.org/0000-0001-8433-6115
  • Katalin Bubnó School of Mathematical and Computational Sciences, University of Debrecen, Debrecen https://orcid.org/0000-0002-5445-2374
  • Gergely Gábor Ráthonyi Institute of Applied Informatics and Logistics, Faculty of Economics and Business, University of Debrecen, Debrecen https://orcid.org/0000-0002-1184-1660
  • Éva Bácsné Bába Institute of Rural Development, Tourism and Sports Management, Faculty of Economics and Business, University of Debrecen, Debrecen
  • Róbert Szilágyi Institute of Applied Informatics and Logistics, Faculty of Economics and Business, University of Debrecen, Debrecen https://orcid.org/0000-0002-1783-6483

DOI:

https://doi.org/10.5334/dsj-2020-038

Keywords:

Formal methods, Data science, Information Management

Abstract

The classic conceptual modeling around business processes followed by the ‘bus matrix’ methodology of designing the data cubes of data warehouses (Kimball & Ross 2013). For a serious system, such a quantity of management questions and dimensions, the bus matrix results a difficult-to-understand conceptual data model. The subject of automation and conceptual design – to which many individual methods already have been developed – are relevant topics in today’s literature also.

In the 2010s data warehouse projects were realized in Hungarian higher education to inform the decision makers of the universities about their own institutions. As we participated in this project in 2009–2010, we faced that our bus matrix at the end contained about 80–120 indicators with nearly 200 dimensions (dimensional attributes), therefore we worked on the early stenography to formalize the management question.

We provide a kind of ‘business intelligence problem solving thinking’ and a kind of descriptive language that can serve it and present a method which has two novelties compared to formers:

  1. It is based on the management questions and its visualization.
  2. As a kind of stenography, it is always based on the terminology corresponding to the current problem, so it forms an intermediate language for the data model.

We introduce our method through an example in a popular research area which is activity tracking.

Downloads

Published

2020-10-13

Issue

Vol. 19 (2020)

Section

Research Papers

License

Copyright (c) 2020 The Author(s)

Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

Authors who publish with this journal agree to the following terms.  If a submission is rejected or withdrawn prior to publication, all rights return to the author(s):

  • Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.

  • Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.

  • Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work.

Submitting to the journal implicitly confirms that all named authors and rights holders have agreed to the above terms of publication. It is the submitting author's responsibility to ensure all authors and relevant institutional bodies have given their agreement at the point of submission.

Note: some institutions require authors to seek written approval in relation to the terms of publication. Should this be required, authors can request a separate licence agreement document from the editorial team (e.g. authors who are Crown employees).