
Methods of forming the join table
Author(s) -
С. В. Зыкин
Publication year - 2019
Publication title -
journal of physics. conference series
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.21
H-Index - 85
eISSN - 1742-6596
pISSN - 1742-6588
DOI - 10.1088/1742-6596/1260/4/042005
Subject(s) - join (topology) , table (database) , computer science , associative property , database , mathematics , combinatorics , pure mathematics
The present work considers the methods of forming data views as a join table intended to be used in table-driven user applications, such as spreadsheets, multidimensional arrays, etc. The main purpose of the join table is to organize the interaction of such applications with the corporate database. The join table can be used at a physical level. This will significantly reduce the time required to generate custom data views in the applications. The use of the join table becomes inefficient, if it needs to be changed in a short period of time. However, the use of storage devices with associative access or “logic-per-track” devices for data processing will significantly reduce the join table transformation time.