RUS  ENG JOURNALS   PEOPLE   ORGANISATIONS   CONFERENCES   SEMINARS   VIDEO LIBRARY   PACKAGE AMSBIB
General information
Latest issue
Archive
Impact factor

Search papers
Search references

RSS
Latest issue
Current issues
Archive issues
What is RSS



Model. Anal. Inform. Sist.:
Year:
Volume:
Issue:
Page:
Find






Personal entry:
Login:
Password:
Save password
Enter
Forgotten password?
Register


Model. Anal. Inform. Sist., 2016, Volume 23, Number 2, Pages 93–118 (Mi mais493)  

Building a data store with the dynamic structure

Yu. N. Artamonov

Federal state budgetary scientific institution Gosmetodcentr, Lyusinovskaya str., 51, Moscow, 117997 Russia

Abstract: This article presents the analysis of approaches to data warehouse construction based on relational and NoSQL solutions and lists the limitations of the relational approach to data mining. The contradiction between data presentation in the real subject domain and the model of data presentation in the relational and NoSQL approaches is revealed. The revealed contradiction is related to the temporality of the values of individual data attributes, the variability of the composition of these attributes, and structure of connections between them. A new logical model of the data warehouse with dynamic structure is proposed. The model is based on the concept of the object as a container for properties storage. Each property of the object includes the property name and two property values — without reference and with reference, that are relevant at a given time. The reference property value points to an object whose name is interpreted as the value of the property at a given time. A formal description of the model with allocation of the necessary functionality to manipulate objects and their properties (selectors, predicates, constructors) is given and the necessary control structures are introduced. Substantiation of the proposed model, called an OP-model is given on the basis of compliance with the logical ER data model. It is proved that any ER data model can be implemented in the OP-model. At the same time, the advantages of the OP-model are indicated, they are associated with the possibility of changing connections between entities due to changes in the reference value at a particular time. The potential for scalability of data warehouse due to the unique identification of each object is noted.

Keywords: NoSQL, Big Data, ER model, Databases, DBMS.

Funding Agency Grant Number
Ministry of Education and Science of the Russian Federation 2.87.2016/
This work was supported by the state task of the Ministry of Education and Science of the Russian under the project 2.87.2016/


DOI: https://doi.org/10.18255/1818-1015-2016-2-93-118

Full text: PDF file (336 kB)
References: PDF file   HTML file

Bibliographic databases:

UDC: 004.652.6
Received: 24.02.2016

Citation: Yu. N. Artamonov, “Building a data store with the dynamic structure”, Model. Anal. Inform. Sist., 23:2 (2016), 93–118

Citation in format AMSBIB
\Bibitem{Art16}
\by Yu.~N.~Artamonov
\paper Building a data store with the dynamic structure
\jour Model. Anal. Inform. Sist.
\yr 2016
\vol 23
\issue 2
\pages 93--118
\mathnet{http://mi.mathnet.ru/mais493}
\crossref{https://doi.org/10.18255/1818-1015-2016-2-93-118}
\mathscinet{http://www.ams.org/mathscinet-getitem?mr=3513355}
\elib{http://elibrary.ru/item.asp?id=25810345}


Linking options:
  • http://mi.mathnet.ru/eng/mais493
  • http://mi.mathnet.ru/eng/mais/v23/i2/p93

    SHARE: VKontakte.ru FaceBook Twitter Mail.ru Livejournal Memori.ru


    Citing articles on Google Scholar: Russian citations, English citations
    Related articles on Google Scholar: Russian articles, English articles
  • Number of views:
    This page:243
    Full text:104
    References:28

     
    Contact us:
     Terms of Use  Registration  Logotypes © Steklov Mathematical Institute RAS, 2020