Models of integrity assurance in big relational databases

被引:0
|
作者
Malikov, Andrey [1 ]
Voronkin, Vladimir [1 ]
Shiryaev, Nikolay [1 ]
机构
[1] North Caucasus Fed Univ, Dept Appl Informat Sci, 1 Pushkin St, Stavropol, Russia
关键词
D O I
10.1109/QUATIC.2016.39
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
This paper explores the issue of group integrity of tuple subsets regarding corporate integrity constraints in relational databases. A solution may be found by applying the finite-state machine theory to guarantee group integrity of data. We present a practical guide to coding such an automaton. After creating SQL queries to manipulate data and control its integrity for real data domains, we study the issue of query performance, determine the level of transaction isolation, and generate query plans.
引用
收藏
页码:179 / 184
页数:6
相关论文
共 50 条
  • [1] Towards semantic integrity in relational databases
    Botha, RA
    [J]. SECURITY IN THE INFORMATION SOCIETY: VISIONS AND PERSPECTIVES, 2002, 86 : 287 - 297
  • [2] High-assurance integrity techniques for databases
    Bertino, Elisa
    Dai, Chenyun
    Lim, Hyo-Sang
    Lin, Dan
    [J]. SHARING DATA, INFORMATION AND KNOWLEDGE, PROCEEDINGS, 2008, 5071 : 244 - 256
  • [3] On a static verification of integrity constraints in relational databases
    Kachniarz, J
    Szalas, A
    [J]. RELATIONAL METHODS FOR COMPUTER SCIENCE APPLICATIONS, 2001, 65 : 97 - 109
  • [5] On Repairing Referential Integrity Constraints in Relational Databases
    Ghawi, Raji
    [J]. BEYOND DATABASES, ARCHITECTURES AND STRUCTURES (BDAS): PAVING THE ROAD TO SMART DATA PROCESSING AND ANALYSIS, 2019, 1018 : 82 - 96
  • [6] A generalisation of entity and referential integrity in relational databases
    Levene, M
    Loizou, G
    [J]. RAIRO-INFORMATIQUE THEORIQUE ET APPLICATIONS-THEORETICAL INFORMATICS AND APPLICATIONS, 2001, 35 (02): : 113 - 127
  • [7] Dependencies in relational models of databases
    Winter, Michael
    [J]. JOURNAL OF LOGICAL AND ALGEBRAIC METHODS IN PROGRAMMING, 2016, 85 (05) : 1095 - 1107
  • [8] Integrity Assurance for Outsourced Databases without DBMS Modification
    Wei, Wei
    Yu, Ting
    [J]. DATA AND APPLICATIONS SECURITY AND PRIVACY XXVIII, 2014, 8566 : 1 - 16
  • [9] Implementing Integrity Assurance System for Big Data
    Alyami, Fawaz
    Almutairi, Saad
    [J]. WIRELESS PERSONAL COMMUNICATIONS, 2022, 122 (03) : 2585 - 2601
  • [10] Implementing Integrity Assurance System for Big Data
    Fawaz Alyami
    Saad Almutairi
    [J]. Wireless Personal Communications, 2022, 122 : 2585 - 2601