Specifics of the tabular models for the operational data analysis of relational sources

DOI

10.2991/ies-18.2019.14How to use a DOI?

Keywords

operational data analysis, tabular model, aggregation, relational data sources

Abstract

The solution of analytical tasks on visual models, which are adequate for the structure of relational data sources, in the interactive mode with a convenient data view is of current interest for small and mid-size businesses with limited resources. When using MS Excel и Power Pivot tools, the relational data source model is designed to have the presence of table relationships under surrogate keys. The surrogate keys are supposed to be input only into dimension tables with composite keys. For this, it is necessary to determine the indexes for the real keys in dimension tables. These actions are sufficient for the automatic construction of tabular model during import tables and their relationships into a tabular model, while keeping the advantages of database integrity support. To reduce the analytical processing time, it is offered to input prepared tables with aggregated data into a tabular model. Such tables should include the most frequently used aggregates and could be created with SQL queries. These queries could also employ relational projection operation to select only those fields, which are used in the analysis. The model characteristics could be improved by preliminary joining fields of interrelated dimension tables into one table of a lower level, which allows creating hierarchies, the use of which makes data analysis in aggregated reports more convenient.

Copyright

© 2019, the Authors. Published by Atlantis Press.

Open Access

This is an open access article distributed under the CC BY-NC license (http://creativecommons.org/licenses/by-nc/4.0/).

Download article (PDF)

TY  - CONF
AU  - Yuri Bekarevich
PY  - 2019/11
DA  - 2019/11
TI  - Specifics of the tabular models for the operational data analysis of relational sources
BT  - Proceedings of the Third International Economic Symposium (IES 2018)
PB  - Atlantis Press
SP  - 389
EP  - 395
SN  - 2352-5428
UR  - https://doi.org/10.2991/ies-18.2019.14
DO  - 10.2991/ies-18.2019.14
ID  - Bekarevich2019/11
ER  -