Formal Language for Description of Transactions in Relational Databases
The article deals with some applied aspects of the design of a distributed information system. The structure of the system is proposed, including components for storing, processing and caching data. The proposed universal storage unit is compatible with relational and non-relational database management systems. The main scenarios for the interaction of all nodes of the information system are described, in particular, the scenario for caching the results of user requests. The issues of data access control and two approaches for ensuring data security are considered. Both approaches use a transaction as a unit of data exchange. The first approach involves the transfer of extended information about the transaction, including the sequence of actions and the context of the transaction. The second approach is based on storing the sequence of actions in the form of a transaction descriptor in the database and involves transferring only the context. The advantages and disadvantages of each of the approaches are considered.