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

Yesin, V.I.; Karpinski, Mikolaj; Yesina, M.V.; Vilihura, V.V.

doi:10.47839/ijc.18.4.1615

Cited by 3 publications

(6 citation statements)

References 5 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…For this purpose, the commands (statements) GRANT / REVOKE of the SQL standard are used. In addition, taking into account the peculiarities of the schema and the possibilities of using the DB with UBR [6,7], an additional mechanism for granting privileges was developed, implemented within the framework of RLS (Row Level Security) technology (also known as Fine Grained Access Control (FGAC) and Virtual Private Database (VPD)) [34][35][36][37][38][39], which required the introduction of some additional relations to the existing basic schema of the database with UBR:…”

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

confidence: 99%

“…When developing the main objects of the database schema with UBR, in order to protect the database from violation of the consistency of the data stored in it, the capabilities of both methods were used. Namely, in the created schema, using the integrity support means provided by the SQL language standard, implementations of the Pr sh integrity constraints obtained as a result of the mapping were defined: γ : Pr → Pr sh (where Pr is the set of integrity constraints that are specified in the data model with UBR (M ubr ) [6]).…”

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

confidence: 99%

“…The constrains on possibility: Changing SD metadata entered into the corresponding relations of the schema (e.g., the maximum values of max_vals ∈ at(R sh event_prop_types )) and the removal of the list values for the corresponding characteristics from the relations R sh pr_vals , R sh ev_pr_vals , and R sh meas_vals if they are present in the relations associated with the data of the modeled SD [6];…”

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

confidence: 99%

“…The objective of our paper was to present techniques and means that ensure the integrity of the main components of the database with a universal basis of relations (UBR) [6].…”

Section: Introductionmentioning

confidence: 99%

See 3 more Smart Citations

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

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

confidence: 99%

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

confidence: 99%

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

confidence: 99%

“…The objective of our paper was to present techniques and means that ensure the integrity of the main components of the database with a universal basis of relations (UBR) [6].…”

Section: Introductionmentioning

confidence: 99%

See 2 more Smart Citations

Ensuring Data Integrity in Databases with the Universal Basis of Relations

et al. 2021

Self Cite

View full text Add to dashboard Cite

show abstract

“…However, quite often, there is a need for masking not only numerical values. For example, in databases built on the basis of a schema with the universal basis of relations [25] that can be used, including data warehouses of various subject domains, the attributes of relations containing sensitive data are defined on the domain of character strings. At the same time, attempts to apply the masking procedure to non-numerical data in the modified MOBAT technique described in [19] would not be successful.…”

Section: Related Workmentioning

confidence: 99%

Hiding the Source Code of Stored Database Programs

et al. 2020

Self Cite

View full text Add to dashboard Cite

The objective of the article is to reveal an approach to hiding the code of stored programs stored in the database. The essence of this approach is the complex use of the method of random permutation of code symbols related to a specific stored program, located in several rows of some attribute of the database system table, as well as the substitution method. Moreover, with the possible substitute of each character obtained after the permutation with another one randomly selected from the Unicode standard, a legitimate user with the appropriate privileges gets access to the source code of the stored program due to the ability to quickly perform the inverse to masking transformation and overwrite the program code into the database. All other users and attackers without knowledge of certain information can only read the codes of stored programs masked with format preserving. The proposed solution is more efficient than the existing methods of hiding the code of stored programs provided by the developers of some modern database management systems (DBMS), since an attacker will need much greater computational and time consumption to disclose the source code of stored programs.

show abstract

Technique for Evaluating the Security of Relational Databases Based on the Enhanced Clements–Hoffman Model

et al. 2021

Self Cite

View full text Add to dashboard Cite

Obtaining convincing evidence of database security, as the basic corporate resource, is extremely important. However, in order to verify the conclusions about the degree of security, it must be measured. To solve this challenge, the authors of the paper enhanced the Clements–Hoffman model, determined the integral security metric and, on this basis, developed a technique for evaluating the security of relational databases. The essence of improving the Clements–Hoffmann model is to expand it by including a set of object vulnerabilities. Vulnerability is considered as a separate objectively existing category. This makes it possible to evaluate both the likelihood of an unwanted incident and the database security as a whole more adequately. The technique for evaluating the main components of the security barriers and the database security as a whole, proposed by the authors, is based on the theory of fuzzy sets and risk. As an integral metric of database security, the reciprocal of the total residual risk is used, the constituent components of which are presented in the form of certain linguistic variables. In accordance with the developed technique, the authors presented the results of a quantitative evaluation of the effectiveness of the protection of databases built on the basis of the schema with the universal basis of relations and designed in accordance with the traditional technology of relational databases.

show abstract

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

Cited by 3 publications

References 5 publications

Ensuring Data Integrity in Databases with the Universal Basis of Relations

Ensuring Data Integrity in Databases with the Universal Basis of Relations

Hiding the Source Code of Stored Database Programs

Technique for Evaluating the Security of Relational Databases Based on the Enhanced Clements–Hoffman Model

Contact Info

Product

Resources

About