arrow
Return

Translating a Distributed Relational Database to a Document Database

delete2022-03-03
delete6
delete
OA
AI
М
Мuon Ha
Y
Yulia Shichkina *
DOI:10.1007/s41019-022-00181-9delete
deleteOriginal
deleteOriginal request for help
deleteShare
deleteSave
Abstract

Abstract

En 中文
The problem of transferring data from a database of one type to a database of another type is relevant today due to the increase in data volumes and the complexity of tasks solved in various fields of human activity. The existing databases are less and less satisfying the needs of users. New types of databases appear that are more suitable for solving large-scale problems. This article proposes an algorithm for solving the problem of optimizing the document structure of a database based on metadata about the structure of a distributed relational database from which data are transferred. The approach also takes into account information about the structure of the priority database queries. The priority of database queries is user-defined. The system of automatic translation of the database, taking into account these metadata, allows the user to create a distributed document database that is optimal in two parameters: in terms of the volume of stored data and in terms of the execution time of priority database queries.
Keywords:
NoSQL
Database query
Collection
Document
Database structure optimization
Embedded documents

Journal

D
Data Science and Engineering
IF:
4.6
Papers:
246
Citations:
665

Organization

S
Saint Petersburg State Electrotechnical University
Scholars:
643
Papers: 347
Citations: 226