Automation of Tabular Application Formation
The paper considers automation problems of the interface formation between a table and a relational database. The task description is formalized and the description of the existing approaches to formation of data representations on an example of widely widespread CASE-tools is submitted. The definit...
Main Author: | |
---|---|
Format: | Article |
Language: | English |
Published: |
Yaroslavl State University
2013-08-01
|
Series: | Моделирование и анализ информационных систем |
Subjects: | |
Online Access: | https://www.mais-journal.ru/jour/article/view/183 |
_version_ | 1797877938382700544 |
---|---|
author | S. V. Zykin |
author_facet | S. V. Zykin |
author_sort | S. V. Zykin |
collection | DOAJ |
description | The paper considers automation problems of the interface formation between a table and a relational database. The task description is formalized and the description of the existing approaches to formation of data representations on an example of widely widespread CASE-tools is submitted. The definition of intermediate data representation as a ”join table” is offered, which is used for maintenance of correctness of data representation formation, and also is necessary for direct and inverse data transformations. On the basis of lossless join property and realized dependencies, the concept and a way of context formation of the application and restrictions is introduced. The considered material is further used for constructing an inverse data transformation from tabular presentation into a relational one. On the basis of relationships properties on a database scheme, the partial order on the relations is established, and the restriction of acyclic databases schemes is introduced. The received results are further used at the analysis of principles of formation of inverse data transformation, and the basic details of such a transformation algorithm are considered. |
first_indexed | 2024-04-10T02:24:43Z |
format | Article |
id | doaj.art-3dd7cb9c7ff04ad59d60736f3f31c3c1 |
institution | Directory Open Access Journal |
issn | 1818-1015 2313-5417 |
language | English |
last_indexed | 2024-04-10T02:24:43Z |
publishDate | 2013-08-01 |
publisher | Yaroslavl State University |
record_format | Article |
series | Моделирование и анализ информационных систем |
spelling | doaj.art-3dd7cb9c7ff04ad59d60736f3f31c3c12023-03-13T08:07:32ZengYaroslavl State UniversityМоделирование и анализ информационных систем1818-10152313-54172013-08-01204415410.18255/1818-1015-2013-4-41-54177Automation of Tabular Application FormationS. V. Zykin0Федеральное государственное бюджетное учреждение науки Институт математики им. С.Л. Соболева Сибирского Отделения Российской академии наукThe paper considers automation problems of the interface formation between a table and a relational database. The task description is formalized and the description of the existing approaches to formation of data representations on an example of widely widespread CASE-tools is submitted. The definition of intermediate data representation as a ”join table” is offered, which is used for maintenance of correctness of data representation formation, and also is necessary for direct and inverse data transformations. On the basis of lossless join property and realized dependencies, the concept and a way of context formation of the application and restrictions is introduced. The considered material is further used for constructing an inverse data transformation from tabular presentation into a relational one. On the basis of relationships properties on a database scheme, the partial order on the relations is established, and the restriction of acyclic databases schemes is introduced. The received results are further used at the analysis of principles of formation of inverse data transformation, and the basic details of such a transformation algorithm are considered.https://www.mais-journal.ru/jour/article/view/183табличные приложенияреляционная база данныханалитическая обработка данныхсоединение без потерь |
spellingShingle | S. V. Zykin Automation of Tabular Application Formation Моделирование и анализ информационных систем табличные приложения реляционная база данных аналитическая обработка данных соединение без потерь |
title | Automation of Tabular Application Formation |
title_full | Automation of Tabular Application Formation |
title_fullStr | Automation of Tabular Application Formation |
title_full_unstemmed | Automation of Tabular Application Formation |
title_short | Automation of Tabular Application Formation |
title_sort | automation of tabular application formation |
topic | табличные приложения реляционная база данных аналитическая обработка данных соединение без потерь |
url | https://www.mais-journal.ru/jour/article/view/183 |
work_keys_str_mv | AT svzykin automationoftabularapplicationformation |