1. CSN
  2. All Volumes and Issues
  3. Number 905, 2018
  4. Principles of constructing a software system of the aggregated data formation

Principles of constructing a software system of the aggregated data formation

CSN.
2018;
, Number 905
: pp. 25 - 32
https://doi.org/10.23939/csn2018.905.025
Authors:
  1. I. Borodii
  2. Yaroslav Paramud
  3. V. Savyak
1
Lviv Polytechnic National University, Computer Engineering Department
2
Lviv Polytechnic National University, Computer Engineering Department
3
Lviv Polytechnic National University, Computer Engineering Department

This paper is devoted to the principles of constructing a software system of the aggregated data formation. The main principles of constructing a software system of the aggregated data formation are considered and their comparative analysis are carried out. An alternative principle of constructing a software system is proposed. This principle of constructing allows to eliminate the problems of fast and reliable data processing, scaling, automation of the software system components, improve data quality and security.

principles of constructing
software system
data analysis
data aggregation
business intelligence
relational database
data warehouse
data mart
OLAP-cube
  1. Kornilov Y. G. Sovremennoye primeneniye OLAP i OLTP tekhnologiy v ekonomike / Kornilov Y. G., Dolgova T. G. – Krasnoyarsk: Siberian State Aerospace University, Sektsiya “Informatsionno-ekonomicheskiye sistemy”, 2010. – P. 419–420.
  2. Marie-Aude Aufaure – Business Intelligence // Marie-Aude Aufaure, Esteban Zimanyi (Eds.): Second European Summer School, eBISS 2012, Brussels, Belgium, July 2012. – 234 p.
  3. Bat'kov V. O. – Analiz problem sovremennykh khranilishch dannykh / Bat'kov V. O. –Moscow: Moscow State University of Economics, Statistics, and Informatics, 2013. – 3 p.
  4. Data aggregation [Electronic resource] / ibm – Access mode: https://www.ibm.com/support/knowledgecenter/en/SSBNJ7_1.4.4/dataView/Con....
  5. M. A. Poltavtseva – Bezopasnost' baz dannykh: problemy i perspektivy / M. A. Poltavtseva, A. R Khabarov – Tver: Nauchno-issledovatel'skiy institut «Tsentrprogrammsistem», Programnyye produkty i sistemy No3 tom 29, 2016. – P. 36–41.
  6. Aarthi Raman –Conceptual Data Vault Modeling and its Opportunities for the Future // Aarthi Raman, Teuta Cata – Dallas, TX: Decision Sciences Institute, 2017 – 10 p.
  7. Data Warehouse: The Choice of Inmon versus Kimball [Electronic resource] / Ian Abramson. – Access mode: https://www.ismll.uni-hildesheim.de/lehre/bi-10s/script/Inmon-vs-Kimball....
  8. Data Source [Electronic resource] / techopedia. – Access mode: https://www.techopedia.com/definition/30323/data-source.
  9. DBMS Database Models [Electronic resource] / studytonight. – Access mode: https://www.studytonight.com/dbms/database-model.php.
  10. The Advantages of a Relational Database Management System [Electronic resource] / techwalla. – Access mode: https://www.techwalla.com/articles/theadvantages-of-a-relational-databas...
  11. Database [Electronic resource] / Margaret Rouse. – Access mode: https://searchsqlserver.techtarget.com/definition/database.
  12. Dusan Petkovic. Microsoft SQL Server 2012. A beginner’s guide // Dusan Petkovic – New York: The McGraw-Hill Companies, 2012. – 833 p.