Skip to main content

The Return of the Entity-Relationship Model: Ontological Query Answering

  • Chapter
  • First Online:
Semantic Search over the Web

Part of the book series: Data-Centric Systems and Applications ((DCSA))

Abstract

The Entity-Relationship (ER) model is a fundamental tool for database design, recently extended and employed in knowledge representation and reasoning due to its expressiveness and comprehensibility. We present an extension of the ER model, called ER +, which is particularly suitable for ontology modeling, as well as being flexible and comprehensible. Our model comprises is-a constraints among entities and relationships, plus functional and mandatory participation constraints. In particular, it allows for arbitrary permutations of the roles in is-a among relationships. We argue that ER-based languages can be profitably used in ontology-enhanced database systems, where queries are evaluated against the union of a database instance and an ontology, which constitute a logical theory. In such systems, the instance has usually large size, therefore ensuring tractable complexity of query answering w.r.t. the instance size is crucial. A key notion that ensures tractability in ER +schemata is separability, i.e., the absence of interaction between the functional participation constraints and the other constructs. We provide a precise syntactic characterization of separable ER +schemata by means of a necessary and sufficient condition. We present a complete complexity analysis of the conjunctive query answering problem under separable ER +schemata, and also under several sublanguages of ER +. We show that the addition of so-called negative constraintsdoes not increase the complexity of query answering. With such constraints, our model properly generalizes the most widely-adopted tractable ontology languages, including those in the well-known DL-Litefamily.

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

Access this chapter

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
Hardcover Book
USD 54.99
Price excludes VAT (USA)
  • Durable hardcover 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

