|
Article information
2024 , Volume 29, ¹ 1, p.74-85
Zhirnov A.A., Harlampenkov I.E., Kudryashova O.B., Potapov V.P.
Information validity problems in OLAP systems
The paper addresses the notion of information validity, relevance and data source reliability as applied to the design, development and information updating in contemporary OLAP systems. Many up-to-date information systems employ a variety of external data sources but the reliability of these sources and data validity therein raise doubts. In addition, the data is continually changed and updated from the old to the latest, which needs to be accounted. The problem is a lack of unified system for qualitative and quantitative assessment of information attributes such as degrees of relevance and validity combined with data source reliability. On the other hand, there is an array of information attributes that can judge relevance and validity of information. The present study aimed to elaborate approaches to assessing information relevance and validity and data source reliability for an OLAP database system and propose units of measurement, algorithms and computational methods. The elaborated approaches will be further employed as algorithms and programs as part of the developed OLAP database system.
[link to elibrary.ru]
Keywords: relevance of information, reliability of information, reliability of information and data sources, data loader, metadata, OLAP system, ETL system, ELT system
doi: 10.25743/ICT.2024.29.1.007
Author(s):
Zhirnov Anatoliy Alekseevich
PhD.
Position: Research Scientist
Address: 630090, Russia, Novosibirsk
E-mail: toluol_88@mail.ru
SPIN-code: 2506-0152Harlampenkov Ivan Evgenevich
PhD.
Address: 630090, Russia, Novosibirsk
E-mail: harlampenkov@ict.sbras.ru
SPIN-code: 3344-3120Kudryashova Olga Borisovna
Dr. , Associate Professor
Address: 659322, Russia, Biisk
E-mail: olgakudr@inbox.ru
SPIN-code: 7788-5572Potapov Vadim Petrovich
Dr. , Professor
Position: Leading research officer
Office: Federal Research Center for Information and Computational Technologies
Address: 650003, Russia, Kemerovo
Phone Office: (3842) 21-14-00
E-mail: vadimptpv@gmail.com
SPIN-code: 8947-1880 References:
1. Nozhenkova L.F. Information-analytical technologies and systems for support of regional management. Computational Technologies. 2009; 6(14):71–81. (In Russ.)
2. Oreshkov V.I., Paklin N.B. Biznes-analitika: ot dannykh k znaniyam [Business intelligence: fromdata to knowledge]. Available at: http://www.cfin.ru/itm/olap/cons.shtml. (In Russ.)
3. Melnykova N., Marikutsa U., Kryvenchuk U. The new approaches of heterogeneous data consolidation. IEEE 13th International Scientific and Technical Conference on Computer Sciences and Information Technologies (CSIT), Sept. 11–14, 2018. Ukraine: Lviv; 2018: 408–411.
4. Eremenko V.T., Minaeva V.A., Fisuna A.P., Koskina A.V. Teoriya informatsii i informatsionnykh protsessov: uchebnik dlya vuzov [Theory of information and information processes: a textbook for universities]. Orel: Gosuniversitet — UNPK; 2015: 443. (In Russ.)
5. Ivanova S.M. Assessment of the reliability of information found on the Internet. Teacher of the 21st Century. 2015; 4(1):54–60. (In Russ.)
6. Gromyko G.L. Teoriya statistiki [Theory of statistics: textbook. 2nd ed., revised]. Moscow: INFRAM; 2005: 476. (In Russ.)
7. Lyalkova E.E. Information sources of management analysis. Management of Economic Systems: Electronic Scientific Journal. 2016; 8(90):25. Available at: https://elibrary.ru/item.asp?id=26539597. (In Russ.)
8. Koops M.A. Reliability and the value of information. Animal Behaviour. 2004; 1(67):103–111.
9. Zhirnov A.A., Kharlampenkov I.E., Potapov V.P. Programma ustanovleniya urovnya dostovernosti istochnika dannykh [A program for establishing the level of reliability of data source]. Available at: https://new.fips.ru/ofpstorage/Doc/PrEVM/RUNWPR/000/002/022/618/984/2022618984-00001/document.pdf. (In Russ.)
10. Zhitnikov V.P., Sherykhalina N.M. Certainty estimation of numerical results obtained by several methods of problem solution. Computational Technologies. 1999; 6(4):77–87. (In Russ.)
11. Zhirnov A.A., Kharlampenkov I.E., Yurchenko A.V. Programma sokhraneniya izmeneniy v yacheykakh odnoy tablitsy bazy dannykh v druguyu tablitsu s zapis’yu versii [A program for saving changes in cells of one database table to another table with a version record]. Available at: https://new.fips.ru/ofpstorage/Doc/PrEVM/RUNWPR/000/002/021/666/299/2021666299-00001/document.pdf. (In Russ.)
Bibliography link:
Zhirnov A.A., Harlampenkov I.E., Kudryashova O.B., Potapov V.P. Information validity problems in OLAP systems // Computational technologies. 2024. V. 29. ¹ 1. P. 74-85
|
