Reformulating Table Constraints using Functional Dependencies—An Application to Explanation Generation

被引:0
|
作者
Hadrien Cambazard
Barry O’Sullivan
机构
[1] University College Cork,Cork Constraint Computation Centre Department of Computer Science
来源
Constraints | 2008年 / 13卷
关键词
Table constraints; Functional dependencies; Explanation generation;
D O I
暂无
中图分类号
学科分类号
摘要
We present a novel approach to automatically reformulating constraints defined as tables of allowed assignments to variables. Constraints of this form are common in a variety of settings. Specifically, we propose an approach in which a high arity table constraint is reformulated as a conjunction of lower arity constraints. The reformulation is logically equivalent to the original constraint. We demonstrate that by using functional dependencies from the field of database design such reformulations can be found. We apply the approach to the problem of generating explanations as minimal conflicts. We show that reformulations can be found that yield compact explanations of inconsistency by reducing both the number of variables required to explain inconsistency and the arity of the largest constraint involved in the explanation. We demonstrate our approach on real-world datasets with positive results.
引用
收藏
页码:385 / 406
页数:21
相关论文
共 50 条
  • [31] FUNCTIONAL-DEPENDENCIES AND DISJUNCTIVE EXISTENCE CONSTRAINTS IN DATABASE RELATIONS WITH NULL VALUES
    ATZENI, P
    MORFUNI, NM
    LECTURE NOTES IN COMPUTER SCIENCE, 1984, 172 : 69 - 81
  • [32] An SQL Data Summarization Tool for the Acquisition of Meaningful Cardinality Constraints and Functional Dependencies
    Gandhi, Aniruddh
    Kohler, Henning
    Hartmann, Sven
    Link, Sebastian
    2018 IEEE 34TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING (ICDE), 2018, : 1549 - 1552
  • [33] AN APPLICATION OF FUNCTIONAL-DEPENDENCIES TO THE TOPOLOGICAL ANALYSIS OF PROTECTION SCHEMES
    JENKINS, L
    KHINCHA, HP
    SHIVAKUMAR, S
    DASH, PK
    IEEE TRANSACTIONS ON POWER DELIVERY, 1992, 7 (01) : 77 - 83
  • [34] Skycube Materialization Using the Topmost Skyline or Functional Dependencies
    Maabout, Sofian
    Ordonez, Carlos
    Wanko, Patrick Kamnang
    Hanusse, Nicolas
    ACM TRANSACTIONS ON DATABASE SYSTEMS, 2016, 41 (04):
  • [35] Cardinality constraints and functional dependencies in SQL: Taming data redundancy in logical database design
    Link, Sebastian
    Koehler, Henning
    Gandhi, Aniruddh
    Hartmann, Sven
    Thalheim, Bernhard
    INFORMATION SYSTEMS, 2023, 115
  • [36] Modelling functional dependencies in databases using mathematical logic
    Lovrencic, Alen
    Cubrilo, Mirko
    Kisasondi, Tonimir
    INES 2007: 11TH INTERNATIONAL CONFERENCE ON INTELLIGENT ENGINEERING SYSTEMS, PROCEEDINGS, 2007, : 307 - +
  • [37] Efficient discovery of functional and approximate dependencies using partitions
    Huhtala, Y
    Karkkainen, J
    Porkka, P
    Toivonen, H
    14TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING, PROCEEDINGS, 1998, : 392 - 401
  • [38] Answering queries using views in the presence of functional dependencies
    Hong, J
    Liu, WR
    Bell, D
    Bai, QY
    DATABASE: ENTERPRISE, SKILLS AND INNOVATION, PROCEEDINGS, 2005, 3567 : 70 - 81
  • [40] Test data generation for web application using a UML class diagram with OCL constraints
    Fujiwara, Shoichiro
    Munakata, Kazuki
    Maeda, Yoshiharu
    Katayama, Asako
    Uehara, Tadahiro
    INNOVATIONS IN SYSTEMS AND SOFTWARE ENGINEERING, 2011, 7 (04) : 275 - 282