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/).
Cite this article
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 -