SpringerLink
Log in

From Database Repairs to Causality in Databases and Beyond

  • Chapter
  • First Online:
Transactions on Large-Scale Data- and Knowledge-Centered Systems LIV

Part of the book series: Lecture Notes in Computer Science ((TLDKS,volume 14160))

Abstract

We describe some recent approaches to score-based explanations for query answers in databases. The focus is on work done by the author and collaborators. Special emphasis is placed on the use of counterfactual reasoning for score specification and computation. Several examples that illustrate the flexibility of these methods are shown.

L. Bertossi—Member of the Millennium Inst. for Foundational Research on Data (IMFD, Chile).

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution

Subscribe and save

Springer+ Basic
EUR 32.99 /Month
  • Get 10 units per month
  • Download Article/Chapter or Ebook
  • 1 Unit = 1 Article or 1 Chapter
  • Cancel anytime
Subscribe now

Buy Now

Chapter
EUR 29.95
Price includes VAT (Germany)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
EUR 50.28
Price includes VAT (Germany)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
EUR 64.19
Price includes VAT (Germany)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free ship** worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Similar content being viewed by others

Notes

  1. 1.

    The fact that it is open is not particularly relevant, because we can instantiate the query with the answer, obtaining a Boolean query.

  2. 2.

    The original paper and related ones on the Shapley value can be found in the book edited by Alvin Roth [28]. Shapley and Roth shared the Nobel Prize in Economic Sciences 2012.

References

  1. Arora, S., Barak, B.: Computational Complexity. Cambridge University Press, Cambridge (2009)

    Book  MATH  Google Scholar 

  2. Arenas, M., Bertossi, L., Chomicki, J. Consistent query answers in inconsistent databases. In: Proceedings of the ACM PODS, pp. 68–79 (1999)

    Google Scholar 

  3. Bertossi, L.: Database repairing and consistent query answering. Synthesis Lectures in Data Management. Morgan & Claypool (2011)

    Google Scholar 

  4. Bertossi, L., Salimi, B.: From Causes for database queries to repairs and model-based diagnosis and back. Theory Comput. Syst. 61(1), 191–232 (2017). https://doi.org/10.1007/s00224-016-9718-9

    Article  MathSciNet  MATH  Google Scholar 

  5. Bertossi, L., Salimi, B.: Causes for query answers from databases: datalog abduction, view-updates, and integrity constraints. Int. J. Approximate Reason. 90, 226–252 (2017)

    Article  MathSciNet  MATH  Google Scholar 

  6. Bertossi, L.: Specifying and computing causes for query answers in databases via database repairs and repair programs. Knowl. Inf. Syst. 63(1), 199–231 (2021)

    Article  Google Scholar 

  7. Bertossi, L.: Declarative approaches to counterfactual explanations for classification. Theory Pract. Logic Program. 23(3), 559–593 (2023). ar**v Paper 2011.07423

    Google Scholar 

  8. Bertossi, L.: Attribution-scores and causal counterfactuals as explanations in artificial intelligence. In: Reasoning Web: Causality, Explanations and Declarative Knowledge. Springer LNCS 13759 (2023). https://doi.org/10.1007/978-3-031-31414-8_1

  9. Bertossi, L., Kimelfeld, B., Livshits, E., Monet, M.: The Shapley Value in Database Management. ACM SIGMOD Rec. 52(2), 6–17 (2023)

    Article  Google Scholar 

  10. Buneman, P., Khanna, S., Tan, W.C.: Why and where: a characterization of data provenance. Proceedings of ICDT, pp. 316–330 (2001)

    Google Scholar 

  11. Chockler, H., Halpern, J.: Responsibility and blame: a structural-model approach. J. Artif. Intell. Res. 22, 93–115 (2004)

    Article  MathSciNet  MATH  Google Scholar 

  12. Deng, X., Papadimitriou, C.: On the complexity of cooperative solution concepts. Math. Oper. Res. 19(2), 257–266 (1994)

    Article  MathSciNet  MATH  Google Scholar 

  13. Faigle, U., Kern, W.: The Shapley value for cooperative games under precedence constraints. Int. J. Game Theory 21, 249–266 (1992)

    Article  MathSciNet  MATH  Google Scholar 

  14. Halpern, J., Pearl, J.: Causes and explanations: a structural-model approach. Part I: Causes British J. Philos. Sci. 56(4), 843–887 (2005)

    Google Scholar 

  15. Halpern, J.Y.: A modification of the halpern-pearl definition of causality. In: Proceedings of IJCAI, pp. 3022–3033 (2015)

    Google Scholar 

  16. Holland, P.W.: Statistics and causal inference. J. Am. Statist. Assoc. 81(396), 945–960 (1986)

    Article  MathSciNet  MATH  Google Scholar 

  17. Hunter, A., Konieczny, S.: On the measure of conflicts: Shapley inconsistency values. Artif. Intell. 174(14), 1007–1026 (2010)

    Article  MathSciNet  MATH  Google Scholar 

  18. Livshits, E., Bertossi, L., Kimelfeld, B., Sebag, M.: The Shapley value of tuples in query answering. Logical Methods Comput. Sci. 17(3), 22.1-22.33 (2021)

    Google Scholar 

  19. Livshits, E., Bertossi, L., Kimelfeld, B., Sebag, M.: Query games in databases. ACM SIGMOD Rec. 50(1), 78–85 (2021)

    Article  MATH  Google Scholar 

  20. Lopatenko, A., Bertossi, L.: Complexity of consistent query answering in databases under cardinality-based and incremental repair semantics. In: Schwentick, T., Suciu, D. (eds.) ICDT 2007. LNCS, vol. 4353, pp. 179–193. Springer, Heidelberg (2006). https://doi.org/10.1007/11965893_13

    Chapter  Google Scholar 

  21. Lundberg, S., et al.: From local explanations to global understanding with explainable AI for trees. Nat. Mach. Intell. 2(1), 2522–5839 (2020)

    Article  Google Scholar 

  22. Lundberg, S., Lee, S.: A unified approach to interpreting model predictions. In: Proceedings of Advances in Neural Information Processing Systems, pp. 4765–4774 (2017)

    Google Scholar 

  23. Meliou, A., Gatterbauer, W., Moore, K.F., Suciu, D.: The complexity of causality and responsibility for query answers and non-answers. In: Proceedings of VLDB, pp. 34–41 (2010)

    Google Scholar 

  24. Meliou, A., Gatterbauer, W., Halpern, J.Y., Koch, C., Moore, K.F., Suciu, D.: Causality in databases. IEEE Data Eng. Bull. 33(3), 59–67 (2010)

    Google Scholar 

  25. Nisan, N., Roughgarden, T., Tardos, E., Vazirani, V.V. (eds.): Algorithmic Game Theory. Cambridge University Press (2007)

    Google Scholar 

  26. Pearl, J.: Causality: Models, Reasoning and Inference, 2nd edn. Cambridge University Press, Cambridge (2009)

    Book  MATH  Google Scholar 

  27. Reshef, A., Kimelfeld, B., Livshits, E.: The impact of negation on the complexity of the Shapley value in conjunctive queries. In: Proceedings of PODS, pp. 285–297 (2020)

    Google Scholar 

  28. Roth, A.E. (ed.): The Shapley Value: Essays in Honor of Lloyd S. Cambridge University Press, Shapley (1988)

    Google Scholar 

  29. Rubin, D.B.: Estimating causal effects of treatments in randomized and nonrandomized studies. J. Educ. Psychol. 66, 688–701 (1974)

    Article  Google Scholar 

  30. Salimi, B., Bertossi, L., Suciu, D., Van den Broeck, G.: Quantifying causal effects on query answering in databases. In: Proceedings of the 8th USENIX Workshop on the Theory and Practice of Provenance (TaPP) (2016)

    Google Scholar 

  31. Shapley, L.S.: A value for n-person games. Contrib. Theory Games 2(28), 307–317 (1953)

    MathSciNet  MATH  Google Scholar 

  32. Struss, P.: Model-based problem solving. In: Handbook of Knowledge Representation, Chap. 4. Elsevier, pp. 395–465 (2008)

    Google Scholar 

  33. Suciu, D., Olteanu, D., Re, C., Koch, C.: Probabilistic Databases. Morgan & Claypool, Synthesis Lectures on Data Management (2011)

    Google Scholar 

