SWS Academic Research eLibraryEarth & Planetary Sciences

Scholarly record

THE ACTIVE DATA WAREHOUSE OF A CONFIGURABLE INFORMATION SYSTEM

Sergey Kucherov, Yuri Rogozov, Julia Lipko, Margarita Kucherova

First published: 2020-09-20https://doi.org/10.5593/sgem2020/2.1/s07.043View metrics

Abstract

The data warehouse in the information system is intended to reflect the changing part of the domain model. In classical information systems, this part includes data values, and the storage, implemented as a database, and the system itself can be considered static in time objects. Modern conditions for the functioning of information systems are characterized by the requirement for the possibility of modifying the functionality of the system at the stage of its operation. In this regard, not only data values, but also the domain model, which is reflected in the information system, become a changing part of the system. A class of information systems has the ability to change the domain model, in various sources called configurable, adaptable, evolutionary, etc. Systems of this kind put forward new requirements for storage tools, which include changing the data domain model without redesigning and re-developing, maintaining the connection between system components and data elements regardless of changes made. To date, various methods and approaches are known that successfully solve the problem of changing the stored data model; these include structurally independent databases, situationally-oriented databases, universal databases, etc. The main idea of ??such approaches is to create a functionally developed layer between physical means of data storage and directly the interfaces used by the application to work with data. The solutions of this class, in addition to the known drawbacks in the form of a decrease in productivity, do not allow to fully reflect the changes in the domain model, since the data is only part of it. To fully support the work of configurable information systems, the storage should allow to store and change the entire domain model, which is currently an unresolved problem. The domain model underlying the configurable information system is a reflection of user actions for obtaining or processing data. Moreover, in reality, the data is inextricably linked with the actions for their receipt and processing. Accordingly, if a user action is used as a basic storage abstraction, then the aforementioned problem can be solved. The database itself, in its classical sense, when using the basic abstraction of user actions, becomes the central link in a configurable information system and an active repository capable of performing these actions to obtain, reproduce, and process the available information. The article presents the results of a study of the current state of science, proposes a fundamental and physical model of an active data warehouse of a configurable system, discusses the issues of its implementation in a schema-free NoSQL DBMS.

Publication Impact Profile

PlumX
  • Citations
  • Scopus - Citation Indexes: 1
  • Captures
  • Mendeley - Readers: 5

Publication details

Title
THE ACTIVE DATA WAREHOUSE OF A CONFIGURABLE INFORMATION SYSTEM
Authors
Sergey Kucherov, Yuri Rogozov, Julia Lipko, Margarita Kucherova
Proceedings
SGEM International Multidisciplinary Scientific GeoConference EXPO Proceedings; 20th International Multidisciplinary Scientific GeoConference Proceedings SGEM 2020, Informatics, Geoinformatics and Remote Sensing
Publisher
STEF92 Technology
Year
2020
Pages
333-340
SWS Citekey
Kucherov20207333340
ISSN
1314-2704
ISBN
978-619-7603-06-4
Language
en
Publication type
Conference Paper
Keywords
References12
  1. J.Garcia, G.Goldszmidt. Building SOA composite business services // http://www.ibm.com/developerworks/webservices/library/ws-soa-composite/

  2. S. Kucherov, Y. Rogozov, A. Sviridov The Model of Subject-Oriented Storage of Concepts Sense for Configurable Information Systems // Proceedings of the First International Scientific Conference “Intelligent Information Technologies for Industry” (IITI’16) Volume 1 in Advances in Intelligent Systems and Computing, Vol 450, 2016. pp 317-327

  3. Carlos Rossi, Antonio Guevara, Manuel Enciso. A TOOL FOR USER-GUIDED DATABASE APPLICATION DEVELOPMENT. Automatic Design of XML Models using CBD Proceedings of the Fifth International Conference on Software and Data Technologies, ICSOFT 2010, Volume 2, p.195-200

  4. El Akkaoui Z. et al. BPMN-based conceptual modeling of ETL processes // Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics). 2012. Vol. 7448 LNCS., Pages 1-14

  5. Oliveira B., Belo O. A domain-specific language for ETL patterns specification in data warehousing systems // Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics). 2015. Т. 9273., Pages 597-602

  6. Khouri S., Abdellaoui S., Nader F. Avoiding ontology confusion in ETL processes // Communications in Computer and Information Science. 2015. Т. 539., Pages 119-126

  7. Schultz A. et al. LDIF - A Framework for Large-Scale Linked Data Integration // 21st Int. World Wide Web Conf. (WWW 2012), Dev. Track, Lyon, Fr. 2012. P. 1–3.

  8. Kimball R. et al. The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning Conforming, and Delivering Data // Wiley. 2004. 526 p

  9. Rogozov Y. Paradigma smyslovogo proektirovaniya sistemnykh ob"ektov [The Paradigm of semantic system objects design] Trudy ISA RAN [Proceedings of ISA RAS]. Vol. 67., No1/2017. pp. 41-53

  10. Sadalage, Pramod J., Fowler, M., 2012. NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence, ISBN-13: 978-0321826626.

  11. McCreary, D., Kelly, A., 2013. Making Sense of NoSQL: A guide for managers and the rest of us. Manning Publications, 312 p. ISBN 978-1-61729-107-4.

  12. Tweed, R.; George, J., 2010. A Universal NoSQL Engine, Using a Tried and Tested Technology. http://www.mgateway.com/docs/universalNoSQL.pdf.

Citing literature

Number of times cited according to Crossref: 1

View or Download full articleAccess options
Full paper accessChoose SWS login, librarian support, or instant article download.

SWS access login

Login as SWS Scientific Committee

Authors and approved SWS contributors will read and export their own linked papers after identity matching by SWS profile, email and SGEM GlobalID.

For librarian assistance: [email protected]

Purchase Instant Access

48-hour online accessComing soon
Online-only accessComing soon
Download the full article in PDF formatEUR 35
  • Article can be downloaded after successful payment.
  • Article may be used according to SWS library access terms.
  • Article cannot be redistributed.
Get full paper

Back to publication list