ABSTRACTS OF ARTICLES OF THE JOURNAL "INFORMATION TECHNOLOGIES".
No. 5. Vol. 24. 2018

DOI: 10.17587/it.24.330-338

S. V. Zykin, D. Sc., Professor, Head of Laboratory, e-mail: szykin@mail.ru, Sobolev Institute of Mathematics SB RAS, Novosibirsk, Russia, V. S. Zykin, Postgraduate, e-mail: vszykin@mail.ru, Omsk State Technical University, Omsk, Russia

Commutative Conversion in the Database when Editing a Multitable Query

Theoretical aspects of the formation of applications for editing data in relational databases are considered. This important problem has not yet been satisfactorily resolved. That problem has been solved by "hard" restrictions on the views and it requires the highly qualified user when using these components. In this paper, the theoretical aspects of the applications formation for work with a relational database are discussed. The application works with a data view such as table formed by a set of database relations using "join – select – projection" queries. The implementation of data editing functions: inserting, deleting and updating of tuples in the table are the requirement for such applications. The application must convert the source database according to the user's view editing providing that the conversion satisfy the commutativity condition. Formulas of relational algebra are obtained for these transformations. The correctness of the transformations is proved. The theory in this paper is the basis for creating a new technology for generating of multitable applications. The technology involves creating a template program, where a query and its restrictions are implemented. The operations of relational algebra are transformed into SQL commands. As a result, the user obtains a ready-to-run program that implements editing of multitable views.
Keywords: relational database, commutative transformations, relational algebra, views editing

P. 330–338

To the contents