Ensuring Database Security with the Universal Basis of Relations

Yesin, V.I.; Yesina, M.V.; Рассомахин, С. Г.; Karpinski, Mikolaj

doi:10.1007/978-3-319-99954-8_42

Cited by 5 publications

(8 citation statements)

References 1 publication

Supporting

Mentioning

Contrasting

Order By: Relevance

“…But, quite often there is a need for masking not only numerical values. For example, in databases built on the basis of the schema with the universal basis of relations [16,17], that can be used, including as data warehouse of various subject domains, the attributes (columns) of relations (tables) containing sensitive data are defined on the domain of character strings.…”

Section: Preliminaries Data Masking Methods Based On the Calculation mentioning

confidence: 99%

Some approach to data masking as means to counteract the inference threat

Yesin¹,

Vilihura²

2019

Radiotekhnika

View full text Add to dashboard Cite

Section: Preliminaries Data Masking Methods Based On the Calculation mentioning

confidence: 99%

Some approach to data masking as means to counteract the inference threat

Yesin¹,

Vilihura²

2019

Radiotekhnika

View full text Add to dashboard Cite

“…where oper j i is j-th combination (from values select, update, delete, and insert) of allowed access operations (transformation procedures (TPs)) to the relation R sh i ∈ R sh (as one of the CDI elements); policy k i is the name of the k-th RLS policy, which is applied to the base relation R sh i ; Ψ l i ∈ Ψ is the name of the l-th function that generates the predicate for the base relation R sh i ; attr µkl i is the value of the µ-th parameter for the k-th RLS policy and the l-th function; pat R sh i contr is pattern of the commands for managing access to R sh i (an example of one of such patterns is given in [40] in the form of program code elements).…”

Section: Applying the Clark-wilson Model Recommendations To Ensure The Integrity Of Databases With The Universal Basis Of Relationsmentioning

confidence: 99%

“…For this purpose, triggers are also used that support the logging of operations performed in the database. In addition, for accountability of user actions, data from the log table of the modified data can be used [40]. Thanks to the information stored in the log table, which is automatically formed when the corresponding parameter of the stored procedure of the data model language interpreter is specified, the process of recovering incorrectly modified or lost data is simplified, and the procedure for determining the users, times, and nature of the modifications made by them is facilitated.…”

Section: Applying the Clark-wilson Model Recommendations To Ensure The Integrity Of Databases With The Universal Basis Of Relationsmentioning

confidence: 99%

Ensuring Data Integrity in Databases with the Universal Basis of Relations

et al. 2021

Self Cite

View full text Add to dashboard Cite

The objective of the paper was to reveal the main techniques and means of ensuring the integrity of data and persistent stored database modules implemented in accordance with the recommendations of the Clark–Wilson model as a methodological basis for building a system that ensures integrity. The considered database was built according to the schema with the universal basis of relations. The mechanisms developed in the process of researching the problem of ensuring the integrity of the data and programs of such a database were based on the provisions of the relational database theory, the Row Level Security technology, the potential of the modern blockchain model, and the capabilities of the database management system on the platform of which databases with the universal basis of relations are implemented. The implementation of the proposed techniques and means, controlling the integrity of the database of stored elements, prevents their unauthorized modification by authorized subjects and hinders the introduction of changes by unauthorized subjects. As a result, the stored data and programs remain correct, unaltered, undistorted, and preserved. This means that databases built based on a schema with the universal basis of relations and supported by such mechanisms are protected in terms of integrity.

show abstract

“…Such data model allows us to get rid of the need for a cost policy of performing unnecessary work. Based on a variety of different analyzed sources, including [9][10][11][12][13][14][15][16][17][18], and the need to solve this problem, the main requirements for the model being developed are:…”

Section: Requirements For the Modelmentioning

confidence: 99%

Formalized Representation for the Data Model With the Universal Basis of Relations

Yesin¹,

Karpinski²,

Yesina³

et al. 2019

IJC

Self Cite

View full text Add to dashboard Cite

The goal of the article is to develop a universal (standard) data model that allows you to get rid of the need for a costly policy of doing extra work when developing new ones or transforming existing relational databases (RDBs) caused by dynamic changes in the subject domain (SD). The requirements for the developed data model were formulated. In accordance with the formulated requirements, the data model was synthesized. To simplify the process of creating relational database schemas an algorithm for transforming the description of the subject domain into the relations of the universal basis of the developed model was proposed. The scientific novelty of the obtained results is: a data model that, unlike known ones, allows us to simplify the creation of RDB schemas at the stage of logical design of relational databases, under the conditions of dynamic changes in subject domains, due to the introduced universal basis of relations, as a means of describing structures and the presentation of data for various SDs has been developed.

show abstract

Ensuring Database Security with the Universal Basis of Relations

Cited by 5 publications

References 1 publication

Some approach to data masking as means to counteract the inference threat

Some approach to data masking as means to counteract the inference threat

Ensuring Data Integrity in Databases with the Universal Basis of Relations

Formalized Representation for the Data Model With the Universal Basis of Relations

Contact Info

Product

Resources

About