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 条
  • [41] PATH CONSTRAINTS FOR GRAPH-BASED DATA MODELS - TOWARDS A UNIFIED THEORY OF TYPING CONSTRAINTS, EQUATIONS, AND FUNCTIONAL-DEPENDENCIES
    COBURN, N
    WEDDELL, GE
    LECTURE NOTES IN COMPUTER SCIENCE, 1991, 566 : 312 - 331
  • [42] Tradeoff generation using soft constraints
    Bistarelli, S
    Kelleher, J
    O'Sullivan, B
    RECENT ADVANCES IN CONSTRAINTS, 2004, 3010 : 124 - 139
  • [43] Discovering Approximate Functional Dependencies using Smoothed Mutual Information
    Pennerath, Frederic
    Mandros, Panagiotis
    Vreeken, Jilles
    KDD '20: PROCEEDINGS OF THE 26TH ACM SIGKDD INTERNATIONAL CONFERENCE ON KNOWLEDGE DISCOVERY & DATA MINING, 2020, : 1254 - 1264
  • [44] A complete axiomatization of fuzzy functional dependencies using fuzzy function
    Tyagi, BK
    Sharfuddin, A
    Dutta, RN
    Tayal, DK
    FUZZY SETS AND SYSTEMS, 2005, 151 (02) : 363 - 379
  • [45] Extracting Functional Dependencies in Large Datasets Using MapReduce Model
    Amshakala, K.
    Nedunchezhian, R.
    Rajalakshmi, M.
    INTERNATIONAL JOURNAL OF INTELLIGENT INFORMATION TECHNOLOGIES, 2014, 10 (03) : 19 - 35
  • [46] Mining frequent conjunctive queries using functional and inclusion dependencies
    Cheikh Tidiane Dieng
    Tao-Yuan Jen
    Dominique Laurent
    Nicolas Spyratos
    The VLDB Journal, 2013, 22 : 125 - 150
  • [47] Relationship design using spreadsheet reasoning for sets of functional dependencies
    Demetrovics, Janos
    Molnar, Andras
    Thalheim, Bernhard
    ADVANCES IN DATABASES AND INFORMATION SYSTEMS, PROCEEDINGS, 2006, 4152 : 108 - 123
  • [48] Rewriting Aggregate Queries Using Functional Dependencies within the Cloud
    Perriot, Romain
    d'Orazio, Laurent
    Laurent, Dominique
    Spyratos, Nicolas
    INFORMATION SEARCH, INTEGRATION, AND PERSONALIZATION, 2014, 421 : 31 - 42
  • [49] Query rewriting using views in the presence of functional and inclusion dependencies
    Gryz, J
    INFORMATION SYSTEMS, 1999, 24 (07) : 597 - 612
  • [50] Using Functional Dependencies in Conversion of Relational Databases to Graph Databases
    Megid, Youmna A.
    El-Tazi, Neamat
    Fahmy, Aly
    DATABASE AND EXPERT SYSTEMS APPLICATIONS (DEXA 2018), PT II, 2018, 11030 : 350 - 357