Download references

Acknowledgments

Part of this work was funded by ANID - Millennium Science Initiative Program - Code ICN17002; and NSERC-DG 2023-04650.

Author information

Authors and Affiliations

  1. SKEMA Business School, Montreal, Canada

    Leopoldo Bertossi

Authors
  1. Leopoldo Bertossi
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Leopoldo Bertossi .

Editor information

Editors and Affiliations

  1. Paul Sabatier University, IRIT, Toulouse, France

    Abdelkader Hameurlain

  2. Technical University of Vienna, IFS, Vienna, Austria

    A Min Tjoa

  3. Aix-Marseille University, LIS, Marseille, France

    Omar Boucelma

  4. Université Clermont Auvergne, CNRS, LIMOS, Aubiere, France

    Farouk Toumani

Rights and permissions

Reprints and permissions

Copyright information

© 2023 Springer-Verlag GmbH Germany, part of Springer Nature

About this chapter

Check for updates. Verify currency and authenticity via CrossMark

Cite this chapter

Bertossi, L. (2023). From Database Repairs to Causality in Databases and Beyond. In: Hameurlain, A., Tjoa, A.M., Boucelma, O., Toumani, F. (eds) Transactions on Large-Scale Data- and Knowledge-Centered Systems LIV. Lecture Notes in Computer Science(), vol 14160. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-662-68014-8_5

Download citation

  • DOI: https://doi.org/10.1007/978-3-662-68014-8_5

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-662-68013-1

  • Online ISBN: 978-3-662-68014-8

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation