Enforcing integrity constraints to preserve data accuracy in business applications

被引:0
|
作者
Lupsoiu, Constantin [1 ]
Boboila, Cristea [1 ]
机构
[1] Univ Craiova, Fac Math & Comp Sci, RO-200585 Craiova, Romania
关键词
relational databases; integrity constraints; functional dependency; multivalued dependency; join dependency;
D O I
暂无
中图分类号
TP39 [计算机的应用];
学科分类号
081203 ; 0835 ;
摘要
Integrity constraints represent a method of ensuring that database updates do not result in data inconsistencies. For business applications in particular, the accuracy of the data is important. Therefore, we need strong guarantees that the information stored in the database system is not tempered with. This paper presents some algorithms for testing the integrity constraints given by the functional, join and multivalued dependencies. Since the update operations are costly, the algorithms described take into consideration efficiency requirements.
引用
收藏
页码:79 / 84
页数:6
相关论文
共 50 条
  • [31] Preserving Referential Integrity Constraints in XML Data Transformation
    Shahriar, Md. Sumon
    Liu, Jixue
    [J]. DATABASE THEORY AND APPLICATION, 2009, 64 : 57 - 65
  • [32] Temporal data modelling and integrity constraints in relational databases
    Tansel, Abdullah Uz
    [J]. INTERNATIONAL JOURNAL OF COMPUTER MATHEMATICS- COMPUTER SYSTEMS THEORY, 2024, 9 (01) : 1 - 20
  • [33] Synthesizing Data Structure Refinements from Integrity Constraints
    Pailoor, Shankara
    Wang, Yuepeng
    Wang, Xinyu
    Dillig, Isil
    [J]. PROCEEDINGS OF THE 42ND ACM SIGPLAN INTERNATIONAL CONFERENCE ON PROGRAMMING LANGUAGE DESIGN AND IMPLEMENTATION (PLDI '21), 2021, : 574 - 587
  • [34] Temporal data modeling and integrity constraints in relational databases
    Tansel, AU
    [J]. COMPUTER AND INFORMATION SCIENCES - ISCIS 2004, PROCEEDINGS, 2004, 3280 : 459 - 469
  • [35] Efficient refinement of uncertain data by fuzzy integrity constraints
    Chang, CS
    Chen, ALP
    [J]. INFORMATION SCIENCES, 1998, 104 (3-4) : 191 - 211
  • [36] Synthesizing Linked Data Under Cardinality and Integrity Constraints
    Gilad, Amir
    Patwa, Shweta
    Machanavajjhala, Ashwin
    [J]. SIGMOD '21: PROCEEDINGS OF THE 2021 INTERNATIONAL CONFERENCE ON MANAGEMENT OF DATA, 2021, : 619 - 631
  • [37] Enforcing Local Non-Zero Constraints in PDEs and Applications to Hybrid Imaging Problems
    Alberti, Giovanni S.
    [J]. COMMUNICATIONS IN PARTIAL DIFFERENTIAL EQUATIONS, 2015, 40 (10) : 1855 - 1883
  • [38] Data mining business applications
    Garrido, Lluis
    Latorre, Jose Ignacio
    [J]. Questiio, 2001, 25 (03): : 499 - 508
  • [39] Business applications of data mining
    Apte, C
    Liu, B
    Pednault, E
    Smyth, P
    [J]. COMMUNICATIONS OF THE ACM, 2002, 45 (08) : 49 - 53
  • [40] Compliance validation and diagnosis of business data constraints in business processes at runtime
    Teresa Gomez-Lopez, Maria
    Gasca, Rafael M.
    Miguel Perez-Alvarez, Jose
    [J]. INFORMATION SYSTEMS, 2015, 48 : 26 - 43