References

  1. Abiteboul, S., Hull, R., Vianu, V.: Foundations of Databases. Addison-Wesley, Reading (1995)

    Google Scholar 

  2. Artale, A., Calvanese, D., Kontchakov, R., Ryzhikov, V., Zakharyaschev, M.: Reasoning over extended ER models. In: Proceedings of ER, pp. 277–292 (2007)

    Google Scholar 

  3. Battista, G.D., Lenzerini, M.: A deductive method for entity-relationship modeling. In: Proceedings of VLDB, pp. 13–21 (1989)

    Google Scholar 

  4. Calì, A., Calvanese, D., Giacomo, G.D., Lenzerini, M.: Accessing data integration systems through conceptual schemas. In: Proceedings of ER, pp. 270–284 (2001)

    Google Scholar 

  5. Calì, A., Lembo, D., Rosati, R.: Query rewriting and answering under constraints in data integration systems. In: Proceedings of IJCAI, pp. 16–21 (2003)

    Google Scholar 

  6. Calì, A., Lembo, D., Rosati, R.: Decidability and complexity of query answering over incosistent and incomplete databases. In: Proceedings of PODS, pp. 260–271 (2003)

    Google Scholar 

  7. Calì, A., Gottlob, G., Kifer, M.: Taming the infinite chase: query answering under expressive relational constraints. In: Proceedings of KR, pp. 70–80 (2008)

    Google Scholar 

  8. Calì, A., Gottlob, G., Lukasiewicz, T.: A general Datalog-based framework for tractable query answering over ontologies. In: Proceedings of PODS, pp. 77–86 (2009)

    Google Scholar 

  9. Calì, A., Gottlob, G., Pieris, A.: Advanced processing for ontological queries. PVLDB 3, 554–565 (2010)

    Google Scholar 

  10. Calì, A., Gottlob, G., Pieris, A.: Query answering under non-guarded rules in Datalog+/ − . In: Proceedings of RR 1–17 (2010)

    Google Scholar 

  11. Calì, A., Gottlob, G., Kifer, M., Lukasiewicz, T., Pieris, A.: Ontological reasoning with F-Logic Lite and its extensions. In: Proceedings of AAAI (2010)

    Google Scholar 

  12. Calì, A., Martinenghi, D.: Querying incomplete data over extended ER schemata. TPLP 10, 291–329 (2010)

    MathSciNet  MATH  Google Scholar 

  13. Calvanese, D., Giacomo, G.D., Lenzerini, M.: On the decidability of query containment under constraints. In: Proceedings of PODS, pp. 149–158 (1998)

    Google Scholar 

  14. Calvanese, D., Lenzerini, M., Nardi, D.: Description logics for conceptual data modeling. In: Logics for Databases and Information Systems, pp. 229–263. Kluwer, Norwell (1998)

    Google Scholar 

  15. Calvanese, D., Giacomo, G.D., Lembo, D., Lenzerini, M., Rosati, R.: What to ask to a peer: ontology-based query reformulation. In: Proceedings of KR, pp. 469–478 (2004)

    Google Scholar 

  16. Calvanese, D., De Giacomo, G., Lembo, D., Lenzerini, M., Rosati, R.: Tractable reasoning and efficient query answering in description logics: the DL-Lite family. J. Autom. Reasoning 39, 385–429 (2007)

    Article  MathSciNet  Google Scholar 

  17. Chandra, A.K., Merlin, P.M.: Optimal implementation of conjunctive queries in relational data bases. In: Proceedings of STOC, pp. 77–90 (1977)

    Google Scholar 

  18. Chen, P.P.: The Entity-Relationship model: towards a unified view of data. ACM Trans. Database Syst. 1, 9–36 (1976)

    Article  Google Scholar 

  19. Deutsch, A., Nash, A., Remmel, J.B.: The chase revisisted. In: Proceedings of PODS, pp. 149–158 (2008)

    Google Scholar 

  20. Fagin, R., Kolaitis, P.G., Miller, R.J., Popa, L.: Data exchange: semantics and query answering. Theor. Comput. Sci. 336, 89–124 (2005)

    Article  MathSciNet  Google Scholar 

  21. Gogolla, M., Hohenstein, U.: Towards a semantic view of an extended Entity-Relationship model. ACM Trans. Database Syst. 16, 369–416 (1991)

    Article  MathSciNet  Google Scholar 

  22. Johnson, D.S., Klug, A.C.: Testing containment of conjunctive queries under functional and inclusion dependencies. J. Comput. Syst. Sci. 28, 167–189 (1984)

    Article  MathSciNet  Google Scholar 

  23. Kozen, D.: Lower bounds for natural proof systems. In: Proceedings of FOCS, pp. 254–266 (1977)

    Google Scholar 

  24. Lenzerini, M.: Data integration: a theoretical perspective. In: Proceedings of PODS, pp. 233–246 (2002)

    Google Scholar 

  25. Maier, D., Mendelzon, A.O., Sagiv, Y.: Testing implications of data dependencies. ACM Trans. Database Syst. 4, 455–469 (1979)

    Article  Google Scholar 

  26. Poggi, A., Lembo, D., Calvanese, D., De Giacomo, G., Lenzerini, M., Rosati, R.: Linking data to ontologies. J. Data Semantics 10, 133–173 (2008)

    MATH  Google Scholar 

  27. van der Meyden R.: Logical approaches to incomplete information: a survey. In: Logics for Databases and Information Systems, pp. 307–356. Kluwer, Norwell (1998)

    Google Scholar 

  28. Markowitz, V.M., Shoshani, A.: Representing extended Entity-Relationship structures in relational databases: a modular approach. ACM Trans. Database Syst. 17, 423–464 (1992)

    Article  Google Scholar 

  29. Markowitz, V.M., Makowsky, J.A.: Identifying extended Entity-Relationship object structures in relational schemas. IEEE Trans. Software Eng. 16, 777–790 (1990)

    Article  Google Scholar 

  30. Marnette, B.: Generalized schema-mappings: from termination to tractability. In: Proceedings of PODS, pp. 13–22 (2009)

    Google Scholar 

  31. Ortiz, M., Calvanese, D., Eiter, T.: Characterizing data complexity for conjunctive query answering in expressive description logics. In: Proceedings of AAAI (2006)

    Google Scholar 

  32. Papadimitriou, C.H.: Computational Complexity. Addison-Wesley, Reading (1999)

    Google Scholar 

  33. Vardi, M.Y.: The complexity of relational query languages. In: Proceedings of STOC, pp. 137–146 (1982)

    Google Scholar 

  34. Vardi, M.Y.: On the complexity of bounded-variable queries. In: Proceedings of PODS, pp. 266–276 (1995)

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Andrea Calì .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2012 Springer-Verlag Berlin Heidelberg

About this chapter

Cite this chapter

Calì, A., Gottlob, G., Pieris, A. (2012). The Return of the Entity-Relationship Model: Ontological Query Answering. In: De Virgilio, R., Guerra, F., Velegrakis, Y. (eds) Semantic Search over the Web. Data-Centric Systems and Applications. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-25008-8_10

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-25008-8_10

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-25007-1

  • Online ISBN: 978-3-642-25008-8

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics