Skip to main content
SpringerLink
Log in

Measuring and Computing Database Inconsistency via Repairs

  • Conference paper
  • First Online:
Book cover Scalable Uncertainty Management (SUM 2018)

Part of the book series: Lecture Notes in Computer Science ((LNAI,volume 11142))

Included in the following conference series:

Abstract

We propose a generic numerical measure of inconsistency of a database with respect to a set of integrity constraints. It is based on an abstract repair semantics. A particular inconsistency measure associated to cardinality-repairs is investigated; and we show that it can be computed via answer-set programs.

L. Bertossi—Member of the “Millenium Institute for Foundational Research on Data” (IMFD, Chile). Research supported by NSERC Discovery Grant #06148.

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

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Notes

  1. 1.

    Abstract distances between two point-sets are investigated in [8], with their computational properties. Our setting is a particular case.

  2. 2.

    For INDs repairs based only on tuple deletions can be considered [6].

  3. 3.

    Other possible measures for single FDs and relationships between them can be found in [11].

  4. 4.

    For certain forms of prioritized repairs, such as endogenous repairs, the normalization coefficient |D| might be unnecessarily large. In this particular case, it might be better to use \(|D^n|\).

  5. 5.

    This approach was followed in [1] to compute maximum responsibility degrees of database tuples as causes for violations of DCs, appealing to a causality-repair connection [3].

  6. 6.

    Certain (or skeptical) reasoning with repair programs for DCs with weak constraints is \(\varDelta ^P_2({ log}(n))\)-complete in data complexity, i.e. in the size of the database [7, 12].

References

  1. Bertossi, L.: Characterizing and computing causes for query answers in databases from database repairs and repair programs. Corr Arxiv cs.DB/1712.01001 (2018). Proc. FoIKs. LNCS, vol. 10833, pp. 55–76. Springer (2018)

    Google Scholar 

  2. Bertossi, L.: Database Repairing and Consistent Query Answering. Synthesis Lectures on Data Management. Morgan & Claypool, San Rafael (2011)

    Google Scholar 

  3. 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)

    Article  MathSciNet  Google Scholar 

  4. Bertossi, L., Rizzolo, F., Jiang, L.: Data quality is context dependent. In: Castellanos, M., Dayal, U., Markl, V. (eds.) BIRTE 2010. LNBIP, vol. 84, pp. 52–67. Springer, Heidelberg (2011). https://doi.org/10.1007/978-3-642-22970-1_5

    Chapter  Google Scholar 

  5. Brewka, G., Eiter, T., Truszczynski, M.: Answer set programming at a glance. Commun. ACM 54(12), 93–103 (2011)

    Article  Google Scholar 

  6. Chomicki, J., Marcinkowski, J.: Minimal-change integrity maintenance using tuple deletions. Inf. Comput. 197(1–2), 90–121 (2005)

    Article  MathSciNet  Google Scholar 

  7. Caniupan-Marileo, M., Bertossi, L.: The consistency extractor system: answer set programs for consistent query answering in databases. Data Knowl. Eng. 69(6), 545–572 (2010)

    Article  Google Scholar 

  8. Eiter, T., Mannila, H.: Distance measures for point sets and their computation. Acta Inform. 34, 109–133 (1997)

    Article  MathSciNet  Google Scholar 

  9. Grant, J., Martinez, M.V. (eds.): Measuring Inconsistency in Information. College Publications, Los Angeles (2018)

    MATH  Google Scholar 

  10. Grant, J., Hunter, A.: Analysing inconsistent information using distance-based measures. Int. J. Approx. Reason. 89, 3–26 (2017)

    Article  MathSciNet  Google Scholar 

  11. Kivinen, J., Mannila, H.: Approximate inference of functional dependencies from relations. Theor. Comput. Sci. 149, 129–l49 (1995)

    Article  MathSciNet  Google Scholar 

  12. Leone, N., et al.: The DLV system for knowledge representation and reasoning. ACM Trans. Comput. Logic. 7(3), 499–562 (2006)

    Article  MathSciNet  Google Scholar 

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

    Article  Google Scholar 

  14. Rajamaran, A., Ullman, J.: Mining of Masssive Datasets. Cambridge University Press, Cambridge (2012)

    Google Scholar 

  15. Staworko, S., Chomicki, J., Marcinkowski, J.: Prioritized repairing and consistent query answering in relational databases. Ann. Math. Artif. Intell. 64(2–3), 209–246 (2012)

    Article  MathSciNet  Google Scholar 

  16. Thimm, M.: On the compliance of rationality postulates for inconsistency measures: a more or less complete picture. Künstliche Intell. 31(1), 31–39 (2017)

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Carleton University, Ottawa, Canada

    Leopoldo Bertossi

  2. RelationalAI, Inc., Berkeley, USA

    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. University of Milano-Bicocca, Milan, Italy

    Davide Ciucci

  2. University of Milano-Bicocca, Milan, Italy

    Gabriella Pasi

  3. Sapienza University of Rome, Rome, Italy

    Barbara Vantaggi

Rights and permissions

Reprints and permissions

Copyright information

© 2018 Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Bertossi, L. (2018). Measuring and Computing Database Inconsistency via Repairs. In: Ciucci, D., Pasi, G., Vantaggi, B. (eds) Scalable Uncertainty Management. SUM 2018. Lecture Notes in Computer Science(), vol 11142. Springer, Cham. https://doi.org/10.1007/978-3-030-00461-3_26

Download citation

  • DOI: https://doi.org/10.1007/978-3-030-00461-3_26

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-030-00460-6

  • Online ISBN: 978-3-030-00461-3

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation